Updates to Web Apps Brings New Features to Excel & PowerPoint Online

by May 16, 2011

With online office programs, such as Google Apps, becoming more popular, it’s getting harder and harder for Microsoft to compete. On June 7, 2010 Microsoft entered the online office program playing field with their new set of apps, called Web Apps which included Word, Excel, PowerPoint and OneNote. A few months ago they made Web…Continue Reading

How to Subtract in Excel

Apr 13, 2011 No Comments

If you are new to Excel and unfamiliar with Excel’s built-in functions, specifically subtraction you will find this guide useful. In the following steps I will show you how to create a formula in Excel that a cell from another to provide you with the difference. Software/Hardware used: Office 2011 running on Mac OS 10.6,…Continue Reading

Hide Those Gridlines in Google Spreadsheets

Mar 01, 2011 No Comments

Google Docs, a wonderful and free alternative to the Microsoft Office suite, isn’t perfect in terms of options, but it is well on its way. If you’ve used Excel in the past I’m sure you’re aware that you can make some simple changes to the viewing of gridlines. Well, Google Spreadsheets hasn’t offered this feature…Continue Reading

How to Print Labels in Word 2011 with Mail Merge

Dec 20, 2010 2 Comments

Are you trying to print a set of labels from an address list stored in Excel, FileMaker, or your Apple Contact list? If so you are going to love this guide. In the steps below I will show you how to print labels from a list using Word 2011. For those of your coming from…Continue Reading

How to Enable the Developer Tab in Excel 2010

Oct 19, 2010 3 Comments

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

Video: How to Create Charts in Excel 2010

Oct 08, 2010 4 Comments

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

How to Change the Default Save Format in Excel, Word and PowerPoint 2010

Sep 13, 2010 No Comments

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

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

Save Time Formatting Cells in Excel with the Format Painter

Jul 30, 2010 No Comments

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

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 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

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