Excel – 10 Must-Know Functions to Boost Your Productivity
  • CODE : MITH-0030
  • Duration : 90 Minutes
  • Level : Intermediate
  • Add To Calendar
  • Refer a Friend

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. In 2012 Mike founded excel trainer.co.uk where he has produced nearly 200 written and video-based Excel tutorials. He has recorded several Excel training courses for plural sight.com and in his career delivered 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.

Microsoft Excel contains almost 500 built-in worksheet functions. Strip away the ones nobody uses. Discount the ones that have a specialized use-case and you’re left with a small set of functions that all Excel users should know, regardless of their job function, industry, or business sector. This webinar covers ten of Excel’s most popular productivity-boosting functions.

Areas Covered

  • IF: Automate data entry…if this condition is true, enter this value into a cell else enter that value into a cell
  • COUNTIF: Count how many times a particular value (date, number, text) appears within a range (e.g. how many times was Customer X a late payer?)
  • SUMIF: Add up a set of numbers that match a criteria (e.g. what was the total number of hours worked on 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, making searching for data in a tabular list quick, simple and straightforward
  • UNIQUE: Quickly generate a unique list of items in a single step
  • FILTER: Quickly generate a dynamic list of filtered items
  • 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: Storing list-based data in a table is best practice. But what if you need to generate a total, count or average from filtered data In the Table? The SUBTOTAL function is just what you need

Course Level - Intermediate

Who Should Attend

This training is categorized as intermediate. It is aimed at users who want to learn about the commonly-used worksheet functions in Excel. Although the training will be delivered using the latest version of Excel, this training is relevant for users of all versions of Excel


  • $149.00



Webinar Variants


contact us for your queries :

740-870-0321

support at grceducators.com