How to use PowerPoint Quick Styles
Posted on June 7, 2009 - Filed Under MS Office Tips | Leave a Comment
There are times that we want to spice up our PowerPoint presentations, but we just don’t have enough time to design the colors and styles for the fonts and slides. If you are not a designer, this could be a real challenge as that means you would need to get your feet wet on design.
Well, the Office developers are aware of that, so they provided a way for users to quickly choose from several predefined styles and apply it to their own document.
Insert an Excel worksheet into a Word doc
Posted on June 1, 2009 - Filed Under MS Office Tips | 2 Comments
Ever need to insert an Excel worksheet into a Word document and have them linked so that when you update the main Excel worksheet, it automatically updates the one in the Word document?
There are actually two ways to insert an Excel object into Word, linking and embedding. When you embed an Excel worksheet, the worksheet will not be updated when you update the main Excel file.
When you insert a linked worksheet, whenever you open the Word file, the linked Excel sheet will update it’s values to match the main external Excel file.
How to use Autofill in Excel
Posted on May 24, 2009 - Filed Under MS Office Tips | Leave a Comment
If you have a series of data that you want to enter into Excel, it is best to let AutoFill handle it. With AutoFill, your serial data gets automatically populated – you will only need to enter the first value on the list and the software will populate the rest for you.
To use this feature, start by entering the initial values of the row. In the example below, I entered a date for column A and a numeric value for column B. You can use Excel to autofill dates, numbers, and characters.
How to create macros in MS Word
Posted on May 8, 2009 - Filed Under MS Office Tips | 1 Comment
Do you always perform repeated tasks in Microsoft Word? Repeated tasks, if not automated are prone to human errors. If you perform a task repeatedly in Microsoft Word, you can automate the task by using a macro.
A macro is a series of Word commands and instructions that you group together as a single command to accomplish a task automatically. Since not all of us are programmers who can write code in Visual Basic, I will show you a way to create macros without even writing code.
How to quickly sort data in Excel
Posted on May 3, 2009 - Filed Under MS Office Tips | 1 Comment
How many times have you recieved an unsorted Excel worksheet? Probably a lot. And you certainly don’t wnat to sort the whole thing manually. If you are like Dexter Morgan who wants his grocery list alphabeticallt, then here’s an important tip that will make you more productive in Excel.
First, make a backup. Fire up Excel and backup your file by clicking Save As then enter a file name for your backup. After making a backup, click the section at the left side of the first row and column. This will select all cells in your sheet. You may also use Control-A to select all cells in an Excel spreadsheet.
How to insert a graphic header in Excel
Posted on April 28, 2009 - Filed Under MS Office Tips | 1 Comment
Want graphics in the header of an Excel spreadsheet? Sounds so easy to do, right? At first this task looks like a piece of cake, but after a while I realized that when I actually want to see the header on every page that I print, I ended up scratching my head.
My first try only printed the header on the first page but I wanted to have the header printed on all the pages. I will show you how to do this properly without pasting the header on every page break.
