Intermediate Excel for Business and Industry - Class

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

Intermediate Microsoft Excel Training

Explore Excel's formula and data processing potential.

Class overview.

Our live, hands-on, 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 layout your problems and 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 and function topics like how to use logic to summarize and count data and how to perform table lookups using VLOOKUP, XLOOKUP, and INDEX.  Also discussed is how use logic to make decisions in your formulas and analyze dates, times, and text using various functions.

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.

Some key topics we cover in class.

Customers
View Customers >

Prerequisites for our Excel training.

Newsletter Signup
Newsletter Signup >

Class time, duration, manual, and repeats.

Class syllabus, training, and price options.

Virtual Signup

View the dates and signup for our hands-on live virtual training.
Virtual Signup: $150.00 >

Public Signup

View the dates and signup for our hands-on in-person public training.
In-Person Signup: $190.00 >

Manual Information

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

Onsite Details

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

Class Syllabus

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

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