Intermediate Microsoft Excel

    Have you been using Excel to its fullest potential? Learn how to work faster and more productively. Discover how the Pivot Table and AutoFilter can help you rapidly create reports and analyses. Learn advanced graphing techniques and how to use functions to get Excel to perform complex math, make decisions, and look up values in a table.

    View dates this course will be offered.

    Requirements:

    For this class, you will need Microsoft Excel 95 or 97 or the Microsoft Office 95 or 97. You'll also need Internet access, e-mail, and the Microsoft Internet Explorer or Netscape Navigator web browser. Completion of the Intro to Excel course (or equivalent experience) is required.

Syllabus

Week One
Lesson 1 Charting fundamentals
Lesson 2 Advanced charting
Week Two
Lesson 3 Data management
Lesson 4 AutoFilter, Goal Seeking
Week Three
Lesson 5 The Pivot Table
Lesson 6 The Pivot Table
Week Four
Lesson 7 The Solver
Lesson 8 The Solver
Week Five
Lesson 9 Macros
Lesson 10 Text functions
Week Six
Lesson 11 Math functions
Lesson 12 Lookup functions

Other Microsoft Office Courses

Other Courses