Excel - Master the Latest & Greatest 365-Only Functions

Tuesday,
April 9, 2024
Time:
10:00 AM PDT | 01:00 PM EDT
Duration:
90 Minutes
Webinar Id:
303743
Register Now
Price List
Live
Version
$149. One Participant
$299. Group Attendees
Recorded Version
$199. One Participant
$399 Group Attendees
Combo Offers
Live + Recorded
$299 $348   One Participant
$599 $698   Group Attendees

Group Attendees: Any number of participants

Recorded Version: Unlimited viewing for 6 months ( Access information will be emailed 24 hours after the completion of live webinar)

Overview:

Elevate your Excel prowess with this training. Aimed at users already versed in Excel's core functions (SUM, X/VLOOKUP, COUNTIF etc), this course introduces users to some of the new innovative functions added since 2020, exclusively available to Microsoft 365 and Excel 2021 users

These cutting-edge tools are designed to streamline your formula creation process, enhance your data interaction, and expand your analytical capabilities. Embrace the simplicity of extracting unique values, sorting and filtering datasets, creating dynamic, self-updating lists and much more!

Whether you’re looking to improve efficiency, accuracy, or both, these features will set you on a path to becoming an Excel ninja. Ensure your skill set remains at the forefront of technological advancements with these essential, transformative functions that redefine what's possible in Excel.

Areas Covered in the Session:
  • UNIQUE: Extract Distinct Values with Ease. Tired of dealing with duplicate data in your Excel sheets? With the UNIQUE function, you can effortlessly extract distinct values from your datasets. Say goodbye to manual filtering and data cleaning, and hello to a more efficient way of handling your information
  • FILTER: The FILTER function empowers you to refine your data with precision, allowing you to quickly and accurately extract specific subsets of information from your datasets, saving you valuable time and ensuring your analysis is based on the most relevant data
  • SEQUENCE: Automatic Ordered Lists. Creating ordered lists can be a tedious task, but not anymore. SEQUENCE enables you to generate ordered lists automatically, saving you valuable time. Whether it's dates, numbers, or any custom sequence, you'll master the art of list creation effortlessly
  • SORT & SORTBY: Effortless Data Arrangement. Data arrangement doesn't have to be a hassle. With SORT and SORTBY functions, you'll discover the easiest way to sort your data. Whether it's numbers, dates, or custom criteria, we'll show you how to arrange your information like a pro
  • CHOOSECOLS & CHOOSEROWS: Sometimes, you need to work with specific data segments. CHOOSECOLS and CHOOSEROWS functions empower you to do just that. Learn how to select columns or rows based on your criteria, streamlining your data analysis process
  • TEXTSPLIT, TEXTBEFORE, and TEXTAFTER: Text Data Mastery. Text data manipulation is a breeze with TEXTSPLIT, TEXTBEFORE, and TEXTAFTER functions. Whether you need to split text into separate elements or extract specific parts of a text string, you'll gain the skills to handle text data like never before
  • VSTACK: Seamless Array Merging. When you need to merge arrays vertically, VSTACK is your go-to function. Discover how to combine data from different sources or consolidate information effortlessly. With VSTACK, you'll achieve data integration without the headaches

Who Will Benefit:
  • This intermediate-level training is tailored for Excel users eager to learn the cutting-edge functions exclusive to Microsoft 365 subscribers and Excel 2021 users. Prior to attending, confirm with your IT department whether your subscription includes these features
Instructor:

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 He founded theexceltrainer.co.uk where he has produced nearly 200 written and video-based Excel tutorials. He has recorded several Excel training courses for pluralsight.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 organisations 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.


Recently Viewed