It’s easy to name a group of cells in Excel, then use that name for navigation.
This Excel video tutorial shows you the steps.
For a written Excel tutorial on naming ranges, see naming ranges in Excel.
______________
On TikTok, I follow Bryan Nothling aka thebnoth, because he’s funny, and he’s Canadian! His “working from home” videos have brightened my days, and he has over 200K followers, so I’m not the only person who enjoys them.
In an Excel pivot table, you can use built-in custom calculations, for a different view of the data. For example, in this video I set up the pivot table to show what % of monthly sales were Binders, and what % for each colour – red, blue, and black. You can get the sample file…
If you get pivot table refresh errors, this video shows how to troubleshoot those errors and try to fix them. For example, one common error is, “The PivotTable field name is not valid”. Or, you might see this error: “PivotTable report cannot overlap another PivotTable report.”
Chandoo started a new Excel series on his blog — How to create a fully interactive Project Dashboard with Excel. In this video for Part 1, Chandoo shows how to set up a Project Gantt Chart, and 3 more lessons in the series are coming.
An Excel worksheet might have headings in column A, and subheadings in column B, with blank cells under each heading. If you want to sort or filter that data, you’ll need to fill in the blank cells. This short video shows you a quick way to clean up the data. For written instructions please read…
Do you ever use check boxes on your Excel worksheets? They’re handy for choosing options, or marking completed items in a To Do list.