Knowledge Centre - Office Tutorials

How to Add an Email Account to Outlook (Gmail, iCloud, Work and More)Add a Gmail, iCloud, Yahoo, work or Outlook.com account to Microsoft Outlook in a few clicks — in new Outlook, classic Outlook and the phone app — and fix the common sign-in problems.
How to Join a Teams Meeting (From a Link, Your Calendar, a Meeting ID or as a Guest)Every way to join a Microsoft Teams meeting — from an email link, the Teams calendar, a meeting ID, your phone, or in the browser without a Teams account.
How to Add Up a Column in Excel (AutoSum and SUM Explained)Add up a column or row in Excel in one click with AutoSum, write your own SUM formula, and fix totals that come out wrong. Includes the Alt + = shortcut.
PowerPoint Keyboard Shortcuts for Beginners (The Ones You'll Actually Use)The Microsoft PowerPoint keyboard shortcuts every beginner should know — adding slides, duplicating objects, lining things up, starting the show and controlling it while you present.
Word Keyboard Shortcuts for Beginners (The Ones You'll Actually Use)The Microsoft Word keyboard shortcuts every beginner should know — saving, formatting, selecting text, moving around a document and reaching any button with Alt.
How to Add a Header and Footer in WordAdd a header and footer in Microsoft Word, use a different first page, set up odd and even pages, and give each section its own header.
How to Add a New Slide and Change the Layout in PowerPointAdd a new slide in PowerPoint, pick the right layout, change the layout of a slide you've already made, and reset a slide that's gone wonky.
How to Create Folders in Outlook (and Keep Your Inbox Tidy)Create folders and subfolders in Outlook, move emails into them quickly, add the ones you use most to Favourites, and learn when a folder is the wrong tool.
How to Schedule a Meeting in Teams (and Set It Up Properly)Schedule a Microsoft Teams meeting from the Teams calendar, invite people inside and outside your organisation, make it repeat, and set the meeting options.
How to Use AutoFill in Excel (Stop Typing Lists by Hand)Use Excel's fill handle to fill days, months, dates and number sequences automatically, copy formulas down a whole column in one double-click, and fix AutoFill when it guesses wrong.
How to Attach a File in Outlook (and What to Do When It's Too Big)Attach files to an email in Outlook by browsing, dragging or picking from recent files — and send large files as a OneDrive link when the attachment is too big.
How to Insert a Table in Word (and Make It Look Good)Insert a table in Microsoft Word, add rows and columns, apply a table style, repeat header rows on every page and convert text into a table.
How to Mute and Unmute in Teams (Yourself and Everyone Else)Mute and unmute yourself in Microsoft Teams with one click or a shortcut, use push to talk, mute everyone at once, and stop attendees unmuting themselves.
How to Use Flash Fill in Excel (Ctrl + E)Flash Fill splits, joins and reformats text in Excel from a single example. Learn how to use Ctrl + E to pull out first names, combine columns and tidy data without formulas.
How to Use Slide Master in PowerPoint (Change Every Slide at Once)Use Slide Master in PowerPoint to put your logo, fonts and colours on every slide in one go, edit individual layouts, and fix a presentation where every slide looks different.
How to Add Speaker Notes in PowerPoint (and See Them While You Present)Add speaker notes to your PowerPoint slides, make the notes pane bigger, see your notes while presenting with Presenter View, and print them as handouts.
How to Sort Data in Excel (Without Scrambling Your Rows)Sort Excel data alphabetically, by number, by date, by multiple columns or by colour, and avoid the classic mistake that mixes up your rows.
How to Turn Your Camera On and Off in Teams (and Fix It When It's Black)Turn your camera on and off in Microsoft Teams, test it before a meeting, pick the right webcam, and fix a black screen or a camera that another app is using.
How to Use Categories in Outlook (Colour-Code Your Emails and Calendar)Use colour categories in Outlook to tag emails, meetings and contacts — create your own categories, rename the colours, filter by category and apply them with one click.
How to Use Styles in Word (The Secret to Tidy Documents)Learn how to use Styles in Microsoft Word: apply headings, modify a style so every heading updates, use style shortcuts and the Navigation pane.
How to Add Footnotes in Word (and Endnotes)Add footnotes and endnotes in Microsoft Word, delete them properly, change the numbering format and convert footnotes to endnotes.
How to Create an Event in Outlook Calendar (Reminders and Repeating Events)Add an appointment to your Outlook calendar, set a reminder, make it repeat every week or month, mark it private, and move or delete it — in new Outlook, classic Outlook and the phone app.
How to Filter Data in Excel (and Clear Filters Again)Show only the rows you need in Excel with filters. Filter by text, number, date or colour, use the search box, total only visible rows and clear filters when you're done.
How to Insert and Crop a Picture in PowerPoint (Including Crop to Shape)Insert a picture in PowerPoint, crop it, crop it to a circle or other shape, fill a box without stretching, and swap one picture for another without losing the formatting.
How to Raise Your Hand and Use Reactions in TeamsRaise your hand in a Microsoft Teams meeting, lower it again, send reactions like 👍 and 👏, and see who has their hand up if you're running the meeting.
How to Create a Table in Excel (and Why You Should)Turn any list into an Excel Table with Ctrl + T. Get banded rows, built-in filters, automatic formulas, a one-click Total Row and ranges that grow as you add data.
How to Insert a Page Break in Word (and When to Use a Section Break)Insert a page break in Microsoft Word with Ctrl + Enter, learn when you need a section break instead, and how to find and remove breaks.
How to Remove a Picture Background in PowerPoint (No Extra Software)Remove the background from a picture in PowerPoint using the built-in Remove Background tool, tidy up the edges with Mark Areas to Keep and Remove, and save the result as a PNG.
How to Send a Meeting Invitation in Outlook (and Track Who's Coming)Invite people to a meeting from Outlook's calendar, mark attendees as optional, see who has accepted or declined, and reschedule or cancel without confusing anyone.
How to Use the Meeting Chat in Teams (Before, During and After)Open the chat in a Microsoft Teams meeting, share links and files, find the chat again after the meeting ends, and turn chat off for attendees.
How to Add a Video to PowerPoint (YouTube or Your Own File)Add a video to a PowerPoint slide from a file or YouTube, trim the start and end, make it play automatically or full screen, and fix a video that won't play on another computer.
How to Check the Word Count in WordSee the word count in Microsoft Word, count words in a selection, show characters with and without spaces and include or exclude footnotes.
How to Start a Chat or Group Chat in Teams (and Give It a Name)Start a one-to-one chat or a group chat in Microsoft Teams, name the group, add and remove people, and decide whether newcomers can see the old messages.
How to Use the Scheduling Assistant in Outlook (Find a Time That Works for Everyone)Stop the back-and-forth. Use Outlook's Scheduling Assistant to see when colleagues are free, pick a slot that suits everyone, and use a scheduling poll for people outside your organisation.
How to Use VLOOKUP in Excel (Step-by-Step for Beginners)Learn how VLOOKUP works in plain English, with a simple example, the four arguments explained, and fixes for #N/A errors and wrong results.
How to Add Music to PowerPoint (That Plays Across All Slides)Add background music or a sound clip to PowerPoint, make it play across every slide, loop it, hide the speaker icon, fade it in and out, and record your own audio.
How to Make a Call in Teams (Audio, Video and Group Calls)Make an audio or video call in Microsoft Teams from a chat, the Calls page or someone's profile, turn a chat into a group call, and answer or decline calls with shortcuts.
How to Make Bullet Points and Numbered Lists in WordCreate bullet points and numbered lists in Microsoft Word, indent list levels, restart numbering, use custom bullets and stop automatic lists.
How to Use INDEX and MATCH in Excel (Explained Simply)INDEX and MATCH is the flexible lookup that works in every version of Excel. Learn what each function does, how to combine them, and how to do a two-way lookup.
How to Use Tasks and Microsoft To Do in OutlookTurn Outlook into a to-do list: add tasks, set due dates and reminders, turn emails into tasks, use My Day, and see the same list in Microsoft To Do on your phone.
How to Change the Layout in Outlook (Reading Pane, Density and Folder Pane)Move the reading pane to the bottom or hide it, show more emails on screen, collapse the folder pane, hide the ribbon and get Outlook looking the way you want it.
How to Find and Replace in Word (Plus Hidden Power Tricks)Use Find and Replace in Microsoft Word to fix repeated mistakes, match case and whole words, remove double spaces and replace special characters.
How to Format Messages in Teams (Bold, Lists, Code and New Lines)Add bold, italics, bullet points, headings, links, quotes and code to Microsoft Teams messages, start a new line without sending, and use the Format toolbar.
How to Use IFERROR in Excel to Hide #N/A and #DIV/0! ErrorsReplace ugly Excel errors like #N/A and #DIV/0! with a blank, a zero or a friendly message using IFERROR. Plus when to use IFNA instead, and why you shouldn't hide every error.
How to Use the Morph Transition in PowerPoint (Smooth Animation, No Effort)Use PowerPoint's Morph transition to animate objects moving, growing and changing between slides — duplicate the slide, move things, apply Morph. Plus the !! naming trick.
How to Animate Bullet Points One at a Time in PowerPointMake bullet points appear one at a time in PowerPoint, dim the previous point, apply the same animation to every slide, and fix bullets that all appear at once.
How to Edit or Delete a Message in Teams (and Undo a Delete)Edit a sent message in Microsoft Teams, delete it for everyone, restore a deleted message, and what the other person actually sees when you do.
Excel Errors Explained: What #N/A, #VALUE!, #REF! and More MeanA plain-English guide to every common Excel error: #####, #N/A, #VALUE!, #REF!, #DIV/0!, #NAME?, #SPILL! and #NUM!. What each one means and how to fix it.
How to Insert a Checkbox in Word (Printable or Clickable)Insert a checkbox in Microsoft Word — either a printable box for paper checklists or a clickable tick box using the Developer tab.
How to Turn Off Email Notifications in Outlook (or Only Get the Ones That Matter)Silence Outlook's pop-ups and sounds, keep alerts only for important people or your Focused inbox, and use Windows Do Not Disturb when you need to concentrate.
How to Add a Watermark in Word (Text or Logo)Add a watermark in Microsoft Word such as DRAFT or CONFIDENTIAL, create a custom text or picture watermark using your logo, and remove a watermark.
How to Reply to a Specific Message in Teams (Quotes and Threads)Reply to one particular message in a busy Microsoft Teams chat so everyone can see what you're answering, and use threaded replies in channels.
How to Unsubscribe from Emails in Outlook (Properly and Safely)Use Outlook's one-click Unsubscribe, manage all your subscriptions in one list, and know when it's safer to block a sender than click their unsubscribe link.
What Does the $ Sign Mean in Excel? Absolute References ExplainedFind out what the $ sign does in an Excel formula, the difference between relative, absolute and mixed references, and how to add $ signs instantly with F4.
How to Use Designer in PowerPoint (Instant Professional Slides)Use PowerPoint Designer (Design Ideas) to turn plain text and pictures into polished slides automatically, get it to appear when it doesn't, and undo a design you don't like.
How to Calculate Percentages in Excel (4 Formulas You'll Actually Use)Work out a percentage of a total, percentage change, and how to add or subtract a percentage in Excel, plus how to fix percentages that show as 2500%.
How to Change the Theme, Colours and Fonts in PowerPointChange the theme of a PowerPoint presentation, swap its colour scheme and fonts in one go, apply a theme to some slides only, and save your own theme to reuse.
How to Make Columns in Word (Newsletter Style)Create two or three columns in Microsoft Word, use columns on just part of a page, add a column break, a line between columns and balance column lengths.
How to Pin, Hide and Mute Chats in Teams (Tidy Up Your Chat List)Keep your most important Microsoft Teams chats at the top with pinning, hide old chats without deleting them, mute noisy group chats, and find a hidden chat again.
How to Stop Emails Going to Junk in Outlook (Safe Senders)Important emails landing in Junk? Add the sender to your Safe Senders list, mark messages as Not junk, allow a whole domain and adjust Outlook's junk filter level.
How to Add Slide Numbers, the Date and a Footer in PowerPointAdd slide numbers, today's date and footer text to every slide in PowerPoint, keep them off the title slide, start numbering from a different number, and fix numbers that won't appear.
How to Change the Margins in WordChange the page margins in Microsoft Word using presets, custom sizes or the ruler, set new default margins and add a gutter for binding.
How to Change Your Profile Picture in TeamsAdd or change your profile picture in Microsoft Teams on Windows, Mac and your phone, remove it again, and fix a picture that won't update or is blocked by your organisation.
How to Round Numbers in Excel (ROUND, ROUNDUP, ROUNDDOWN and More)Round numbers in Excel to decimal places, whole numbers, the nearest 10 or 100, or the nearest 0.05. Plus why the decimal buttons don't actually round your numbers.
How to Use Sweep in Outlook (Clear Thousands of Emails in Seconds)Outlook's Sweep tool deletes or moves every email from a sender in one go — and can keep doing it automatically. Here's how to use it, and the classic Outlook alternatives.
How to Add Comments in Word (Reply, Resolve and Delete)Add comments in Microsoft Word, @mention colleagues, reply to and resolve comment threads, and delete every comment before you send a document.
How to Change the Meeting View in Teams (Gallery, Large Gallery, Together Mode and Focus)Switch between Gallery, Large gallery, Together mode and Focus in Microsoft Teams meetings, see up to 49 people at once, hide your own video and show everyone at the same size.
How to Combine Text From Two Cells in ExcelJoin first and last names or any text in Excel using the & sign, CONCAT or TEXTJOIN. Add spaces, commas and line breaks, and keep number and date formatting.
How to Insert a Chart in PowerPoint (and Edit the Numbers)Insert a chart in PowerPoint, type your own numbers into the spreadsheet, change the chart type, tidy it up with the plus button, and paste a chart from Excel that stays linked.
How to Print an Email in Outlook (or Save It as a PDF)Print an email from Outlook with or without attachments, print just a page or two, and save any email as a PDF file using Microsoft Print to PDF — no extra software needed.
How to Change the Default Font in OutlookSet the font, size and colour Outlook uses for every new email and reply — in new Outlook, classic Outlook and on the web — and fix emails that arrive looking tiny.
How to Compare Two Documents in WordCompare two versions of a Microsoft Word document to see every change, accept or reject differences, ignore formatting and combine edits from two reviewers.
How to Insert a Table in PowerPoint (and Make It Readable)Insert a table in PowerPoint, add and delete rows and columns, make the rows the same height, style it so it's readable from the back, and paste a table from Excel or Word.
How to Remove Extra Spaces in Excel (TRIM and Other Fixes)Hidden spaces break lookups and sorting in Excel. Learn how to remove extra spaces with TRIM, fix non-breaking spaces from the web, and clean up data with Find and Replace.
How to Use Whiteboard in Teams MeetingsOpen Microsoft Whiteboard in a Teams meeting, draw and add sticky notes with everyone at once, use templates, and find the whiteboard again after the meeting.
How to Add Citations and a Bibliography in WordAdd citations and create a bibliography automatically in Microsoft Word in APA, MLA, Harvard or Chicago style, and update it when you add sources.
How to Change Text to Uppercase, Lowercase or Proper Case in ExcelExcel has no Change Case button, but UPPER, LOWER and PROPER fix capital letters in seconds. Here's how to use them, replace the original text, and the Flash Fill shortcut.
How to Make a Timeline in PowerPoint (SmartArt in Two Minutes)Make a timeline in PowerPoint with SmartArt, add and reorder events, change the colours and style, convert a bullet list into a timeline, and build a custom one with shapes.
How to Turn On Dark Mode in Outlook (and Turn It Off Again)Switch Outlook to dark mode on Windows, Mac, the web and your phone, keep the reading pane white if you prefer, or follow your system's light and dark schedule.
How to Control the Lobby and Who Can Present in Teams (Meeting Options Explained)Use Microsoft Teams meeting options to decide who waits in the lobby, who can present, whether attendees can unmute, and how to admit people during the meeting.
How to Add Captions to Pictures in WordAdd numbered captions to pictures and tables in Microsoft Word, create a table of figures, cross-reference captions and keep captions with their images.
How to Change the Date Format in Excel (and Fix Dates That Won't Change)Change how dates look in Excel with Format Cells and custom codes like dd/mm/yyyy and d mmm yyyy. Plus how to fix text dates, US-style dates and ##### in date columns.
How to Forward Emails Automatically in Outlook (to Another Address)Forward every email, or just some of them, from Outlook to another address automatically — using the Forwarding setting or a rule — and turn it off when you're done.
How to Use Copilot in Teams (Beginner's Guide)Use Microsoft Copilot in Teams to catch up on a meeting you joined late, summarise a long chat, list action items and draft replies — and what it can't do without a transcript.
How to Use Sections in PowerPoint (Organise a Long Presentation)Organise a long PowerPoint presentation into sections, rename and collapse them, move whole sections at once, and jump to a section while presenting.
How to Add a Tab or App to a Channel in TeamsAdd tabs to a Microsoft Teams channel so a spreadsheet, website, Planner board or OneNote notebook is one click away for the whole team, and rename, reorder or remove them.
How to Calculate the Number of Days Between Two Dates in ExcelCount days, working days, months or years between two dates in Excel. Covers simple subtraction, NETWORKDAYS with bank holidays, DATEDIF and adding days to a date.
How to Change the Time Zone in Outlook (and Show a Second One)Fix meetings showing at the wrong time by setting Outlook's time zone, add a second time zone to your calendar for colleagues abroad, and swap them when you travel.
How to Create a Hanging Indent in WordCreate a hanging indent in Microsoft Word for APA, MLA and Harvard reference lists using a shortcut, the Paragraph settings or the ruler.
How to Hide a Slide in PowerPoint (Keep It Without Showing It)Hide a slide in PowerPoint so it's skipped during the show but kept in the file, show it again, jump to a hidden slide if you need it, and set up a custom show for different audiences.
How to Add Hyperlinks and Buttons in PowerPoint (Link to a Slide, a Website or a File)Add a hyperlink in PowerPoint to a website, another slide or a file, turn a shape into a clickable button, add a Home button to every slide, and fix links that don't work.
How to Calculate Age From a Date of Birth in ExcelCalculate someone's age from their date of birth in Excel with DATEDIF and TODAY. Get age in years, years and months, or age on a specific date, and avoid the divide-by-365 mistake.
How to Set Your Working Hours and Location in OutlookTell Outlook when you work and where — office or home — so colleagues stop booking you at 7am, the Scheduling Assistant knows your day, and your hybrid week is visible to the team.
How to Use Format Painter in WordUse Format Painter in Microsoft Word to copy formatting from one piece of text to another, lock it on for multiple uses, and use the keyboard shortcut.
How to Use Planner in Teams (Shared Task Boards for Your Team)Set up a Planner board in a Microsoft Teams channel, add tasks with owners and due dates, organise them into buckets, and track progress with the Board and Charts views.
How to Clear Formatting in Word (and Paste Without Formatting)Clear all formatting in Microsoft Word with one click or a shortcut, paste text without formatting, and set Keep Text Only as your default paste option.
How to Hide and Unhide Rows and Columns in ExcelHide and unhide rows and columns in Excel with a right-click or keyboard shortcut, unhide everything at once, and bring back a hidden column A or row 1.
How to Set Up Outlook on Your iPhone or Android PhoneInstall the Outlook app, add your work and personal email accounts, set up swipe actions and notifications, and learn the features that make Outlook mobile worth using.
How to Use Teams on Your Phone (Mobile App Essentials)Install Microsoft Teams on iPhone or Android, join meetings and chat on the go, set quiet hours so it doesn't buzz all evening, and use your phone as a second screen in meetings.
How to Use Zoom in PowerPoint (An Interactive Menu for Your Slides)Use PowerPoint's Zoom feature to build an interactive menu slide — Summary Zoom, Section Zoom and Slide Zoom explained, with the settings that make it return to the menu after each section.
How to Add a Guest to a Team in Microsoft Teams (External Users)Invite someone outside your organisation into a Microsoft Teams team as a guest, understand what guests can and can't do, and remove them when the project ends.
How to Align Objects in PowerPoint (Guides, Smart Guides and Distribute)Line up shapes, pictures and text boxes in PowerPoint with the Align menu, space them evenly with Distribute, use Smart Guides and drawing guides, and centre something on the slide.
How to Insert Multiple Rows in Excel at OnceInsert several rows or columns in Excel in one go with a right-click or Ctrl + Shift + +. Plus how to insert a blank row between every row, and what to do when Insert is greyed out.
How to Request a Read Receipt in Outlook (and Whether You Should)Ask for a read receipt or delivery receipt on an Outlook email, understand why they often don't come back, and decide how to respond when someone requests one from you.
How to Show Formatting Marks in Word (¶)Show hidden formatting marks in Microsoft Word — paragraph marks, spaces, tabs, and page and section breaks — to fix layout problems fast.
How to AutoFit Column Width and Row Height in ExcelFix cut-off text and ##### in Excel by auto-fitting columns and rows to their contents. Double-click method, whole-sheet AutoFit, keyboard shortcuts and fixes when AutoFit doesn't work.
How to Group Objects in PowerPoint (Move Several Things as One)Group shapes, pictures and text in PowerPoint so they move and resize together, edit one item inside a group, ungroup and regroup, and fix the greyed-out Group button.
How to Insert Symbols in Word (©, °, €, ™ and More)Insert symbols in Microsoft Word such as copyright, degree, euro, trademark, arrows and dashes using the Symbol menu, shortcuts, AutoCorrect and Alt codes.
How to Leave a Team or Group Chat in Teams (and Hide Ones You Can't Leave)Leave a team or a group chat in Microsoft Teams, hide a team you have to stay in, what happens to your messages and files when you go, and how to get back in.
How to Use Cc and Bcc in Outlook (and Show the Bcc Field)What Cc and Bcc mean, when to use each, how to make the Bcc box appear in new and classic Outlook, and how to email a big group without sharing everyone's address.
How to Keep Leading Zeros in ExcelStop Excel removing the zeros from the start of phone numbers, ID numbers and codes. Use an apostrophe, a custom number format, the TEXT function, or turn off automatic conversion.
How to Turn an Email into a Calendar Event or Task in OutlookDrag an email onto the calendar to make an appointment with the email attached, reply to an email with a meeting invitation, or drop it into My Day to make it a task.
How to Use Loop Components in Teams (Live Lists, Tables and Checklists in Chat)Add a Loop component to a Microsoft Teams chat or channel — a list, table, checklist or paragraph that everyone edits together and that stays in sync wherever it's shared.
How to Use the Eyedropper in PowerPoint (Match Any Colour Exactly)Use PowerPoint's Eyedropper to pick a colour from a logo or photo and apply it to shapes, text and backgrounds, grab a colour from outside PowerPoint, and add it to your theme colours.
How to Write Equations in WordWrite maths equations in Microsoft Word with the Equation editor — fractions, powers, square roots and Greek letters — using Alt + =, shortcuts or handwriting.
How to Change the Slide Background in PowerPoint (Colour, Gradient or Picture)Change the background of one slide or every slide in PowerPoint — solid colour, gradient, picture or texture — make a background picture more transparent so text is readable, and remove a background.
How to Create a Fillable Form in WordCreate a fillable form in Microsoft Word with text boxes, drop-down lists, date pickers and checkboxes, then lock it so people can only fill in the fields.
How to Schedule a Message in Teams (Send It Later)Write a Microsoft Teams chat message now and have it delivered later with Schedule send — perfect for other time zones, Monday mornings and not pinging people after hours.
How to Transpose Data in Excel (Switch Rows and Columns)Flip rows into columns, or columns into rows, in Excel using Paste Special > Transpose or the TRANSPOSE function. Plus how to fix the overlap and #SPILL! errors.
How to Use Quick Steps in Outlook (One-Click Email Actions)Create Quick Steps in Outlook that file, flag, forward or reply to an email with a single click or keyboard shortcut — in classic Outlook and the new Outlook settings.
How to Password Protect a Word DocumentPassword protect a Microsoft Word document so it can't be opened without a password, remove a password, or restrict editing so the document is read-only.
How to Spotlight and Pin Someone's Video in TeamsPin a person's video so it stays on your screen in a Microsoft Teams meeting, or spotlight them so everyone sees them large — including spotlighting yourself when you're presenting.
How to Turn a PowerPoint into a Video (MP4 with Narration and Timings)Export a PowerPoint presentation as an MP4 video, choose the quality, set how long each slide stays on screen, include your recorded narration and timings, and fix an export that fails.
How to Turn Conversation View On or Off in OutlookOutlook groups email threads into conversations. Learn how to turn it on or off, show the newest message on top, and make grouped emails easier to follow.
How to Use Paste Special in Excel (7 Tricks Worth Knowing)Paste Special lets you paste values without formulas, copy formatting or column widths, transpose data and even do maths as you paste. Here are the Paste Special tricks worth knowing.
How to Clean Up Your Inbox in Outlook (Clean Up, Ignore and Mark All as Read)Four fast ways to tame an overflowing Outlook inbox: Clean Up redundant replies, Ignore conversations you don't care about, mark everything as read, and empty a folder in one go.
How to Convert a PDF to Word for Free (No Website Needed)Convert a PDF to an editable Word document for free using Microsoft Word itself — no online converter — plus tips for scanned PDFs and layout problems.
How to Download an Attendance Report in Teams (Who Joined and for How Long)See who attended a Microsoft Teams meeting, when they joined and left, and download the attendance report as a spreadsheet — during the meeting or afterwards.
How to Save a PowerPoint as a PDF (Slides, Handouts or Notes)Save a PowerPoint presentation as a PDF, choose one slide per page or several, include speaker notes, leave out hidden slides, and keep the file size down for emailing.
How to Use Find and Replace in Excel (Including Wildcards)Find anything in an Excel workbook and replace it in seconds. Learn Ctrl + F and Ctrl + H, search every sheet, match whole cells, use wildcards and find cells by formatting.
How to Create a Poll in an Outlook EmailAdd a poll to an Outlook email so people vote with one click instead of replying — create it, see the results, and use voting buttons in classic Outlook.
How to Lock Cells in Excel (Protect Formulas, Allow Typing)Stop people accidentally overwriting formulas in Excel. Learn how to lock specific cells, leave input cells editable, hide formulas and protect a sheet with or without a password.
How to Print Handouts in PowerPoint (Several Slides per Page)Print PowerPoint handouts with 2, 3, 4, 6 or 9 slides per page, add lines for notes, print in black and white to save ink, add a header and footer, and leave out hidden slides.
How to Print Labels in Word (Avery and More)Print address labels in Microsoft Word using the Labels tool — choose your Avery product number, print a full sheet or a single label, and test before printing.
How to Use Scheduling Assistant in Teams (Find a Time That Works for Everyone)Use Scheduling Assistant in the Microsoft Teams calendar to see when colleagues are free, drag a meeting into a gap, and check availability for rooms and optional attendees.
How to Change Text Case in Word (Fix CAPS LOCK Without Retyping)Change text to uppercase, lowercase, sentence case or capitalise each word in Microsoft Word using Shift + F3 or the Change Case button.
How to Insert a Checkbox in Excel (and Build a To-Do List)Add tick boxes to Excel cells in Microsoft 365 with Insert > Checkbox, count ticked items, strike through completed tasks, and add checkboxes in older versions using the Developer tab.
How to @Mention Someone in an Outlook EmailUse @mentions in Outlook to grab a colleague's attention inside an email, add them to the recipients automatically, and filter your inbox to see only emails where you're mentioned.
How to Rehearse Timings in PowerPoint (and Advance Slides Automatically)Use Rehearse Timings in PowerPoint to practise your talk and see how long each slide takes, save the timings so slides advance automatically, set a fixed time per slide, and turn timings off again.
How to Search in Teams (Messages, Files and People)Find any message, file or person in Microsoft Teams with the search box, filter results by date, sender and chat, search inside one conversation, and use slash commands.
How to Add a Page Border in WordAdd a page border in Microsoft Word — plain lines or decorative art borders — apply it to the first page only, fix borders that get cut off, and remove it.
How to Insert a Picture into the Body of an Email in OutlookPut a picture inline in an Outlook email rather than as an attachment, resize it, add alt text, and fix the common problem of Outlook attaching images instead of showing them.
How to Make a PowerPoint Loop Automatically (Self-Running Display)Set up a PowerPoint presentation that runs on its own and loops forever — for a reception screen, trade stand or open day — with kiosk mode, automatic slide timing and a file that opens straight into the show.
How to Set Up a Webinar in Teams (Registration, Presenters and Q&A)Create a Microsoft Teams webinar with a registration page, add presenters and co-organisers, control what attendees can do, and download the registration and attendance lists.
How to Use the FILTER Function in ExcelThe FILTER function creates a live, self-updating filtered list in Excel. Learn the formula, AND and OR conditions, how to handle no results, and how to sort the output.
How to Create and Use Named Ranges in ExcelGive cells and ranges meaningful names in Excel so formulas read like =Price*VAT. Create names with the Name Box, from headings, manage them with Name Manager and jump to them fast.
How to Draw in Word (Pens, Highlighters and Shapes)Draw in Microsoft Word using the Draw tab's pens and highlighters, a drawing canvas and shapes — plus how to turn on the Draw tab if it's missing.
How to Fix Your Microphone or Camera Not Working in TeamsStep-by-step fixes when Microsoft Teams can't hear you or your camera won't turn on: device settings, Windows and Mac privacy permissions, test calls, drivers and the browser version.
How to Reduce the File Size of a PowerPoint (Compress Pictures and Media)Make a PowerPoint file smaller so it will email — compress pictures, delete cropped areas, compress videos and audio, remove unused slide masters, and find what's making the file big.
How to Use Copilot in Outlook (Draft, Summarise and Coach)A beginner's guide to Copilot in Outlook: summarise a long email thread, draft a reply from a few words, get coaching on tone before you send, and find what's hiding in your inbox.
How to Embed Fonts in PowerPoint (So It Looks Right on Any Computer)Embed fonts in a PowerPoint file so your presentation looks the same on another computer, choose between embedding all characters or just the ones used, and fix fonts that won't embed.
How to Fix Teams Not Loading or Stuck (Clear the Cache and More)Fix Microsoft Teams when it won't open, sits on the loading screen, freezes or shows old messages — sign out, clear the Teams cache on Windows and Mac, repair or reinstall the app.
How to Insert a Text Box in WordInsert a text box in Microsoft Word, remove its border, move it freely around the page, rotate the text and link text boxes so text flows between them.
How to Use Goal Seek in Excel (Work Backwards to an Answer)Know the result you want but not the input you need? Goal Seek in Excel works backwards to find it. Step-by-step examples for exam marks, break-even sales and loan payments.
How to Use Read Aloud and Dictate in OutlookHave Outlook read your emails to you and write emails by talking — how to use Read Aloud, Immersive Reader and Dictate in new and classic Outlook, plus the voice commands that matter.
How to Add Sparklines in Excel (Mini Charts in a Cell)Sparklines are tiny charts that fit inside a single Excel cell. Learn how to insert line, column and win/loss sparklines, highlight high and low points, and remove them.
How to Copy Slides From Another Presentation in PowerPoint (and Keep the Look)Copy slides from one PowerPoint presentation to another with Reuse Slides or copy and paste, choose whether they take on the new design or keep their own, and tidy up afterwards.
How to Make a Flowchart in WordMake a flowchart in Microsoft Word the easy way with SmartArt, or build a custom flowchart with shapes and connectors on a drawing canvas.
How to Reduce Background Noise in Teams (Noise Suppression and Voice Isolation)Turn on noise suppression and voice isolation in Microsoft Teams so typing, traffic, dogs and other people's conversations don't make it into your meeting.
Outlook Not Receiving Emails? 8 Fixes to TryEmails not arriving in Outlook? Work through these eight fixes in order — Other tab, Junk, rules, Work Offline, a full mailbox, blocked senders, account passwords and repairing the profile.
How to Add a Hyperlink in WordAdd a hyperlink in Microsoft Word to a website, email address, file or heading in the same document, follow links with Ctrl + click and remove hyperlinks.
How to Change the Slide Size in PowerPoint (16:9, 4:3, A4 and Custom)Change the slide size in PowerPoint between widescreen 16:9 and standard 4:3, set a custom size such as A4, a poster or a social media square, and choose Maximize or Ensure Fit without ruining your slides.
How to Group Rows and Columns in Excel (Collapse and Expand)Group rows or columns in Excel so you can collapse and expand sections with a click. Includes the keyboard shortcut, outline levels, automatic subtotals and how to ungroup.
How to Start an Instant Meeting in Teams (Meet Now)Start a Microsoft Teams meeting right now without scheduling it — from the calendar, a chat or a channel — then invite people by name or share the link.
Outlook Email Stuck in the Outbox? How to Fix ItAn email sitting in Outlook's Outbox won't send — here's why it happens (attachments, offline mode, passwords, delayed delivery) and how to get it moving or delete it.
How to Add Comments and Work Together in PowerPoint (Co-Authoring)Add, reply to and resolve comments in PowerPoint, @mention a colleague, share a presentation so several people can edit it at once, see who changed what, and remove all comments before sending.
How to Back Up Outlook Emails (Export to a PST File)Export your Outlook email, contacts and calendar to a .pst file for safekeeping or to move to a new computer, export an Outlook.com mailbox, and open a .pst file later.
How to Count Blank and Non-Blank Cells in ExcelCount filled cells, empty cells, numbers or text in Excel with COUNT, COUNTA, COUNTBLANK and COUNTIF. Plus why COUNTA sometimes counts cells that look empty.
How to Create Tags in Teams (@Mention a Group of People at Once)Create tags in Microsoft Teams such as @managers or @weekend-shift so you can notify a group of people in a channel with one mention, and manage who's in each tag.
How to Use Read Aloud in Word (Make Word Read to You)Make Microsoft Word read your document out loud with Read Aloud, change the voice and speed, and use Immersive Reader for easier reading.
How to Add and Edit Contacts in Outlook (and Import from a Spreadsheet)Add a contact from an email or from scratch, edit and merge duplicates, import a list of contacts from a CSV spreadsheet, and sync Outlook contacts to your phone.
How to Change the Default Font in WordChange the default font and size in Microsoft Word so every new document starts the way you like — plus how to change default line spacing.
How to Show Formulas in Excel Instead of ResultsSee every formula in an Excel sheet at once with Ctrl + `, display a single formula with FORMULATEXT, trace precedents, and fix cells that show the formula instead of the answer.
How to Use Copilot in PowerPoint (Beginner's Guide)Use Copilot in PowerPoint to create a presentation from a prompt or a Word document, add a slide, rewrite text, summarise a deck, and tidy the design — plus what it can't do and what to check.
How to Use the Activity Feed in Teams (and Stop Missing Mentions)Understand the Activity feed in Microsoft Teams, filter it to show only @mentions, replies or missed calls, mark everything as read, and use it as your morning catch-up list.
How to Add a Calendar in Outlook (Holidays, Birthdays, Sport and Shared Calendars)Add UK bank holidays, your team's fixtures, a colleague's calendar or your own extra calendar to Outlook, show them side by side or overlaid, and hide the ones you don't need today.
How to Add a Header and Footer in Excel (Page Numbers, Dates and More)Add a header and footer to an Excel sheet so every printed page shows a title, page numbers, the date or the file name. Includes Page 1 of 5, a different first page, and adding a logo.
How to Add Live Subtitles in PowerPoint (Captions as You Speak)Turn on live subtitles in PowerPoint so your words appear as captions while you present, translate them into another language on screen, position and style them, and fix subtitles that don't appear.
How to Mark a Message as Unread and Turn Off Read Receipts in TeamsMark a Microsoft Teams chat as unread so you remember to come back to it, see who has read your messages, and switch read receipts off so nobody sees when you've read theirs.
How to Use AutoSave and Version History in WordTurn on AutoSave in Microsoft Word so you never lose work, and use Version History to open or restore an earlier version of a document.
How to Forward an Email as an Attachment in OutlookForward an email as an attachment in Outlook so the recipient gets the original intact — including its headers and attachments — in new Outlook, classic Outlook and on the web.
How to Repeat Header Rows on Every Printed Page in ExcelPrint your column headings at the top of every page in Excel with Print Titles. Also repeat columns on the left, and fix the greyed-out Rows to repeat at top box.
How to Translate a Document in WordTranslate a whole document or selected text in Microsoft Word into over 100 languages with the built-in Translator, and set the correct proofing language.
How to Use Emojis, GIFs and Stickers in Teams (and Add Your Own)Send emojis, GIFs and stickers in Microsoft Teams, react to messages, use emoji shortcodes like :smile:, upload custom emojis for your organisation, and turn GIFs off if they're not appropriate.
How to Use Speaker Coach in PowerPoint (Practise With AI Feedback)Rehearse a presentation with PowerPoint's Speaker Coach — it listens as you practise and reports on pace, filler words, reading from the slides and more. How to start it, read the report and improve.
How to Post an Announcement in a Teams Channel (and Post to Several Channels at Once)Post a big, headlined announcement in a Microsoft Teams channel, add a banner image, post the same message to several channels at once, and turn replies off for one-way notices.
How to Recover an Unsaved or Lost Excel FileClosed Excel without saving, or it crashed? Here's how to get your work back with Recover Unsaved Workbooks, Document Recovery and Version History, and how to stop it happening again.
How to Recover an Unsaved PowerPoint (5 Ways)Recover an unsaved or crashed PowerPoint presentation — the Document Recovery pane, Recover Unsaved Presentations, AutoRecover files, OneDrive version history and the Recycle Bin — then set AutoSave so it never happens again.
How to Translate an Email in OutlookTranslate an email you've received into English with one click, translate a selected sentence, set Outlook to translate automatically, and translate your own email before sending.
How to Use Copilot in Word (Beginner's Guide)A beginner's guide to Copilot in Microsoft Word — draft a document from scratch, rewrite paragraphs, summarise long documents and ask questions about your file.
How to Create Slides From a Word Document in PowerPointTurn a Word document into PowerPoint slides — set up headings in Word, use Slides from Outline or Export to PowerPoint, fix the layout, and go the other way to export slides to Word.
How to Encrypt an Email in Outlook (and Mark It Confidential)Send an encrypted email from Outlook so only the recipient can read it, stop it being forwarded, add a sensitivity label, and understand what encryption does and doesn't protect.
How to Open a CSV File in Excel Without Breaking Your DataDouble-clicking a CSV can strip leading zeros, mangle dates and long numbers, and garble accented letters. Import CSV files into Excel properly with Data > From Text/CSV.
How to Switch Between Accounts and Organisations in TeamsAdd a second work, school or personal account to Microsoft Teams, switch between organisations you're a guest in, see notifications from all of them, and sign out of one without losing the rest.
How to Use Spell Check and Grammar Check in WordUse spell check and grammar check in Microsoft Word — understand the red and blue underlines, run a full check with F7, add words to the dictionary and switch to UK English.
How to Add a Cover Page in WordAdd a professional cover page in Microsoft Word, fill in the title and author placeholders, remove boxes you don't need, hide the page number and remove the cover page.
How to Insert a Picture in a Cell in ExcelPut pictures inside Excel cells so they sort, filter and resize with your data. Use Place in Cell, the IMAGE function, or lock floating pictures to cells in older versions.
How to Record Your Screen in PowerPoint (Free Screen Recorder)Use PowerPoint's built-in screen recorder to capture part of your screen with audio and the mouse pointer, trim the recording, save it as an MP4 and use it in a slide or on its own.
How to Spot and Report a Phishing Email in OutlookSix signs an email is a scam, how to check a sender's real address and a link's real destination in Outlook, and how to report phishing so it stops reaching you and your colleagues.
How to Take Meeting Notes in Teams (Collaborative Notes, Agenda and Follow-up Tasks)Use the Notes button in Microsoft Teams meetings for a shared agenda, live notes everyone can edit, and follow-up tasks that go straight to Planner and To Do — then find them again afterwards.
How to Add a Table of Contents in Word (That Updates Itself)Create an automatic, clickable table of contents in Microsoft Word using Heading styles — then update it, customise it and fix headings that won't appear.
How to Recall an Email in Outlook (and When It Won't Work)Sent an email too soon? Learn how to recall a message in new Outlook, classic Outlook and Outlook on the web — plus how to set up Undo Send so you never need to.
How to Share Your Screen in Microsoft Teams (Without Oversharing)Share your whole screen, a single window or a PowerPoint in Microsoft Teams meetings — include computer sound, give control, and fix screen sharing on a Mac.
How to Use Presenter View in PowerPoint (See Your Notes)See your speaker notes, the next slide and a timer while your audience sees only the slides. How to turn on Presenter View in PowerPoint, fix the wrong screen, and practise with one monitor.
How to Use XLOOKUP in Excel (With Simple Examples)Learn how to use XLOOKUP in Excel with easy, real-world examples — find prices, names and more, look to the left, and replace #N/A errors with a friendly message.
How to Add Transitions and Animations in PowerPointAdd slide transitions and animations in PowerPoint, make bullet points appear one at a time, use Morph for smooth movement, and control timing with the Animation Pane.
How to Blur Your Background in Microsoft TeamsBlur your background in Microsoft Teams before or during a meeting, use a picture as your background, upload your own image, and get a cleaner blur with better lighting.
How to Freeze Panes in Excel (Rows, Columns or Both)Keep your headings visible while you scroll. Learn how to freeze the top row, the first column, or multiple rows and columns in Excel — and how to unfreeze them.
How to Set Up an Out of Office in Outlook (Automatic Replies)Turn on automatic replies in new Outlook, classic Outlook and Outlook on the web. Set start and end dates, write separate replies for outside senders, and see example messages.
How to Use Track Changes in Word (Edit, Accept and Reject)Learn how to turn on Track Changes in Word, choose how edits are shown, accept or reject changes one by one or all at once, and add comments.
How to Add an Email Signature in Outlook (Every Version)Create a professional email signature in new Outlook, classic Outlook, Outlook on the web and the Outlook mobile app — and make it appear automatically on every email.
How to Add Page Numbers in Word (and Skip the First Page)Add page numbers in Microsoft Word, show 'Page 1 of 10', remove the number from the cover page, and start numbering from any page or number you like.
How to Create a Pivot Table in Excel (Beginner's Guide)A step-by-step beginner's guide to PivotTables in Excel: prepare your data, create a PivotTable, drag fields to summarise sales, and refresh it when your data changes.
How to Record a Presentation in PowerPoint (With Voice and Video)Record your PowerPoint presentation with voiceover and webcam, use the teleprompter, re-record single slides, and export it as an MP4 video to share.
How to Record a Microsoft Teams Meeting (and Find the Recording)Record a Microsoft Teams meeting, stop the recording, and find, share or download it afterwards. Plus what to do if the Record button is missing.
How to Create a Drop-Down List in Excel (Step by Step)Create a drop-down list in Excel with Data Validation — type the options directly or use a range, make the list grow automatically, block wrong entries, and remove it.
How to Delete a Blank Page in Word (Even the Stubborn Ones)Get rid of an unwanted blank page in Microsoft Word — including the one that won't delete at the end of a document after a table. Every cause and fix explained.
How to Schedule an Email in Outlook (Send It Later)Write an email now and send it later. How to schedule emails in new Outlook, classic Outlook, Outlook for Mac and the Outlook mobile app — and how to edit or cancel them.
How to Use Breakout Rooms in Microsoft TeamsSplit a Teams meeting into small groups with breakout rooms. Create rooms, assign people, send announcements, set a timer and bring everyone back.
How to Change Your Status in Microsoft Teams (and Why It Goes Yellow)Set your Teams status to Available, Busy, Do not disturb or Away, make it reset automatically, add a status message, and understand why Teams shows you as Away.
How to Create Rules in Outlook (Sort Your Email Automatically)Set up rules in new Outlook, classic Outlook and Outlook on the web to move newsletters, file receipts and flag important emails automatically. Plus how to run rules on old email.
How to Save a Word Document as a PDF (Free, Built In)Convert a Word document to PDF for free using Word itself — on Windows, Mac and Word for the web. Plus how to save only some pages, add bookmarks and make the file smaller.
How to Use Conditional Formatting in Excel (Beginner's Guide)Use conditional formatting in Excel to highlight values, spot duplicates, add data bars and colour scales, and colour a whole row based on one cell.
Excel Keyboard Shortcuts for Beginners (The Ones Worth Learning)The Excel keyboard shortcuts beginners actually need: move and select data fast, AutoSum, insert dates, format cells, add filters, Flash Fill and more — with Mac equivalents.
How to Create a Team and Channels in Microsoft TeamsCreate a new team in Microsoft Teams, choose private or public, add members and set up channels — including private and shared channels. Plus tips to keep it tidy.
How to Recover an Unsaved Word Document (5 Ways)Word crashed or you closed without saving? Try these five ways to recover an unsaved or lost Word document — and set up AutoSave so it never happens again.
How to Share Your Calendar in OutlookShare your Outlook calendar with colleagues, family or an assistant. Choose how much they see, let them edit, publish a calendar link, and stop sharing when you need to.
How to Block Emails in Outlook (Senders and Whole Domains)Block unwanted senders and entire domains in new Outlook, classic Outlook and Outlook on the web. Plus how to report phishing, unblock someone and stop real emails going to Junk.
How to Change Line Spacing in Word (and Remove Extra Gaps)Change line spacing in Word to single, 1.5 or double, remove the extra space between paragraphs, and set your favourite spacing as the default for new documents.
How to Manage Notifications in Microsoft Teams (Without Missing What Matters)Turn down the noise in Microsoft Teams: change notification settings, mute chats, quieten channels, use Do not disturb with priority access, and set quiet hours on your phone.
How to Remove Duplicates in Excel (3 Easy Ways)Clean up your spreadsheet by removing duplicate rows in Excel. Use Remove Duplicates, highlight duplicates before deleting, or use the UNIQUE function to keep your original list.
How to Create a Teams Meeting in OutlookSchedule a Microsoft Teams meeting straight from your Outlook calendar in new Outlook, classic Outlook and Outlook on the web. Add a Teams link to every meeting and fix a missing Teams button.
How to Do a Mail Merge in Word (Letters, Labels and Emails)A step-by-step guide to mail merge in Word using an Excel list. Create personalised letters, address labels and emails, and fix formatting problems with numbers and dates.
How to Wrap Text in Excel (and Add Line Breaks in a Cell)Stop long text spilling across your spreadsheet. Learn how to wrap text in Excel, add a line break inside a cell, and fix rows that won't grow to fit.
Microsoft Teams Keyboard Shortcuts (The Ones Worth Learning)The most useful Microsoft Teams keyboard shortcuts: mute and unmute, turn your camera on and off, raise your hand, push to talk, answer calls, search and more — with Mac equivalents.
How to Archive Emails in Outlook (Clear Your Inbox Without Deleting)Use the Archive button in new Outlook, classic Outlook and Outlook on the web to clear your inbox without deleting anything. Plus Online Archive, AutoArchive and finding archived email.
How to Merge Cells in Excel (and a Better Alternative)Learn how to merge and unmerge cells in Excel, why merged cells cause problems with sorting and filtering, and how to use Center Across Selection instead.
How to Move a Picture Freely in Word (Text Wrapping Explained)Pictures in Word jumping around or refusing to move? Learn how text wrapping works, how to place images anywhere on the page, and how to stop them moving when you type.
How to Use Live Captions and Transcripts in Microsoft TeamsTurn on live captions in Microsoft Teams meetings, change the spoken language, start a transcript, and find and download it after the meeting.
How to Create a Contact Group in Outlook (Email Lots of People at Once)Create a contact list (contact group) in new Outlook, classic Outlook and Outlook on the web, then email everyone by typing one name. Plus how to keep addresses private with Bcc.
How to Make a Chart in Excel (Beginner's Guide)Create a chart in Excel in seconds, choose the right chart type, add titles and data labels, and fix charts that come out the wrong way round.
How to Share Files in Microsoft Teams (Chats and Channels)Share files in Microsoft Teams chats and channels, edit documents together in real time, find where Teams files are stored, and sync them to File Explorer.
How to Use Dictate in Word (Type With Your Voice)Use Microsoft Word's free Dictate feature to type with your voice. Learn the voice commands for punctuation and new lines, change settings, and dictate in any app on Windows.
How to Create a Poll in Microsoft Teams (Chats and Meetings)Create a quick poll in a Teams chat or channel, run polls during meetings, choose anonymous or multiple answers, and see the results live.
How to Make One Page Landscape in WordMake just one page landscape in a Word document while the rest stays portrait — perfect for wide tables and charts. Two easy methods, plus how to fix page numbers afterwards.
How to Search Emails in Outlook Like a ProFind any email in seconds with Outlook search operators like from:, subject:, hasattachments: and received:, exact phrases, search filters and the right search scope.
How to Use the IF Function in Excel (With Easy Examples)Learn the Excel IF function with simple examples: pass/fail, overdue invoices and bonuses. Plus how to check more than one condition with AND, OR and IFS.
How to @Mention Someone in Microsoft Teams (and Get Noticed)Use @mentions in Microsoft Teams to notify a person, a channel, a whole team or a tag group. Plus how to mark messages as important or urgent, and find your own mentions.
How to Recover Deleted Emails in Outlook (Even After Emptying the Bin)Recover deleted emails in new Outlook, classic Outlook and Outlook on the web — from Deleted Items, and from Recoverable Items after the folder has been emptied.
How to Use COUNTIF and SUMIF in Excel (Simple Guide)Count and add up only the rows that match. Learn COUNTIF, SUMIF, COUNTIFS and SUMIFS in Excel with real examples, criteria like greater than, and wildcards.
How to Split Text into Columns in Excel (3 Easy Ways)Split full names, addresses or codes into separate columns in Excel using Text to Columns, Flash Fill or the TEXTSPLIT function — with step-by-step examples.
How to Use (or Turn Off) Focused Inbox in OutlookWhat Outlook's Focused Inbox is, how to teach it which emails matter, and how to turn it off in new Outlook, classic Outlook, Outlook on the web and the mobile app.
How to Flag Emails and Set Reminders in OutlookFlag emails in Outlook so nothing slips through the cracks. Set due dates and reminders, snooze and pin emails in new Outlook, and see flagged emails in Microsoft To Do.
How to Print an Excel Sheet on One PageFit your Excel spreadsheet onto one printed page, set a print area, switch to landscape, repeat headings on every page and adjust page breaks.
How to Create Email Templates in Outlook (Stop Retyping the Same Email)Save time with email templates in Outlook. Use My Templates in new Outlook and Outlook on the web, save .oft templates and Quick Parts in classic Outlook.
How to Password Protect an Excel File (and Lock Cells)Add a password to open an Excel workbook, protect a sheet from changes, lock only some cells, and stop people adding or deleting sheets. Plus how to remove a password.
How to Add a Shared Mailbox in OutlookOpen a shared mailbox like info@ or sales@ in new Outlook, classic Outlook and Outlook on the web, send emails from it, and fix a shared mailbox that won't appear.
New Outlook vs Classic Outlook: What's the Difference (and How to Switch)New Outlook or classic Outlook? Learn the key differences, how to tell which one you have, and how to switch between them — and back again — on Windows.
Outlook Keyboard Shortcuts That Save HoursThe most useful Outlook keyboard shortcuts for writing, replying, sending, tidying your inbox and switching between Mail and Calendar — plus how to use Gmail shortcuts in new Outlook.