Microsoft Office

Microsoft Excel: Level Three

CPEs: 14|CEUs: 1.4
Classroom, Virtual

Who Should Attend

All students who took our Microsoft Excel: Level Two course OR advanced users with strong Excel skills.

We suggest that you bring a sample workbook from your job. There will be an opportunity for students to ask questions specifically related to their work projects.

Additional Information

Suggested Prerequisite: Microsoft Excel: Level Two or strong Excel skills

Advanced Preparation:

CPE Field of Study: Computer Software

What You Will Learn

  • Summarize and analyze large amounts of data in a logical, organized manner.
  • Create interactive pivot tables and pivot charts to perform real time data analysis, including specifying the data analyzed, changing a calculation, selecting what appears, and formatting and charting a pivot table.
  • Learn advanced formulas and functions.
  • Create a formula with several operators and cell ranges.
  • Create conditional formatting rules.
  • Fix formula errors.
  • Perform data imports and exports.
  • Review advanced filtering techniques.
  • Create and sort a list, filter a list with Advanced Filter, and copy filtered records.
  • Use data validation and drop down lists.
  • Use lookup functions.
  • Automate repetitive tasks using Macros.
  • Record a Macro, play a Macro, and assign a Macro a shortcut.
  • Perform “What if” analysis.
  • Create forms with command buttons.
  • Use advanced database functions.
  • Protect a worksheet and a workbook.
  • Add a print title and gridlines.
  • Add and work with hyperlinks.
  • Save a workbook as a macro-enabled page.
  • Import an external data source, including CSV files.

Why You Should Attend

We developed a course to cater to our students who want to learn Excel’s most advanced features and functions!  This class covers those advanced features and functions with an emphasis on Excel’s data analysis capabilities. 


Select a Date and Location
Jul 1 - 2, 2024
9am-4pm ET
Class ID: 10004637
Aug 12 - 13, 2024
9am-4pm ET
Class ID: 10004638
Sep 25 - 26, 2024
9am-4pm ET
Class ID: 10004639
Dec 11 - 12, 2024
9am-4pm ET
Class ID: 10004640
Group Training
Would you like us to bring one of our instructor-led courses to your location or provide instructor-led training virtually? If so, please complete the Group Training Request Form. Group Training Request Form
Fax or Email
Please complete the registration form. Registration Form