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!

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.

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!

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!

Excel Formula Check

Hi friends!

When your spreadsheet has formulas, it’s easy for unexpected problems to occur within your formulas, particularly if you copy and paste or autofill your formulas. This tip is one way to get a clear visual of what’s happening with any given formula.

Double-click on the cell you want to check. The formula will appear in the formula bar, but looking at it in its resident cell, you can see each cell reference is a different color. A1 is blue, A2 is green, and C3 is purple.

In my graphic, you can see that cell C3 has nothing in it. I really wanted that to be A3 instead. A quick, easy fix for that is to click and drag the purple box up to C3. Hit enter.

Thanks for stopping by!

PowerPoint – Creating Your Own Pictures

Hi Friends!

A picture says a thousand words, so they say. But you can help that conversation in PowerPoint. I frequently use screenshots (see my article on that at http://cybersavvyservices.com/2011/03/25/screenshots-snipets-and-snapshots/), and I like to mark them up with circles and arrows. Of course you can layer and group graphics together, but did you know you can save them as one picture? Then you can insert that picture in any document, share it on the Web, Facebook, or wherever you’d like.

Here’s how I do it. Once I’ve grouped my graphics (select all the elements, and there are a few ways to do that), I right-click on the graphic I want to save, and select “Save as picture.”

It will save it as a .PNG file, but it works in most picture applications such as those I mentioned in my introductory paragraph.

Play around with that. It’s pretty handy!

Thanks for stopping by!

Excel: Converting Formulas to Static Values

Hi Friends!

You have a spreadsheet that’s full of formulas, and you need to share the results with others. You might not want to throw confusion in by leaving your formulas in the cells. You might also not want them to be able to change the formulas, accidentally (or on purpose). Yes, that can be managed with security settings, but this is another way.

Converting formulas to values is simple. Right click on the cell, select copy. Right click again, hit “Paste Special,” then select “Values.” OR, if you have Excel 2007 or 2010, make sure you’re on the home tab (circled below). Select your target cells or just hold “Ctrl” and hit A to select the entire worksheet.

1.   Click on “Copy”

2.   Click the down-arrow under “Paste”

3.   Click “Paste Values.”

Yes, it’s that easy!

Thanks for stopping by!

Word: Create Your Own Default Style

Hi Friends!

Don’t like the default “Style” in Microsoft Word 2007 or 2010? This tip will help you with that.

Word 2007 and 2010 have Styles that you can choose from on the Ribbon. You can see the rest of Microsoft’s styles by clicking the dash/down-arrow (red circle below):

If you don’t like any of those styles, right-click on the one that is closest to what you want. A box will pop up from which you need to select “Modify.”

When you click “Modify,” another box will pop up called the “Modify Style.” I’ve boxed around the various changes you can make.

The changes in box 2 are standard format changes – font changes, alignment, line spacing, indents. The arrow with the 3 next to it points to an alternative option to a one-time use of the new style. More format options are available by clicking on “Format” (arrow 4). Another box will pop up giving you the areas you can modify:

To make this the new default, follow these steps:

1.   Make sure the newly created Style is highlighted.

2.   Click “Change Styles” (not the down arrow)

3.   Select “Set as default”

You’re done!

Thanks for stopping by!

PowerPoint – From Your Computer to Another

Hi Friends!

Have you spent hours on your PowerPoint presentation, e-mailed it, then discovered that your fonts went crazy, changed to something that messed up your entire presentation? You could spend HOURS fixing that back or at least to something that “will just have to do.” There’s a quick and easy prevention tool.

First, make sure you have saved your presentation the usual way (as a .ppt file).

1.   In the 2007 version, click on the Office icon (square “1” in the illustration below). In the 2010 version, click on the File tab.

2.   Next, hover over “Save As” (square “2”). A menu of options for versions of your file will slide out to the right.

3.   Click on “PowerPoint Show” (square 3).

If you want to make extra sure you will preserve your fonts, follow these steps:

1.   In the 2007 version, click on the Office icon (top left corner). In the 2010 version, click on the File tab.

2.   Click on “PowerPoint Options.”

3.   A new box will open up called – imagine this! – “PowerPoint Options”. Click on “Save” in the left side of the box (square “1” in the illustration below).

4. Click “Embed fonts in the file (box “2” below),” then choose one of the two options below. If you choose the second option, “Embed all characters,” your file size will be bigger. However, if you choose the first option, no one – yourself included – will be able to make any changes to the presentation on another computer.

5.   Click “Ok” (box #3).

That’s it! Thanks for stopping by!

Posting a Resumé on LinkedIn

Hi Friends!

I give workshops on LinkedIn and one of the most common questions is, “How do I upload my resumé?” There are two answers for that question. The first will only work IF your profile is not already 100% complete.  Click on “Profile,” then “Edit Profile.” You will see a link on the right side of your screen that says, “Import your resumé to complete your profile quickly.” Note: this  “Import your resumé” on your profile page is actually a link. When you click it, you will be directed to browse to your resumé. LinkedIn pulls in key information from your resumé and places it in your profile. You will want to look over the information in your profile (“View Profile tab), and make sure you’re satisfied with the result. It’s not a perfect application.

Is your profile already at 100%, or would you like to post the actual resumé? You will need to add the application called “Box.net” under the “More” tab. I started to write all the steps to complete this process, but it would be too long. If you want help with this, please use my request for services form on the “Our Services” tab. I will direct you to pre-pay via my Paypal link, it will be $20.

Thank you for stopping by!