Guaranteed to be Good
All training experiences include a 7-day 100% money-back guarantee.
Microsoft Excel: Advanced Training for Today's Top Professionals
Summary
In this 90-minute, instructor-led training, you will learn how to leverage all that Excel has to offer, by mastering its most advanced formulas, functions, shortcuts, and features. We’ll provide step-by-step guidance, plus powerful techniques for automating your data analysis and reporting processes.
Gain must-have skills and join us for this hands-on training to discover:
- Ways to combine data from multiple worksheets & quickly create a linked summary
- Next level filtering techniques, customization options & automation strategies
- How to create a macro, macro shortcuts, buttons, settings & more
- Advanced solutions for preparing, managing & analyzing reports
Program Highlights
Expert Level Formulas, Functions & Data Tools - You’ll Wish You Knew Sooner
- 3D formulas & Consolidate: Combine data from multiple worksheets & feed a linked summary
- What-if scenarios: record projections based on variables in a variety of fields, automatically
- Macros: Automate advanced filtering techniques & enable them for future use & sharing
- Build One and Two-Input tables & test how changes in two variables impact formulas
- Set objectives & targets: Produce results using Goal Seek and Solver
- Advanced dashboards for reporting, analysis & presenting data
- View live data on separate tabs with the Excel camera
Additional tools:
- Question, Answer, Review & Wrap-up Session
- Have your questions answered & gain solutions for specific challenges/use cases
- Interactive Lab
- You will practice what you've just learned with the expert
- The exercise file can also be used for post-event practice
Additional Materials
- A PowerPoint presentation
- An exercise file
About The Speaker
Mitzi Gibson Katz has trained thousands of end users and developed curriculum for over twenty-five years.
- As a consultant, she specializes in the Microsoft Office suite including Excel, Access, PowerPoint, Word, Outlook and much more.
- After teaching a variety of special education classes in Kansas, Montana, and Alaska for the early part of her career, Mitzi became interested in technology as the first personal computers were introduced to the market. She made the change in careers from public school education to private computer training and has been teaching students how to use software applications ever since.
- Mitzi helps students understand Microsoft Applications by her passion: "It's the people part of the business that keeps me involved.
Program Benefits
In this webinar, you will discover how to automate and streamline your work, making Excel your most powerful productivity tool ever!
If you'd like this program customized for your organization, call us at 1-800-964-6033.
We're certain we can fulfill your training needs, while making it fit in your budget!
Purchase this On-Demand Workshop
Microsoft Excel: Advanced Training for Today's Top Professionals
On-Demand $199 +
applicable taxes
more info
For the live training(s) you've selected:
You will receive access to the live event(s) which includes a copy of the speaker's presentation, real-time training with our expert instructor, and an interactive question & answer period. Two to three business days after each live training concludes, an email is sent to registrants which contains a link for unlimited access to the on-demand recording you can revisit & review.
You will receive access to the live event(s) which includes a copy of the speaker's presentation, real-time training with our expert instructor, and an interactive question & answer period. Two to three business days after each live training concludes, an email is sent to registrants which contains a link for unlimited access to the on-demand recording you can revisit & review.
For the on-demand training(s) you've selected:
You'll receive a link to access the recording(s) in your order confirmation email. On-demand recordings also include a copy of the speaker's presentation and the ability to submit your questions to the expert, for up to 7 days after viewing.
You'll receive a link to access the recording(s) in your order confirmation email. On-demand recordings also include a copy of the speaker's presentation and the ability to submit your questions to the expert, for up to 7 days after viewing.
3 Workshop
Bundle $300 +
applicable taxes
more info
Take advantage of our three workshop bundle to enhance your learning beyond the training you initially selected. Our workshop bundle allows you to select three workshops (Live or On-Demand) at a discounted price.
For the live training(s) you've selected:
You will receive access to the live event(s) which includes a copy of the speaker's presentation, real-time training with our expert instructor, and an interactive question & answer period. Two to three business days after each live training concludes, an email is sent to registrants which contains a link for unlimited access to the on-demand recording you can revisit & review.
You will receive access to the live event(s) which includes a copy of the speaker's presentation, real-time training with our expert instructor, and an interactive question & answer period. Two to three business days after each live training concludes, an email is sent to registrants which contains a link for unlimited access to the on-demand recording you can revisit & review.
For the on-demand training(s) you've selected:
You'll receive a link to access the recording(s) in your order confirmation email. On-demand recordings also include a copy of the speaker's presentation and the ability to submit your questions to the expert, for up to 7 days after viewing.
You'll receive a link to access the recording(s) in your order confirmation email. On-demand recordings also include a copy of the speaker's presentation and the ability to submit your questions to the expert, for up to 7 days after viewing.
One-year subscription (All Access Membership) $699 +
applicable taxes
more info
With this subscription, you will receive 1 year of unlimited access to our full library of on-demand trainings as well as priority access to trainings that are upcoming.
For the live training(s):
You will receive access to the live event(s) which includes a copy of the speaker's presentation, real-time training with our expert instructor, and an interactive question & answer period. Two to three business days after each live training concludes, an email is sent to registrants which contains a link for unlimited access to the on-demand recording you can revisit & review.
You will receive access to the live event(s) which includes a copy of the speaker's presentation, real-time training with our expert instructor, and an interactive question & answer period. Two to three business days after each live training concludes, an email is sent to registrants which contains a link for unlimited access to the on-demand recording you can revisit & review.
For the on-demand training(s):
You'll receive access to our full library of on-demand trainings along with the speaker's presentation and handouts for each event.
You'll receive access to our full library of on-demand trainings along with the speaker's presentation and handouts for each event.
Full-Team Pass
Simply share the invite link with your team so you can learn and grow together!
Yours Forever
The event recording and materials are yours to rewatch and share as you choose.
