Sunday, February 9, 2014

Lecture Slides


Introduction to Excel - Excel 2013 Tutorial from SpreadsheetTrainer

Introduction to MS Excel Document https://docs.google.com/file/d/0B4XYehDzf79qQ1hLSEtCY090alk/edit
Microsoft Excel http://en.wikipedia.org/wiki/Microsoft_Excel

Reading Material

Click here to open Excel2003BeginnersGuide.pdf>>Excel 2003 Beginners Guide

The aim of this document is to introduce some basic techniques for using Excel to enter data, perform calculations and produce simple charts based on that information. You will look at different techniques for ensuring that your spreadsheet appears as intended both on screen and when printed. 

Reading Material
Click here to open the Week 1:Getting Started with Google Sheets

VIDEO LECTURES

Excel 2010 Beginner Tutorial 1 of 5: What is a Spreadsheet?


Excel 2010 Beginner Tutorial 2 of 5: Creating A New Spreadsheet

Excel 2010 Beginner Tutorial 3 of 5: Excel Charts Made Easy

Excel 2010 Beginner Tutorial 4 of 5: VLookup, PMT and SUMIF

Excel 2010 Beginner Tutorial 5 of 5: Sum Across Worksheets

Video Materials
Getting Started (Excel 2003)
Spreadsheet Uses Watch Video1 
Toolbars and Menus Video 2
Moving Around Video 3
Getting Help Video 4


Excel Spread Sheet Basics - Using a Formula

Excel 2010 Tutorial For Beginners #7 - Formatting Worksheets