Intermediate Microsoft Excel
for Business Training

Intermediate Microsoft Excel for Business Training
Play Video >

Since 1998

Close

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. Excel in person training will hopefully resume in the near future.

Learn the fundamentals of using Excel formulas, worksheet functions, and data tools to quickly analyze and report business data.

Our 1-day hands-on Excel training shows you how to use formulas, tables, Excel tables, names, key worksheet functions, filters, charts, and basic pivot tables to quickly analyze and report business data. It also shows you how to quickly link and update Excel data in Word and PowerPoint reports.

Questions? 1.805.498.7162   Customers >

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

About our intermediate Microsoft Excel training.

Our 1-day intermediate Excel training will show you how to effectively use Excel to process, analyze, and model business information. Key topics include:

The skills you need for our intermediate training.

Select this intermediate Excel training if you or your group have:

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.

 A Review of Formula Design, Data Entry, Cell References, Cell Names, Formatting, and Sheet Linking

Using Data Validation to Control Your Worksheet Cell Entries

Construction Rules for Worksheet Tables and Excel Tables Storing Business Data

How to Run Worksheet Functions in Formulas

Performing Table Lookups and Merging Business Data with Worksheet Functions

Using Logic Worksheet Functions to Make Decisions About Your Business Data

Using Logic to Summarize Business Data With SUMIFS, COUNTIFS...

Importing Text Files and Modifying Worksheet Text Data

Using Conditional Formatting to Flag Your Business Data Based on Logic

Filtering, Sorting, and Grouping Business Table Data to Make Reports

Creating and Formatting Business Charts

Creating Basic PivotTables / PivotCharts to Rapidly Summarize and View Business Data

Linking Excel with Word and PowerPoint to Quickly Build Business Reports

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