How-to basics
Everyday tasks: sorting, filtering, formatting, printing, shortcuts.
- Excel Power Query Fuzzy Matching ExplainedExcel Power Query fuzzy matching finds likely matches between text values that are similar but not identical. In Excel for Microsoft 365…
- Upload a Budget Spreadsheet: Safe Steps and OptionsYes. To upload a budget spreadsheet for use in Excel, save or upload the workbook to OneDrive, then open it in Excel…
- Vacation Budget Spreadsheet: Plan Costs and Track SpendingA vacation budget spreadsheet helps you estimate trip costs before booking, then compare those estimates with what you actually spend. In Excel…
- Excel Power Query for Beginners: A Practical GuideExcel Power Query is a built-in tool for importing, cleaning, combining, and reshaping data without repeating the same manual edits each time.…
- Uniform Inventory Spreadsheet: Build a Useful TrackerCreate a uniform inventory spreadsheet in Excel with one row per item and size, columns for opening stock, receipts, issues, current stock,…
- Excel Power Query for Data Cleaning: A Practical GuideYes—Excel Power Query is a built-in tool for cleaning and reshaping data, and it can save each cleanup step so you can…
- Uni Budget Spreadsheet: Build a Student Budget in ExcelA uni budget spreadsheet is a simple way to compare the money you expect to receive with the costs you expect to…
- Excel Power Query Editor: What It Does and How to Use ItThe Excel Power Query Editor is the workspace where you connect to data, clean and reshape it, and prepare it to load…
- Excel Power Query: How to Extract and Refresh DataYes. In Excel for Microsoft 365 on Windows, select Data > Get Data, choose a source such as a workbook, CSV file,…
- Excel Power Query Date Format: Types, Changes, and FixesIn Excel Power Query, set a column’s data type to Date to make its values usable as dates; set the displayed format…
- 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…
- 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…
- 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…
- 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…