Creating Your Own “Button”

Hi Friends!

This tip is for Outlook, PowerPoint, or Word. I’m not sure what other programs it will work in. It works if your recipient will read an electronic (soft) copy, rather than a hard copy (for obvious reasons).

Basically, you’ll copy a logo for your link. In this case I’m going to choose LinkedIn. Then you’ll associate a hyperlink to that logo. In this case I’ll associate my LinkedIn page to the LinkedIn logo. Here’s how it’s done:

1.   Go to Google.com and click “Images”

2.   Enter “LinkedIn” in the search box and hit enter

3.   Choose your favorite logo for LinkedIn and click on it to open it in its largest form

4.   Right-click and select “Copy Image from the resulting list”

5.   Go to you document (e-mail, slide, or Word document) and hold “Ctrl” and tap “V” to paste.

6.   Resize as needed.

Now we’re going to save your hyperlink in your documents.

1.   Go to your LinkedIn profile and find “Public Profile”

2.   Right-click on the URL (circled above) to the right of “Public Profile”

3.   Click “Save link as…”

4.   At this point you will see a file saving screen pop up. Save it in a place and as a name you will remember easily.

Now go to your document (e-mail, slide, or Word document)

1.   Right-click on the logo you pasted and choose “Hyperlink”

2.   Navigate to the URL you saved in LinkedIn and double-click it.

Your logo/icon is now a hyperlinked button! (Make sure you test it before you send it along though.)

Thanks for stopping by!

Leave a comment

Filed under More..., MS Word, PowerPoint, Social Networking

Excel: Drop-down Column Headers

Hi Friends!

Today I will show you how to create drop-downs for your columns in Excel. I like it more than sorting, because you can sort by a value, or values, and exclude all other data. It’s another really quick tip.

If you have a column or more that has just a lot of repetitiion, e.g. seven possible categories, filtering helps. I did that with my tips catalog. I keep a running “master” of all the posts I do, so I like to filter them by category. That way I can quickly see how evenly I’m spreading my attention to each topic.

Here’s how to do it:

1.   Select one or more column header(s)

2.   Click on the Data tab

3.   Click on “Filter” (the funnel icon)

Now you have drop-down arrows for each column. I’m not sure why you can’t filter just select columns.

Here’s a tip on using the drop-downs: Notice that you have the option to choose to sort the list or more than one item in the list (see below). To select one or just a few items, click the “select all” checkbox to deselect the whole list. Then check each item you wish to see exclusively.

And there you have it! That’s filtering.

Thanks for stopping by!

Leave a comment

Filed under MS Excel

PowerPoint: Sound for ONE Slide, Several Animations

Hi Friends!

Well, I stumped myself today and, of course, I must always get to the bottom of it or I can’t rest. Here’s the story:

While working on a PowerPoint presentation, my client and I decided to illustrate the skills it takes to successfully enjoy a whitewater kayaking expedition on one PowerPoint slide. She had about 8 words to list; and instead of listing them, I thought it’d be cool to have each word fade in and out individually. She came up with the idea of adding a rushing river sound to it. GREAT! That was an awesome idea!! So, I showed her how to add sound and make it start automatically when that slide came up. It would end when the slide changed.

Ok…but the words wouldn’t animate. For some unknown (at that moment) reason, the animation was hanging up at the sound byte. Now YOU get to benefit from my stumped-ness!

1.   Add your sound byte, by going to the Insert tab, clicking on “Sound,” and then “Sound from file.” Then navigate to your sound and double click it. Answer the pop-up box by clicking “Automatic.”

2.   Check the option boxes, “Hide during show” and “Loop until stopped.”

3.   Click the Animations tab and select “Custom animation” (2007) or “Animation Pane” (2010).

4.   Click on the sound byte in the Animation pane, and then click the down-arrow (1 below).

5.   Select “Effect Options.” (Arrow 2)

6.   About half way down that first screen, you’ll see the section called “Stop playing.”Click the radio button called “After _____ slides” and make sure the blank says 1.
7.   Click “Ok.”
Test it by clicking the slide show icon in the lower right corner of the screen.
Thanks for stopping by!

Leave a comment

Filed under PowerPoint

Take Screenshots of your iPhone!

Hi Friends!

If you saw my post from two days ago, you probably noticed I used screenshots of my iPhone. This is a fun feature, particularly if you play games that show huge scores. (This will be the quickest little tip yet!) All you have to do is push the power button and the dented button under the screen.

Thanks for stopping by!

Leave a comment

Filed under More...

iTunes: Deleting Apps from Your iPhone

Hi Friends!

For those of you who saw yesterday’s tip, you know it was on how to delete apps from your iPhone itself. Today, I’ll help you manage them on your iTunes. Here we go:

1.   Plug your iPhone into your computer and open iTunes.

2.   Click on your phone under “Devices.”

3.   You will see a tab called “Apps,” circle #1. Click on that. Here is what you’ll see (minus the red circles and arrows, of course!)

4.   Uncheck the boxes to the left of the list on the left side of the apps window (circle #2) OR tap the black “X” to the left of the app’s icon on the right half of the app window (circle #3). Note: if you accidentally remove the app from the icon side of the screen, it will just uncheck it from the list side. You don’t lose it permanently. Just re-check the checkbox on the list side of the window.

Leave a comment

Filed under More...

Getting Rid of Apps on iPhone

Hi Friends,

If you have apps on your iPhone you don’t like or want anymore, it’s easy to get rid of them on your iPhone. You’ll also want to make sure they don’t jump back on your phone when you sync with iTunes.

To delete apps from your iPhone:

1.   Touch any app icon for about 3 seconds or so. Your icons will start moving and each one will have a tiny black “X” in the upper left corner of the icon – all except the default icons anyway. We’ll talk about that tomorrow.

2.   Just touch the “X” on the app you want to delete. A box pops up and asks if you want to delete this app.

3.   Hit “Delete” if you’re sure that’s what you want to do.

Now, hopefully you’re the kind of person that syncs their iPhone pretty regularly, because if you do, you’re apps will all be in your iTunes. If you change your mind and want that app back, you can sync it back to your phone. That will be covered in tomorrow’s tip.

Thanks for stopping by!

Leave a comment

Filed under More...

Facebook: correction to status or post

Hi Friends!

I don’t know about you, but while entering a comment or status, I keep hitting “Enter” by accident. Enter causes an immediate “post” as soon as you hit it. Ugh!

No worries. If you like most or all of what you’ve said so far, follow these steps; otherwise just follow steps 3 – 7, skipping 6.

1.   Click in front of the first word and drag across the rest of what you want to keep.

2.   Hold down the “Ctrl” key and hit “C” (for copy).

3.   Hover your mouse over your posted comment (DON’T click on it!).

4.   Look for the little “x” to appear out to the right, and click that.

5.   A box will pop up asking if you want to delete the post. Click “Remove Post.”

Now the bum post is gone!

5.   Click in the new box (if you’re commenting, you’ll have to hit “Comment” again).

6.   Hold down the “Ctrl” key again and hit “V” to paste the stuff you copied.

7.   Fix the rest of the post! Or, if you just deleted the whole thing, write your new post.

8.   Hit “Enter”  – on purpose! (Grin)

Thanks for stopping by!

1 Comment

Filed under Social Networking