Excel - Master the Latest & Greatest 365-Only Functions

Mike Thomas
Instructor:
Mike Thomas 
Duration: 90 Minutes
Webinar ID: 72533

More Trainings by this Expert

Price Details
Recorded Webinar
$199 One Attendee
$399 Corporate Recorded

Recorded: Access recorded version, only for one participant unlimited viewing for 6 months ( Access information will be emailed 24 hours after the completion of live webinar)

Corporate Recorded: Access recorded version, Any number of participants 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


Speaker Profile
Mike Thomas - In a career spanning over 30 years, Mike Thomas, a UK-based IT Trainer, has delivered thousands of courses and produced hundreds of written and video-based tutorials.

He is a subject matter expert in a range of technologies on the Windows and Mac platforms however his primary focus and passion is Microsoft Office and Power BI.

Mike is a Microsoft MVP and a Fellow of The Learning and Performance Institute and has worked with and for many global and UK-based companies and organisations across a range of industries including healthcare, pharmaceutical and public sector.

In addition to training, he also designs and develops Microsoft Office-based solutions that automate key business tasks and processes


You Recently Viewed

Subscribe to our Newsletter