How-to basics
Everyday tasks: sorting, filtering, formatting, printing, shortcuts.
- Accounting Year-End Checklist Template for Excel UsersAn accounting year-end checklist template for Excel is a task tracker that assigns each close activity an owner, due date, status, and…
- 3-Way Forecast Excel Template: 3 Models to CompareA three-way forecast Excel template links a projected income statement, balance sheet, and cash flow statement so changes in sales, costs, working…
- 5 Year Sales Forecast Excel Template: 5 Options to CompareFor a five-year plan, start with Smartsheet’s dedicated 5-Year Sales Forecast Template if you want a ready-made Excel layout; choose Vertex42 or…
- Remove Duplicates in Excel: Steps, Options, and TipsTo remove duplicate rows in Excel for Microsoft 365 on Windows, select a cell in your data, go to Data > Remove…
- Structured Cell References in Excel: How They WorkA structured reference in Excel names a table and its columns instead of relying on cell addresses such as B2:B20. If your…
- Q-Q Plot in Excel: How to Create and Interpret OneTo make a normal Q-Q plot in Excel, sort your numeric observations, calculate matching theoretical normal quantiles with NORM.S.INV, then plot the…
- Q-Q Plot in Excel: How to Make and Read OneTo make a normal Q-Q plot in Microsoft Excel for Microsoft 365, sort your observations, calculate matching standard-normal quantiles with NORM.S.INV, and…
- Protect Sheet vs. Protect Workbook in Excel: Key DifferencesIn Excel, Protect Sheet limits what people can change on a particular worksheet, while Protect Workbook can protect the workbook’s sheet structure…
- Protect Excel Sheets Except for a Few CellsTo protect an Excel worksheet while leaving a few cells editable, first select the cells people may change, open Format Cells with…
- Named Range in Excel: How to Create and Use OneA named range in Excel is a descriptive name assigned to a cell, a group of cells, or a formula, so you…
- Excel Data Analysis: What It Can Do and Where It FitsYes—Microsoft Excel can handle a wide range of data analysis, from sorting and summarizing everyday business records to statistical tests and regression.…
- GPT for Excel Data Analysis: Uses, Limits, and TipsYes. GPT tools can analyze Excel data: upload a workbook to ChatGPT with data-analysis features enabled, or use an eligible Copilot feature…
- Free AI Excel Analysis: What You Can Do at No CostYes—you can analyze Excel data with AI for free by using a free AI assistant that accepts spreadsheet uploads, or by trying…
- Finding a Z Value in Excel: Scores, Tests, and CutoffsTo calculate a z-score in Excel, subtract the mean from the value and divide by the standard deviation. If A2:A6 contains the…
- Excel Yin-Yang Analysis: Build a Balanced ComparisonExcel has no built-in feature named “yin-yang analysis.” To use the idea in a worksheet, list the favorable and unfavorable sides of…
- Excel String + String: How to Join TextIn Excel, + adds numbers; it does not join ordinary text strings. To combine text, use &: with text in A1 and…
- Excel Statistical Analysis Tools and How to Use ThemExcel’s statistical analysis tools include the Analysis ToolPak add-in, statistical functions such as AVERAGE and T.TEST, and charts that help reveal patterns…
- Excel Z-Test: How to Calculate and Interpret ResultsTo run a one-sample z-test in Excel, calculate a z-score using the sample mean, hypothesized mean, known population standard deviation, and sample…
- Excel Site Analysis: Methods, Limits, and ExamplesExcel site analysis means organizing information about a property or project site in a workbook so you can compare conditions, calculate areas,…
- Excel RAG Analysis: Build a Red-Amber-Green TrackerExcel RAG analysis usually means tracking status with red, amber, and green indicators: red signals a serious issue, amber a warning, and…
- Excel Regression Analysis: Run It and Read the ResultsExcel regression analysis estimates how one or more input variables relate to an outcome. In Microsoft Excel for Microsoft 365 on Windows,…
- Excel Profit Analysis Tool: Build One Step by StepAn Excel profit analysis tool can be a simple workbook that compares sales revenue with variable and fixed costs to show contribution,…
- Excel Predictive Analysis: Methods, Steps, and LimitsYes. Excel can perform predictive analysis using tools such as Forecast Sheet, forecasting functions, and regression in the Analysis ToolPak. These methods…
- Excel Not Equal to Null? How to Check Blank CellsExcel worksheet formulas do not have a special NULL value: to test whether a cell is not blank, a common formula is…
- Excel NOT ISBLANK: How to Check for Nonblank CellsTo check whether a cell is not blank in Excel, use =NOT(ISBLANK(A2)), replacing A2 with the cell you want to test. The…
- Excel Portfolio Analysis: Track Risk and ReturnsExcel portfolio analysis means organizing holdings and market data so you can calculate what you own, how it is allocated, how it…
- How to Hide a Column in Excel: Steps and ShortcutsIn Excel for Microsoft 365 on Windows, select the column by clicking its lettered header, right-click it, and choose Hide. You can…
- Excel Print Area: How to Set, Change, and Clear ItTo set a print area in Excel for Microsoft 365 on Windows, select the cells you want to print, then choose Page…
- Excel Market Analysis: A Practical Guide to Market ResearchExcel market analysis means using spreadsheets to organize market data, estimate the size and value of customer segments, compare competitors, and make…
- Excel Shortcut to Insert a Row on Windows and MacIn Excel for Microsoft 365 on Windows, select the row where you want the new one, then press Ctrl+Shift+= (the plus shortcut).…