Intermediate Microsoft Excel Training
for Business

Since 1998

In Person / Live Online

Next Date: Click Dates|Signup

All Dates | Signup

*Our live, hands-on, instructor led Excel online training is running as scheduled above. Public in person training resumes on 8/1.

Supercharge your formula and data analysis skills in Excel.

Our intermediate Excel training shows you the skills that you need to start analyzing, processing and modeling business information using a whole host of Excel tools, functions and formulas.

Questions? 1.805.498.7162   Customers >

Excel Worksheet Layout
Scroll Picture > > >
< 1 > Delete

Take a tour of our intermediate Microsoft Excel training.

Take Visual Tour

Take a visual tour of our class.

Download Visual Tour

Download the visual tour in PDF form.

Our 1-day intermediate Excel training will show you how to effectively use Excel to process business data. Key topics include cell and range naming, building formulas using functions like VLOOKUP, COUNTIF, SUMIF and IF; linking and managing worksheet information; organizing and analyzing worksheet data with Excel's data tools and functions; building professional charts; building basic Pivot Tables and Pivot Charts; cleaning worksheet text and working with text files; and linking Excel to other programs like Word and PowerPoint. Also discussed are the basics of creating and organizing models on the worksheet.

The skills you need for our intermediate training.

Select this intermediate Excel training if you or your group:

Our intermediate Microsoft Excel training syllabus.

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

Intermediate Excel Review of Worksheet Formulas, Cell Naming and Sheet Linking

Using Data Validation to Control Your Worksheet Data Entry

Key Things Intermediate Excel Users Need to Know About Building Tables on the Worksheet

Worksheet Formatting and Form Construction

Key Worksheet Function Review for the Intermediate Excel User

Key Lookup Worksheet Functions for the Intermediate Excel User

Key Logical Worksheet Functions for the Intermediate Excel User

Essential Data Analysis Worksheet Functions for the Intermediate Excel User

Must Know Text Analysis Techniques for the Intermediate Excel user

Using the Group, Advance Filter and Sort Tools on Your Worksheet Tables

Using Conditional Formatting to Flag Your Data

Creating Business Charts

How to Create Pivot Tables and Pivot Charts on the Worksheet

Linking Excel with Word and PowerPoint

The details about our intermediate Excel training.

Microsoft Excel Business Essentials Self Study Manual
Learn More >
Excel-Aided Engineering Self Study
Our full EAB manual is free with our training.

If you need to contact us about our intermediate Excel training.

Contact us directly through email or phone.

Contact us by form.

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

Microsoft Excel Products

- Excel Self-Study Manuals

Copyright © 2002-2020

EMAGENIT All Rights Reserved