Microsoft Office TikTok-Style Training AssembleYou
Introducing TikTok-style training resources (not courses) for your people.
This collection of Microsoft Office training resources from Assemble You, provides just-in-time support for Microsoft Office through mobile-ready, expert-led portrait videos. All backed up with practice exercises, and take away key-point infographics.
It’s Microsoft Office training like you’ve never seen it before, designed to troubleshoot common Microsoft Office issues and improve productivity for your learners on the go.
Lessons in this collection
![](https://lpshowcase.learningpool.com/wp-content/uploads/2024/04/microsoft-150x89.jpg)
How this Collection Works
View
![](https://lpshowcase.learningpool.com/wp-content/uploads/2024/04/Excel-150x97.jpg)
Organising Data with Subtotals in Excel
View
![](https://lpshowcase.learningpool.com/wp-content/uploads/2024/04/Excel-150x97.jpg)
Check for Issues and Accessibility in Excel
View
![](https://lpshowcase.learningpool.com/wp-content/uploads/2024/04/Excel-150x97.jpg)
Conditional Formatting with Icon Sets in Excel
View
![](https://lpshowcase.learningpool.com/wp-content/uploads/2024/04/Excel-150x97.jpg)
Cleaning Data in Excel with Power Query Part 1
View
![](https://lpshowcase.learningpool.com/wp-content/uploads/2024/04/Excel-150x97.jpg)
Cleaning Data in Excel with Power Query Part 2
View
![](https://lpshowcase.learningpool.com/wp-content/uploads/2024/04/Excel-150x97.jpg)
Cleaning Data in Excel with Power Query Part 3
View
![](https://lpshowcase.learningpool.com/wp-content/uploads/2024/04/Excel-150x97.jpg)
IF with Partial Match in Excel
View
![](https://lpshowcase.learningpool.com/wp-content/uploads/2024/04/Excel-150x97.jpg)
Create an Expiry Alert in Excel
View
![](https://lpshowcase.learningpool.com/wp-content/uploads/2024/04/Excel-150x97.jpg)
Chat GPT to Bulk Send Emails
View
![](https://lpshowcase.learningpool.com/wp-content/uploads/2024/04/Excel-150x97.jpg)
New Checkboxes in Excel
View
![](https://lpshowcase.learningpool.com/wp-content/uploads/2024/04/Excel-150x97.jpg)
Calculate Work Days Excluding Time Off in Excel
View
![](https://lpshowcase.learningpool.com/wp-content/uploads/2024/04/Excel-150x97.jpg)
Calculate Work Days with Custom Days off in Excel
View
![](https://lpshowcase.learningpool.com/wp-content/uploads/2024/04/Excel-150x97.jpg)
Create a Table of Figures in Word
View
![](https://lpshowcase.learningpool.com/wp-content/uploads/2024/04/Excel-150x97.jpg)
Use VBA to Create a Message PopUp Box in Excel
View
![](https://lpshowcase.learningpool.com/wp-content/uploads/2024/04/Excel-150x97.jpg)
4 Efficiency Tips in Excel
View
![](https://lpshowcase.learningpool.com/wp-content/uploads/2024/04/Excel-150x97.jpg)
GROUPBY in Excel
View
![](https://lpshowcase.learningpool.com/wp-content/uploads/2024/04/Outlook-150x97.jpg)
Outlook Search
View
![](https://lpshowcase.learningpool.com/wp-content/uploads/2024/04/PowerPoint-150x97.jpg)
Understand the Slide Master in PowerPoint
View
![](https://lpshowcase.learningpool.com/wp-content/uploads/2024/04/PowerPoint-150x97.jpg)
Copilot in PowerPoint
View
![](https://lpshowcase.learningpool.com/wp-content/uploads/2024/04/PowerPoint-150x97.jpg)
Blur Effect in PowerPoint
View
![](https://lpshowcase.learningpool.com/wp-content/uploads/2024/04/Word-150x97.jpg)
Create an Index in Word
View
![](https://lpshowcase.learningpool.com/wp-content/uploads/2024/04/Word-150x97.jpg)
Why Word Styles are Useful – Word
View
![](https://lpshowcase.learningpool.com/wp-content/uploads/2024/04/PowerPoint-150x97.jpg)
Get Live Audience Feedback – Forms and PowerPoint
View
![](https://lpshowcase.learningpool.com/wp-content/uploads/2024/04/PowerPoint-150x97.jpg)
Create a Custom Theme – PowerPoint
View
![](https://lpshowcase.learningpool.com/wp-content/uploads/2024/04/PowerPoint-150x97.jpg)
Slide Zoom – PowerPoint
View
![](https://lpshowcase.learningpool.com/wp-content/uploads/2024/04/PowerPoint-150x97.jpg)
Create a Spotlight Effect with Morph – PowerPoint
View
![](https://lpshowcase.learningpool.com/wp-content/uploads/2024/04/Outlook-150x97.jpg)
Search Folders – Outlook
View
![](https://lpshowcase.learningpool.com/wp-content/uploads/2024/04/Outlook-150x97.jpg)
Manage Emails with Quick Steps – Outlook
View
![](https://lpshowcase.learningpool.com/wp-content/uploads/2024/04/MS-365-150x97.jpg)
How Outlook Groups, SharePoint and Teams Link Together – Microsoft 365
View
![](https://lpshowcase.learningpool.com/wp-content/uploads/2024/04/Excel-150x97.jpg)
XLOOKUP with Multiple Criteria in Excel
View
![](https://lpshowcase.learningpool.com/wp-content/uploads/2024/04/Excel-150x97.jpg)
Data Validation Input Messages and Error Alerts – Excel
View
![](https://lpshowcase.learningpool.com/wp-content/uploads/2024/04/Excel-150x97.jpg)
Export Form Data to Excel the Right Way – Forms and Excel
View
![](https://lpshowcase.learningpool.com/wp-content/uploads/2024/04/Excel-150x97.jpg)
Find and Replace Hack
View
![](https://lpshowcase.learningpool.com/wp-content/uploads/2024/04/Excel-150x97.jpg)
Lookups with Duplicates
View
![](https://lpshowcase.learningpool.com/wp-content/uploads/2024/04/Excel-150x97.jpg)
INDEX and MATCH With Multiple Criteria
View
![](https://lpshowcase.learningpool.com/wp-content/uploads/2024/04/Excel-150x97.jpg)
VLOOKUP Approximate Match Explained
View
![](https://lpshowcase.learningpool.com/wp-content/uploads/2024/04/Excel-150x97.jpg)
Create a Daily Habit Tracker – Excel
View
![](https://lpshowcase.learningpool.com/wp-content/uploads/2024/04/Excel-150x97.jpg)
Power Toys Colour Picker – Windows
View
![](https://lpshowcase.learningpool.com/wp-content/uploads/2024/04/Excel-150x97.jpg)
The AND Function with Conditional Formatting – Excel
View
![](https://lpshowcase.learningpool.com/wp-content/uploads/2024/04/Excel-150x97.jpg)
Are you Using Data Bars Effectively – Excel
View
![](https://lpshowcase.learningpool.com/wp-content/uploads/2024/04/Excel-150x97.jpg)
Use ChatGPT to Write Excel Formulas – Excel
View
![](https://lpshowcase.learningpool.com/wp-content/uploads/2024/04/Excel-150x97.jpg)
Generate a Practice Dataset with ChatGPT – Excel
View
![](https://lpshowcase.learningpool.com/wp-content/uploads/2024/04/Excel-150x97.jpg)
Data Validation with Conditional Formatting – Excel
View
![](https://lpshowcase.learningpool.com/wp-content/uploads/2024/04/Excel-150x97.jpg)
A Simple LAMBDA – Excel
View
![](https://lpshowcase.learningpool.com/wp-content/uploads/2024/04/Excel-150x97.jpg)
Filter Data Like an Expert – Excel
View
![](https://lpshowcase.learningpool.com/wp-content/uploads/2024/04/Excel-150x97.jpg)
Excel ‘Pearl’ Charts and Stacking – Excel
View
![](https://lpshowcase.learningpool.com/wp-content/uploads/2024/04/Excel-150x97.jpg)
Most Useful Keyboard Shortcuts – Excel
View
![](https://lpshowcase.learningpool.com/wp-content/uploads/2024/04/Excel-150x97.jpg)
Combine Files in Power Query – Excel
View
![](https://lpshowcase.learningpool.com/wp-content/uploads/2024/04/Excel-150x97.jpg)
The IMAGE Function – Excel
View
![](https://lpshowcase.learningpool.com/wp-content/uploads/2024/04/Excel-150x97.jpg)
Print Headers and Selections – Excel
View
![](https://lpshowcase.learningpool.com/wp-content/uploads/2024/04/Excel-150x97.jpg)
Create Usable Barcodes – Excel
View
![](https://lpshowcase.learningpool.com/wp-content/uploads/2024/04/Excel-150x97.jpg)
Find the Closest Match to a Number – Excel
View
![](https://lpshowcase.learningpool.com/wp-content/uploads/2024/04/Excel-150x97.jpg)
Permanently Hide Worksheets – Excel
View
![](https://lpshowcase.learningpool.com/wp-content/uploads/2024/04/Excel-150x97.jpg)
COUNT and SUM by Cell Colour – Excel
View
![](https://lpshowcase.learningpool.com/wp-content/uploads/2024/04/Excel-150x97.jpg)
New Functions TOCOL and TOROW – Excel
View
![](https://lpshowcase.learningpool.com/wp-content/uploads/2024/04/Excel-150x97.jpg)
Three Ways to Split Text – Excel
View
![](https://lpshowcase.learningpool.com/wp-content/uploads/2024/04/Excel-150x97.jpg)
Convert Values in a Spreadsheet – Excel
View
![](https://lpshowcase.learningpool.com/wp-content/uploads/2024/04/Excel-150x97.jpg)
Excel Tables Explained – Excel
View
![](https://lpshowcase.learningpool.com/wp-content/uploads/2024/04/Excel-150x97.jpg)
Data Validation Lists with Images – Excel
View
![](https://lpshowcase.learningpool.com/wp-content/uploads/2024/04/Excel-150x97.jpg)
Do You Know These Pivot Table Hacks – Excel
View
![](https://lpshowcase.learningpool.com/wp-content/uploads/2024/04/Excel-150x97.jpg)
Create a Conditional Chart – Excel
View
![](https://lpshowcase.learningpool.com/wp-content/uploads/2024/04/Excel-150x97.jpg)
How to Do a Weighted Average – Excel
View
![](https://lpshowcase.learningpool.com/wp-content/uploads/2024/04/Excel-150x97.jpg)
Split Columns at Line Break – Excel
View
![](https://lpshowcase.learningpool.com/wp-content/uploads/2024/04/Excel-150x97.jpg)
Wrap Rows Like a Boss – Excel
View
![](https://lpshowcase.learningpool.com/wp-content/uploads/2024/04/Excel-150x97.jpg)
STOP using SUMIF – Excel
View
![](https://lpshowcase.learningpool.com/wp-content/uploads/2024/04/Excel-150x97.jpg)
Add a Search Box to a Spreadsheet – Excel
View
![](https://lpshowcase.learningpool.com/wp-content/uploads/2024/04/Excel-150x97.jpg)
The Advanced Filter – Excel
View
![](https://lpshowcase.learningpool.com/wp-content/uploads/2024/04/Excel-150x97.jpg)
The LARGE and SMALL Functions – Excel
View
![](https://lpshowcase.learningpool.com/wp-content/uploads/2024/04/Excel-150x97.jpg)
Sort Columns Horizontally – Excel
View
![](https://lpshowcase.learningpool.com/wp-content/uploads/2024/04/Excel-150x97.jpg)
Custom Formatting in Excel
View
![](https://lpshowcase.learningpool.com/wp-content/uploads/2024/04/Excel-150x97.jpg)
Convert Numbers to Words – Excel
View
Based on Microsoft Office TikTok-Style Training AssembleYou we recommend
![](https://lpshowcase.learningpool.com/wp-content/uploads/2022/01/Banner-6-1920x600-1.jpg)
Get in Touch
"*" indicates required fields