How-to basics
Everyday tasks: sorting, filtering, formatting, printing, shortcuts.
- Construction Project Timeline Template Excel: Build OneA construction project timeline template in Excel is a task schedule with planned start and finish dates, durations, dependencies, owners, and progress;…
- Excel Conditional Formatting: Find Cells That Contain TextYes. In Excel for Microsoft 365 on Windows, a formula-based conditional formatting rule can highlight cells that contain specified text. For example,…
- Construction Cash Flow S Curve Excel Template GuideYes. Build a construction cash flow S curve in Excel by listing each month’s planned and actual cash expenditure, calculating each series’…
- Construction Profit and Loss Template Excel: How to UseA construction profit and loss template in Excel summarizes earned revenue, direct job costs, gross profit, overhead, and operating profit for a…
- Conditional Formatting in Excel for a Specific DateYes. In Excel for Microsoft 365 on Windows, select the date cells and use Home > Conditional Formatting > New Rule >…
- Excel Conditional Formatting Icons: How to Use ThemIn Excel for Microsoft 365 on Windows, conditional formatting icons add a symbol to each cell based on its value: select the…
- Excel Conditional Formatting Icon Sets: A Practical GuideTo apply an icon set in Excel for Microsoft 365 on Windows, select the cells, then choose Home > Conditional Formatting >…
- Excel 3-Flag Icon Set: Setup and ThresholdsIn Excel for Microsoft 365 on Windows, select the cells you want to mark, then choose Home > Conditional Formatting > Icon…
- Excel Conditional Formatting for Duplicates: How It WorksYes. In Excel for Microsoft 365 on Windows, select the cells to check, then choose Home > Conditional Formatting > Highlight Cells…
- Compare Excel Workbooks: Methods, Steps, and DifferencesTo compare Excel workbooks, use View > View Side by Side for a visual review, Spreadsheet Compare for a detailed report of…
- Company Cash Flow Template Excel: Build and Use ItA company cash flow template in Excel is a worksheet that tracks when money is expected to enter and leave the business,…
- Commercial Invoice Template in Excel: What to IncludeYes—you can make a commercial invoice template in Microsoft Excel by setting up seller and buyer details, shipment information, and a line-item…
- Commission Calculation Software in Excel: A Practical GuideYes—Microsoft Excel can calculate commissions with a formula linked to each sale and its commission rate. With a salesperson in A2, eligible…
- Commission Calculator Excel Template: Build One That FitsA commission calculator Excel template can calculate payouts from sales, commission rates, and plan rules; for a flat-rate plan, put eligible sales…
- Redo in Excel: Keyboard Shortcuts and How It WorksTo redo an action in Excel for Microsoft 365 on Windows, press Ctrl+Y. On a Mac, press Command+Y. Redo restores an action…
- Excel Zoom Shortcut: How to Zoom In on a WorksheetIn Excel for Microsoft 365 on Windows, hold Ctrl and scroll the mouse wheel up to zoom in on the worksheet. You…
- Combine Excel Worksheets into One: Practical MethodsTo combine Excel worksheets into one, use Power Query to append the sheets when you want a refreshable result, or stack matching…
- Excel Hide Commands: Shortcuts for Rows, Columns, and SheetsIn Excel for Microsoft 365 on Windows, select the row or rows and press Ctrl+9 to hide them; select columns and press…
- Colour Cells in Excel: Fill, Conditional Rules, and MoreTo colour cells in Excel, select them and choose Home > Fill Color to apply a fill manually. To make colour change…
- Combine Address, City, State, and ZIP in ExcelTo combine an address, city, state, and ZIP code in Excel, put them in separate cells and join them with a formula.…
- Combine Excel Sheets Into One Sheet?Yes. In Excel for Microsoft 365 on Windows, combine worksheets by copying their data into one worksheet, appending source tables with Power…
- Closing Checklist Template Excel: Set Up and Use ItYes. A closing checklist template in Excel can track each task, its owner, due time, status, and notes in one reusable worksheet.…
- How to Close the Queries & Connections Pane in ExcelTo close the Queries & Connections pane in Excel for Microsoft 365 on Windows, click the X in the pane’s upper-right corner.…
- Cleaning Checklist Template Excel: Setup and Tips for TeamsA cleaning checklist template in Excel is a worksheet that lists cleaning tasks, when they are due, who is responsible, and whether…
- Close and Load in Excel: How It WorksIn Excel for Microsoft 365 on Windows, choose Home > Close & Load in the Power Query Editor to save the query…
- Clean-Looking Excel Sheets: Practical Formatting TipsClean-looking Excel sheets use consistent formatting to make important information easy to find without distracting from the data. Start with a clear…
- Clean Up an Excel Spreadsheet: A Practical GuideTo clean up an Excel spreadsheet, first save a separate copy, then inspect the data, correct inconsistent values and formats, remove only…
- Clean an Excel Spreadsheet: Steps for Cleaner DataTo clean an Excel spreadsheet, make a copy, standardize text and data types, resolve blanks and duplicates, and then check the results…
- Clean Excel File Online: Safe Steps and Best OptionsYes—you can clean an Excel file online by opening it in Excel for the web or by using a reputable browser-based spreadsheet…
- Clause 34 of Tax Audit Report in Excel: What to IncludeClause 34 is a disclosure in the tax audit report, not a special Excel feature. You can prepare its supporting schedule in…