Excel Tips
March 12, 2002
There are hundreds of Excel keyboard shortcuts, but no one can remember all of them. Here are a few of my favorites that you can start with.
Excel Pivot Table Date Order »
March 5, 2002
I have a pivot table with clients down the side and months going across the top. For some reason, May of 2000 is appearing after December of 2000.
Returning Specific Data on Examining a Range »
March 2, 2002
How to examine a range of cells and return a certain value if any one of the cells in the range contains a certain word.
Calculate and Display the Largest Value »
March 1, 2002
How to calculate and display the largest value.
Automatically Add a Character in a Cell »
February 28, 2002
How to automatically add a character in a cell.
Have IF Function to Return Yes or No »
February 27, 2002
How to have IF function to return Yes or No.
February 26, 2002
I have an Excel spreadsheet with a column of lengths in the format of 12' 6 7/8". How can I use Excel to convert this to decimal feet?
Close Workbook without Saving with VBA »
February 26, 2002
How to close a workbook without saving it by using VBA.
Create and Name a Worksheet with VBA »
February 25, 2002
How to create and name a new worksheet with Visual Basic for Applications - VBA