Learn to control task panes in your Microsoft Office Programs with just a few keystrokes.
MS Excel: Your Inserting Options
Do you know your options when you insert a row or column into and MS Excel worksheet? No? Then here's what you need to know when it comes to some fast formatting choices for those new rows and columns.
MS Excel: Looking at Some New Merged Cell Behavior
If you're old-school when it comes to MS Excel and love to use the merge cell feature, then you know the frustrations that they can cause during editing. You need to check this out to discover some good news for Excel 2007 & 2010 users.
MS Office: Calculating Time Difference in Excel
It is possible to calculate time totals in Excel. Here's a quick tutorial to show you how!
MS Excel: Select From Current Cell to Top, Bottom, Left or Right
Learn to use your keyboard to select cells from your current location to one of the 4 edges of the data range and beyond!
MS Excel: The New Accounting Number Format Button
Use Excel for a lot of monetary data? Is that data in something other than dollars... maybe Euros? With Excel 2007 & 2010 you've got quick access to these formats that you may have not even noticed!
MS Excel: Sort Direction Choices
Is your Excel data set up "backwards" for the purposes of sorting? Don't transpose your data - take charge and make Excel change its sorting direction to meet your needs.
MS Office: Customize Your Hyperlink Screen Tips
If you're going to see a screen tip when you hover over the link, then it might as well be something more useful than the old "Click to follow link"! Learn how to customize your hyperlink screen tips here.
MS Excel: Change a Chart’s Location
Unknown to many, once a chart has been created it is not locked into that location. Learn what your options are and how to make a chart move locations here.
MS Office: Switch SmartArt Layouts Without Starting Over
Let MS Office transfer SmartArt information from one layout to another.