Microsoft 365 training that keeps people learning

Clean up messy Excel data with Copilot and follow the steps it takes so you can check the result.

Build a Copilot workflow in plain language that sorts your daily emails and summarises them into Teams.

Put Copilot Cowork to work: the agentic side of Copilot that analyses Excel data, runs deep research and builds presentations from your documents.

Three quick ways to reuse formatting so your spreadsheets stay consistent.

Four Excel habits that cut clicks: status-bar copying, paste values, and named ranges.

Turn a long formula into a named custom function you can call again anywhere.

Learn when to lock a cell reference and when to let it move, so copied formulas give the right result.

Build a search box that highlights matching rows as you type, for datasets of any size.

Pin key documents and apps as tabs in a Teams channel so everyone can reach them.

Set your tone, length, and greeting once so Copilot writes every draft your way.

Apply formatting that grows with your data automatically, without switching to Excel tables.

Set up a one-click Quick Step that moves, categorises and forwards an email together.

Reformat every instance of a Word style in one step using the Styles pane.

Apply and customise Excel data bars so a range's values are easier to read and compare.

Ask Copilot the right questions in Outlook to summarise, advise, and answer without switching apps.

Turn an Excel list into a batch file that creates many folders and subfolders at once.

Set number formats once in the data model so your pivot tables stay consistent without repeated reformatting.

Add a blurred backdrop to PowerPoint title slides so your text stays sharp and readable.

Use breakout rooms in Microsoft Teams to run focused group discussions inside a larger meeting.

Combine several tables in Power Pivot and report across them from one pivot table.

Work out project end dates and working-day counts in Excel while skipping weekends and holidays.

Calculate project durations in Excel when your work week is not Monday to Friday.

Add custom calculations inside an Excel Pivot Table without touching your original data.

Use cell styles to show at a glance which cells hold data and which hold formulas.

Link a worksheet title to its tab name with a formula, no VBA needed, in any recent Excel.

Personalise how Outlook for the Web looks by changing its theme, background and highlight colour.

Use ChatGPT to write the VBA behind a bulk email send from Excel.

Check a spreadsheet for accessibility problems before you share it with others.

Tidy a messy dataset into an analysis-ready table using Excel's built-in tools, no Power Query needed.

Start cleaning messy data in Excel with Power Query and Applied Steps.

Reshape a messy dataset in Power Query by trimming, splitting, and merging.

Finish the Power Query workflow by loading and refreshing your cleaned data.

Merge every file in a folder into one dataset and refresh it as new files arrive.

Shrink a heavy PowerPoint file with Compress Pictures while keeping your slides sharp.

Set up conditional formatting in Outlook for the Web to colour-code emails from key senders.

Show data trends visually with icon sets in conditional formatting.

Turn figures like 1,250 into words using a short piece of VBA code in your workbook.

Use the CONVERT function to switch values between units such as centimetres and feet.

A fast start with Microsoft Copilot: generative AI foundations, best practice, the Copilot versions, and how to prompt like a pro.

Set up conditional formatting in Excel with plain-language prompts instead of building rules by hand.

Build and troubleshoot dynamic Excel formulas with Copilot, then check they hold up as data grows.

Consolidate messy data from several sheets and build a summary with a single Copilot prompt.

Turn dense financial reports into clear Excel dashboards with Copilot in a few seconds.

Sort and filter large datasets in Excel with short Copilot prompts, then reset them just as fast.

Translate a full presentation, slides and notes, with Copilot instead of editing each slide by hand.

A beginner's guide to harnessing Microsoft Copilot: understand what it is, write effective prompts, and use Copilot across Excel, PowerPoint, and Word.

Fix a greyed-out Copilot icon in Outlook yourself before you call IT.

Use plain prompts to format, highlight, sort, filter and add formula columns in Excel with Copilot.

Put Microsoft Copilot to work in Excel: generate insights from raw data, sort and filter with natural language, format, clean, build formulas and create dashboards.

Put Microsoft Copilot to work in Outlook: draft and reply to emails, summarise threads, manage your inbox with rules and flags, and stay on top of your calendar.

