How-to basics
Everyday tasks: sorting, filtering, formatting, printing, shortcuts.
- Can Power Automate Refresh Excel Power Query?Yes, Power Automate can refresh an Excel Power Query, but a cloud flow cannot do it with a built-in Power Query refresh…
- Align Images in Excel: Steps, Options, and Common FixesYes. In Excel for Microsoft 365 on Windows, select two or more pictures, then choose Picture Format > Arrange > Align and…
- Can Excel Compare Means With a T-Test? Steps and ChoicesYes. Excel can compare means with a t-test using the T.TEST function or the Analysis ToolPak. Choose the test that matches your…
- Can Excel Interpolate Data? Methods and ExamplesYes. Excel can interpolate data, most often with a linear formula between two known values or with the FORECAST.LINEAR function. Excel does…
- Can AI Replace Excel Jobs? The Work It Can DoAI can replace some repetitive tasks done in Excel, and in certain workplaces it may reduce the need for particular spreadsheet roles.…
- Calendar Timeline Template Excel: Build Your OwnA calendar timeline template in Excel is a date-based grid that shows tasks or events across days or weeks. To build a…
- Calendar Planner Template in Excel: Build and Use OneTo make a calendar planner template in Excel, enter a date from the month you want in B1, add weekday headings, and…
- Calendar Schedule Template in Excel: How to Build OneA calendar schedule template in Excel can be a ready-made workbook or a simple grid you create yourself. In Excel for Microsoft…
- Free Calendar Excel Templates: How to ChooseYes—free calendar Excel templates are available, including templates you can find from Excel’s New screen and downloadable workbooks from Microsoft and other…
- Calendar Layout Template for Excel: How to Make OneA practical calendar layout template for Excel has a year and month selector, seven weekday columns, and a six-week date grid. In…
- Calendar Excel Sheet Template: Build or Choose OneA calendar Excel sheet template is a reusable workbook for displaying dates, appointments, deadlines, or shifts in a calendar layout. In Microsoft…
- How to Calculate FV in ExcelUse Excel’s FV function to calculate an investment’s future value. For example, if B2 contains an annual interest rate, B3 the number…
- Weighted Average in Excel PivotTables: How to CalculateTo calculate a weighted average in an Excel PivotTable, add a source-data helper column that multiplies each value by its weight, then…
- Calculate Time-Weighted Average in Excel with ExamplesA time-weighted average in Excel is the sum of each value multiplied by the time it applies, divided by the total time…
- Calculate ROI in Excel Over Multiple YearsTo calculate ROI in Excel over multiple years, subtract the investment’s total cost from its ending value, divide by the total cost,…
- How to Calculate a Monthly Loan Payment in ExcelTo calculate a monthly loan payment in Microsoft Excel, use the PMT function: with the loan amount in B1, annual interest rate…
- Excel PivotTable Percentages: How to Calculate ThemTo calculate percentages in an Excel PivotTable, right-click a value, choose Show Values As, and select % of Grand Total, % of…
- Calculate Percentile in Excel for Each Value in a ListTo calculate a percentile rank for every value in Excel, enter =PERCENTRANK.INC($A$2:$A$11,A2) in the first result cell, then fill the formula down.…
- Loan Amortization in Excel: Calculate Payments and ScheduleTo calculate loan amortization in Excel, enter the loan amount in B1, annual interest rate in B2, and term in years in…
- Business Loan Amortization Calculator in Excel: StepsYes. You can build a business loan amortization calculator in Microsoft Excel using the PMT function for the regular payment and a…
- Business Expense Tracking Excel Template: Setup & UseA practical business expense tracking Excel template uses one row per transaction, with columns for date, vendor, description, category, payment method, amount,…
- Bullet Point in Excel: Add Bullets to Cells and ListsExcel has no dedicated bullet-list button for worksheet cells. To add a bullet, edit a cell and insert the • character with…
- Bullets in Excel: How to Add, Format, and Manage ListsTo add a bullet in an Excel cell, edit the cell, place the cursor where the bullet should go, and insert the…
- Budgeting Template for Excel: Build a Monthly PlanA practical budgeting template for Excel has columns for each category’s planned amount, actual amount, and difference, plus totals for income, spending,…
- Bullet in Excel: Add Bullets to Cells and ListsTo add a bullet in an Excel cell, edit the cell, type a bullet using Alt+0149 on the Windows numeric keypad, press…
- Free Budget Tracker Excel Template: Setup and TipsYes—free budget tracker templates are available for Excel, and you can also make a simple tracker yourself with a blank workbook. In…
- Budget Template NZ Excel: Build a Practical Household PlanA New Zealand budget template in Excel can be a simple table of monthly income, planned spending and actual spending, with formulas…
- Budget and Expense Tracking Excel Template: How to Use ItA budget and expense tracking Excel template is a workbook that compares planned spending with recorded transactions, usually by month and category.…
- Break-Even Analysis Calculator Excel TemplateA break-even analysis calculator in Excel shows how many units you must sell—or how much sales revenue you need—to cover costs without…
- Break External Links in Excel: Steps and Side EffectsTo break an external workbook link in Microsoft Excel for Microsoft 365 on Windows, save a backup, open Data > Workbook Links,…