Intermediate Microsoft Excel Training

Since 1998

Intermediate Microsoft Excel Training

Business Professionals

Click Dates|Signup
All Dates | Signup

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 >

We cover Excel for Mac.

Learn More >

 Excel for Mac Training

US Military, DOD Discounts

Learn More >

EMAGENIT US Military Discounts
Excel Worksheet Layout
Back Forward
> > > >

About our intermediate Microsoft Excel training.

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.

Over 20+ years of Excel training experience.
Our Excel training covers what you need to succeed. How do we know? We use the same knowledge to design software for customers like NASA and BMW.
Microsoft Excel Essentials for Engineers and Scientists

The key skills learned in our intermediate Excel training.

Key intermediate Excel skills learned:

Did you know you can take this training live online?
Can't make the public event, no problem, we broadcast it as a live, hands-on webinar. Use the All Dates | Signup button above to take the online webinar. Learn more >
Excel Online Webinars

The skills you need for our intermediate training.

Select this intermediate Excel training if you or your group:

Free repeats with our Excel training.
All of our Excel training comes with Free Repeats. Our Excel classes have a lot to learn in them. Learn more >
Microsoft Excel Training Free Repeats

The topics covered in our intermediate Microsoft Excel training.

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

Having trouble deciding on a class?
We have a page that can help. Learn more about our classes on our Excel Classes Guide and Skills page. >
Microsoft Excel Essentials for Engineers and Scientists

The details about our intermediate Excel training.

  • Audience:   Business professionals
  • Duration:   8:30 AM - 4:30 PM
  • # of Days:   1-day
  • Instruction Type:   Hands-on, live, instructor taught training
  • Manual Included:   2200 + page Microsoft Excel Aided Business manual full of Excel tips, how-to-do topics and Excel examples included with the training
  • Excel Versions   2007-2016, Office 365, Windows and Mac
  • Free Repeats:   Repeat your Excel training as many times as you like, no date or limit
  • Personal Examples:   We review our attendees personal examples in our training instruction
  • Available Training Formats:
Microsoft Excel Business Essentials Self Study
Learn More >
Excel-Aided Engineering Self Study
Our full manual is free with our training.

More Training Options

Public / Online Events

Public Events
Schedule / Signup
Beginning Excel Training for Business Professionals Advanced Excel Training for Business Professionals Beginning Excel VBA Training for Business Professionals Intermediate Excel VBA Training for Business Professionals Advanced Excel VBA Training for Business Professionals Microsoft Excel Dashboard Training for Combined Audience Microsoft Excel-Aided
Business
Upcoming 2018 Excel Public Events Schedule
Beginning Excel Training for Business
Next Date:
See Schedule
Advanced Excel Training for Business
Next Date:
See Schedule
Beginning Microsoft Excel VBA Training for Business
Next Date:
See Schedule
Intermediate Microsoft Excel VBA Training for Business
Available Onsite Only
Advanced Microsoft Excel VBA Training for Business
Next Date:
See Schedule
Microsoft Excel Dashboard Training
Next Date:
See Schedule
Microsoft Excel-Aided Business
Available Onsite Only

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
Facebook Contact Us Newsletter
Need Help? Please call us at 1.805.498.7162

Excel Software Design/Consulting

- Microsoft Excel Software

- Microsoft Excel Consulting

Microsoft Excel Products

- Excel Self-Study Manuals

Copyright © 2002-2019

EMAGENIT All Rights Reserved