
Think of a three ring binder with three sheets of paper in it. It is called Book because it is a Workbook that is initially made up of three Worksheets (accessible from the tabs in the lower left corner of your excel window - see Fig. Worksheet when you open Excel, a new file is created called Book 1 (until you name it differently). Spreadsheets are commonly be used to perform many different types of calculations.ĭefinitionsWorkbook vs. Spreadsheets allow information to be organized in rows and tables and analyzed with automatic mathematics. Getting StartedMicrosoft Office Excel is a powerful tool used to create and format spreadsheets. Updated by Rachael Steller (Summer 2008) 2

Getting Started 2-3Definitions 2Ribbon 3Navigating Cells 3Įditing Data/Text 4Autofill 5-6Controlling Your View of Data 6Sorting and Filtering 6-7įormulas 7-9Cell References Autofill with Formulae 7AutoSum 8Functions 8AutoCalculate 9Name Manager 9Ĭharts 9Pivot table 10-11Trouble-shooting 11Printing 12

Navigate Cells Manipulate Data Use Formulas and Functions Create Charts and Tables
Excel 2007 tutorial 12 free#
If you have any questions, feel free to ask a TLC staff consultant for assistance during staffed hours at your center. Spreadsheets are commonly be used to perform many different types of calculations. Microsoft Office Excel is a powerful tool used to create and format spreadsheets. Updated by Rachael Steller (Summer 2008) 1
