I have a set of documents that I frequently use in Excel and Word. Most of the time I can find them using the Recent Documents menu, but at times when they are not listed (because I’ve opened so many other documents) I have to locate the files to open them. I am always looking for ways to speed...

Like I stated in my previous post, I was able to get a copy of Office 2010 and have been playing with it since. The videos below are just a preview of each of the applications mentioned below, more will follow. Even though it is a technical preview I found it to be extremely stable throughout the...

Excel like many of Microsoft’s other Office applications are extremely powerful tools that have many ‘hidden’ features. I stumbled on the Analysis ToolPak when I took an quantitative analysis class for my Masters program. Once I enabled the add-in and learned how to use the tools...

When using Excel and working with two data sets that differ greatly in range it can be difficult to chart those values due to the larger range of one of your data sets. A classic example of this would be your monthly data and your YTD values for each month. When you put these together in a chart the...

Most of the time I work with a lot of data and I’ve found that the most effective and simple way of sorting and making use of that data is by applying AutoFilters in Excel. The AutoFilter tool allows you to arrange a set of data in a variety of ways which helps you find specific information...