Guaranteed to be Good
All training experiences include a 7-day 100% money-back guarantee.
Microsoft Excel: Advanced Formulas & Logic Functions
Summary
If you’ve mastered the basic Excel formulas and functions but want to take your skills to the next level, join us, for a 90-minute workshop.
You will engage in real-time practice sessions led by our Excel expert while gaining step-by-step guidance for automating complex tasks, optimizing your time, minimizing errors, and MUCH more.
Gain must-have skills and join us for this hands-on training to discover:
- How to utilize Excel's logic functions to eliminate repetitive tasks
- The best practices to design immaculate, fluid & error-proof spreadsheets
- Ways to leverage Excel's most potent yet underexplored functions & formulas
- Essential tips & tricks for efficiently handling vast data sets & executing intricate data analysis
Program Highlights
Eradicate Errors, Automate Tasks & Make Data-Driven Decisions
- Ease the frustration of executing manual & repetitive Excel tasks
- Leverage the power of Excel for superior data analysis & report generation
- Enhance your ability to ensure no detail is overlooked, even in large datasets
Deep Dive into Excel Logic Functions & Advanced Formulas: Unlock the Secrets of Data Mastery
- Demystifying the IF function: Dynamic conditional calculations for versatile data analysis
- Harnessing the COUNTIF & COUNTIFS functions: Efficiently quantify specific criteria, such as overdue invoices
- Mastering the SUMIF & SUMIFS functions: Evaluate total values under particular conditions
- Navigating the IFERROR & IFNA functions: Enhance presentation by substituting standard error codes with customized messages
- Merging Logic functions: Integrate with VLOOKUP & other functions seamlessly
- Expanding Logic function applications: Incorporate into charts, pivot tables & more
Master the Art of Data Automation & Analysis
- Harness Excel's hidden arsenal of tools to boost your efficiency
- Dive into how logic functions can revolutionize repetitive task automation
- Unveil strategies for enhanced data analysis using Excel's diverse formulas & functions
Have questions during the session? Great!
- Our expert will be addressing questions all throughout the webinar to ensure a comprehensive learning experience
About The Speaker
Mike Thomas has worked in the IT training business since 1989. He is a subject matter expert in a range of technologies including Microsoft Office and Apple Mac.
- During his career, he has produced nearly 200 written and video-based Excel tutorials. He’s also delivered hundreds of courses and webinars on a variety of Excel topics.
- Thomas is a Fellow of The Learning and Performance Institute and has worked with and for many global and UK-based companies and organizations across a diverse range of sectors.
- In addition to training, he also designs and develops Microsoft Office-based solutions that automate key business tasks and processes.
Program Benefits
In this webinar, you will discover how to master Excel's advanced formulas and functions, to improve your efficiency, and elevate your expertise to confidently address complex data challenges.
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 Formulas & Logic Functions
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.
