Skip to main content
Request a Training Proposal

Instructor-led training

Advanced Microsoft Excel Training in Rochester Hills, Michigan

Microsoft Office training from Hartmann Software Group, delivered onsite in Rochester Hills, Michigan or live online.

Request a Training Proposal View Course Outline

What you'll learn

The Advanced Excel course is designed for experienced users looking to leverage Excel's powerful features to streamline their work and enhance their data analysis capabilities. The course delves into topics such as PivotTables, advanced functions, auditing workbooks, and data tools. Students will also explore importing and consolidating data, What-If analysis, recording and using macros, and collaborating with others. Through hands-on exercises and real-world examples, students will master advanced Excel techniques, equipping them with the skills needed to tackle complex data analysis tasks efficiently.

Prerequisites

Intermedate Excel skills.

Course Outline

  1. Using PivotTables
    1. How PivotTables Work
    2. Timeline Filters
    3. Inserting Slicers
    4. Grouping Data
    5. Calculated Fields
    6. PivotCharts
    7. Working with PivotTables (Exercise)
  2. Advanced Functions
    1. Function Syntax
    2. ROWS, COLUMNS, INDEX, and XMATCH
    3. Arrays and Array Formulas
    4. Getting Unique Values (Exercise)
    5. SORT, FILTER, and SORTBY
    6. Lookup Functions
    7. Using the XLOOKUP Function (Exercise)
    8. The LET Function
    9. The TRANSPOSE Function
  3. Auditing Workbooks
    1. Inspecting a Workbook
    2. Tracing Precedents and Dependents
    3. Tracing Precedents and Dependents Practice (Exercise)
    4. Watch Window
    5. Evaluating Formulas
    6. Error Checking
  4. Data Tools
    1. Importing Data from online source
    2. Converting Text to Columns
    3. Converting Text to Columns (Exercise)
    4. Importing Files
    5. Importing Text Files (Exercise)
    6. Linking to External Data
    7. Controlling Calculation Options
    8. Data Validation
    9. Using Data Validation (Exercise)
    10. Consolidating Data
    11. Consolidating Data (Exercise)
    12. What-If Analysis
    13. Using Goal Seek (Exercise)
  5. Recording and Using Macros
    1. Recording Macros
    2. Recording a Macro (Exercise)
    3. Running Macros
    4. Editing Macros
    5. Adding Macros to the Quick Access Toolbar
    6. Adding a Macro to the Quick Access Toolbar (Exercise)
  6. Working with Others
    1. Comments and Notes
    2. Protecting Worksheets and Workbooks
    3. Password Protecting a Workbook (Exercise)
    4. Marking a Workbook as Final
    5. Other Sharing Concerns

Training locations

Advanced Microsoft Excel training across the U.S. and beyond.

We provide Advanced Microsoft Excel training onsite and live online for organizations throughout the United States and internationally.

View all Advanced Microsoft Excel training locations

Train your team with HSG

Private, instructor-led training customized for your organization.

  • Onsite or live online delivery
  • Customized curriculum
  • Training for groups of 3 or more
  • Flexible scheduling
  • Experienced instructors
Request a Training Proposal

Questions? Call us at 303.377.6176
or email info@hartmannsoftware.com

Browse all Microsoft Office courses →

Ready to train your team?

Let's customize this training for your organization.

Tell us about your employees, your goals, and your preferred schedule. We'll prepare a training proposal covering scope, delivery format, and pricing.

Request a Training Proposal

or call 303.377.6176