Dynamically Link an Excel Spreadsheet into a Word 2010 Document
Posted on October 24, 2011 - Filed Under MS Office Tips | Leave a Comment
There are times when you’re working in both Word and Excel where you’d like the data that you’re using in Excel to appear in your word document as a table, but you’d also like any changes you make to the Excel sheet to be automatically updated in your Word document. This is possible using dynamic links with OLE objects.
To see how this works, first open and create a simple Excel spreadsheet, in this example, we’ll use this simple example sheet:
Enable Text-to-Speech in Outlook 2010
Posted on October 21, 2011 - Filed Under MS Office Tips | Leave a Comment
Email is the communication medium of choice for most of large businesses. Employees often feel drowned in the sheer amount of emails received in a given day. Instead of skimming emails and potentially missing important information, a better way to multitask is to set Outlook to read emails to you.
Outlook 2010 has built-in text-to-speech capability. To turn it on, open an email, then right-click in the blank space on the top ribbon. From the menu that appears, click Customize the Ribbon.
How to Use Conditional Formatting with Excel 2010
Posted on October 17, 2011 - Filed Under MS Office Tips | Leave a Comment
One of the neat features of Excel is how there are so many cool ways to automatically show off your data; and one of those ways is by using Conditional Formatting.
In short Conditional Formatting is where Excel causes formatting to occur based on the contents of the cell. To see how this works, create yourself a little test sheet, in this example, we’ll use this one:
Next highlight your data, then click on the Conditional Formatting icon on the main ribbon; you should get this drop-down menu:
How to Use the Excel 2010 Basic Fill Feature
Posted on October 12, 2011 - Filed Under MS Office Tips | Leave a Comment
Microsoft Excel has had a fill feature of some kind going back several versions, and while each version did much the same as the last, you couldn’t always count on things just exactly the same way; below is the way it works in Excel 2010.
To begin, let’s start with a simple data sheet:
Next, highlight the bottom row of data and the one below it, like this:
Then, click on the Fill icon on the Home tab ribbon:
Use Templates in MS OneNote 2010
Posted on September 17, 2011 - Filed Under MS Office Tips | Leave a Comment
With the latest additions to its Office suite of products, Microsoft has added new functionality to all its entire lineup, and OneNote is no exception. One change that many users have noticed right away is the lack of a Templates choice on the main ribbon, or any other ribbon for that matter. This is because in OneNote 2010, the only way to add a template is by doing so when adding a new page; thus the means for doing so is on the new page menu, and it’s located way over on the top right side of the OneNote screen:
Track Changes When Two or More People Work on the Same Word 2010 Document
Posted on September 11, 2011 - Filed Under MS Office Tips | Leave a Comment
Quite often, especially in a work environment, multiple people wind up working on the same Word document, although not necessarily at the same time. While this makes sense because oftentimes a document needs input from several people, or its edited by more than one, such activity can make it difficult to keep track of who did what. For Word users, that problem can be eliminated by learning how to use the track changes options that are available.
To begin, it’s best to start with a dummy document, here’s the one we’re going to use here: