Would you like to get better at using Excel? Well, you’re in luck. There’s an amazing, free resource that’s just a click away!
Chandoo.org is committed to helping you become awesome in Excel. Download their free “95 Excel Tips & Tricks” E-book now!
Click here to download your copy of the Excel Tips & Tricks E-book.
I often hear grumbles around the office from people who have unfortunately been left off of important emails. A lot of times, this is only by mistake. It’s hard to remember every person you need to include! So here’s a quick run-down on how to create contact groups using Outlook 2013. By following these steps, you can create a group of contacts. And then later, when you email the group, you won’t need to individually remember every person you want to contact.
1. In Outlook 2013, under the “Home” tab, in the “New” section, click “New Items.”
2. Under “More Items,” click “Contact Group.”
3. A new window will appear. To add members to your group, under “Add Members,” click “From Outlook Contacts.”
4. Now, in the new pop-up that appears, go to the “Address Book” drop-down menu and select “Global Address List.” From here, you will be able to find any of your contacts by searching.
5. When you are done finding all of your contacts, click “OK.” Before you finish, don’t forget to name your group!
+
6. That’s it! Click “Save & Close.” Now, when you create a new e-mail, in the “To…” field you can just type in the name of your contact group to email all of the people in that group simultaneously.
I just finished putting the final touches on a user guide. Now I want to publish it as a PDF and I want to have working links in the Table of Contents and bookmarks in the PDF. Choosing Print [to PDF] from the file menu will not result in a hyperlinked, bookmarked PDF file. But here’s how you can do it, especially if you use Heading 1 and Heading 2 paragraph formatting.
1. From the Word File menu, click Save As.
2. Navigate to where you want to save your file.
3. From the Save as type drop-down, select PDF (*.pdf).
4. Click Options…
5. In the Options pop-up screen, make sure that Create bookmarks using: Headings is selected.
6. Click OK in the Options pop-up screen.
7. Click Save.
8. The saved PDF will show hyperlinked bookmarks to the major headings. Click the bookmark icon to reveal the bookmarks if you do not see them.
9. The Table of Contents is hyperlinked too. Clicking on a line will take you to that page of the PDF document.
Using your computer, smartphone, camera, or the web definitely can be fun, but have you ever thought to yourself, “There has to be an easier way!” Well, there probably is, and you just don’t know it yet.
Tech columnist David Pogue is the personal technology columnist for the New York Times and a tech correspondent for CBS News. He’s also one of the world’s bestselling how-to authors, with titles in the “For Dummies” series and his own line of “Missing Manual” books.
He presented a terrific five-minute Ted Talk that gives you ten simple, clever tips for computer, web, smartphone, and camera users. And yes, you may know a few of these already – but there’s probably at least one you don’t. Click this link to view the Ted Talk now, and see how many of these tips you can put to use today!
I have to admit this. Some people are good at keeping meticulous records, but I am not one of them. My colleagues laugh at me because I am always losing notes, notepads, and even the pens I use to write my notes. Knowing this, I do use technology to help me. For some bizarre reason that I can’t really explain, I keep my digital life in much better order than my physical one. Perhaps it’s because you can throw a pile of virtual papers into a digital stack and rely on your technology to sort things out.
If you want me to dig out an address of someone I haven’t seen for ten years, I usually have all the contact details because I faithfully record any contact every time I make one. Here are some of the things I do:
That is how I make sure I don’t waste any time looking for someone’s contact information. It’s usually at the tip of my fingers. The maintenance of this information takes no time at all, and it is very handy to be able to reach the right people when you need them.
Outlook is an incredibly powerful tool, and it can do so much more than simply send and receive emails. Maintenance of a good contacts database is an excellent, painless way of making your professional and personal life easier to manage.
If you are an Analysis user, you may want to make sure that you are using the correct version of Internet Explorer (IE). Analysis does not work on IE10. If your computer is “possessed” and upgraded to IE10 “on its own,” ask your LAN administrator to install IE9. Don’t forget to have him/her keep your bookmarks.
If you are ashamed to say that you don’t know how to check your IE version, there’s hope for you too, since I included the instructions below.
That should show you what version you are running.
Do you ever use the Track Changes feature in any Microsoft Office products? It’s great! I use it in Word all the time. It’s especially useful when I’m working with a client and they have revisions to make to documents. Track Changes makes it easy to locate and see exactly what changes they’ve made.
Recently, we’ve had to update older documents. One document came to me that was nearly 100 pages long. My colleague had made numerous changes, but not on every page. I only needed to print the changed pages so I could physically take them into the audio recording booth. But wait – Word does not have the capability to just print Track Changes! (Trust me, I used the Help menu and tried to Google how it was done. Nope – it’s not possible.) I was fearful that I’d have to look through page by page and write down which individual pages to print. Before I gave in to that solution, I found a much better work-around. Here’s a trick to help you save a serious amount of time and paper.
It’s 11:30 a.m., you have a teensy break before your next meeting, and you are rushing to answer one more email. You push the Send button on that email and less than a split-second later, you realize that you just sent the wrong version or that the auto-correct feature in the TO line included someone who shouldn’t be receiving this particular message.
What to do?
You can try recalling the message in Outlook…
However this does not guarantee 100% success because of the reasons listed below:
Limitations:
Click here for more information on recalling emails in Outlook.
URL is the abbreviation for Uniform Resource Locator — otherwise known as a website address. Short URLs became popular when services such as Twitter gained momentum. It was impossible to stay within the allotted number of characters when you wanted to include the URL to a website. The only problem with short URLs are that you never know where the link will really take you. It could be to the website you expected, or it could be to a website that is full of viruses.
In today’s world, I never click on a short URL, even if it’s from someone I know. It’s just too risky. So what should you do instead? I found this great website (http://www.URLreveal.com) where you can enter in a short URL and it will show you the real URL behind it. If the real URL is not to the website you were expecting or to a random, unknown website, don’t go there. If you received the short URL from someone you know, ask the person for the full URL instead.
Bookmark this! Use it! Think of it as your online URL protection.
According to Global Equities Research data, the average iPhone user takes his phone out of his pocket for a glance about 110 times a day. Teenagers check their phones about every five to seven minutes.
Do you check your phone more or less than the average iPhone user? I suspect that I am average or higher. But I also suspect that it isn’t a very good thing.
Perhaps I should resolve to put the thing away and smell the roses of life!
How about you? Do you check your phone or other portable device all the time? And does that enhance or diminish your quality of life?
Let us know in the Comments section.
