Don’t forget attachments in Outlook 2007 anymore
Posted on June 29, 2009 - Filed Under MS Office Tips | Leave a Comment
Just two days ago, I wrote about the most useful Gmail Labs features, one of which is a attachment reminder. If you mention somewhere in your email that you have “attached” a file, etc, and if you click Send and there is no attachment, it will prompt you before sending.
Unfortunately, this functionality is not available in Outlook by default, however, since it’s one of the most used email clients in the world, it would be nice to have the option!
How to open a new instance of Excel 2007 workbooks
Posted on June 26, 2009 - Filed Under MS Office Tips | 3 Comments
If you work with Excel a lot, you’ve probably noticed that each workbook you open doesn’t create a new instance of Excel. There are not several tabs for Excel in your taskbar like for Internet Explorer or other programs.
Why is this and how can it cause problems? For the most part, it’s not a big deal and doesn’t bother most Excel users. However, it is a real pain when working with many spreadsheets and they are treated as a group.
Remove backgrounds from pictures using Office 2010
Posted on June 22, 2009 - Filed Under MS Office Tips | Leave a Comment
Removing picture backgrounds for an image has always been a challenging task for casual users. Traditionally we need a good picture editing software like Photoshop and use its magnetic Lasso tool to select the portion of the image that we want to retain.
In the technical preview of the incoming MS Office 2010, there is built-in capability to remove the background of an image so that the subject of the portrait will be the only thing remaining.
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 | 1 Comment
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.
