Microsoft Excel Class Guide

See how we can boost your Excel skills.

Three ways to train you.

All of our classes below are available in the following training options.

Virtual: We can train you live, hands-on over the web >.

In-Person: We can train you in person, hands-on at a public class >.

Onsite: We can train your company live or virtually >.

How to select and signup for an Excel class.

Use the following 4 steps when looking at our Excel classes below. If you have any questions please give us call at 805.498.7162 or you can use our contact form >.

	Choose a training category: Business / Industry > or Engineering / Science >. Our classes below are organized by these groupings.
	Determine if you want to learn general Excel (formatting, formulas, functions...) or Excel VBA macros (programming). General classes do not have VBA in their titles.
	Read the desired class syllabus and its prerequisites section by clicking a class below. Also look at the skill level for the class to determine if it is right for you. The classes below will mark their level in the title and/or details section.
	Choose a training type: virtual, in-person, or onsite. For virtual and in-person, you will choose which one when you signup on the Signup > page. All class pages will lead you directly to their signup. For onsites, please contact us directly.

Business and Industry Classes

Our Excel business and industry classes below are organized from the Excel essentials to the most advanced Excel VBA topics (top-left to bottom-right). They cover a wide range of Excel topics that can be readily applied to industry fields like accounting, inventory, human resources, logistics, project management, production, data analysis...and much more.

Key Excel topics covered in our classes include formulas, logic, functions, formatting, worksheet assembly, PivotTables, Power Query, automated reports, data processing, VBA macros, and much more. Join us and we will show you how to use Excel in innovative ways to solve your problems fast. View our tutorial on Excel VBA automation >.

Beginning Excel
for Business and Industry

1-day. Learn how to use Excel's basic features and develop the problem solving skills needed to quickly perform your everyday workplace tasks. Prerequisites >

Level: Beginning >

Intermediate Excel
for Business and Industry

1-day. Use Excel's powerful data, function, formula, and reporting features to perform calculations, process data quickly, and make reports. Prerequisites >

Level: Intermediate >

Advanced Excel
for Business and Industry

1-day. Use Excel's advanced querying, formula, visual, and data capabilities to build calculation and reporting tools that automatically update. Prerequisites >

Level: Advanced >

Excel Dashboards for Business and Industry

Excel Dashboard Design
for Business and Industry

3-day. Assemble Excel's built-in features in innovative ways to create dashboards that track, integrate, and visualize data the way you need. Prerequisites >

Level: Intermediate / Advanced >

Beginning Excel VBA
for Business and Industry

2-day. Build effort saving Excel VBA tools that automate your everyday Excel tasks, format data, perform calculations, and process data. Prerequisites >

Level: Beginning Programming >

Excel VBA Data Processing
for Business and Industry

2-day. Learn to create powerful data tools in Excel VBA that quickly process, integrate, and report data from multiple sources, files, and folders. Prerequisites >

Level: Intermediate Programming >

Advanced Excel VBA
for Business and Industry

3-day. Learn to command the advanced abilities of Excel VBA and userforms to create interface driven data processing, analysis, and dashboard tools. Prerequisites >

Level: Advanced Programming >

Engineering and Science Classes

Our Excel engineering and science classes below are organized from the must know Excel fundamentals to advanced Excel VBA macro solutions (top-left to bottom-right). Our classes cover a variety of topics related to engineering and science including problem formulation, modeling, numerical analysis, optimization, data processing, technical drawing, automated reporting, dashboards, data integration...and much more.

Key Excel topics covered include formulas, form design, conditional formatting, data validation, advanced logic, technical charts, curve fitting, PivotTables, PowerQuery, VBA and that's just for starters. Join us and we will show you how to unleash Excel to rapidly create the tools you can only imagine. View our tutorial on Excel VBA automation >.

Microsoft Excel
for Engineers and Scientists

1-day. Learn to harness Excel's powerful calculation, charting, display, and UI abilities to build problem solving tools Includes LAMBDA discussion. Prerequisites >

Level: Beginning / Intermediate >

Excel Data Analysis
for Engineers and Scientists

1-day. Learn to combine Excel's external querying abilities, functions, and data tools to integrate / analyze data and build automated reports. Prerequisites >

Level: Intermediate / Advanced >

Excel VBA
for Engineers and Scientists

2-day. Learn the fundamentals of using Excel VBA to automate calculations, perform data processing, model, and create rapid reporting tools. Prerequisites >

Level: Beginning Programming >

Excel VBA Data Analysis
for Engineers and Scientists

2-day. Learn to design scalable Excel VBA data tools that analyze, format, integrate, and report data from multiple sources, files, and folders. Prerequisites >

Level: Intermediate Programming >

Advanced Excel VBA Design for Engineers and Scientists

Advanced Excel VBA
for Engineers and Scientists

3-day. Learn about Excel and VBA's extensive UI capabilities and create powerful interface driven data processing, modeling, and analysis apps. Prerequisites >

Level: Advanced Programming >

Interfacing Excel VBA with Fortran for Engineers / Scientists Outline

Mixed Language Programming
with Excel VBA / Fortran

3-day. Learn to combine the interface and data abilities of Excel VBA with the speed of Fortran DLLs to create powerful modeling and analysis tools. Prerequisites >

Level: Intermediate / Advanced Programming >

About our skill levels.

Our classes teach not only how to use Excel's many features, but solve different problems with them as well. Our skill levels are based on the Excel features presented as well as the type of problems solved in the class.

Beginning	Class covers the fundamental features of Excel or Excel VBA and the solutions for typical problems that will be encountered.
Intermediate	Class covers the more sophisticated features of Excel or Excel VBA and the strategies of how to combine and build solutions with them.
Advanced	Class covers the complex features of Excel or Excel VBA and how to assemble them to build adaptive automated problem solutions.

*More than 1 level for a class indicates the skill levels covered throughout the class.

Microsoft Excel class guide.

See how we can boost your Excel skills.

Three ways to train you.

How to select and signup for an Excel class.

Business and Industry Classes

Beginning Excelfor Business and Industry

Intermediate Excelfor Business and Industry

Advanced Excelfor Business and Industry

Excel Dashboard Designfor Business and Industry

Beginning Excel VBAfor Business and Industry

Excel VBA Data Processingfor Business and Industry

Advanced Excel VBAfor Business and Industry