Getting Started with MS Excel

My first introduction to Microsoft Excel was in the early 90’s. I remember when I first opened it and looked at those little boxes I thought to myself “What the heck do I do with this?”. I looked around the menu items and closed the program for the day to let my brain take it […]
Those Pesky New Year Digits

Now that it is a new year, sometimes we forget to date things with the correct year. Use conditional formatting to alert yourself of a wrong year entered in excel.
Working With Time in Excel
When entering time in the cell don’t forget it starts with hours. Using a 24 hour clock is best, no need to type “am or pm”. Once you enter your time you can format the cell as needed and the formula will work. If you are only adding minutes and seconds, you still need the […]
Opening Old Files

Q: How can I open this [file type] file? When I click it it will not open. I often get calls from friends and colleagues to help them open a file that was either sent to them via email or something that is in their archives that they need to revisit. The answer is short […]
Have Fun with Tab
Hold down the shift key while tabbing to go backwards. Hold down the ctrl key to tab in a table (MS Word).