Do you use Excel to manage your lists? Contact lists, financial lists any data lists at all. Have you ever wanted to find duplicates in your list? With Excel 2007 this new feature has made managing and finding duplicates as easy as clicking a button.
A pop-up window will appear, choose the column that you believe contains the duplicates and uncheck the columns that do not and click OK.
If your column has duplicates they will have been removed.
See easy as pressing a button.
Co-workers leave and computers crash, and you may have a PDF file saved in your email that you need to make a change to. Here is what you can do IF you have the full version of Adobe Acrobat 8. This means the reader and writer for creating PDF files.
1. Start by opening the PDF in Acrobat. Now try selecting some text by using the select tool – this can be found on the basic toolbar it is a black arrow with the word select next to it. Click this tool and try double-clicking on a word. If you can not highlight the word then you will need to convert it to a text-friendly document before you convert it to Microsoft Word. If you can select the word, skip the next step.
Have you ever wanted to have one page in your Word document with one margin and on a second page another margin? Frequently, companies need to use this with a two page letter head or proposals with a cover letter.
If on page 1 you want a 2 inch top margin for your letter head and on page 2 you want a 1 inch margin. Here is what you need to do.
Ever open up a Word document and can’t find the button for changing the text to Bold? How frustrating is that? That little “bold” button and all the other icons on the top of your window are toolbars. You can accidentally move them around or remove them completely by hitting keys on your keyboard.
Programs like Word, Excel, Outlook, Powerpoint and Internet Explorer all have toolbars. If you do not see any icons on the top portion of your program window it is because your toolbars are turned off.
Click here for downloadable notes of this week’s tip
I have a favorite spot that I like to sit in, my couch. When I ride the train into New York City, I even have a favorite side of the train I like to sit on. Many of us are drawn to doing things a certain way because we are comfortable. One thing I’ve learned as an Entrepreneur is that I need to be open to advice from other people, and what once was awkward now seems second nature to me.
Do you use your logo on the cover of folders or address labels? Why not it’s easy to brand your company with Word.
In the past few weeks I have been working with clients on using Microsoft Word and being more productive with the tools available. Formatting is always an issue, especially with large documents. If you are working with a document that has many sections and content from outside sources, here are some things you need to keep in mind:
Copy & Paste
Everyone grabs text by using the copy command, but did you realize when you click paste not only are you pasting the text, but you are also pasting the formatting? To avoid this instead of choosing Paste – choose Paste Special. When you Paste Special, you will be given the option to paste unformatted text. By selecting this option your text will default to the normal style of your word document.
Microsoft Office do you use it? Of course you do. But do you use all the tools that are part of Word, Excel, Outlook and PowerPoint – probably not. Everyone asks me about knowing more about these great software programs, but just don’t know what they should be asking. Today let’s start with a business issue instead of a software issue. I want to use my Outlook more like a contact management program, can I do that?
“Is there a way to email a distribution list for people to put in their address book?”
– Michael G, NYC, NY
Yes Michael, if the people you are sending the list to use Outlook, then you can send them a copy of your distribution list.
A distribution list is a group of contacts assigned to one list that you name, to eliminate the constant need to add the same 5, 10 or even 30 people to an email. It is a great time saver.
““How do I set images in Outlook to download all the time with out having to do it in each email?” – Kathy
If you recieve my email or emails from stores raving about the products on sale, then odds are the email contains images. So how do you set Microsoft Outlook to downlaod images automatically?
Open Outlook and click Tools from the menu bar, then choose Options from the menu. The Options window has many tabs at the top – click on the tab marked Security. Half way down the window you will see a button marked: Change Automatic Download Settings…
Give us your email address below and
receive free tips from the Technology
Therapist.
