Description
Learn Excel tricks that make you instantly more proficient.Learn powerful tips, tricks, and shortcuts to help you become more productive in your use of Excel. Learn timesaving tricks for working with listbased data, speeding up data entry, turning poorlystructured data into useable data, and more The training will be delivered using the latest version of Excel and many of the features are only available to Microsoft 365 subscribers you may need to check with your company.
Date: 2022-01-13 Start Time: End Time:
Learning Objectives
Convert List-Based Data Into a Table, and Magic Things Happen
Use CONCATENATE, Text-to-Columns, and Flash Fill to Combine and Split Data
Conditional Formatting: What Is It and How to Use It
Dynamic Array Functions: SORT, UNIQUE, SEQUENCE, and More; New Functions That Are a Potential Game-Changer to the Way That Worksheets Are Designed and Constructed (Microsoft® 365 Only)
XLOOKUP: A Modern, Flexible, and More Powerful Replacement for VLOOKUP and HLOOKUP (Microsoft 365 Only)
Power Query: A Huge Topic in Its Own Right, Learn How You Can Turn Poorly Formatted Data Into Great Data in Seconds
ASAP PACE ,IAAP ,Additional credit may be available upon request. Contact Lorman at 866-352-9540 for further information.
Mike Thomas-theexceltrainer.co.uk
