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

Select a Date and Location

Date/TimeLocationPrice 
April 21 - 22, 2020
9am-4pm
$815.00 Register
June 29 - 30, 2020
9am-4pm
$815.00 Register
August 3 - 4, 2020
9am-4pm
$815.00 Register
August 26 - 27, 2020
9am-4pm
$815.00 Register
December 16 - 17, 2020
9am-4pm
$815.00 Register

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.

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.
 
GSA
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: info@federaltraining.com
Contact Us: Tel: 301-749-5600 | Fax: 301-839-6616 | © 2020 Human Resources Institute | Privacy Policy