How to Create and Edit Sparklines in Excel 2010

Aug 27, 2010 View Comments by Gilberto J Perera

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

Excel 2010, How-to, Office 2010 Read more

Save Time Formatting Cells in Excel with the Format Painter

Jul 30, 2010 View Comments by Gilberto J Perera

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-to, Office 2010 Read more

How to Use the Formula Auditing Tools in Excel 2010

May 21, 2010 View Comments by Gilberto J Perera

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

Excel 2010, How-to, Office 2010 Read more

How to Access the Calculator Without Leaving Excel 2010

May 20, 2010 View Comments by Gilberto J Perera

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

Excel 2010, How-to, Office 2010 Read more

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

May 10, 2010 View Comments by Gilberto J Perera

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

Excel 2010, How-to Read more

How to Add a Header and Footer to Excel 2010 Spreadsheets

May 10, 2010 View Comments by Gilberto J Perera

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 2010, How-to, Office 2010 Read more

3 Ways to Enter Formulas in Excel 2010

May 10, 2010 View Comments by Gilberto J Perera

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

How-to, Office 2010 Read more

How to Save Office 2010 Files Directly to SkyDrive

Apr 09, 2010 View Comments by Gilberto J Perera

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

How-to, Office 2010, Office WebApps, Outlook 2010, PowerPoint 2010 Read more

How to Change the Color Scheme for Office 2010 Applications

Apr 09, 2010 View Comments by Gilberto J Perera

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

How-to, Office 2010 Read more

Let Excel Speak to You and Save Time

Feb 03, 2010 View Comments by Gilberto J Perera

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

How-to Read more