Course Description

Get the Excel training you need to achieve success so you can manipulate data faster and more efficiently in most workplace situations. If your organization uses lists of any kind, you need to know how to use Microsoft Excel. Earning the Microsoft Office Specialist Excel Expert certification sets your professional skill set apart from other Excel users. The course will prepare you for the Microsoft Office Specialist: Microsoft Excel Expert exam.

In this online Excel course, you will first learn to create, modify, and format Excel worksheets, perform calculations, and print Excel workbooks. The course then moves on to teach you how to use advanced formulas, work with lists, work with illustrations and charts, and use advanced formatting techniques. You will also learn Excel's advanced features, such as pivot tables, audit worksheets, data tools, macros, and collaboration methods.

Course Outline

1. Introduction to Excel
   1. Microsoft Office Basics
   2. Creating a Microsoft Excel Workbook
   3. The Ribbon
   4. The Backstage View (The File Menu)
   5. The Quick Access Toolbar
   6. Entering Data in Microsoft Excel Worksheets
   7. Formatting Microsoft Excel Worksheets
   8. Editing Worksheets
   9. Working with Rows and Columns
   10. Using Formulas in Microsoft Excel
   11. Finalizing Microsoft Excel Worksheets
   12. Introduction to Excel Exam
2. Intermediate Excel
   1. Common Functions
   2. Working with Lists
   3. Visualizing Your Data
   4. Working with Tables
   5. Advanced Formatting
   6. Intermediate Excel Exam
3. Advanced Excel
   1. Using PivotTables
   2. Advanced Functions
   3. Auditing Workbooks
   4. Data Tools
   5. Working with Others
   6. Recording and Using Macros
   7. Advanced Excel Exam
4. Final Exam