How-to basics
Everyday tasks: sorting, filtering, formatting, printing, shortcuts.
- Snowball Effect Debt Spreadsheet: Build and Use OneA snowball effect debt spreadsheet helps you list debts from smallest balance to largest, pay each minimum, and direct extra money to…
- Why Can’t I Add Slide Numbers in PowerPoint?You usually can add slide numbers in PowerPoint through Insert > Header & Footer: select Slide number on the Slide tab, then…
- Excel Power Query Add-In: What It Is and How It WorksIn modern Excel, Power Query is built in, so Microsoft 365 users generally do not need to install a separate add-in. Find…
- Shirt Inventory Spreadsheet: Track Sizes and StockA shirt inventory spreadsheet is a workbook for recording each shirt style, color, size, and quantity, then calculating what remains in stock.…
- Excel Power Query: Add Data to an Existing Table?Yes—use Power Query’s Append operation to combine rows from an existing table and another data source, then load the combined result as…
- Why Can’t I Embed a Video in PowerPoint?You usually cannot embed a video in PowerPoint because the file’s codec is unsupported, the video is being added as an online…
- Excel Power Query: Add Leading Zeros to TextTo add leading zeros in Excel Power Query, create a custom column with Text.PadStart(Text.From([Code]), 6, "0"), replacing Code with your column name…
- Excel Power Query: How to Add a ColumnTo add a column in Excel Power Query, open the Power Query Editor, select the Add Column tab, and choose Custom Column,…
- Run a PowerPoint Slideshow in a Continuous LoopTo run a PowerPoint slideshow continuously in Microsoft 365 for Windows, open the presentation and select Slide Show > Set Up Slide…
- Record Voice Over a PowerPoint PresentationTo record a voice-over in PowerPoint, open the presentation in the desktop app, select Record > From Beginning (or From Current Slide),…
- Sample Project Tracker Spreadsheet: Layout and TipsA useful project tracker spreadsheet has one row per task, clear ownership and due dates, a consistent status, and a simple way…
- Recording a PowerPoint Presentation: Steps and TipsTo record a PowerPoint presentation in Microsoft 365 for Windows, open the deck and select Record > From Beginning or Record >…
- How to Record a PowerPoint Presentation With SubtitlesYes. In PowerPoint for Microsoft 365, record your slides and narration, export the presentation as a video, then add subtitles to that…
- Small Business Budget Spreadsheet: Sample and SetupA useful small-business budget spreadsheet lists monthly revenue, direct costs, operating expenses, and the difference between budget and actual results. In Excel…
- Record a PowerPoint Presentation With Your FaceYes. In PowerPoint for Microsoft 365 on Windows, open the deck and choose Record > From Beginning (or From Current Slide), turn…
- Salon Inventory Spreadsheet: How to Create One Step by StepCreate a salon inventory spreadsheet in Microsoft Excel by listing each product on a separate row, recording its stock movements, and calculating…
- How to Record and Save a PowerPoint Presentation FileTo record and save a PowerPoint presentation in Microsoft 365 for Windows, open the deck, select Record and then From Beginning (or…
- Salon Inventory Spreadsheet: Setup and Stock ControlA salon inventory spreadsheet is a simple way to track what products you have, where they are, and when to reorder. Start…
- Present PowerPoint With Notes: Presenter View GuideTo present a PowerPoint presentation with speaker notes, turn on Presenter View: in PowerPoint for Microsoft 365 on Windows, open the Slide…
- Roommate Expense Tracker Spreadsheet: Setup and TipsA roommate expense tracker spreadsheet is a shared record of bills, who paid them, and each person’s share; in Excel for Microsoft…
- Retirement Savings Tracker Spreadsheet: Build YoursA retirement savings tracker spreadsheet can show your account balances, contributions, withdrawals, and progress toward a savings target in one place. In…
- PowerPoint Slideshow Loop: How to Repeat It ContinuouslyYes. In PowerPoint for Microsoft 365 on Windows, open the presentation, select Slide Show > Set Up Slide Show, and check Loop…
- Retirement Budget Spreadsheet: How to Build OneA retirement budget spreadsheet helps you compare expected monthly income with the costs you expect to face, then see whether the plan…
- Reselling Inventory Spreadsheet: Track Stock and ProfitA reselling inventory spreadsheet is a workbook for recording what you buy, what remains in stock, and what each sale earns after…
- PowerPoint Slideshow Continuous Loop: Setup and FixesYes. In the Microsoft PowerPoint desktop app, open Slide Show > Set Up Slide Show and select Loop continuously until ‘Esc’; then…
- Retired Budget Spreadsheet: Plan Income and ExpensesA retired budget spreadsheet is a worksheet for comparing retirement income with day-to-day and occasional expenses. In Excel for Microsoft 365 on…
- PowerPoint Present with Notes Visible? Presenter ViewYes. In PowerPoint for Microsoft 365, turn on Presenter View to see your speaker notes on your own screen while the audience…
- Reseller Inventory Spreadsheet: Free Template and SetupYes—you can make a reseller inventory spreadsheet for free in Excel by setting up a simple item table and adding a few…
- Reseller Inventory Spreadsheet: Track Stock and ProfitA reseller inventory spreadsheet is a workbook for recording what you buy, what you sell, what remains in stock, and the costs…
- PowerPoint Presenter View: Show Notes While PresentingTo present a PowerPoint with your notes visible only to you, turn on Presenter View: in PowerPoint for Microsoft 365 on Windows,…