Master new Excel functions - boost efficiency, accuracy, and analytics like a pro.
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 re-define what’s possible in Excel.
Learning Objectives
- You will be able to extract distinct values with ease.
- You will be able to review how create automatic ordered lists.
- You will be able to explain how to create effortless data arrangement.
- You will be able to utilize text data mastery.
Agenda
- UNIQUE: Extract Distinct Values With Ease
- FILTER: Empowers You to Refine Your Data With Precision
- SEQUENCE: Automatic Ordered Lists
- SORT & SORTBY: Effortless Data Arrangement
- CHOOSECOLS & CHOOSEROWS: Sometimes, You Need to Work With Specific Data Segments
- TEXTSPLIT, TEXTBEFORE, and TEXTAFTER: Text Data Mastery
- VSTACK: Seamless Array Merging
Speakers
Mike Thomas,
theexceltrainer.co.uk- UK-based IT trainer with a career spanning 30+ years
- Delivered thousands of courses and produced hundreds of written and video-based tutorials
- Subject matter expert in a range of technologies with a primary focus and passion for Microsoft Office (especially Excel) on both the Windows and Mac platforms and Power BI
- 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 industries, including healthcare, pharmaceutical, and public sector
- Designs and develops Microsoft Office®-based solutions that automate key business tasks and processes
Who Should Attend
This live webinar is designed for business owners and managers, supervisors, associates, administrative professionals, analysts, bookkeepers, and accountants.
