Total Time - 7 hours
The
Basics
Select
and Navigate Cells
Enter
Data
Edit
and Delete Data
Cut,Copy
and Paste
Undo
and Redo
Drag
and Drop
Auto
Fill
AutoCorrect
On up coming PC User CDs
Working with Worksheets
Zoom Control
Views
Resize Rows and Columns
Insert and Delete Cells
Insert and Delete Rows and Columns
Rename Worksheets
Insert and Delete Worksheets
Move and Copy Worksheets
Hide and Unhide
Formatting Cells
Text formats
Align and Text Wrap
Alignment Effects
Borders and Shading
Number Formats
Date and Time Formats
Custom Formats
Format Painter
Autoformat
Conditional Formating
Styles
Basic Formulas
Formula Structure
Operators
Creating Formulas
Autofill Formulas
Autosum
Relative Reference
Absolute Reference
Function Wizard
Ready for Printing?
Headers and footers
Print Preview
Scaling the Print Area
Set Print Area
Margins
Printing
Charts and Maps
Creating a Chart
Chart Wizard
Chart Options
The Legend
The Series
Chart Toolbar
3D Charts
Creating Maps
Customizing Maps
Labeling Maps
Advanced Formulas
If Functions
And, Or
Nested If Functions
Using Excel as a Database
Create a database
Sort Data
Filter data
Advance filter
Data forms
Database Functions
Linking and Protecting
Formula Links
Range names
Paste Special
Protect Cells
Protect Worksheets and Workbooks
Passwords
Analysis
Goal Seek and Solver
Scenarios
Pivot Tables
Validation
Auditing
Outlining
Toolbars and Macros
Customizing Toolbars
Create a Macro
Edit a Macro
Create a Macro Button
Graphics and the Drawing Toolbar
Insert a Picture
Move, Resize and Crop
Creating Shapes and Lines
Arranging and Grouping
Fills and Line Color
Arrows
AutoShapes
Flip and Rotate
Text boxes
WordArt
Shadow and 3D Effects