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.
______________
Sometimes it’s easy to make an Excel chart, and sometimes a struggle. There are days when you feel like a superhero, if you just manage to build a simple chart, and change the colours in it! Here are a couple of short videos that show how to work with Excel pie charts, and win the…
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.”
Here’s a bit of Friday fun, with Excel song videos by professor Clint Tuttle. I used to look forward to his videos, in December and April, when the school terms ended.
Highlight all the cells in a row, if one cell is above or below a specific value. To do this, use Excel conditional formatting, as described in this short Excel video tutorial. For detailed instructions, please visit the page Excel Conditional Formatting Based on another cell ____________________
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.