Excel – An Introduction (FULL COURSE)
containing: Differences between a Workbook and a Worksheet, Identifying cells and the Active Cell, How large is a worksheet?, Entering data, Selecting…
Category: Course Recording
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…
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…
