Archive for Excel 2010

Help Fix Americas Debt Using Excel 2010 and PowerPivot

by Mar 30, 2011

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

How to Create and Edit Sparklines in Excel 2010

Aug 27, 2010 2 Comments

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

Tip: Use the Office 2010 Screenshot Tool to Quickly Capture Your Screen

Jun 14, 2010 4 Comments

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 to Use the Formula Auditing Tools in Excel 2010

May 21, 2010 No Comments

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

How to Add a Database to PowerPivot for Excel

May 21, 2010 No Comments

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 to Access the Calculator Without Leaving Excel 2010

May 20, 2010 No Comments

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

How to Create a Line Chart in Excel 2010

May 11, 2010 11 Comments

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

Use the NETWORKDAYS.INTL Function to Calculate Workdays Using Excel 2010

May 10, 2010 No Comments

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

How to Add a Header and Footer to Excel 2010 Spreadsheets

May 10, 2010 No Comments

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