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 [...]

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 [...]

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 [...]

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 [...]

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 [...]

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 [...]

Excel’s power lies in the vast array of formulas that allow you to calculate the sum of a given list all the way to determining the interest rate on a loan. But in order to use these powerful formulas you must become familiar with the several ways that formulas can be entered and used. While [...]

Wouldn’t you like to be able to access all of your Word Documents, Presentations, Spreadsheets, and even your Notes on the Go? Well, if you use Office 2010 and your Windows Live SkyDrive you’ll have your files securely stored online so that you can access them from anywhere. Gone are the days of additional plug-ins [...]

If you really want to differentiate yourself from others who use the default color scheme in Office 2010 applications, then read on. Office 2010 (beta) ships with three color schemes to help customize the look of all Office 2010 applications. To change the color schemes on your Office 2010 installation, follow the instructions below.
Note: When [...]

If you’re like me and you’re not that great with the number pad on a standard keyboard, Excel’s ability to speak what you type as you enter it can make the difference between a couple of minutes in front of a spreadsheet or hours. The Speak Cells command will enable Excel to dictate the information [...]