How-to basics
Everyday tasks: sorting, filtering, formatting, printing, shortcuts.
- Construction Budget Spreadsheet: Plan Costs and Track ChangesA construction budget spreadsheet is a workbook for listing project costs, comparing the approved budget with current forecasts, and recording commitments and…
- How to Make an A3 Poster in PowerPointTo make an A3 poster in PowerPoint, open the Design tab, choose Slide Size > Custom Slide Size, and set the page…
- Excel Data Validation From a Table: Setup and FixesYes. In Excel for Microsoft 365 on Windows, you can use a table column to supply choices for a data-validation drop-down. The…
- Computer Budget Spreadsheet: Plan Your PurchaseA computer budget spreadsheet helps you set a spending limit, list the full cost of a setup, and compare planned costs with…
- Coin Inventory Spreadsheet: Track Your Collection in ExcelA coin inventory spreadsheet is a simple catalog for recording what you own, where it is stored, and what you paid or…
- How to Make a Poster in PowerPoint: A Practical GuideTo make a poster in PowerPoint, create a blank presentation, set a custom slide size to the poster’s final dimensions, then add…
- How to Create a Master Template in PowerPoint That WorksTo create a reusable master template in Microsoft PowerPoint, open View > Slide Master, set the theme and shared design elements, build…
- Excel Data Tables: How They Work and When to Use ThemExcel data tables can mean two different things: structured Excel Tables that organize lists of records, or What-If Analysis data tables that…
- How to Loop a PowerPoint SlideshowTo loop a PowerPoint slideshow in Microsoft 365 for Windows, open the presentation and select Slide Show > Set Up Slide Show.…
- Clothing Inventory Spreadsheet: Build and Use OneA clothing inventory spreadsheet is a worksheet for recording each sellable garment variant, its quantity, location, and other details; in Excel for…
- How to Add Speaker Notes in PowerPoint on Any DeviceIn PowerPoint for Microsoft 365 on Windows, open the presentation in Normal view, select Notes on the status bar, click the notes…
- How to Create a Reusable Table Template in PowerPointTo create a reusable table template in PowerPoint, build and format a starter table on a slide, then save that slide in…
- How to Create a PowerPoint Template That You Can ReuseTo create a reusable PowerPoint template, open a presentation, use View > Slide Master to set its theme and layouts, then save…
- Excel Two-Variable Data Tables: Setup and ExamplesAn Excel two-variable data table tests how one formula’s result changes across combinations of two input values. In Microsoft Excel for Microsoft…
- Closet Inventory Spreadsheet: What to Track and HowA closet inventory spreadsheet is a simple list of the clothes, shoes, bags, and accessories you own, organized so you can find…
- Cattle Inventory Spreadsheet: What to Track and HowA cattle inventory spreadsheet is a structured record of the animals in a herd, including each animal’s identifier, status, location and key…
- How to Make a Timeline in PowerPointIn PowerPoint for Microsoft 365 on Windows, choose Insert > SmartArt > Process > Basic Timeline, enter your milestones in the text…
- Excel Data Consolidate Example: Combine Sheets by LabelsTo consolidate matching tables in Excel for Microsoft 365 on Windows, choose a blank destination cell, select Data > Data Tools >…
- How to Add Slide Numbers in PowerPoint on Any DeviceTo add slide numbers in PowerPoint for Microsoft 365 on Windows, open the presentation and choose Insert > Slide Number (or Insert…
- How to Create a PowerPoint Template With Your LogoCreate a reusable PowerPoint template with your logo by adding the logo and shared design elements in Slide Master view, arranging the…
- Business Expense Tracker Spreadsheet: Free Options and SetupYes. You can use a free business expense tracker spreadsheet by creating a simple log in Excel for the web or downloading…
- Embed a Video in PowerPoint: Steps, Formats & FixesTo embed a video in PowerPoint for Microsoft 365 on Windows, open the slide, choose Insert > Video > This Device, select…
- How to Create a Poster Template in PowerPoint That WorksCreate a reusable poster template in PowerPoint by setting the final page size, arranging editable design elements on a slide master, and…
- Excel Consolidate Tabs Into One Sheet: Methods & TipsTo combine Excel tabs into one sheet, use Power Query to append the tabs when you want one refreshable list; for a…
- Flowchart in PowerPoint: Create, Connect, and FormatYes. In Microsoft PowerPoint for Microsoft 365, make a flowchart by choosing Insert > Shapes, selecting symbols from the Flowchart section, and…
- PowerPoint Photo Template: Create Reusable Slide LayoutsCreate a reusable photo template in PowerPoint by adding picture placeholders to a slide layout in Slide Master view, styling the layout,…
- Embed Video in PowerPoint: Methods, Playback and FixesYes. In PowerPoint for Microsoft 365 on Windows, choose Insert > Video > This Device, select a video, and choose Insert to…
- How to Create a Design Template in PowerPointTo create a reusable design template in PowerPoint, build the look and standard layouts in Slide Master view, then save the presentation…
- Business Expense Tracker Spreadsheet: Setup and TipsA business expense tracker spreadsheet is a workbook for recording purchases, payments, and reimbursements in one organized place. In Microsoft Excel for…
- PowerPoint Template: How to Create Your OwnTo create a custom PowerPoint template, design your theme and slide layouts in Slide Master view, then save the presentation as a…