0

Excel: Master the Latest & Greatest Functions

TheExcelTrainer No Comments 3 likes Lessons

Content Restricted

Sign up for MPUG Membership to view this on-demand webinar and get unlimited access to our Webinars

Event Description:

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

Ensure your skillset remains at the forefront of technological advancements with these essential, transformative functions that redefine what’s possible in Excel.

Learning Objectives:

  • Generate sequences: SEQUENCE
  • Select specific rows and columns from a range: CHOOSECOLS, CHOOSEROWS and TAKE
  • Combine and merge data: VSTACK and HSTACK
  • Manipulate text: TEXTSPLIT, TEXTBEFORE and TEXTAFTER

PMI PDUs: 1 Ways of Working, 0 Power Skills, 0 Business Acumen

Related Content

Written by TheExcelTrainer
Mike Thomas has worked in the IT training business since 1989. He is a subject matter expert in a range of technologies, his primary focus and passion being Microsoft Office (especially Excel) and Power BI. In 2012 Mike founded The Excel Trainer where he has produced nearly 200 written and video-based Excel tutorials. He has recorded several Excel training courses for Pluralsight and in his career delivered thousands 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.
Share This Post
Have your say!
30

Leave a Reply