Computer Super Secrets

PowerPoint:  Use to Touch Up Pictures You don't always need expensive picture software.  Sometimes, PowerPoint can do the job just as...

A customer of mine recently wanted to know why her pictures appeared to have a layer of line impressions. We went through her printing proc...

MS Office 2010 has been out for awhile now and I recently did the "Big Install". I opened up Word to take a look and I see these ...

The "CTRL" key is a powerful tool in Excel. Open Excel - any version: - Ctrl and click random cells . This will select a range...

The vital role of Formula Auditing. An amazing but little known tool in Excel. Trick 1) F2 Key, Shows formula in current cell (rather ...

You read that right. You can total the columns, rows, and Grand Total in just 2 clicks. View this quick video and be smarter and happier....

One of the best kept secrets in Excel is the amazing 'Fill Handle' for data entry purposes. Watch this video, the link will take yo...

Adding new columns within your Excel spreadsheet is super easy: Right Click, Insert, Columns. And then I learned a new way recently and j...

If you enter any block of data into Excel, you can produce a chart in 2 quick steps: 1. Click into one cell of the data (Excel will assum...

An Excel Data Form is a useful data entry tool if you have the tedious job of entering data. (I avoid this at all costs, but periodically I ...

In Excel, when you type an email address into a cell it automatically changes to a Hyperlink. (Tip: to Undo that automation, just hit Ctrl Z...

My definition of MetaData: Hidden threads of document changes, revisions, the author's name, and various other incriminating details tha...

Creating a Watermark in Excel 2003 & 2007 Watermarks are dim images in the background of a spreadsheet. 'Back in the day' we ...

Watermarks are dim images in the background of a document to mark them as Confidential, Draft, a company logo, etc. Here's how...

Do you work in the corporate world and have that handy list of "Global Contacts" in Outlook? If so, then you know what happens whe...

Last week, for some freak reason, an email would come into my Outlook, appear long enough for me to notice it and see the first line, then v...

Question: "When I enter a new contact in my Outlook 2003 it automatically inserts a (651) area code for the phone number. How can I ch...

If you use Outlook Exchange, it's easy to click Tools, Out-of-Office Assistant. But if you don't use Exchange, how do you get your ...

Sometimes, I just need to add a note on my email Inbox list to remind me what to do with a certain email. Here are the steps to get there.....

Note: This does not apply to "Outlook Express" With Outlook, you can Color Code emails as they arrive in your Inbox. Color coding...

If you use MS Outlook as an email, calendar, and contact manager, then you are familiar with switching screens back and forth to check your ...

If you want to jazz up your presentation with some actual and decent sounding music or effects, here are a couple of sites that provide free...

Have you ever used color-coded file folders in your office? Of course! The red ones mean "this", the yellow ones mean "that...

Many times throughout my day I am looking ahead at my calendar, shifting, adding, deleting, and scheduling appointments. In fact, besides m...

OK - Depending on your profession, your schedule may need multiple appointment slots per hour, rather than just 1 per hour. For instance a ...

I was writing a letter to the editor and the instructions said my word count had to be less than 300. Well how am I supposed to know withou...

When you are in Microsoft Word, and you are in Print Layout view (View, Page Layout or Print Layout), you will see a ruler on the left side ...

When someone emails a Word document to me, and I click to open and read it, it opens in this odd "Reading Layout". It sort of res...

Swapping paragraphs in Microsoft Office Word can be complicated. As well as having to cut and paste, you often have to reformat line breaks ...

My friend Anthony called me immediately after he had accidentally deleted 1300 pictures. And he was thorough... he also emptied his recycle...

I remember way-back-when how easy it was to print a screen. We just hit the "Prt Scr" button on the keyboard above the Home and En...

Is it possible to change a Desktop Icon's picture? Yes. I get bored with those little yellow files on my desktop. Here's how...

Here is a Computer "Underground" Super Secret: Everyone knows that when you work in an industry for any length of time you learn...

Sometimes productivity isn't possible if you're away from your main computer. For instance, I teach a class on Digital Cameras and ...

While you are reading this, right now, press and hold Control on your keyboard and scroll the mouse wheel up or down. Welcome to the Super...

Here is a Computer Secret that I use just once in awhile - but it's a Biggy: System Restore - the best thing Microsoft ever did for t...

It seems like the your computer is the all important tool, until you lose your files and you realize the computer is just the box that held ...

For External computer care , a can of air to blow out the keyboard and an alcohol pad to clean the keyboard and mouse are standard in my des...

This is an important topic; have you seen the price of computers? They're incredibly low! Buying a new computer isn't such a bad ide...

Does your home office have various cords and plugs and gadgets scattered around, laying on shelves, in the bottom of boxes, and at the back ...

There are just some things in my office that I can't live without. I highly recommend these simple and inexpensive items so your comput...

Microsoft SmartArt graphics allow you to create high-impact, professional diagrams. Instead of spending hours designing your own, use Micros...

An audience is an interesting animal and your presentation can tame them or turn them against you. Here are some tips to keep them focused ...

Would you like to have access to your slide notes during a PowerPoint presentation--without printing? Microsoft Office PowerPoint 2003 and 2...

I'm big on organizing my piles and piles of papers. With Microsoft Outlook, you will eventually accumulate piles and piles of contacts. ...

So many contacts, and now... so many folders of contacts. I literally have 28 folders of contacts that apply to many industries. So I seper...

If you follow my weekly email super secrets, but occasionally need to dig back into your archives to find a particular computer tip, it migh...

Excel 2007 charting is absolutely delightful. The color splashes are beautiful, fresh, and just COOL! I couldn't wait to get started u...

First of all, what is an Excel comment?  It's basically a post-it note attached to any cell in the spreadsheet.

My friend Bill writes: Andy, for some reason my attachments are not showing in the heading of my e-mails, but are in the body of the e-mail...

Outlook has a featured called "automatic completion" for any email address typed into the To or CC fields. This feature does not p...

Outlook allows up to 2 active signatures for each email account on your system depending on if it's a NEW email or a REPLY email. For in...

Microsoft Outlook is configured to block automatic picture downloads from the Internet. This can help protect your computer. But you can un...

Take a look at your list of Outlook contacts. Have you ever noticed the vertical lines between the columns? They have a purpose:

In technology, the term "backdoor" originally meant a "hidden code" or "secret sequence". It has come to also...

Privacy Policy for ComputerSuperSecrets.blogspot.com