![](https://www.learnexcelnow.com/wp-content/uploads/2021/06/Image-5.png)
10 Essential Excel Functions You Need to Know to Increase Productivity
Summary
This program is designed to unlock the power of Excel's most popular productivity-boosting functions. Master these ten essential functions and you'll find yourself overcoming challenges, automating tasks, improving efficiency, and drastically reducing your time spent on manual data management processes.
Gain must-have skills and join us for this hands-on training to discover:
- The logic behind Excel’s efficiency boosting functions
- Ways to manage & quickly manipulate list-based data
- Solutions for automating tasks & improving productivity
- How to streamline data analysis for better decision making
Program Highlights
We’ll provide demonstrations of the following functions, including an overview of each, plus specific use-cases.
- IF: Automate data entry in a snap
- COUNTIFS: Count how many times a particular value (date, number, text) appears within a range (how many times has Customer X paid late?)
- SUMIFS: Add a set of numbers that match a criteria (what was the total number of hours worked on for Project 123?)
- IFERROR: Want to get rid of those ugly #DIV/0 and #N/A errors? IFERROR is your friend
- XLOOKUP: Often referred to as "VLOOKUP on steroids" - XLOOKUP is the new kid in town!
- UNIQUE: Quickly generate a unique list of items in a single step
- FILTER: Quickly generate a dynamic list of filtered items with this powerhouse of a function
- SORT: Quickly generate a sorted list of items - combine the SORT function with the UNIQUE function for extra power!
- GETPIVOTDATA: If you ever need to refer to a cell inside a pivot table - the GETPIVOTDATA function has you covered
- SUBTOTAL: If you need to generate a total, count, or average from filtered data In the Table - the SUBTOTAL function is just what you need
Additional tools:
- Your questions & specific use-cases will be addressed in real-time, all throughout the event
- A 15-minute question & answer, plus wrap-up & review session
Program Benefits
By the end of the training, you’ll be equipped to leverage these ten Excel functions to their fullest. Walk away prepared to transform your Excel workbooks into powerful tools for data analysis, management, and decision making!
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!
About The Speaker
![](https://www.learnexcelnow.com/wp-content/uploads/2021/06/Mike-Thomas-297x300.jpeg)
Mike Thomas
"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. Mike has produced nearly 200 written and video-based Excel tutorials, and... hundreds of courses and webinars on a wide variety of technology-related topics.
Mike is a Fellow of The Learning and Performance Institute and has worked with and for a large number of 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."