Dynamically Link an Excel Spreadsheet into a Word 2010 Document
Posted on October 24, 2011 at 5:43 am
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:
» Filed Under MS Office Tips | Leave a Comment
How to Use Conditional Formatting with Excel 2010
Posted on October 17, 2011 at 5:15 am
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:
» Filed Under MS Office Tips | Leave a Comment
Build a Unique and Colorful Resume the Easy Way
Posted on October 15, 2011 at 5:22 am
Making your resume stand out in a large pile of other resumes is a challenge facing all job seekers, especially in a weakened economy. Depending on the job for which you are applying, a creative and visually appealing resume can mean the difference between being called for an interview and not.
Many apps for creating resumes that stand out in a crowd are appearing on the Web. One of the easiest-to-use apps is Resumesimo.
Click Get Started to start building your resume.
» Filed Under Cool Websites | Leave a Comment
How to Use the Excel 2010 Basic Fill Feature
Posted on October 12, 2011 at 6:47 am
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:
» Filed Under MS Office Tips | Leave a Comment
Clean and Fix Windows 7 Registry Errors
Posted on October 11, 2011 at 6:04 am
The registry for Windows based computers, whether they be XP or 7, is a bit more complex than most everyday PC users would like it to be. Over time, through installing applications, uninstalling applications, and software updates, the registry can become cluttered with errors. In today’s post, we will review how to quickly scan and clean the registry in Windows 7, to remove errors and other broken paths.
For this tutorial, we will be using the popular freeware CCleaner, an application that has received countless positive reviews, and works equally as good as some more expensive paid programs.
» Filed Under Windows 7 | Leave a Comment
iPhone 4S FAQs and Things You Should Know
Posted on October 8, 2011 at 5:19 am
Although the iPhone 4S doesn’t seem as much like a “new phone,” because the design hasn’t changed, there are still several things that you may want to take into consideration if you are planning on purchasing the 4S. In today’s post, we will cover some frequently asked questions regarding the 4S, and also list some things you should know, prior to purchasing the device.
Let’s start with some frequently asked questions regarding the Apple iPhone 4S.
FAQs
When will the iPhone 4S be available in stores?
» Filed Under Gadgets | Leave a Comment