Excel 2010 - Level 1

Course details

After an introduction to spreadsheet terminology and Excel's window components, students will learn how to use the Help system and navigate worksheets and workbooks. Then they will enter and edit text, values, formulas, and pictures, and save workbooks.

Course Outline

1 - Getting started

• Spreadsheet terminology
• The Excel environment
• Getting help
• Navigating a worksheet

2 - Entering and editing data

• Entering and editing text and values
• Entering and editing formulas
• Working with pictures
• Saving and updating workbooks

3 - Modifying a worksheet

• Moving and copying data
• Moving and copying formulas
• Absolute and relative references
• Inserting and deleting ranges, rows, and columns

4 - Using functions

• Entering functions
• AutoSum
• Other common functions

5 - Formatting

• Text formatting 
• Row and column formatting 
• Number formatting 
• Conditional formatting
• Additional formatting options

6 - Printing

• Preparing to print
• Page Setup options
• Printing worksheets

7 - Charts

• Chart basics
• Formatting charts

8 - Managing large workbooks

• Viewing large worksheets
• Printing large worksheets
• Working with multiple worksheets

9 - Graphics and screenshots

• Conditional formatting with graphics
• SmartArt graphics
• Screenshots

Target Audience: This course is intended for an inpidual with little or no experience using Microsoft Excel or any other spreadsheet program. Student will get the most out of this course if their goal is to become proficient in using Excel to creat basic worksheets and charts for data tracking and reporting.