Accreditations and Endorsements

CPD certified

Also in Microsoft 365 Shorts by Assemble You

How this Collection Works
lesson / 15m

This is not a lesson, this is an explainer video on how this collection works.  

View
Organising Data with Subtotals in Excel
lesson / 15m

This lesson explores the feature that simplifies dataset summarisation. Subtotals enable you to calculate and display total values for different groups within a dataset. […]

View
Check for Issues and Accessibility in Excel
lesson / 15m

Before sharing your Excel spreadsheets with others, it’s crucial to check for potential issues and ensure accessibility for all users. In this lesson, we’ll […]

View
Conditional Formatting with Icon Sets in Excel
lesson / 15m

If you’ve ever wondered how to enhance your data visualisation skills and make meaningful insights at a glance, this one’s for you. In this […]

View
Cleaning Data in Excel with Power Query Part 1
lesson / 15m

If you’ve ever found yourself grappling with messy datasets or are new to the Power Query, this lesson is for you. In this lesson, […]

View
Cleaning Data in Excel with Power Query Part 2
lesson / 15m

Ready for the second part of Cleaning Data in Excel with Power Query? In this lesson, we’re transforming our unruly dataset for easy, organised […]

View
Cleaning Data in Excel with Power Query Part 3
lesson / 15m

Welcome to the final instalment of our three-part series on Cleaning Data in Excel with Power Query. In this lesson, we’ll briefly revisit the […]

View
IF with Partial Match in Excel
lesson / 15m

In this lesson, we tackle the challenge of identifying data in a list using the IF function with a partial match. Imagine you’re a […]

View
Create an Expiry Alert in Excel
lesson / 15m

Imagine having a dynamic and colour-coded dashboard at your fingertips, effortlessly keeping track of invoice statuses – it’s a game-changer! In this lesson, we’ll […]

View
Chat GPT to Bulk Send Emails
lesson / 15m

Streamlining your bulk email-sending process has never been easier. Say goodbye to the complexities of VBA coding and programming as we guide you through […]

View
New Checkboxes in Excel
lesson / 15m

Whether you’re tracking workouts or managing tasks, checkboxes offer a visual record and keep things organised. Discover the power of TRUE and FALSE outputs […]

View
Calculate Work Days Excluding Time Off in Excel
lesson / 15m

If you’ve ever needed to determine the end date of a project based on workdays (excluding weekends and holidays), this is the lesson for […]

View
Calculate Work Days with Custom Days off in Excel
lesson / 15m

Imagine a scenario where your work week is not the conventional Monday to Friday and you want to estimate project durations based on this […]

View
Create a Table of Figures in Word
lesson / 15m

Whether you’re new to Word or just looking to enhance your skills, this lesson guides you through creating a customised Table of Figures in […]

View
Use VBA to Create a Message PopUp Box in Excel
lesson / 15m

Ready to level up your Excel game? This lesson will enhance your efficiency by automating invoice reminders using VBA to create a customised message […]

View
4 Efficiency Tips in Excel
lesson / 15m

Are you ready to transform your Excel game? In this lesson, we’ll guide you through four essential efficiency tips that might just revolutionise how […]

View
GROUPBY in Excel
lesson / 15m

Have you ever wondered how to perform data aggregations effortlessly within a single formula? GroupBy is your answer! We’ll cover the essential components of […]

View
Outlook Search
lesson / 15m

This lesson shares essential tips to enhance your email searching skills. Understanding the search scope is crucial; you can search within the current mailbox, […]

View
Understand the Slide Master in PowerPoint
lesson / 15m

If you’ve ever felt overwhelmed by the intricacies of PowerPoint, then understanding the Slide Master is a game-changer. We’ll guide you through the creation […]

View
Copilot in PowerPoint
lesson / 15m

This lesson focuses on harnessing the power of Copilot within PowerPoint. It covers the recent expansion of Copilot accessibility, the Designer feature, and a […]

View
Blur Effect in PowerPoint
lesson / 15m

Are you prepping a presentation that demands a stunning introduction? Look no further! In this lesson, we show you how to add a blur […]

View
Create an Index in Word
lesson / 15m

We all know scrolling through lengthy documents to find specific information is a chore. The solution? An index is the unsung hero at the […]

View
Why Word Styles are Useful – Word
lesson / 15m

If you find yourself grappling with the tedious task of manually formatting headings in your documents, this lesson is your game-changer. This lesson will […]

View
Get Live Audience Feedback – Forms and PowerPoint
lesson / 15m

Discover the power of combining Microsoft Forms with PowerPoint to collect real-time responses from your audience and display them directly on your presentation slides. […]

