Intermediate Excel for Business and Industry - Class

Learn to harness Excel’s calculation, data processing, and reporting abilities to solve problems. Use formulas and functions, build charts, filter data, and create PivotTables.

Next Class: Check Dates

Intermediate Microsoft Excel Training

How our class will boost your Excel skills.

Boost Advanced Excel VBA Training

Our 1-day class shows you how to start harnessing Excel’s calculation, data processing, and reporting abilities. It covers essential topics like building key formulas, linking worksheets and workbooks, and organizing data in Excel tables for quick analysis.

In addition, our training shows how to use worksheet functions to perform table lookups; sum and count data; parse dates and text; and make logic decisions.

Also covered is how to use various table filters; build professional charts; and create powerful PivotTable 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
  • Laying out your problems, entering data, and building formulas on the worksheet
  • Building and using worksheet and Excel tables to store data
  • Using Data Validation to control worksheet data entry in problems, forms, and tables
  • Using Conditional Formatting to automatically flag data based on logic
  • Filtering, sorting, and grouping worksheet data to make reports
  • Looking up and merging worksheet data using the lookup functions
  • Using logic to summarize and count worksheet data
  • Making decisions in your formulas using the IF function
  • Analyzing date time worksheet data using the date functions
  • Importing text file data to the worksheet using Text Wizard
  • How to parse, clean, and combine worksheet text using the text functions and string concatenation
  • Creating and formatting industry grade charts
  • Building basic PivotTables / Pivot Charts to rapidly summarize data

Some key topics we cover in class.

Intermediate 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

Problem Layout, Entering Data, and Building Formulas on the Worksheet

Building Tables to Store Data

Using Data Validation to Control Problem Input

Filtering, Sorting, Grouping, and Flagging 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 Charts

Creating Basic PivotTables / Pivot Charts to Rapidly Summarize Data

Additional Class Information

Prerequisites for our Excel training.

Class time, duration, 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