Microsoft Office Specialist series

Excel 2000 Expert Skills

The Excel 2000 Expert course:
Lesson 1 – Names, Multiple Worksheets
Lesson 2 – Rounding and Filtering
Lesson 3 – GoTo, Range Finder, Subtotals, IF
Lesson 4 – VLOOKUP, Conditional Formatting
Lesson 5 – Auditing and Validation
Lesson 6 – Comments, Reviewing, Tracking Changes
Lesson 7 – Printing, 3-D Totals
Lesson 8 – Pivot Tables
Lesson 9 – Goal Seek, Solver, and Scenarios
Lesson 10 – Report Manager, Importing data, Workspaces
Lesson 11 – Recording and Editing a Macro
Lesson 12 – Playing with Toolbars
Lesson 13 – Using Templates
Lesson 14 – Track Changes, Protect Documents
Lesson 15 – Sharing a Workbook
Lesson 16 – Merging Workbooks (sample this lesson from our Sample Lessons page)
Lesson 17 – Sorting and Subtotals
Lesson 18 – Microsoft Query
Lesson 19 – Consolidating Spreadsheets
Lesson 20 – Importing Text File, and Database as a PivotTable
Lesson 21 – Exporting to PowerPoint and Word

All of our courses are now accessible online for FREE.