More Counting in Excel
Last year I wrote a blog about using the COUNT and COUNTA functions in Excel, but what if you wanted to count the number of cells within a range that meet a single criterion that you specify. For example, I want to know how many OFF2007NF classes we’ve scheduled for this year (see following image).
In [...]
Keyboard Shortcuts in MS Office
Here are some of my favorite shortcuts. If you feel like you can’t find any of your commonly used features now that you have MS Office 2007, all the keyboard shortcuts have remained the same.
Feel free to add your favorites to the list!
All of MS Office
Ctrl-Home
Move to the beginning of the file
Ctrl-EndÂ
Move to the end [...]
Using Excel’s COUNT and COUNTA Function to Return Number of Records
Sooner or later you will need to know how many items are within a range of cells. If you try to count them by hand, it will be difficult and time-consuming. For example, imagine trying to count the items in a range consisting of 200 cells. Excel provides different functions that you can use to [...]