Draft and refine PowerPoint presentations quickly using Copilot and your own documents.

Put Microsoft Copilot to work in PowerPoint: create and edit presentations, apply company templates, reference files, and present with confidence.

Put Microsoft Copilot to work in Teams: meeting recaps, real-time help during calls, and AI summaries that keep everyone aligned.

Put Microsoft Copilot to work in Word: draft documents, turn content into PDFs and decks, handle emails, visualise data as tables, and ask questions of your text.

Group your project files into a Copilot notebook and get answers drawn only from them.

Reuse a conditional formatting rule in another workbook without rebuilding it.

Count and sum cells by their fill colour without touching VBA, using SUBTOTAL and filters.

Build a conditional clustered column chart with a moving target line, and highlight the data points that matter.

Match your slides to a logo or brand image by building a custom colour theme.

Build a habit tracker in Excel with checkboxes that show your weekly completion as a percentage.

Turn a static macro into one that works across changing data by editing its VBA code.

Build a one-click filter in Excel by recording a macro and attaching it to a button.

Fit a large dataset into a compact scrolling table so your sheet stays tidy and interactive.

Create a 100% stacked bar chart in The Economist style that updates as your data changes.

Use Morph transitions to spotlight key elements on a slide.

Build a stock chart that updates from a chosen ticker and reads clearly.

Build a tracker that shows in-stock and out-of-stock items automatically using the FILTER function.

Build a Table of Figures in Word so readers can find every image, chart, and table.

Build a team from scratch in Microsoft Teams and add members with the access levels you want.

Turn an existing Microsoft 365 group into a Teams team, keeping its members, settings and permissions.

Build a formula-driven bar chart inside cells using REPT, TEXT and SUM, no chart tools needed.

Build a colour-coded invoice tracker that flags expiry dates automatically.

Add an index to a long Word document so readers can jump straight to the topic they need.

Turn an email into a calendar appointment in one step, with its content already filled in.

Turn a prompt or a reference file into a structured PowerPoint deck with Copilot in minutes.

Edit photo backgrounds and prepare a profile picture using the Windows 11 Photos app.

Add totals, running totals and quick charts from one Quick Analysis button, no formulas typed.

Turn product IDs into scannable barcodes in Excel using a free barcode font.

Build a working table of contents from bookmarks when Word styles are not applied.

Save text and content you reuse often and drop it into any document in a couple of clicks.

Change how numbers, dates and text look in your cells without altering the underlying values.

Set up a looping slide show that runs while your audience arrives, then return to your main deck.

Filter and sort a shared spreadsheet without changing what colleagues see.

Guide people as they type and stop wrong entries before they reach your spreadsheet.

Build a dropdown list that swaps in the matching image as you change your selection.

Set up a dropdown list in Excel that automatically highlights the rows matching your selection.

Five tips to make your Excel workbooks clearer and easier to use.

Turn a confusing sales chart into a clear PivotTable and tidy line chart.

Give Copilot the context it needs to draft and reply to emails well.

Turn a short prompt into a written email you can review and edit.

A hands-on beginner's guide to Excel 365: enter and format data, navigate the interface, build simple formulas, and share your work online with confidence.

The beginner-to-intermediate Excel course: master navigation and data entry, essential formulas and functions, tables, clean data, PivotTables, and formatting.

Get the basics of Excel formulas right, from cell references to order of operations.

Calculate the gap between two dates with DATEDIF, and a safer YEARFRAC method for when it breaks.

Four keyboard shortcuts that speed up everyday Excel work, from resizing cells to summing tables.

Use Excel tables to keep formulas and charts updating as your data grows.

Build a pearl chart in Excel by stacking coloured circles to represent your data points.

Pull a folder's file names into Excel and make each one a clickable link.

Set up Forms so new responses update your Excel file without manual exports.

Filter Excel data with dropdowns inside a table and with the FILTER function.

Pull out specific non-adjacent columns from a large dataset using Excel's FILTER function.

Find the value nearest a target number, with a helper column or a single-cell formula.

Clean up stray wildcard characters in imported data using Find and Replace.

Use Find and Replace in Word to update text, special characters and formatting at once.