View
Create a Custom Theme – PowerPoint
lesson / 15m

This lesson will explore how to add a personal touch to your presentations. Forget the default themes; let’s infuse some personality into your slides! […]

View
Slide Zoom – PowerPoint
lesson / 15m

This lesson explores the features of PowerPoint’s Slide Zoom functionality. Slide Zoom makes your content much more appealing to your audience and enhances their […]

View
Create a Spotlight Effect with Morph – PowerPoint
lesson / 15m

This lesson will guide you through using Morph transitions to craft a visually stunning spotlight effect, allowing you to highlight crucial elements in PowerPoint. […]

View
Search Folders – Outlook
lesson / 15m

Discover the functionality of Outlook’s Search Folders in this lesson. Learn how to create folders with different criteria and make email management efficient. We’ll […]

View
Manage Emails with Quick Steps – Outlook
lesson / 15m

QuickSteps in Outlook is ideal for personalised and on-the-spot email handling. We’ll explore the often-overlooked QuickSteps group on the Home tab, revealing the power […]

View
How Outlook Groups, SharePoint and Teams Link Together – Microsoft 365
lesson / 15m

This lesson explores how Outlook Groups, SharePoint, and Microsoft Teams can work together within the Microsoft 365 suite to simplify tasks and boost collaborative […]

View
XLOOKUP with Multiple Criteria in Excel
lesson / 15m

Have you ever needed to quickly find data based on two distinct conditions? This one’s for you. Get the most out of Excel’s XLOOKUP […]

View
Data Validation Input Messages and Error Alerts – Excel
lesson / 15m

Explore advanced data validation techniques, features and Excel’s data validation capabilities in this lesson. While dropdown lists are commonly used to control data entry, […]

View
Export Form Data to Excel the Right Way – Forms and Excel
lesson / 15m

If you’ve ever used Microsoft Forms in your Microsoft 365, you know the convenience of collecting responses and exporting them to Excel for analysis. […]

View
Find and Replace Hack
lesson / 15m

If you’ve ever imported data from the web and found pesky wildcard characters like asterisks messing with your cell contents, this lesson is your […]

View
Lookups with Duplicates
lesson / 15m

A standard VLOOKUP has its limitations. XLOOKUP offers additional search options but fails to provide the desired result. This lesson presents a familar scenario […]

View
INDEX and MATCH With Multiple Criteria
lesson / 15m

This lesson will support you in performing complex two-way lookups with ease. We’ll explore the mechanics of the two-way lookup using the combination of […]

View
VLOOKUP Approximate Match Explained
lesson / 15m

While VLOOKUP may seem like old news, it remains a powerhouse in data analysis. This lesson focuses on the often misunderstood “approximate match” argument. […]

View
Create a Daily Habit Tracker – Excel
lesson / 15m

This lesson is a guide to building a habit tracker using Excel. You can add checkboxes for each day of the week, allowing you […]

View
Power Toys Colour Picker – Windows
lesson / 15m

Ever wished for the eyedropper tool, commonly found in PowerPoint, to be available in Excel? Well, this one’s for you. This lesson explores the […]

View
The AND Function with Conditional Formatting – Excel
lesson / 15m

Using the AND function within the conditional formatting rule, we demonstrate how to highlight specific rows where two conditions must be met simultaneously. We’ll […]

View
Are you Using Data Bars Effectively – Excel
lesson / 15m

This is a guide to making your data bars a precise and powerful tool for effective data communication. Explore the power of data bars […]

View
Use ChatGPT to Write Excel Formulas – Excel
lesson / 15m

This lesson explores how ChatGPT can be used to generate formulas. It emphasises practicality by applying the generated formula to a real-world scenario. It’ll […]

View
Generate a Practice Dataset with ChatGPT – Excel
lesson / 15m

This lesson explores the effective use of ChatGPT to effortlessly create diverse datasets. Learn how to interact with ChatGPT to instruct it to generate […]

View
A Simple LAMBDA – Excel
lesson / 15m

If you’ve mastered the basics of Excel and are ready for a challenge, this lesson is your ticket to understanding the powerful LAMBDA function. […]

View
Filter Data Like an Expert – Excel
lesson / 15m

This lesson explores the fundamental distinction between filtering and conditional formatting. It covers how to hide and reveal data based on your specified criteria. […]

View
Excel ‘Pearl’ Charts and Stacking – Excel
lesson / 15m

Discover a unique option that adds a touch of magic to your charts. Picture a “pearl chart” created by stacking colourful circles representing data […]

View
Most Useful Keyboard Shortcuts – Excel
lesson / 15m

This lesson explores a variety of keyboard shortcuts grouped into categories like navigation, selection, and command execution. Whether you’re a beginner or an experienced […]

