How to Cleanse Raw Data (FULL COURSE)
containing: Data cleansing functions, Text substitution functions, Using Flash Fill, Extracting the correct text, De-duplication techniques, Using Tex…
Category: Course Recording
Introduction to XLOOKUP (FULL COURSE)
containing: Using XLOOKUP instead of VLOOKUP or HLOOKUP, Using a nested XLOOKUP, Limitations of VLOOKUP and HLOOKUP, Using XLOOKUP instead of INDEX an…
Conditional Formatting (FULL COURSE)
containing: What is Conditional Formatting?, Demonstrating preset highlighting rules, Creating a Conditional Formatting rule using a formula, Clearing…
What’s New in Outlook (FULL COURSE)
containing: Message Templates, Focused Inbox, Read Aloud, @mentions, Quick replies via Teams, Sharing an email to Teams, Scheduling a Teams Meeting, M…
Introduction to Creating Charts (FULL COURSE)
containing: Using a recommended chart, Modifying your chart design, Formatting chart elements, Selecting a specific chart type, Using keyboard shortcu…
Teams – Breakout Rooms (FULL COURSE)
This video explains who can create breakout rooms in a Teams Meeting. It shows how to manage them, assign people, move in and out of rooms, access cha…
Introduction to Data Validation techniques (FULL COURSE)
containing: Demonstrating Data Validation controls, Understanding the Data Validation dialog box, Modifying existing Data Validation controls, Creatin…