Ask Copilot Chat in plain words to find the email or attachment you need in seconds.

Reveal bullets one at a time and fade each to grey as you move through the slide.

Add footnotes and endnotes in Word to support your text with extra detail.

Use ChatGPT to generate practice datasets in Excel, and work around its size and output limits.

Add Microsoft Forms to your slides to gather live audience responses as you present.

Summarise and total data in Excel with a single GROUPBY formula, no pivot table needed.

Create a drop-down that removes chosen items and marks selections, so you cannot enter the same value twice.

See how one Microsoft 365 group connects Outlook, SharePoint and Teams for a shared team space.

Work out an average where some values count for more, using SUMPRODUCT.

Switch off the Focused Inbox in classic or new Outlook so every message lands in one list.

Label rows by a partial text match using IF, SEARCH, and ISNUMBER.

Combine INDEX and MATCH to look up a value by two criteria, such as a company and a month.

Join public and private teams in Microsoft Teams using a code, an invitation or direct access.

Lock a whole worksheet while keeping slicers active for filtering.

Let Copilot pick and write your lookup formula so you spend less time wrestling with syntax.

Look up the right row in tables with duplicate values by building a unique key from several columns.

Store a macro once and run it in any workbook you open.

Post announcements in Teams that stand out so updates are hard to miss.

Use Quick Steps to run your own multi-step email actions on demand from the Home tab.

Organise and move around multiple worksheets faster with a few simple techniques.

Unlock AI-powered productivity in Excel: use ChatGPT, the ChatGPT for Excel add-in, and Microsoft Copilot to generate and clean data, write formulas, and automate analysis.

A beginner's guide to collaboration in Microsoft Teams: navigate the interface, chat and message, run meetings, and organise work with teams and channels.

Lock just the row or just the column in a reference to keep dynamic formulas working across a table.

Work faster in Excel with shortcuts for navigation, selection, and ribbon commands.

Faster ways to manage rows and columns, and how to spot when something is hidden.

Move around and rearrange long documents quickly using headings and the Go To function.

Track tasks with Excel's new checkboxes linked to TRUE and FALSE values.

Add the new Excel checkboxes for task tracking without setting up a linked cell.

Build and reshape a presentation outline in PowerPoint using Copilot, then generate the slides.

Highlight the row and column of any selected cell so you can track your place in large datasets.

Reshape ranges into a single column or row and drop the blanks you do not want.

A practical guide to Microsoft OneNote: organise notebooks, sections, and pages, take rich notes, collaborate, and use Copilot to summarise and extract action items.

Summarise grouped data quickly with Subtotals, without building a pivot table.

Take control of your inbox and calendar in Outlook 365: set up your account, organise email with folders and categories, and schedule meetings with confidence.

Find any email in Outlook faster by setting the right search scope and refining results.

Control where pages start and split a document into sections with their own layout.

Collect text and images from any app and paste them from one Windows Clipboard panel.

Collect up to 24 items with the Office Clipboard and paste them without switching back and forth.

Copy exactly what you need from a cell, including a linked picture that updates itself.

Hide a worksheet so it cannot be unhidden the usual way, then bring it back when you need it.

Pull just the columns you need from a large dataset with CHOOSECOLS in Microsoft 365.

Turn a basic plan into a working task list you can assign, schedule, and track.

Set up a new plan from scratch and choose the starting point that fits the work.

Find your way around Planner and set up a place to organise, manage, and track your team's tasks.

From zero to dashboard hero: install and navigate Power BI, shape data with Power Query, model it with DAX, and build interactive reports you can publish and share.

Use the PowerToys Colour Picker to grab a colour from anywhere and apply it consistently in Excel.

Create engaging presentations with ease in PowerPoint 365: choose slide layouts, work with text and images, and present with confidence.

Print large tables cleanly, with repeated headings and only the rows you want.

Print large spreadsheets so the data stays organised and readable across every page.

Protect chosen cells in a workbook so colleagues edit only where you allow.

Record a macro to handle repetitive Excel tasks without writing any code.

Practise your talk in PowerPoint and get feedback on pace, filler words, and pitch.

