If you haven’t been stuck under a rock for a while, then you should be well aware that America is in debt. Politicians have their own way of configuring numbers to help manage debt, of which many people don’t agree upon. However, one author, Tyler Chessman, of the book Understanding the United States Debt has…Continue Reading
If you’ve ever tried making sense of a lot of trend data in Excel you’ve usually found that plotting the data using a line chart or bar graph helps you make sense of it all. However what happens when you have more than one data set and all you need is a quick preview? Rather…Continue Reading
Are you looking for a way to quickly insert screenshots from your computer into a Word document? In Word 2010 the Screenshot tool has been improved so that is more intuitive and easier to use. The guide below will show you how to use the Screenshot tool in Office 2010 to quickly insert screenshots into…Continue Reading
How many times have you found cells with errors or the famous ##### entry? These can all be attributable to errors or improper formatting. In this tutorial we are going to focus on the error part. In Excel you have the ability to compose simple formulas that add a list of numbers or you can…Continue Reading
Are you new to PowerPivot for Excel? You’ve come to the right place. In this tutorial and in upcoming tutorials, I will be covering the basics of Excel’s powerful new data analysis tool. In this guide I will show you how to add an Access database with more than one table. Before you get started…Continue Reading
How often do you find yourself opening the Windows calculator to quickly find the solution to a problem? How often do you create a formula in Excel to find the answer to a silly calculation? If any of these apply, then you might want to add the Calculator command to the Office Ribbon in Excel…Continue Reading
If you are looking for a quick and easy way to display trend data for a period of time, like stock prices, the best chart to use is the line chart and its variants. Excel comes the option to chart data using various line charts that allow you to customize the look and feel of…Continue Reading
In Excel 2010, Microsoft introduced a new formula to complement the NEWORKDAYS formula that exists in previous versions of Excel. NETWORKDAYS allows you to calculate the number of workdays in a given time period including holidays. In the new version of the equation for Excel 2010 you can specify when the the weekend falls in…Continue Reading
Want to make your Excel spreadsheets stand out? Use the header and footer. Like Word documents, Excel spreadsheets have the ability to use a header and a footer to display important information about the spreadsheet/chart you are working on. The header and footer are usually visible when the Page Layout view is enabled and when…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
