Microsoft Office
Course Name: Microsoft Excel: Level Three
Credits: NASBA CPEs: 14|CEUs: 1.4
Level: Advanced
 

Select a Date and Location

Date/TimeLocationPrice 
December 13 - 14, 2018
9am-4pm
$785.00 Register
June 24 - 25, 2019
9am-4pm
$785.00 Register
August 22 - 23, 2019
9am-4pm
$785.00 Register
September 11 - 12, 2019
9am-4pm
$785.00 Register

Who Should Attend

All students who took our Microsoft Excel: Level Two course OR advanced users with strong Excel skills.

Notes: 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. 

Also, we suggest that you bring a sample workbook from your job. There will be an opportunity for students to ask questions specifically related to their work projects.  

What You Will Learn

  • Summarize and analyze large amounts of data in a logical, organized manner.
  • Create interactive pivot tables and pivot charts to perform real time data analysis, including specifying the data analyzed, changing a calculation, selecting what appears, and formatting and charting a pivot table.
  • Learn advanced formulas and functions.

  • Create a formula with several operators and cell ranges.
     
  • Create conditional formatting rules.
     
  • Fix formula errors.
  • Perform data imports and exports.
  • Review advanced filtering techniques.
     
  • Create and sort a list, filter a list with Advanced Filter, and copy filtered records.
     
  • Use data validation and drop down lists.
  • Use lookup functions.
  • Automate repetitive tasks using Macros.
     
  • Record a Macro, play a Macro, and assign a Macro a shortcut.
  • Perform “What if” analysis.
  • Create forms with command buttons.
     
  • Use advanced database functions.
     
  • Protect a worksheet and a workbook.
     
  • Add a print title and gridlines.
     
  • Add and work with hyperlinks.
     
  • Save a workbook as a macro-enabled page.
     
  • Import an external data source, including CSV files.

Why You Should Attend

We developed a course to cater to our students who want to learn Excel’s most advanced features and functions!  This class covers those advanced features and functions with an emphasis on Excel’s data analysis capabilities. 

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