Microsoft 365 Shorts by Assemble You
Introducing short-form training resources (not courses) for your people.
This collection of Microsoft 365 training resources from Assemble You, provides just-in-time support for Microsoft 365 through mobile-ready, expert-led portrait videos. All backed up with practice exercises, and take away key-point infographics.
It’s Microsoft 365 training like you’ve never seen it before, designed to troubleshoot common Microsoft 365 issues and improve productivity for your learners on the go.
This Collection was previously named Microsoft Office Tik-Tok Style Training.
Lessons in this collection

How this Collection Works
View

Customise Views With Sheet View In Excel
View

Footnotes And Endnotes In Word
View

Creating A Table Of Contents With Bookmarks In Word
View

New Checkboxes In Excel
View

Create A Slick Bar Chart Like ‘The Economist’ In Excel
View

Join A Public Or Private Microsoft Team
View

Working With Presence Status In Microsoft Teams
View

The New Microsoft Teams For Personal Use
View

Whiteboard In Microsoft Teams
View

Breakout Rooms in Microsoft Teams
View

Take Control Of Key And Mouse In Microsoft Teams Meetings
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 365 Shorts by Assemble You we recommend

Get in Touch
"*" indicates required fields