How-to basics
Everyday tasks: sorting, filtering, formatting, printing, shortcuts.
- Excel Inventory Tracker Template: How to Build OneThe fastest way to get an Excel inventory tracker is to use a built-in template: open Excel, go to File > New,…
- Excel Insert Yes No Checkbox: 2 WaysYou can insert a yes/no checkbox in Excel using either a Form Control checkbox (for a simple clickable box linked to a…
- Excel Instrument Repair Vernon CT: Full GuideExcel Instrument Repair in Vernon, CT is a local service that repairs and restores band and orchestra instruments, primarily serving students and…
- Excel Interpolate Between Numbers: How ToYes, Excel can interpolate between numbers, and the quickest method is to use the FORECAST.LINEAR function. For example, with known x-values in…
- Excel Income and Expense Tracking Spreadsheet: How to Build OneYou can track income and expenses in Excel by setting up a simple table with columns for Date, Description, Category, Income, and…
- Excel Import and Align with Existing TimesYes, Excel can import data and align it with existing times, but it depends on what you mean by “align.” If you…
- Excel How to Ungroup Cells: Rows, Columns & SheetsTo ungroup cells in Excel, select the grouped rows or columns, then go to the Data tab and click the Ungroup button…
- How to Unmerge Cells in Excel (Group of Cells)To unmerge a group of cells in Excel, select the merged cell (or range of merged cells), then go to the Home…
- Excel HR Templates for Attendance: A Practical GuideYes, Excel HR templates for attendance are downloadable spreadsheets that let you log employee work hours, track absences, and calculate totals without…
- Excel: How to Split Information in a CellThe fastest way to split information in a cell in Excel is to use the Text to Columns wizard (Data tab >…
- How to Rotate a Table in Excel: 3 Easy WaysTo rotate a table in Excel, meaning to turn its rows into columns and columns into rows, use the Transpose feature. The…
- Excel How to Select Certain Cells: 6 Quick WaysTo select certain cells in Excel, hold Ctrl (Windows) or Cmd (Mac) and click each cell you want; to select a range,…
- Excel Transpose: How to Quickly Flip DataTo quickly transpose data in Excel, select the range you want to flip, press Ctrl+C to copy, right-click the destination cell, and…
- How to Rename a Cell in Excel: A Complete GuideTo rename a cell in Excel, you use the Name Box (located to the left of the formula bar) to assign a…
- Excel Replace Only in Selected Cells: 2 WaysTo replace text only in selected cells in Excel, first select the range, then press Ctrl+H (Windows) or Control+H (Mac) to open…
- Excel How to Get to Data Validation: Full GuideTo get to Data Validation in Excel, select the cell or range of cells you want to apply it to, then go…
- Excel: How to Hide Rows in a Table (3 Ways)The fastest way to hide rows in an Excel table is to select the row(s), right-click, and choose Hide (or press Ctrl+9…
- Excel Split Cells Fast: 4 Ways That WorkThe fastest way to split cells in Excel is to use the Text to Columns wizard (Data tab > Data Tools >…
- Excel: How to Count X’s in a ColumnThe fastest way to count X’s in a column is with the COUNTIF function. For example, if your data is in column…
- Excel: How to Divide Text in ColumnsTo divide text in columns in Excel, use the Text to Columns wizard (Data > Data Tools > Text to Columns) for…
- Excel Subtotals: How to Add Them Step by StepTo add subtotals in Excel, first sort your data by the column you want to group by, then go to Data >…
- Excel Hourly Schedule Template: How to Make OneThe fastest way to get an hourly schedule in Excel is to use a built-in template: open Excel, go to File >…
- Excel: How to Add Lines in a Cell (3 Easy Ways)To add lines in a cell in Excel, press Alt+Enter (Windows) or Control+Option+Return (Mac) after typing the first line, then continue typing…
- Excel Holiday Schedule: How to Build OneTo create a holiday schedule in Excel, list employee names in column A, each date of the holiday period in row 1,…
- Excel Hotel Group Jobs: Hiring, Pay, and How to ApplyExcel Hotel Group jobs are positions at a hotel management and development company that operates branded and independent hotels across the United…
- Excel Group of Schools Zimbabwe: Full GuideExcel Group of Schools Zimbabwe is a private Christian school network with campuses in Harare and Bulawayo, offering education from early childhood…
- Excel Gradebook Template for Teachers: How to UseThe best way to get an Excel gradebook template for teachers is to start with a built-in template from Microsoft (File >…
- Excel Group Lake Jackson TX: What It Is & ServicesExcel Group in Lake Jackson, Texas, is a local business services and staffing company that provides administrative, clerical, and light industrial staffing…
- Excel Flexi Timesheet Template UK: How to Build OneThe quickest way to get an Excel flexi timesheet in the UK is to build your own using a simple layout: Date,…
- Excel First Letter Uppercase Rest Lowercase?Yes, Excel can change the first letter of each word to uppercase and the rest to lowercase, but there is no single…