TechFest TV: Meet Sheri and Find Out About Office 2010
Sheri Trine, PMP, shares a short video clip of her upcoming “New Features of Office 2010” presentation at Philly TechFest 2010 (May 7th) and DC TechFest 2010 (May 21st). This session will cover some pretty cool features such as:
Users can customize the Ribbon
Document versions – during the autosave process, a version will be saved each [...]
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 [...]
