How-to basics
Everyday tasks: sorting, filtering, formatting, printing, shortcuts.
- Daily Cash Flow Report Template in Excel: Setup and UseA daily cash flow report template in Excel lists each day’s opening cash, money received, money paid, net cash movement, and closing…
- Customizable Invoice Template in Excel: How to Make OneYes. You can make a customizable invoice template in Microsoft Excel by laying out your business and customer details, adding an itemized…
- Daily Attendance Register Template Excel: Setup and TipsA daily attendance register in Excel is a worksheet that lists people down the rows, dates across the columns, and a short…
- Customizable Calendar Template in Excel: How to Make OneYes. You can make a customizable calendar template in Excel by starting with a blank worksheet or adapting a calendar from File…
- Customer Details in Excel: How to Set Up a Useful ListYes. In Excel, keep customer details in a single, clearly labeled table, with one customer per row and one type of information…
- Ctrl+H in Excel: Find and Replace Step-by-Step GuideIn Excel for Microsoft 365 on Windows, press Ctrl+H to open the Find and Replace dialog with the Replace tab ready. Enter…
- Ctrl+Q in Excel: What Quick Analysis Does and How to Use ItIn Excel for Microsoft 365 on Windows, Ctrl+Q opens Quick Analysis for a selected range of data. Quick Analysis offers shortcuts for…
- Customer Data Management Excel Template: Setup GuideA customer data management Excel template is a structured workbook for recording customer details, contact history, consent, and follow-up status in one…
- Creating Shift Schedules in Excel: A Practical GuideTo create a shift schedule in Excel, list each assignment in a table with its date, employee, role, start time, end time,…
- CSV vs Excel: What’s the Difference?CSV is a plain-text format for storing rows of values, while Excel is spreadsheet software that can work with CSV files and…
- Creating an Audit Tool in Excel: A Practical GuideTo create an audit tool in Excel, build a checklist table with one row per test, use dropdowns for consistent statuses, and…
- Create a Project Timeline in Excel: Step-by-StepCreate a project timeline in Excel by listing each task with an owner, start date, and finish date, then displaying the scheduled…
- Excel PivotTable Calculated Fields: How to Create OneTo create a calculated field in an Excel PivotTable, select the PivotTable, then choose PivotTable Analyze > Fields, Items, & Sets >…
- Degree Symbol in Excel: Add It to a Cell and Format ValuesTo show a degree symbol in an Excel cell, type it with the Windows numeric-keypad shortcut Alt+0176, or enter =UNICHAR(176) in a…
- Dynamic Named Range in Excel: Create One That ExpandsIn Excel for Microsoft 365 on Windows, the easiest way to make a range expand as you add rows is to convert…
- CRA Mileage Log Template Excel: What to Track and WhyFor a CRA mileage log template in Excel, create columns for the trip date, starting and ending odometer readings, distance, destination, and…
- Cost Sheet Excel Template for Practical Budget PlanningA cost sheet Excel template for budget planning lists each expense, estimates its quantity and unit price, calculates the planned total, and…
- Convert Text to Numbers in Excel: Methods That WorkTo convert text numbers in Excel, select the cells and choose the warning icon’s Convert to Number command when it appears. If…
- How to Add the Copilot Icon in ExcelTo get the Copilot icon in Excel for Microsoft 365 on Windows, sign in with an account that has an eligible Copilot…
- Convert ZIP to Excel: What Works and What Does NotYou cannot convert a ZIP archive itself into an Excel workbook: a ZIP is a container, not a spreadsheet format. Extract the…
- Convert XLS to Excel: How to Save as an XLSX WorkbookAn .xls file is already an Excel workbook; it uses an older Excel file format. To convert it to the modern format…
- Convert XML to Excel: Import, Clean, and Save DataTo convert XML to Excel in Microsoft 365 for Windows, choose Data > Get Data > From File > From XML, select…
- Convert Percentage to Text in Excel: Methods and TipsTo convert a numeric percentage to text in Excel, use the TEXT function: if A2 contains 25%, enter =TEXT(A2,"0%") in another cell;…
- Convert Text to Numbers in Excel: Methods That WorkTo convert text values to numbers in Excel, select the cells and choose the warning icon’s Convert to Number command when it…
- Convert Excel to ZIP: How to Compress and Share a WorkbookTo put an Excel workbook in a ZIP file on Windows, open File Explorer, right-click the workbook, and choose Send to >…
- Convert an Excel Binary Worksheet (.XLSB) to ExcelTo convert an Excel binary workbook (.xlsb) to a standard Excel workbook, open it in Excel for Microsoft 365 on Windows, choose…
- Content Calendar Template Excel: Create and Use OneYes. A useful Excel content calendar template is a workbook with one row per planned post and columns for the publish date,…
- Ctrl+G in Excel: Open Go To and Select CellsIn Excel for Microsoft 365 on Windows, press Ctrl+G to open the Go To dialog, type a cell reference or named range,…
- Excel Redo Shortcut: How Ctrl+Y Works and When It FailsIn Excel for Microsoft 365 on Windows, press Ctrl+Y to redo an action you just undid. If there is nothing to redo,…
- Construction Project Cash Flow Template Excel GuideA construction project cash flow template in Excel tracks when project money is expected to come in and when it must go…