Office Window Elements Time: 40 Min

• Basic Windows Elements
• Menu featuers
• Customizing Menus and Toolbars
• Getting Help
• Using the Slide Master

Introduction to Excel Time: 70 Min

• What is Excel?
• Starting Excel
• Getting to Know the Excel Screen
• Navigating an Excel Workbook
• Selecting and Moving Cells
• Inserting and Deleting Cells
• Using Cut, Copy, and Paste
• Using Find and Replace
• Saving a Workbook
• Exiting Excel

Creating and Editing Workbooks Time: 70 Min

• Creating New Workbooks
• Entering Data
• Working with AutoComplete
• Including Calculations
• Introducing to Functions
• Copyinng Formulas
• Using Undo and Redo
• Using AutoCalculate
• Working with Worksheets
• Linkin Formulas
• Using the Error Checking Smart Tag

Working with Functions Time: 80 Min

• Inserting Functions
• Supplying Functions Arguments
• Controlling Calculations
• Determining Calculation Accuracy
• Evaluating Formulas
• Introduction to Financial Functions
• Using FV and PMT Functions
• Specifying Conditions with IF
• Using Date and Time Functions

Formatting Workbooks Time: 70 Min

• adjusting Columns and Row Sizes
• Chaning Cell Alignment
• Using Number Formatting
• Formatting Text
• Using the Format Painter
• Using Styles and AutoFormatting
• Finding and Replacing Formats
• Using the Spelling Checker
• Working with AutoCorrect
• Using AutoFill

Adding Charts and Pictures Time: 70 Min

• Creating Charts
• Formatting Charts
• Modifying Charts
• Changing Char Types
• Using Drawing Tools
• Inserting Graphics
• Printint a Chart
• Adding Hyperlinks

Viewing and Printing Time: 80 Min

• Viewing the Worksheet
• Splitting and Freezing a Worksheet
• Using AutoFilter
• Adding Heders and Footers
• Working with Page Setup
• Setting a Print Area
• Using Print Preview and Printing
• Saving a Workbook as a Web Page
• Adding Comments
• E-mailing a Workbook