Microsoft Office
Course Name: Microsoft Excel: Level Two
Credits: NASBA CPEs: 14|CEUs: 1.4
Level: Intermediate

Select a Date and Location

April 21 - 22, 2020
$795.00 Register
June 29 - 30, 2020
$795.00 Register
August 3 - 4, 2020
$795.00 Register
August 20 - 21, 2020
$795.00 Register
December 16 - 17, 2020
$795.00 Register

Who Should Attend

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

Note: We have Microsoft Excel 2010 and 2013 available in class for each student.  You can work with either version (or both) and our instructor will demonstrate the minor differences.


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.

Related Courses

Member Login

Already a member? Click here to login.

Fax or Mail Registrations

Please complete the registration form.

Group On-Site Training

Do you want us to bring one of our courses to your location? Then, please complete the on-site request form and someone from our office will contact you shortly.
Sign up to receive our course catalog?
Available Courses | Certificate Programs | Training at Your Location | For Training Officials | Why HRI? | Get Started
Human Resources Institute, 6172 Oxon Hill Road, Oxon Hill, Maryland 20745. General Information:
Contact Us: Tel: 301-749-5600 | Fax: 301-839-6616 | © 2020 Human Resources Institute | Privacy Policy