Category: Podcast

Articles that contain video, audio, or files that are part of the VitaminCM.com podcast.

Make Windows Run Better than New with TuneUp Utilities

Keeping your Computer Running Like a Top

Overview: Learn how to clean, optimize, and repair Windows to better-than-new using TuneUp Utilities software.

How to Battle Windows Bit-Rot

TuneUp Utilities 2011 is an very thorough suite of Windows Cleaning, Repair, and Optimization tools that can get just about every aspect of your Windows PC running even better than the day you took it home. First the bad news: the application costs $49.95 retail. I like to recommend as much free software as possible on this site, but this one might be worth using a crowbar on that old wallet. I have set this up on my parents’, aunts’, cousins’ and neighbors’ computers and they have all be extremely happy.

Become an Excel Guru with ASAP Utilities

Use this Super Add-In to Man-handle Excel

OVERVIEW: Learn how to use the ASAP Utilities add-in to dramatically boost the power and ease of using Excel.

ASAP Utilities Tutorial

What is ASAP Utilites?

I work in an Accounting/Finance area dealing with lots of reporting, so I have Microsoft Excel open all day long. One of the best things that I ever installed on my work machine is ASAP Utilities. This powerful Excel add-in allows you to do complex, advanced tasks quickly and efficiently. It also allows you to do some very handy things that Excel doesn’t even do out of the box.


How Much Does it Cost?

There are two versions: the FREE one which is really for personal use and the $50 version which is for professional use (at work). Aside from the personal/professional rules, they are almost identical.

How Does ASAP Work?

ASAP Utilities installs itself as an Add-In which creates an ASAP Utilities tab on Excel’s ribbon.

asap-ribbon

All of the operations that ASAP performs are grouped into categories represented by dropdown lists on its ribbon tab.

Some of the features that I used most are under the Sheets, Range, Numbers, Text, and Import categories.

Greatest Hits

Among the numerous features that I use, my favorites are:

Advanced Character Find and Replace – great for removing carriage returns in text.

Copy (formula generated) Data as Values – paste the actual numbers anywhere.

Find and Clear Duplicate Values – great for getting one of each value in a big table.

Color Every Nth Column/Row – get striped rows without making a table.

Delete Leading or Trailing Characters – Strip area codes or middle initials off a list in seconds.

There is even a Favorites option where you can save your most frequently used commands.

These are very useful, but two that I use A LOT are under the Import and Sheets categories. I regularly have to produce a report that pulls data out of 10 – 20 separate Excel files. The data is the same, just for different business groups. I need to get all of this data into one file, then onto one worksheet.

Here’s how I do it:

Us the Merge and/or Import Multiple Files command under the Import category to grab the data from all of my files and pull it into a new workbook. Each file creates a tab named after the original file name.

Opening 15 files, copying their data, and pasting it into a new workbook would take a LOOONG time and be very prone to screw-ups.

Now that I have all of the data in separate tabs in the same workbook, I need to get all of the data onto the same worksheet. I select all of the worksheets (tabs) and run the Put together rows/columns from separate sheets command under the Sheets category. This places a copy of all of the data on my 15 tabs into a brand new tab. Voila! Now I can sort, subtotal, and analyze everything at once. This takes me about three minutes depending on the number and size of the files. Try doing that as a copy and paste job in less than 20!

See it in Action

The following video shows how to combine data from 15 separate Excel files into one worksheet in a new file.

Some Other Weird but Cool Options

There are more commands/features than I care to count. Most people will probably stick to a few core features, but here are a few obscure ones that I like:

Bulk Create Folders – type a bunch of folder names in cells and it will create them on your hard drive.

Text Case – Convert hundreds of rows of text to UPPERCASE, lowercase, or Title Case.

List All Fonts in a New Workbook – List every font on your machine and display every character in that font. Pretty handy for typesetting.

Find and Remove All Links – Strips html links from data that you pasted from the internet.

What are you Waiting For, Go Get It

Head on over to http://asap-utilities to get yourself a FREE copy of ASAP Utilities. You will be the new Excel Guru in your office.

Did you Like this Article?

Why not get free updates from VitaminCM.com?

RSS IconSubscribe via RSS Reader

VitaminCM.com Email Feed

Enter your Email Address to Subscribe via Email

VitaminCM on YouTube Subscribe via YouTube

Or just VitaminCM on Twitter Follow me on Twitter, where I am constantly sharing great articles written by people WAY smarter than me. Or, see some of the other places where you can connect with me out there in the wilds of the internets.

