Microsoft Office

Microsoft Excel: Level Two

NASBA CPEs: 14|CEUs: 1.4
Intermediate

Who Should Attend

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

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 Microsoft Excel Visual: Quick Tips - a user-friendly, color manual.

Select a Date and Location
June 29 - 30, 2020
9am-4pm
Class ID: 10003795
August 3 - 4, 2020
9am-4pm
Class ID: 10003796
August 26 - 27, 2020
9am-4pm
Class ID: 10003842
December 16 - 17, 2020
9am-4pm
Class ID: 10003798
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