This interactive course is designed for students who are new or have had limited exposure to Microsoft Excel 2007. Each lesson is packed with real world examples giving participants the necessary skills to get started creating top notch speadsheets.
How it works
The Excel 2007 Introductory course is two hours in total length. However, the class is split up into two, one hour sessions. Each session is on a separate day.
Example: Tuesday, Thursday
Student Materials
Each participant will receive the following:
Quick reference guide
Support forum for life
Course Outline
Hour 1:
Lesson 1: Creating a Basic Worksheet
Explore the User Interface and the Ribbon
Navigate and Select in Excel
Obtain Help
Enter Data and Save a Workbook
Customize the Quick Access Toolbar
Lesson 2: Modifying a Worksheet
Manipulate Data
Insert and Delete Cells, Columns, and Rows
Search for Data in a Worksheet
Spell Check a Worksheet
Lesson 3: Formatting a Worksheet
Modify Fonts Add Borders and Color to Cells Change Column Width and Row Height Apply Number Formats Position Cell Contents Apply Cell Styles
Hour 2:
Lesson 4: Managing Large Workbooks
Format Worksheet Tabs Manage Worksheets in a Workbook Manage the View of Large Worksheets
Lesson 5: Basic Calculations
Create Basic Formulas Calculate with Functions Copy Formulas and Functions
Lesson 6: Workbook Printing
Print Workbook Contents Using Default Print Options Set Print Options Set Page Breaks
