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
How this Collection Works
View
Organising Data with Subtotals in Excel
View
Check for Issues and Accessibility in Excel
View
Conditional Formatting with Icon Sets in Excel
View
Cleaning Data in Excel with Power Query Part 1
View
Cleaning Data in Excel with Power Query Part 2
View
Cleaning Data in Excel with Power Query Part 3
View
IF with Partial Match in Excel
View
Create an Expiry Alert in Excel
View
Chat GPT to Bulk Send Emails
View
New Checkboxes in Excel
View
Calculate Work Days Excluding Time Off in Excel
View
Calculate Work Days with Custom Days off in Excel
View
Create a Table of Figures in Word
View
Use VBA to Create a Message PopUp Box in Excel
View
4 Efficiency Tips in Excel
View
GROUPBY in Excel
View
Outlook Search
View
Understand the Slide Master in PowerPoint
View
Copilot in PowerPoint
View
Blur Effect in PowerPoint
View
Create an Index in Word
View
Why Word Styles are Useful – Word
View
Get Live Audience Feedback – Forms and PowerPoint
View
Create a Custom Theme – PowerPoint
View
Slide Zoom – PowerPoint
View
Create a Spotlight Effect with Morph – PowerPoint
View
Search Folders – Outlook
View
Manage Emails with Quick Steps – Outlook
View
How Outlook Groups, SharePoint and Teams Link Together – Microsoft 365
View
XLOOKUP with Multiple Criteria in Excel
View
Data Validation Input Messages and Error Alerts – Excel
View
Export Form Data to Excel the Right Way – Forms and Excel
View
Find and Replace Hack
View
Lookups with Duplicates
View
INDEX and MATCH With Multiple Criteria
View
VLOOKUP Approximate Match Explained
View
Create a Daily Habit Tracker – Excel
View
Power Toys Colour Picker – Windows
View
The AND Function with Conditional Formatting – Excel
View
Are you Using Data Bars Effectively – Excel
View
Use ChatGPT to Write Excel Formulas – Excel
View
Generate a Practice Dataset with ChatGPT – Excel
View
Data Validation with Conditional Formatting – Excel
View
A Simple LAMBDA – Excel
View
Filter Data Like an Expert – Excel
View
Excel ‘Pearl’ Charts and Stacking – Excel
View
Most Useful Keyboard Shortcuts – Excel
View
Combine Files in Power Query – Excel
View
The IMAGE Function – Excel
View
Print Headers and Selections – Excel
View
Create Usable Barcodes – Excel
View
Find the Closest Match to a Number – Excel
View
Permanently Hide Worksheets – Excel
View
COUNT and SUM by Cell Colour – Excel
View
New Functions TOCOL and TOROW – Excel
View
Three Ways to Split Text – Excel
View
Convert Values in a Spreadsheet – Excel
View
Excel Tables Explained – Excel
View
Data Validation Lists with Images – Excel
View
Do You Know These Pivot Table Hacks – Excel
View
Create a Conditional Chart – Excel
View
How to Do a Weighted Average – Excel
View
Split Columns at Line Break – Excel
View
Wrap Rows Like a Boss – Excel
View
STOP using SUMIF – Excel
View
Add a Search Box to a Spreadsheet – Excel
View
The Advanced Filter – Excel
View
The LARGE and SMALL Functions – Excel
View
Sort Columns Horizontally – Excel
View
Custom Formatting in Excel
View
Convert Numbers to Words – Excel
View
Based on Microsoft Office TikTok-Style Training AssembleYou we recommend
Get in Touch
"*" indicates required fields