Home > Excel Class Guide > Intermediate Excel

Intermediate Excel Class for Business and Industry

Intermediate Microsoft Excel Training

Learn to use tables, formulas, functions, and Excel's data tools to quickly perform calculations, analyze data, and create reports.

  • Our 1-day class shows you how to start harnessing Excel’s powerful calculation, data processing, and reporting abilities.
  • It covers 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 and much more >.

Next Class: 12/06/2022

More Dates >

Black Friday Sale

See the must know topics you will learn.

See What You Master

No time to attend, get a manual instead.

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. Learn More >
  • Buy a manual now, apply the price towards a class later. Manuals are included with our classes.

Key Excel topics covered in class.

Intermediate Excel Preview

Class examples.

Pricing and class options.

virtual learning

Online Virtual Learning

  • Live, hands-on, talk to the instructor training
  • Bring your own problems to class
  • Online Details >
Dates / Signup >
virtual learning

Public In-Person Learning

  • Live hands-on training
  • Bring your own problems to class
  • We can supply a computer
Dates / Signup >
corporate learning

Onsite Hands-On Learning

  • We come to you and solve your problems
  • We cover in person in the USA and Canada
  • We cover the world virtually using your time zone
Details >

Detailed 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 Syllabus

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

Additional Classes:
Beginning Excel
for Business / Industry
Intermediate Excel
for Business / Industry
Advanced Excel
for Business / Industry
Excel Dashboard Design
for Business / Industry
Beginning Excel VBA
for Business / Industry
Excel VBA Data Processing
for Business / Industry
Advanced Excel VBA
for Business / Industry
Learn the key Excel topics and problem solving skills you need to quickly accomplish everyday Excel workplace tasks. Learn to use tables, formulas, functions, and Excel's data tools to quickly perform calculations, analyze data, and create reports. Learn about Excel's advanced querying, formula, and data processing capabilities and use them to build automated calculation and reporting tools. Learn to assemble Excel's pre-made features to create powerful hi-tech dashboards that integrate, analyze, and visualize your data. Learn to build time-saving Excel VBA tools that automate common data processing, calculation, and formatting tasks in seconds. Learn to create powerful data tools in Excel VBA that quickly process, integrate, and report data from multiple sources, files, and folders. Learn to command the advanced abilities of Excel VBA and userforms to create interface driven data processing, analysis, and dashboard tools.

Excel skills needed for our class.

Select this Excel training if you or your group have:

  • Opened and saved a workbook file
  • Copied and pasted worksheet data
  • Performed basic cell formatting tasks like coloring a cell, bolding, aligning...
  • Typed data in worksheet cells
  • Built basic formulas like =A1+A2 and know how to use cell references
  • Used a worksheet function like =Sum(A1:A10) in a formula or have seen it before

The class details.

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 >

Contact us by form.

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

Copyright © 2002-2022

EMAGENIT All Rights Reserved