Home Tags Excel 2010

Tag: Excel 2010

How to Subtract in Excel

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

Help Fix Americas Debt Using Excel 2010 and PowerPivot

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

How to Make Office Documents More Search Friendly

If you work in an office environment where documents are stored in a central repository it can be very difficult to quickly find documents,...

How to Enable the Developer Tab in Excel 2010

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

Video: How to Create Charts in Excel 2010

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

10 Reasons You Should Consider Switching from Office 2007 to Office 2010

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

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

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

How to Create and Edit Sparklines in Excel 2010

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

Save Time Formatting Cells in Excel with the Format Painter

Applying a specific set of formatting settings to range of cells can be time consuming so imagine having to do the same for another...
Office 2010 and Office Web Apps Compared

Office 2010 and Office Web Apps Compared

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...
Word 2010 Screenshot Office

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

Are you looking for a way to quickly insert screenshots from your computer into a Word document? In Word 2010 the Screenshot tool has...
Formula Auditing Tools in Excel

How to Use the Formula Auditing Tools in Excel 2010

How many times have you found cells with errors or the famous ##### entry? These can all be attributable to errors or improper formatting....
Add a Database to PowerPivot for Excel

How to Add a Database to PowerPivot for Excel

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