Create a Simple Macro in Excel 2010 and Assign it to a Button
Posted on August 14, 2011 - Filed Under MS Office Tips | Leave a Comment
One of the best ways to speed up your work in Excel, especially repetitive tasks, is to record macros that perform the things you do over and over. Another way is to use buttons to tell Excel to do things that you may not always remember how to do. To really speed up your work and make your life easier though, combine the two by creating a macro and then assign it to a custom button you create.
Create and Use a Table of Contents In Word 2007 – 2010
Posted on August 11, 2011 - Filed Under MS Office Tips | Leave a Comment
For most of its history, Microsoft’s flagship word processor has had a means for creating and using a table of contents automatically; and with each iteration, Microsoft has improved upon the prior version, which has led to a table of contents generator that after all this time, is finally easy to use.
To see how a table of contents is created in Word, first create yourself a dummy document that has some chapter headings in it; something that looks like this:
Create and Use Range Names in Excel 2010
Posted on August 5, 2011 - Filed Under MS Office Tips | Leave a Comment
Microsoft Excel has long allowed users to create and use range names in earlier versions, of Excel, but that doesn’t mean everyone learned how to use them, which is a shame, because the main purpose of range names is to make things easier for you when creating and using spreadsheets.
In Excel, 2010, creating a range name is relatively simple; first, create some data, as we have in this test sheet:
Highlight the data for semester 1, then click on the Formulas ribbon, then click on Define Name; you should get a popup like this:
Insert a Watermark in Word 2010
Posted on August 1, 2011 - Filed Under MS Office Tips | 2 Comments
If you need to insert a watermark into your Word 2010 document, it’s pretty easy! You can insert a template-based watermark or you can create your own using your own text or your own image.
Oddly, you would have thought to insert a watermark, you would go to the Insert ribbon, right? Wrong! You can always count on Microsoft to make you hunt for simple options like inserting watermarks.
Anyway, it’s under the Page Layout ribbon. Towards the center you will see the option called Watermark.
How to Create Fillable Forms in Word 2010
Posted on July 17, 2011 - Filed Under MS Office Tips | 1 Comment
Not many people know that Microsoft has given Word users a way to create fillable forms for several iterations. In 2010, it all happens under a normally hidden tab, called Developer.
So, to start, the first thing you need to do is make the Developer tab visible on your main ribbon; to do that, click on the File option, then move down and select Options
Then click Customize Ribbon:
Then check the box that says Developer:
Create and Use a Simple Database in Excel 2010
Posted on July 8, 2011 - Filed Under MS Office Tips | Leave a Comment
A lot of people use Microsoft Excel as a database because they don’t want to learn how to use an actual database program, or because they don’t want to spend the money; whatever the reason, using Excel 2010 as a database is something that can be done relatively easy, so long as you keep things as simple as possible.