Explore practical tutorials for Microsoft Office and Microsoft 365 applications, including Excel, Word, PowerPoint, and Outlook. These guides are designed to help you learn common features, complete everyday tasks, and become more comfortable using Microsoft tools for work, school, and personal projects.
Use the links below to browse tutorials by program, or continue down the page to explore the latest Microsoft Office tutorials.
Browse Tutorials
Microsoft Word Basics: Features, Tools, and Functions Explained
Get familiar with Microsoft Word and learn what its most common tools and features do. This guide explains Word’s main tabs, formatting options, styles, tables, images, page layout tools, headers and footers, saving files, and more, with a guided video walkthrough and detailed training manual for additional help.
How to Use PowerPoint to Prepare for an Interview
Learn how to use PowerPoint as a practical interview preparation tool. This guide includes free, customizable presentation templates, step-by-step instructions, and additional presentation ideas to help you research a company, understand a role, organize your thinking, and prepare more confidently for interviews or new responsibilities.
How to Turn on & Use the Undo Send Option in Outlook
Learn how to turn on and use Undo Send in the new Outlook. This tutorial shows you how to choose a sending delay, find the Undo button, and return an email to draft form before it is delivered – giving you time to catch typos, missing attachments, or incorrect recipients.
How to Insert a Horizontal Line Across the Page in Word (3 Easy Methods)
Learn three easy ways to insert a horizontal line across the page in Microsoft Word. This tutorial covers the AutoFormat shortcut, the Borders button, and drawing lines with Shapes, plus how to customize line styles, colors, and thickness for professional-looking documents.
How to Add & Use Speaker Notes in PowerPoint
Learn how to add, format, and use speaker notes in Microsoft PowerPoint. This tutorial shows how to display the Notes pane, organize talking points, use Presenter View, and confidently present during in-person or online meetings while keeping your notes hidden from your audience.
How to Get Missing Inbox Columns Back in Outlook
Learn how to restore missing inbox columns such as Subject, From, or Received in Classic Microsoft Outlook. This tutorial also shows how to add new columns and customize the order of your inbox so you can display the information that’s most important to you.
How to Record Your Screen Using PowerPoint & Add It to a Slide
Learn how to record your screen directly in Microsoft PowerPoint and insert the recording into a presentation. This tutorial shows how to capture a specific area of your screen, record audio and mouse movements, and create software demonstrations, tutorials, or narrated presentations without additional screen recording software.
How to Remove Extra Spaces in Excel
Learn how to remove extra spaces from text in Microsoft Excel using the TRIM function. This beginner-friendly tutorial explains what TRIM removes, when to use it, and why it’s one of the most useful functions for cleaning imported or inconsistent data.
How to Create Recurring Appointments & Tasks in Outlook
Learn how to create recurring appointments and recurring tasks in Microsoft Outlook. This step-by-step tutorial shows how to schedule daily, weekly, monthly, yearly, and custom recurring reminders in both Classic Outlook and New Outlook so you can automate your calendar and stay organized.
How to Remove the Thick Black Line (Horizontal Line) in Word
Learn how to remove the thick black line that sometimes appears in Microsoft Word after pressing Enter. This tutorial explains why it happens, how to remove it using paragraph borders, how to prevent it from happening again, and includes a quick reference guide for Word’s automatic line styles.
How to Create an Order Form with Drop-Down Menus in Microsoft Excel
Learn how to create a professional order form in Microsoft Excel using drop-down menus, Data Validation, and named ranges. This step-by-step tutorial also covers formatting dates, ZIP codes, and credit card fields to build cleaner, more accurate spreadsheets for real-world business use.
How to Change the Orientation in PowerPoint
Learn how to change slide orientation in Microsoft PowerPoint from landscape to portrait. This step-by-step tutorial shows where to find the Slide Size settings, explains the available layout options, and includes tips for preserving your slide content when changing orientations.
How to Auto-Populate Fields in Excel Using a Drop-Down and VLookup
Learn how to combine a drop-down list with VLOOKUP to automatically populate customer information in Microsoft Excel. This step-by-step tutorial demonstrates a practical business workflow that can be adapted for order forms, packing lists, customer databases, contact management, and other data-entry tasks.
How to Use XLOOKUP for Multi Criteria Searches in Excel
Learn how to use XLOOKUP to retrieve data based on multiple criteria in Microsoft Excel. This step-by-step tutorial demonstrates how to combine values from multiple columns to perform more flexible lookups using a practical real-world example.
2 Ways to Insert Filler Text in Microsoft Word
Learn two quick ways to insert filler text in Microsoft Word using the built-in =lorem() and =rand() commands. This tutorial shows how to generate both Lorem Ipsum and random English text while controlling the number of paragraphs and sentences created.
How to Set Up a Gmail Account in the New Outlook
Learn how to connect your Gmail account to the new Outlook for Windows. This step-by-step tutorial walks through the Google authorization process, Outlook setup options, and everything you need to start managing your Gmail messages from one convenient application.
How to Create a Searchable Drop-down List in Excel
Learn how to create a searchable drop-down list in Microsoft Excel using the FILTER function, named ranges, and Data Validation. This tutorial includes downloadable examples for partial, exact, and case-sensitive searches, with solutions for both Microsoft 365 and older versions of Excel.
How to Combine Multiple Names Based on Same or Different Last Names in Excel
Learn how to automatically combine names in Microsoft Excel based on whether two people share the same last name. This tutorial uses IF, AND, and TEXTJOIN to create mailing label-friendly names while supporting households with one or two people.
How to Turn on Focus Cell in Excel to Highlight the Active Cell Row and Column
Learn how to enable the Focus Cell feature in Microsoft Excel to highlight the active row and column. This simple productivity feature makes it easier to navigate large spreadsheets, improve accuracy, reduce eye strain, and quickly locate the cell you’re working in.
How to Delete a Pattern of Rows in Excel
Learn how to delete repeating patterns of rows in Microsoft Excel using a helper column, AutoFill, and sorting or filtering. This simple technique makes it easy to remove groups of rows from large datasets without writing formulas or manually selecting each row.
How to Create Mailing Labels in Word From an Excel List
Learn how to create mailing labels in Microsoft Word using an Excel spreadsheet with Mail Merge. This step-by-step tutorial shows you how to connect your data, insert merge fields, preview your labels, and print professional mailing labels. Includes downloadable sample files and a printable quick reference guide.
How to Print Only the Outline of Text in Microsoft Word
Learn how to print only the outline of text in Microsoft Word using built-in text effects. This simple formatting technique is perfect for creating coloring pages, tracing worksheets, craft projects, and printable templates by combining text outlines with a white font fill.
2 Ways to Create a Dropdown List in Excel
Learn two easy ways to create dropdown lists in Microsoft Excel using Data Validation. This tutorial demonstrates both the typed list method and the named range method, explains when to use each one, and includes downloadable practice files and a quick reference guide.
How to Manage Prospects or Leads in Excel
Learn how to create a simple lead and prospect tracker in Microsoft Excel using Data Validation, drop-down lists, filters, and notes. This tutorial demonstrates an easy-to-maintain system for organizing contacts, tracking follow-up activities, and managing sales or networking opportunities.
How to Show the Developer Tab in Excel
Learn how to show the Developer tab in Microsoft Excel so you can access advanced features like macros, VBA, form controls, and automation tools. This quick tutorial walks you through the Ribbon settings to enable the Developer tab in current versions of Microsoft Excel.
Choosing the Right Method to Combine Text in Excel
Learn four easy ways to combine names or other text in Microsoft Excel using CONCAT, TEXTJOIN, the ampersand (&) operator, and CONCAT with ranges. This tutorial explains when to use each method and how to preserve your combined results after merging your data.
2 Easy Ways to Separate First & Last Names in Excel
Learn two easy ways to separate first and last names in Microsoft Excel using Flash Fill and Text to Columns. This tutorial explains when each method works best, how to split names safely, and includes a downloadable practice workbook so you can follow along.
How to Keep the Zero at the Beginning of a Number in Excel
Learn three easy ways to keep the zero at the beginning of a number in Microsoft Excel. Whether you’re working with ZIP codes, employee IDs, or other fixed-length numbers, this tutorial explains the best method for your data and why Excel removes those beginning zeros in the first place.
How to Randomize a List in Excel
Learn how to randomize a list in Microsoft Excel using the RANDBETWEEN function and Excel’s Sort feature. This quick tutorial shows how to shuffle names, numbers, or other data into a random order for drawings, group assignments, surveys, and many other real-world uses.
Something went wrong. Please refresh the page and/or try again.
Simple Software Tutorials 