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 work in an office environment where documents are stored in a central repository it can be very difficult to quickly find documents, spreadsheets, and other files without specific direction. Fortunately there’s a way to add keywords and other information that will help you and others locate files during searches. Office 2010 and with…Continue Reading

Are you trying to create a macro in Excel 2010, but can’t find the macro button anywhere? Don’t worry it’s there, but the tab containing the macro button and others is disabled by default. Follow the instructions in the guide below so that you can enable the Developer tab in the Excel Ribbon so that…Continue Reading

Have you ever wanted to chart data in Excel, but didn’t know how? In this short video how-to I will walk you through the steps necessary to add a line chart in Excel 2010. As you will soon see the same steps apply for bar charts, pie charts, and other charts. If you have any…Continue Reading

If you’re on the fence regarding the decision to upgrade to Office 2010 then you might want to consider reviewing some of the new features highlighted below. Most people will say that Office 2010 is just another release of Office with a couple of embellishments similar to previous versions of Office, but in this case they…Continue Reading

How many times have you received a reply from someone who cannot seem to open an attachment you sent them recently? If you’re using Office 2010 chances are that others have yet to upgrade to the latest version of Office, this means that you are likely sending them Word, Excel, and PowerPoint files that are…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

Applying a specific set of formatting settings to range of cells can be time consuming so imagine having to do the same for another sheet or workbook. Luckily in Excel 2010, the Office team included one of my favorites, the Format Painter tool. The Format Painter tool is an easy to use tool that allows…Continue Reading

Microsoft today debuts Office 2010 along with the much anticipated Office Web Apps. Office Web Apps is essentially an online version of Microsoft’s most popular products; Word, PowerPoint, Excel, and OneNote. The online versions of these products are free to anyone with a Live/Hotmail account and will allow you to create, edit, open, and save…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