Often businesses identify products, projects, or people with numbers. Sometimes those numbers have a zero at the beginning. This is … More
Tag: Excel
Excel: Shortcuts for Selecting a Cell, Highlighting a Range, Going to the End of your Data
I have found that I understand Excel because I seem to think in Excel terms. Even before … More
Excel: Counting with Totals Row in a Table
In the last two lessons, we learned about Filtering and Excel’s Format as Table command. Open up the dog breed … More
Excel: Why should I use “Format as Table” command when my table is already there?
In a previous blog, I introduced filtering, but warned you not to use the sort command when you use filtering … More
Excel: Giving Me Only the Information I Want, aka, Filtering
I will be devoting three days to this topic. Sorting and filtering information is one of the most efficient uses … More
Excel: Why is “Keep my Headings on Top” called “Freeze Panes?”
Last spring, I taught an Excel workshop. Now I receive lots of “just one quick question” calls and visits. By … More
Helpful Office Tips 