View
Combine Files in Power Query – Excel
lesson / 15m

This lesson explores how to merge multiple files housed in a designated folder using Power Query. We’ll guide you through the process of transforming […]

View
The IMAGE Function – Excel
lesson / 15m

If you’re a Microsoft 365 user or use Excel for the web, this lesson is for you – the IMAGE function is exclusive to […]

View
Print Headers and Selections – Excel
lesson / 15m

This lesson shares essential tips and tricks for effectively managing large datasets, focusing specifically on printing. Whether you’re dealing with extensive tables or spreadsheets, […]

View
Create Usable Barcodes – Excel
lesson / 15m

Learn to create barcodes using Excel. This lesson will guide you through turning product IDs into barcodes. We’ll introduce you to the Libre Barcode […]

View
Find the Closest Match to a Number – Excel
lesson / 15m

This lesson shows you how to find the closest match to a given number using two methods – one with a helper column and […]

View
Permanently Hide Worksheets – Excel
lesson / 15m

If you’re tired of worrying about unauthorized changes to your Excel spreadsheets, this lesson offers a clever solution that goes beyond the typical hiding […]

View
COUNT and SUM by Cell Colour – Excel
lesson / 15m

Ever found yourself grappling with the challenge of counting or summing cells based on their background fill color in Microsoft Excel? Look no further! […]

View
New Functions TOCOL and TOROW – Excel
lesson / 15m

In this lesson, we’ll be exploring two dynamic functions that are making waves in the world of data manipulation: TOCOL and TOROW. These functions, […]

View
Three Ways to Split Text – Excel
lesson / 15m

In this lesson, we’ll explore various methods for efficiently dividing text across columns in Excel, a common task with different approaches depending on your […]

View
Convert Values in a Spreadsheet – Excel
lesson / 15m

This lesson explores practical methods for converting data efficiently. We examine the CONVERT function in Excel, demonstrating how simple it is to switch between […]

View
Excel Tables Explained – Excel
lesson / 15m

This lesson will debunk common misconceptions and showcase the potential of Excel tables. Discover the ease of transforming your raw data into a table […]

View
Data Validation Lists with Images – Excel
lesson / 15m

Ever wondered how to seamlessly integrate a data validation dropdown list with dynamic images in Excel? Look no further! This lesson will guide you […]

View
Do You Know These Pivot Table Hacks – Excel
lesson / 15m

This lesson covers data analysis and visualisation and confronts the challenge of deciphering a confusing sales chart. We’ll explore the intricacies of data and […]

View
Create a Conditional Chart – Excel
lesson / 15m

This lesson will guide you through creating a dynamic and visually impressive conditional clustered column chart with a moving target line using Microsoft Excel. […]

View
How to Do a Weighted Average – Excel
lesson / 15m

This lesson examines calculation methods. If terms like AVERAGE function and SUMPRODUCT have left you confused, fear not – our step-by-step guide is here […]

View
Split Columns at Line Break – Excel
lesson / 15m

This lesson explains the process of breaking up information contained in a single cell into separate columns using Text to Columns. This technique is […]

View
Wrap Rows Like a Boss – Excel
lesson / 15m

This lesson showcases efficient data organisation with WrapRows. It provides insights for both Microsoft 365 users and those on other Excel versions. We’ll address […]

View
STOP using SUMIF – Excel
lesson / 15m

In this lesson, we examine a common practice in Excel that might be holding you back: the SUMIF function. While SUMIF has been a […]

View
Add a Search Box to a Spreadsheet – Excel
lesson / 15m

This lesson explores the process of adding a dynamic Search Box to an Excel spreadsheet. Whether you’re managing a vast dataset or something smaller, […]

View
The Advanced Filter – Excel
lesson / 15m

The Advanced Filter feature provides an alternative to the more commonly used dropdown menus and the FILTER function. This lesson guides you through the […]

View
The LARGE and SMALL Functions – Excel
lesson / 15m

While many of us are familiar with the MIN and MAX functions, LARGE and SMALL offer a unique twist to data analysis. This lesson […]

View
Sort Columns Horizontally – Excel
lesson / 15m

Ever struggled with chaotic data columns? In this lesson, we share a quick Excel hack: skip manual dragging and dropping by using a numbering […]

View
Custom Formatting in Excel
lesson / 15m

Unlock the power of Custom Formatting in Excel as we guide you through transforming your data with style. Discover how to add colour, symbols, […]

View
Convert Numbers to Words – Excel
lesson / 15m

Ever wondered how to transform numerical values into descriptive text? From accessing the Visual Basic Editor to customising the formula and adapting it for […]

View