Keep table headers on every printed page and stop rows breaking awkwardly across pages.

Pull several columns at once with a single VLOOKUP instead of repeating the formula.

Save your common email replies as Quick Parts and drop them into messages in seconds.

Reshape a Copilot email draft in Outlook and pick the best version before you send.

Turn one mail merge into individual personalised letters, saved as separate files.

Group emails by sender, flag or size automatically without moving them from their folders.

Share files in Microsoft Teams meetings and co-edit documents live with PowerPoint Live and Excel Live.

Reveal hidden formatting marks so you can find and fix layout problems in a document.

See when a dynamic table serves you better than a named range, and when it doesn't.

Use Slide Zoom to build presentations your audience can navigate as you present.

Reorder columns in place using left-to-right sorting instead of dragging them by hand.

Put lists and tables in order, including tricky horizontal lists, using Word's Sort tools.

Order data with SORT and SORTBY, and keep results current as your dataset grows.

Break the contents of one cell into separate columns using a line break as the split point.

Use Excel's TEXTBEFORE and TEXTAFTER functions to split names and mixed text into separate cells.

Set up the Quick Access Toolbar so your everyday commands are always one click away.

Sum values against several conditions at once, going further than SUMIF can.

Get the key points of a long email in seconds with Copilot in Outlook.

Pass and reclaim keyboard and mouse control in Teams meetings so others can navigate your slides.

Pull out data that meets your criteria and refresh the results with a short macro.

Use the AND function in a conditional formatting rule to highlight rows only when two conditions are met.

Take a snapshot of a data range that updates itself whenever the source changes, ideal for dashboards.

Pull company logos into cells from a web address using the IMAGE function in Microsoft 365.

Return the nth highest or lowest value in a range and match related data to it.

Use the new Microsoft Teams for personal use to build communities, schedule events and chat.

Clean up messy lists in Excel 365 with the TRIMRANGE function and the dot shortcut.

Summarise data with one PIVOTBY formula and let the report update itself as data changes.

Split names and other text into separate columns three different ways in Excel.

Record edits, review them by author, and accept or reject changes when working with others.

Build an Excel tracker that counts down to each deadline and colour- codes its status automatically.

Show your calendar and tasks next to your inbox so you can plan the week in one view.

A hands-on journey through Excel PivotTables: create and customise them, sort, filter and group data, add calculations and PivotCharts, and build an interactive dashboard.

The complete Microsoft Copilot and AI journey: generative AI foundations, prompting, custom GPTs and agents, and Copilot across Excel, PowerPoint, Word, Teams, and Outlook.

Format every slide consistently in PowerPoint by editing the Slide Master once.

Use ChatGPT to draft Excel formulas such as XLOOKUP, then check them against your own data.

Use plain prompts in Copilot Chat to schedule, summarise, and act across your inbox.

Set up an automatic pop-up in Excel that reminds you about due and overdue invoices.

Use the Microsoft Teams chat panel to send clear messages, share files and collaborate in meetings.

Run calculations inside Word tables and refresh the results when your figures change.

Copy formatting across text and shapes in Word with Format Painter, and know its limits.

Use VLOOKUP and set the approximate match option that trips many people up.

Use Whiteboard in Microsoft Teams to sketch ideas and plan projects with your team live.

Centre headings across cells without the sorting and formula problems Merge and Centre causes.

Format documents faster with styles that keep headings, navigation, and updates consistent.

Apply Word Styles to headings so formatting and your Table of Contents update in one step.

Start from Excel's built-in templates instead of building every workbook from scratch.

Master the basics of document creation in Microsoft Word 365: navigate the interface, work with text and paragraphs, and set up polished, well-organised documents.

Add, reply to, and resolve comments, and choose whether they appear when you print.

Add headers and footers that stay consistent and keep page numbers running correctly.

Set your Teams presence status and duration so colleagues know when you are free or focusing.

Read documents in a clean, book-like layout and have Word read the text aloud to you.

Split one long row of data into a tidy grid of columns in a few steps.

Get suggestions on tone, clarity, and impact for a draft before you send it.

Pull a value from a table by matching two conditions at once with XLOOKUP.