Learn Excel Now

Conquer the Fear of Excel

  • Home
    • Our Team
  • Training
    • Custom Training
      • Custom Virtual Group Training
      • Custom Onsite Group Training
      • Consulting Services
    • Excel
    • MS Office
    • Outlook
    • PowerPoint
    • Word
    • OneDrive
    • Google
  • All-Access
  • eLearning
    • Excel Foundations
    • Micro Courses
      • Simply Excel
      • Simply Excel Pt. II
  • Resources
    • Contact
    • FAQ
    • New User Onboarding
  • Login

10 Essential Excel Functions You Need to Know to Increase Productivity

Share

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

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.

Mr. 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

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!

Purchase this On-Demand Workshop

10 Essential Excel Functions You Need to Know to Increase Productivity

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.
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.
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.
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.
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.
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.
Add To Cart

Guaranteed to be Good

All training experiences include a 7-day 100% money-back guarantee.

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.

Purchase This On-Demand Webinar

10 Essential Excel Functions You Need to Know to Increase Productivity

On-Demand $199 + applicable taxes
3 Workshop Bundle $300 + applicable taxes
One-year subscription (All Access Membership) $699 + applicable taxes
Add To Cart

Guaranteed to be Good

All training experiences include a 7-day 100% money-back guarantee.

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.

Learn Excel Now helps you conquer the fear of Excel. By providing self-paced and instructor-led training and free strategies and guides, we leave no Excel mystery unsolved.

  • Home
  • Training
  • All-Access
  • Excel Foundations
  • Resources

Connect with Us

  • Facebook
  • Linkedin

Contact

Learn Excel Now
questions@learnexcelnow.com
1-484-259-7664 or 1-800-964-6033
660 American Ave
Suite 203
King of Prussia, PA 19406

Microsoft® Office Excel® is a registered trademark of the Microsoft Corporation in the United States and other countries. All rights reserved.

Copyright © 2023 ­Learn Excel Now

Terms of Service

Privacy Policy

Copyright © 2023 · News Pro Theme on Genesis Framework · WordPress · Log in

WELCOME BACK!

Enter your username and password below to log in

Forget Your Username or Password?

Reset Password

Lost your password? Please enter your username or email address. You will receive a link to create a new password via email.

Log In

All Access Subscription
Our 1-year all-access subscription provides step-by-step guidance for mastering Microsoft Office applications, with workshops, exercises and quick reference eGuides. It's perfect for anyone that needs to brush up on certain skills or even folks who need to learn the programs - from a beginner’s level.
Excel Foundations
Take the fear out of Excel with this 20 module self-paced training course. You will cover the most essential topics to develop a solid foundation of Excel or a lifetime of mastery.