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

Select a Date and Location

Date/TimeLocationPrice 
December 11 - 12, 2018
9am-4pm
$785.00 Register
April 22 - 23, 2019
9am-4pm
$785.00 Register
June 19 - 20, 2019
9am-4pm
$785.00 Register
August 20 - 21, 2019
9am-4pm
$785.00 Register
September 5 - 6, 2019
9am-4pm
$785.00 Register
December 18 - 19, 2019
9am-4pm
$785.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.
     
  • Receive an introduction to Macros.
  • 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 | © 2018 Human Resources Institute | Privacy Policy