Business professional working on a laptop using Microsoft Excel

Instructor-Led Training

Advanced Microsoft Excel Techniques

You may use Microsoft Excel daily, or maybe only casually, but one thing’s for sure — you’ve probably wished you knew more about this dynamic program. That’s why you’ll want to attend this two-day Excel workshop. In it, you’ll learn ways to make your job easier and increase the sophistication of your data reporting and analyzing. Each Excel advanced training session focuses on saving-you-time techniques, advanced “how-to’s,” exploring those previously “programmer only” features and more. Along with this practical and usable training, you’ll learn how to integrate your work within the Office suite for even greater results. If you’ve ever been frustrated using Excel because you knew there had to be a better way of accomplishing your tasks, you’ll soon be on your way to getting more done — more efficiently — with this power-boosting workshop. Enroll today!

For an optimal experience with this course, we recommend Excel 2016 and later. Windows platform preferred.

Course Outcomes

Time-saving techniques that’ll allow you to get your work done faster with Excel
Effectively utilize charts to visually communicate your data
Build interactive forms with Excel, ensuring data quality with forms controls
Use built-in visualizations to communicate data effectively
Efficiently analyze data and make recommendations using Scenario Manager, Goal Seek and other tools
And much more!

Course Agenda

Instructor-Led Training

Print Agenda

Session 1: Time-Saving Techniques — Understanding Essential Power Shortcuts and Functions

Session 2: Charting Essentials

Session 3: Mastering Forms, Form Objects and Templates

Session 4: Data Visualization Techniques

Session 5: Powerful Data Analysis Tools

Use formula auditing tools when you’re the original author of a workbook
Experiment with different inputs and compare the outputs using Scenario Manager
How to work backwards from a desired result using Goal Seek
Harness the Solver to help schedule employees while controlling payroll
Use the Descriptive Statistics tool to calculate details about a population of numbers instead of writing many formulas
Forecast sales and expenses based on historical patterns using the Forecast tool and Excel’s Analysis ToolPak

You’ll also receive the Microsoft Excel for Office 365 Tool Kit, a robust reference guide containing helpful shortcuts and a glossary of Excel terms.

Request group training

Complete the form below to request tailored, private training for your team. We’ll be in touch to discuss your group’s specific goals.

More Courses in

Instructor-Led Training Business & Technology

Related Courses