Archive for Office 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

To The Cloud with Google and Microsoft

Mar 01, 2011 No Comments

Have you have been working on a document with your colleagues, either across the room or across the world, and have had the hassle of sending updated documents back and forth to each other? It’s quite a pain to do and you don’t always get the correct file. Google and Microsoft have teamed up to…Continue Reading

Create Sections in Word 2010 to Use Multiple Page Formats

Oct 14, 2010 3 Comments

How many times have you wanted use a specific header for certain pages and another header for others? You have probably sat there fighting with Word until you came across this guide. The answer to your problem is simple, sections. In Word users can create sections to divide the document into sections and each section…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 Add and Edit Hyperlinks in Word 2010

Sep 01, 2010 No Comments

Have you ever wanted to include a link to a website within a document you were working on? Did you know that you could include links to websites, parts of the document, new documents and even email addresses? In Word 2010 you have a lot of flexibility when adding hyperlinks (links) to documents. In the…Continue Reading

How to Test Your Document’s Readability in Word 2010

Aug 30, 2010 2 Comments

If you have ever been interested in the readability level of your writing then you are going to love a hidden feature in Word 2010. Why would you care about the readability of your writing? Depending on your audience, the level at which you write needs to be adjusted accordingly, for example, if you write…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

How to Customize Outlook 2010 Panes

Aug 24, 2010 2 Comments

Does the default font size and style used throughout Outlook’s program interface bug you because it’s too small or the font isn’t your favorite? Have you ever wanted to change the font size used for Outlook’s folders? If you’ve ever found yourself wanting to change how text looked in Outlook 2010, you’ve come to the…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 Save Attachments in Outlook 2010

Jul 22, 2010 8 Comments

Attachments come in many file types and sizes, luckily the act of saving them to your computer for later use is quite simple. Due to the number of messages that I have received regarding this task, I’ve decided to create a short guide that will walk users through the process of saving documents, images, and…Continue Reading

Tip: Use Columns to Vertically Split Content in Word Documents

Jul 21, 2010 5 Comments

Have you ever wanted to use a newspaper-like format for a document you were working with? If so, you’ll find that formatting content using multiple columns in Word is quite easy. The guide below will show you how to split the content in a Word document into two or more columns, similar to the layout…Continue Reading

How to Disable AutoCorrect Features in Word 2010

Jun 25, 2010 11 Comments

Although Word’s AutoCorrect  feature makes us a bit careless with what we type, it does heck of a job to increase our productivity. It corrects typos, capitalizes words for us, and makes sure that we capitalize the correct words. It also does a great job of being really annoying at times because it will automatically…Continue Reading

Tip: Change AutoRecovery Frequency in Word 2010 to Avoid Disasters

Jun 25, 2010 No Comments

Have you ever worked on a monstrous paper only to have Word crash? Luckily the AutoRecover feature backed up the file and you are saved, but what about the work you got done in the past 10 minutes? If you haven’t changed the default value that Word uses for AutoRecover, then you might have just…Continue Reading