How-to basics
Everyday tasks: sorting, filtering, formatting, printing, shortcuts.
- Train Inventory Spreadsheet: What to Track and HowA train inventory spreadsheet is a practical Excel list of locomotives and rail vehicles, with fields for identification, status, location, assignments, and…
- Tool Inventory Spreadsheet: Setup, Tracking, and TipsA tool inventory spreadsheet is a structured list of the tools an organization owns, where they are, who is responsible for them,…
- Excel Power Query: How to Create a Connection Only QueryYes. In Excel for Microsoft 365 on Windows, open the query in Power Query Editor, choose Home > Close & Load >…
- The Knot Wedding Budget Spreadsheet: What to KnowThe Knot’s wedding budget planner is an online planning tool, not something you should assume is a downloadable Excel spreadsheet. Check the…
- Excel Power Query Course: What to Learn and How to ChooseAn Excel Power Query course teaches you to import, clean, combine, and refresh data using Excel’s built-in data transformation tools. Choose a…
- The Knot Budget Spreadsheet: Set Up a Wedding TrackerThe Knot budget spreadsheet usually means either The Knot’s online wedding-budget planner or a spreadsheet someone has made to track wedding costs.…
- Wedding Budget Spreadsheet Templates: How to Choose OneWedding budget spreadsheet templates are preformatted Excel or Google Sheets files for listing costs, setting spending limits, and tracking payments. Choose one…
- Excel Power Query Connection Only ExplainedIn Excel Power Query, Connection Only saves a query in the workbook without loading its results into a worksheet table. The query…
- Stampin’ Up Inventory Spreadsheet: What to TrackA Stampin’ Up! inventory spreadsheet is a practical way to track the paper, stamps, ink, tools, and other supplies you own, where…
- Spreadsheet Free Budget Planner: A Simple Excel SetupYes—a free budget planner spreadsheet can be made in Excel for the web or Google Sheets, and it can track income, planned…
- Spreadsheet Budget: Build a Monthly Plan in ExcelA useful spreadsheet budget is a simple list of monthly income and spending, with formulas that total planned and actual amounts. In…
- Excel Power Query: Combine Queries ExplainedIn Excel Power Query, combine queries with Append to stack rows from similar tables, or Merge to match rows using one or…
- Snowball Debt Payoff Spreadsheet: Free Excel SetupYes—you can make a free snowball debt payoff spreadsheet in Excel by listing each debt, its balance, annual interest rate, minimum payment,…
- Excel Power Query: Change a Data Source Step by StepTo change a Power Query data source in Excel for Microsoft 365 on Windows, go to Data > Get Data > Data…
- Spending Expense Tracker Spreadsheet: Build One in ExcelA spending expense tracker spreadsheet is a workbook for recording purchases and totaling them by category and month. In Excel, put transaction…
- Debt Snowball Spreadsheet: Build a Payoff PlanTo make a debt snowball spreadsheet in Excel, list each debt’s current balance, APR, and minimum payment, then send any extra monthly…
- Free Snowball Debt Spreadsheet: Build One in ExcelYes—a debt snowball spreadsheet can be free: you can build a practical tracker in Excel without buying a template, and Excel for…
- Snowball Method Debt Spreadsheet: Build One in ExcelA snowball method debt spreadsheet lists debts from the smallest balance to the largest, tracks each debt’s interest and minimum payment, and…
- Excel Power Query Append Queries: Combine Tables EasilyIn Excel for Microsoft 365 on Windows, Power Query append queries combine tables by stacking their rows into one query result. In…
- Snowball Debt Payoff Spreadsheet: How to Build One in ExcelA snowball debt payoff spreadsheet helps you list debts from smallest balance to largest, pay at least the required minimum on every…
- 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),…