Guaranteed to be Good
All training experiences include a 7-day 100% money-back guarantee.
Excel Formulas and Functions 101
Summary
Microsoft Excel has hundreds of formulas and functions. Therefore, experienced users still find themselves asking if they could be working more efficiently in Microsoft Excel.
Don’t waste any more time clicking around in Excel, trying to find the right tools needed to get your work done professionally and on time.
Join us for this 90-minute interactive instructor-led training to get more done in less time and build foundational Excel skills.
You’ll learn:
- Steps to create formulas to automate calculations (add, subtract, multiply and divide)
- Popular aggregate functions to analyze your data like a pro
- Easy solutions for simplifying long-winded formulas
- How to avoid common “copying formula pitfalls”
- Expert methods to verify formula accuracy
- BONUS - All attendees will receive the following Quick Reference e-Guides:
- Excel Shortcut Favorites
- A Quick Guide to Formulas
- A Quick Guide to Functions
- A Guide to Absolute Cell References
Topics Covered
- How to create formulas quickly and easily from scratch
- Formulas v Functions – what is the difference?
- Auditing tools that verify accuracy of results
- The role that absolute and relative values play in formulas (one mix-up could make your whole sheet inaccurate)
- Auto Calculate feature (it does exactly what it sounds like!)
- Real-life scenarios where IF Functions will save you time
- SUM, AVERAGE and COUNT functions to speed up your work (total game-changer when working with large data)
- CONCATENATE – combine text from multiple cells
- SORT and UNIQUE – Manipulating Lists
- And more!
About the Speaker
Mike Thomas is a Fellow of The Learning and Performance Institute and has worked with plus for a large number of global organizations.
- Mike also designs and develops Microsoft Office-based solutions that automate key business processes.
- Mike will show you how to let Excel and other Microsoft programs solve your problems for you!
Program Benefits
It’s perfectly possible to use Excel without ever creating a formula or using a function - but if you don’t - you’re missing out on a HUGE part of the application’s power.
Without them, you waste much time doing manual work and correcting worksheets filled with errors (IF you’re lucky enough to catch them).
This interactive training will not only save you time, but push you forward in your career to be able to make informed, strategic decisions every day.
Purchase this On-Demand Workshop
Excel Formulas and Functions 101
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.