52 Time Saving Windows Tips

If you want to work faster and more efficiently on your PC you really need to leverage the shortcut keys that

If you want to make Windows a super-efficient productivity machine, you really need to make use of it’s built in shortcuts. Learning just a few simple keystrokes can help you get everything done quicker and easier than you may imagine. Here is a list compilation of over 50 shortcuts, tips, commands, and more that will dramatically improve your computing experience.

The Control Key

The Control key is your most powerful ally. Ctrl + some keys will allow you to quickly perform the most important, useful operations on your computer.

CTRL + A = Select All

CTRL + B = Bold selected content

CTRL + C = Copy selected content

CTRL + V = Paste copied content

CTRL + X = Cut selected content

CTRL + P = Print

CTRL + N = Create a New File

CTRL + S = Save

CTRL + Z = Edit> Undo

CTRL + I = Italicize selected content

CTRL + E = Center selected content (only some apps)

CTRL + Q = Quit active program

CTRL + U = Underline selected content

CTRL + O = Open a file in the active application

CTRL + R = Refresh browser

CTRL + G = Group selected items into one

CTRL + T = Open a new Browser tab

CTRL + HOME = Top of a document or page

CTRL + END = Bottom of a document or page

CTRL + SHIFT + ESCAPE = Open Task Manager

CTRL + SHIFT + S = Save As


The Windows Key

windows keyboard key

The Windows or Start key does some very useful tricks.

+ E = Opens Windows Exporer

+ D = Minimize or Restore all open application windows

+ L = Locks your computer (Same as Ctrl + Alt + Del, then Lock button)

+ R = Open Run command

+ F = Search Files on computer

+ U = Open Utility Manager

+ F1 = Help Menu

The Alt Key

The Alt key is infrequently used, but it has a few gems up its sleeve.

ALT + TAB = Toggle between running applications

ALT + “any letter” = Show quick tasks in menus and toolbars (ALT + F opens the File Menu)

The Function Keys

F1 = Help Menu

F2 = Rename File / Folder

F4 = Repeat last formatting option in Office

F5 = Refresh Browser

F11 = Hide/Restore Browser toolbars

F12 = Print

Windows Explorer Tips

Make shortcuts to your frequently used folders and files

Place shortcuts to your frequently used folders in the Favorites folder (C> Windows>Favorites)

Quickly jump to your favorite

Drag files from Explorer to a document, email, etc.

Drag file attachments from an email or browser to a folder in Explorer

Keep two Explorer Windows open and drag and drop files between folders

Microsoft Office

F4 = Apply the last formatting command

CTRL + Z = Undo last action

CTRL + Y = Redo the action that was Undone

Right click on text to show formatting options. (Office 2007 & 2010)

Internet and Browser Shortcuts

These shortcuts will work in any browser on Windows.

Backspace = Go to the previous page

ALT + = Go to the previous page

ALT + = Go Forward a page

F5 Key = Refresh Browser

CTRL + R = Refresh Browser

CTRL + T = Open a new Browser tab

CTRL + Click a link = Open link in a new tab

SHIFT + Click a link = Open link in new Browser window

F11 = Hide/Restore Browser toolbars/menus

Right Click to copy or save an image

Scroll Wheel Click on a link to open it in another tab

Scroll Wheel Click on a tab to close the tab

Drag a tab out of the window to open that tab in its own window

Drag a tab from one browser to another to open the page in a different Browser

Right Click Options

Right Click

If you are in ANY application and are looking for a quick way to get something done, try the Right Click trick. Right clicking usually opens up a menu with several convenient options in most software. This is a lifesaver lots of times.

When in doubt, Right Click!

More Resources

Here are a few great places to find even more handy tips.

How to navigate Windows using a keyboard

Save time with quick computer shortcuts

Mac Keyboard Shortcuts

If you’re using a Mac, there is a similar collection of incredibly useful shortcuts to help you out. Try some of these.

Mac OS X keyboard shortcuts

More Mac Keyboard shortcuts

Reference for EVERY Character Key on a Mac

Did you Like this Article?

Why not get free updates from VitaminCM.com?

RSS IconSubscribe via RSS Reader

VitaminCM.com Email Feed

Enter your Email Address to Subscribe via Email

VitaminCM on YouTube Subscribe via YouTube

Or just VitaminCM on Twitter Follow me on Twitter, where I am constantly sharing great articles written by people WAY smarter than me. Or, see some of the other places where you can connect with me out there in the wilds of the internets.

Back To Top