How-to basics
Everyday tasks: sorting, filtering, formatting, printing, shortcuts.
- How to Split First and Last Name in ExcelSplit first and last names in Excel with Text to Columns, formulas, or Flash Fill. Handle extra spaces and middle names with…
- How to Freeze Top Row and First Column in ExcelFreeze the top row and first column together in Excel with Freeze Panes, plus fixes for common issues and tips so labels…
- Excel conditional formatting based on another cell?Learn Excel conditional formatting from another cell with formula rules, reference examples, and fixes for common problems, so your highlights stay useful.
- How to Calculate Age in Excel from Date of BirthCalculate age in Excel with DATEDIF, handle blank or invalid dates, and format results correctly. Follow the steps for a reliable age…