Advanced Excel for Business and Industry - Class

Learn to use Excel’s advanced features to build automated reports and solve problems. Create powerful self-adjusting tools that will save you time and effort.

Next Class: Check Dates

Advanced Microsoft Excel Training

How our class will boost your Excel skills.

Boost Advanced Excel Training

Our 1-day class shows you how to build powerful self-adjusting Excel tools and reports. Our class starts off with how to use Power Query along with Excel tables; various filtering functions; and spill over arrays to quickly create autonomous reports.

In addition, our training shows how to build advanced lookups; logic formulas; and array formulas to solve tough data problems. Also discussed is how to use LAMBDA to create your own custom worksheet functions.

It also shows how to combine PivotTables, Pivot Charts, Conditional Formatting, shapes, and linked pictures to rapidly build dashboards and reports.

Read our detailed outline > below and see what you'll discover in our class.

Take a video tour of what you'll learn.

Video Play
  • Rapidly parsing reports using Excel tables, names, spill over arrays, and the UNIQUE, FILTER, Sort... functions
  • Building report templates with formulas and charts that self-adjust to typed, pasted, or external data
  • Using Excel tables, slicers, structured references, and charts to quickly build report dashboards
  • Building self-adjusting logic for SUMIFS, COUNTIFS... that process data with varying logic conditions
  • Processing data with multi-decision and multi-condition logic using the IF, IFS, AND, OR... functions
  • Using the Text, Date/Time, Math... functions to build powerful logic formulas
  • Using Conditional formatting to auto-format reports and build visual displays
  • Creating worksheet interfaces to control your Excel data tools using Data Validation and ActiveX Controls
  • Performing advanced lookups on partial and multiple tables using the VLOOKUP, XLOOKUP, INDEX, INDIRECT... functions
  • Using Power Query to rapidly import, merge, and shape data from workbooks, text files, and databases
  • Using array formulas to quickly analyze multi-step data problems and perform multi-condition lookups
  • Using LAMBDA to create custom worksheet functions that can be rapidly entered to process data
  • Using slicers, timelines, PivotTables, Pivot Charts, and Excel tables to construct adaptive reports

Some key topics we cover in class.

Advanced Excel Training Topics

4 ways to train.

Virtual Signup
Virtual

View the dates, signup, and pricing for our hands-on live virtual training.
Virtual Signup >   Learn More >

Public Signup
In-Person

View the dates, signup, and pricing for our hands-on in-person training.
In-Person Signup >   Learn More >

Manual Information
Manual

Can't take the class, buy the self-study manual, apply the price later.
View Manual >

Onsite Details
Onsite

Learn how we can help your business save time and effort in Excel.
View Onsite Details >

Class syllabus.

How we run the class: We focus our training on what our customers need. When training begins, we analyze those needs and shift our training outline appropriately. We will stress topics or add topics that our customers want. No two training sessions are ever the same with EMAGENIT.
Class PDF

Download Class Brochure

Building Self-Adjusting Reports Using Functions, Excel Tables, Spill Over Arrays

Using Power Query to Rapidly Access, Merge, and Shape Your Report Data

Using Advanced Formulas, Logic, and LAMBDA to Quickly Analyze Data

Visualizing Your Report Data and Controlling Your Data Tools

Building Powerful Lookups to Track and Find Your Data

Using Array Formulas to Solve Multi-Step Data Problems in One Formula

Using PivotTables and Pivot Charts to Create Advanced Reports

Additional Class Information

Prerequisites for our advanced Excel training.

Class time, manual, and repeats.

If you need to contact us about our class.

Phone Number: 1.805.498.7162

Business Hours: Mon-Fri 8:00 AM - 7:00 PM CT

You can email us at info@emagenit.com >

Form >
Need Help? Please call us at 1.805.498.7162

Copyright © 2002-2023

EMAGENIT All Rights Reserved