Microsoft Office

Microsoft Excel: Level Two

CPEs: 14|CEUs: 1.4
Classroom, Virtual

Who Should Attend

All students should take our Microsoft Excel: Level One class first, unless you have intermediate level Excel skills.

Additional Information

Suggested Prerequisite: Microsoft Excel:Level One

Advanced Preparation:

CPE Field of Study: Computer Software 

What You Will Learn

  • Produce and link multiple spreadsheets.
  • Practice with drop down lists, formatting, conditional formatting, and embedding.
  • Receive an introduction to data analysis with Pivot Tables.
  • Learn to use Excel as a database. 
  • Create and use range names.
  • Select nonadjacent cell ranges.
  • Use the AutoCalculate feature.  
  • Use the PMT function.
  • Display and print formulas in a worksheet.
  • Identify and fix formula errors.
  • Learn advanced functions for Graphs and Charts.
  • Format a Data Series and Chart Axis.
  • Add headers, footers, and page numbers to a worksheet.
  • Reference external data sources.  
  • Protect and hide a worksheet.
  • Save a “reader friendly” Custom View.
  • Create and use templates.
  • Add records to a list using a Data Form.
  • Work with Lists.
  • Work with AutoFormat, create a custom number format, find and replace formatting, and use conditional formatting.
  • Work with and understand Absolute and Relative cell references.
  • Preview and print worksheets and use advanced print options.
  • Hands-on exercises with time set aside to practice what you have learned.

Why You Should Attend

Our training maximizes learning and allows for more “hands-on” practice. You also receive a copy of Teach Yourself Visually Excel - a user-friendly, color manual.

Select a Date and Location
Jun 26 - 27, 2024
9am-4pm ET
Class ID: 10004633
Aug 7 - 8, 2024
9am-4pm ET
Class ID: 10004634
Sep 23 - 24, 2024
9am-4pm ET
Class ID: 10004635
Dec 9 - 10, 2024
9am-4pm ET
Class ID: 10004636
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