Home > Excel Class Guide > Intermediate Excel
Intermediate Microsoft Excel Training

Intermediate Excel for Business & Industry

Use the power of Excel to quickly solve problems and analyze data! Learn to use tables, formulas, functions, and Excel's data tools to quickly perform calculations, analyze data, and create reports.

Next Class: Check Dates

  • Live, Hands-On
  • Industry topics
  • Bring your problems
  • Limited class size
Dates / Sign Up >

Class overview.

Our 1-day class shows you how to start harnessing Excel’s powerful calculation, data processing, and reporting abilities. It covers the must know Excel skills like how to build worksheet tables; filter data for reports; control what you type in a cell; report data with PivotTables; and make professionally formatted charts. Our class also covers important formula / function topics like how to summarize and count data; perform table lookups; use logic to make formula decisions; and parse dates / text. Join us and our class will show you how to use Excel in new ways that will allow you to complete your work tasks rapidly.  Key Topics >

Holiday Sale

Key Topics


Some key topics we cover in class.

See What You'll Learn!
See What You Master

Some Class Examples

Intermediate Excel Preview

Can't Attend? Get the Manual.


Covers the Excel topics, strategies, and methods needed to solve your Excel workplace tasks quickly.

  • Our manual is a combination of beginning, intermediate, and advanced Excel topics and also covers hi-tech dashboard design.
  • Covers everything from typing data to using functions and formulas to automated reporting using Power Query, Excel tables, and Pivot Tables.
  • Also discusses must know topics like problem organization; using names to pass data efficiently; and data processing.
  • 100's of real world examples included.
  • Buy the manual now and apply its price to a class later. Just let us know when purchasing a class. The manual comes with the class.
See the Manual >

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

Laying Out Problems, Entering Data, and Building Formulas on the Worksheet

Building Worksheet and Excel Tables to Store Data

Using Data Validation and Conditional Formatting to Control and Flag Data

Filtering, Sorting, and Grouping Worksheet Data to Make Reports

Performing Table Lookups and Merging Worksheet Data

Using Logic to Make Decisions in Your Formulas

Using Logic to Summarize and Count Worksheet Data

Analyzing Dates and Times in Your Worksheet Data

Importing, Parsing, and Cleaning Text Data on the Worksheet

Creating and Formatting Industry Grade Charts

Creating Basic PivotTables / Pivot Charts to Rapidly Summarize Data


Required Class Skills


Select this Excel training if you or your group have:


Class Details


Duration, #days, and audience details about our class.


Contact Us


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 >

Click to View Form
Need Help? Please call us at 1.805.498.7162

Copyright © 2002-2022

EMAGENIT All Rights Reserved