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…Continue Reading
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…Continue Reading
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 it provided, I have not used any other statistical…Continue Reading
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…Continue Reading
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…Continue Reading
This Excel Add-in allows you to create treemaps which can be used to visually represented for easier interpretation, think of it like a multiple-level pie chart. I’ve seen maps (Smart Money’s Maps) like these used in the stock market to display different Market segments and their performance for any given day. If you’re interested in…Continue Reading
Most computer users are not aware that files created from the Microsoft Office Suite (Word/Excel/PowerPoint) may contain hidden information that you may want to keep private. If you’re wondering what kind of information can be obtained, here’s the list; Author information Collaboration information Editing Time Date Created Date Copied and more… To battle this issue…Continue Reading
If you’re building up an extensive collection of movies in the new Blu-ray format, chances are that you’ve spent a couple of bucks putting it together. To help protect that small fortune that you call a movie collection, there are a couple of apps out there that will help you backup these discs so that…Continue Reading
If you are looking for a quick, easy and FREE method to convert your favorite movies and TV shows to a format you can take with you anywhere, you need to check out BDlot Video Converter. BDlot Video Converter is part of a greater suite of applications that allows you to convert videos to any…Continue Reading
With the imminent launch of iOS 5 for the iPhone and the iPad, Apple is moving forward with its new music offering for iTunes, Match. iTunes Match stores your entire music library in iCloud (another new service from Apple debuting this fall). When you store your music in iCloud you can access it from anywhere…Continue Reading
One of the settings I always enjoyed in Outlook is the ability to customize work hours so that my available time (work time) would appear on the calendar as a reminder not to schedule anything past a certain time. Google has taken this concept event further and now allows users to hide those morning and…Continue Reading
Just the other day I needed to print a monthly calendar in Mac OS X and realized that I had never done it before. When I opened the print dialog box I was amazed at the number of options available to print a calendar in iCal. So I decided to write this guide to help…Continue Reading
Have you ever found yourself looking for a particular set of files that are either named similarly or are of the same file type? Rather than perform a search in Mac OS to locate these files each time you want to access them, you have the option of creating a Smart Folder to simplify this…Continue Reading
