Get to know the interface and features of Excel 2007

Learn to use Excel 2007 so that you can create a spreadsheet with formula, graph, chart, and much more.

Lessons include text, voice, and mouse activities to accommodate the three basic learning styles: reading, hearing, and doing.

The best step-by-step tutorial using the latest eLearning technology

No prior knowledge of using Excel nor spreadsheet is necessary


Level: Basic to Intermediate

Lesson 1: Getting Acquainted with Excel 2007
The interface of Excel 2007
How to customize the quick access toolbar
The status bar
How to use help
New features of Excel 2007

Lesson 2: Basic Operation
Create a new worksheet
Perform basic operations upon cells
Add comments
Sort your data
Use and manipulate multiple worksheets
Split windows and freeze panes
Protect your worksheet
Use Print Review
Save a worksheet

Lesson 3: Worksheet Format
Change fonts and font styles
Change number format settings
Adjust row height and column width
Hide/unhide columns and cells
Change borders and shading
Use formatting

Lesson 4: Formula and Functions
Use formulas
Use array formulas
Insert functions
Use AutoSum

Lesson 5: Editing Graphics
Insert pictures
Edit pictures
Use SmartArt
Insert shapes

Lesson 6: Chart Design
Insert Charts
Resize a chart
Move a chart
Format the text settings
Choose appropriate chart types
Re-choose source data
Change layouts and patterns
Use auto-update
Edit the title
Hide data labels
Show vertical axis and gridlines
Set background color
Format data series
Insert WordArt
Display source data in the chart

Lesson 7: Managing Data Lists and Worksheet
Create a data list
Filter data
Sort data
Show subtotal
Create PivotTable

Lesson 8: Excel Macro and Application
Show the developer tab.
Record Macros
Edit Macros
Use Macro Security

Lesson 9: Sharing and Networking
Share your workbook
Tack changes
Protect shared workbooks
Create hyperlinks

Windows 9X, 2000, NT, XP & Vista
Pentium 133Mhz or Higher
32 MB Ram
10MB Free Disk Space
24X CD-Rom Drive

Product Packaging: Retail DVD Case