Category: Tutorials

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.

How to Set Up a Dual Monitor Desktop – Windows

Add More Screen Real Estate to Get More Done

Overview: See how to boost your productivity by setting up a two monitor desktop on your Windows computer.

how to set up a dual monitor desktop

If you have a laptop, or a desktop with a dual-port video card, you can stretch your desktop across two monitors. This is an extremely easy way to boost your productivity when working with multiple documents and applications.

Frequently, you need to constantly jump back and forth between multiple windows on your computer. This becomes confusing, because one of the windows is always hidden behind the other. When you need to make comparisons or analysis, it is easy to miss small details.

Why not have two monitors and view both windows side-by-side at the same time, like you would do if you were comparing two printed documents.

This is a very quick and easy process.

What you will need:

  • One external monitor
  • One laptop or desktop computer
  • Two minutes

Optional: If you have a desktop, you can still do this. You will need to get two external monitors and make sure that you have a dual-port video card. The diagram below shows what a dual-port video card will look like on your computer.

video ports on desktop computer

Setting up the Hardware

Start by plugging the external monitor into your laptop’s monitor port.

laptop monitor connection port

Turn on your computer and log in.

Configuring Your Settings

Minimize any software that you have open until you see your desktop.

Right click on your desktop to open an options menu.

right-click-desktop-properties

Select Properties from the options menu.

The Display Properties menu will open.

desktop properties menu

There are five tabs on this menu. Click the Settings tab.

The settings tab will allow you to control how the monitor(s) on your system work.

display-properties-settings-tab.jpg

If you have the external monitors hooked up, you will see two boxes in the top portion of the menu. (Numbers 1 and 2 represent your two monitors.)

By default, they will both have the same exact information. This is so that if you ever hook up a projector, you and the audience will see the same thing.

Spilt the Two Monitors

Now, you want to make the second (external) monitor act independently of the laptop’s monitor.

Click on the “2” icon to view and edit the second monitor’s settings.

enable second monitor

The last checkbox at the bottom of the screen will allow you to split the monitors in two. Check the Extend my Windows desktop onto this monitor checkbox.

Do not close the Display Properties menu yet.

Arrangingthe Montitors to Match their Physical Locations

Depending on how you have your laptop and monitor positioned on your desk, you may need to adjust the arrangement on screen.

By default, the laptop’s monitor (1) will be to the left of the external monitor (2). If you don’t have your desk set up this way, you will need to click and drag them to match your setup.

arranging mulitple monitor alignment

Identifying your Physical Montiors

You can always see which monitor is which by clicking the Identify button at the bottom of the Display Properties menu.

A giant number 1 and 2 will appear on each monitor for identification purposes.

identify monitors

Moving Applications Between Monitors

Now that you have both of your monitors set up and working properly, you can separate windows into whichever one is most convenient.

You cannot move a window if it is maximized on one monitor. You will need to “un-maximize” the window before it can be moved.

Click the resize window button  button to un-maximize the window.

resize window

Click on the Title Bar at the top of the window and drag it from one monitor to the other.

Click and drag the bottom corner of the window to resize it, or just click the maximize button to re-maximize the window.

Final Step:

Sit back and bask in the glory of your super-terrific multi-monitor wonderland.

See How it’s Done in this Video Tutorial

The following video tutorial shows you how to set up a two monitor desktop on a windows computer.

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.

Share Files Between All of your Computers

Sharing Files Between Any Devices in your Home

OVERVIEW: You will learn how to share folders and file on your Windows, Macintosh, and Linux computers on your home netork.
share files between windows linux and mac

This is the first article in a three part series on Sharing Files Between Any Devices in your Home.

You Can Get there from Here

Your home has any number of “connected” devices (Computers, Video Game Consoles, Phones, Portable Media Players, Televisionss, DVRs, etc.). Are they all really connected? Here are some simple (and not so simple) steps to get all of your devices singing in harmony.

Sharing Files on your Computers

If you’re like me, the bulk of your media and files sit on one or more computers. You may even have more than one Operating System to further complicate the business of sharing information. Here is how you can share your files between computers runing Windows, Mac, and Linux.

NOTE: This article only addresses sharing files between devices INSIDE of your home network. While connecting to devices on your home network from the outside world (internet) is possible, it will not be covered here.

Sharing the Files on your Computers

IMPORTANT: The following set of instructions shows how to share ALL of the files on your computer. This is not the most secure approach to sharing. You should determine which folders you want to share (for example My Documents or My Music) and perform the following steps at that level.

Sharing Files on a Windows Computer

Windows allows you to share an entire hard drive or select specific folder to share. You can choose the drive or folder to share from Windows Explorer.

Open Windows Explorer (Windows Key + E)

You will see all of your computer’s drives (C, D, etc.)

windows explorer share files

Browse to the entire drive or specific folder that you would like to share.

Right click on the folder that you want to share and select Properties from the options menu.

windows explorer right click menu

The Properties menu will open.

Go to the Sharing tab

windows sharing menu properties

Check the Share button.

Optional: You can also apply finer controls to the sharing priviledges from the Advanced Sharing menu.

Click the OK button to close the Properties menu.

Now, users on your network will be able to access the files on this compter.

Sharing Files on a Mac Computer

You can also share folders with other computers on your Mac computer. You need to go to the System Preferences menu to configure sharing (Applications> System Preferences).

Mac system preferences panel

The preferences are grouped by topic on this menu. Click the Sharing icon under the Internet & Wireless heading.

This will open the Sharing panel.

Mac sharing panel share hard drive

You can share several of your Mac’s resources from here.

Check the resources that you want to share and close this menu.

Now, other computers on your network will be able to this compter.

Sharing Files on a Linux Computer

One of the best and easiest ways to share folders between Linux computers and machines running Windows is using Samba. Samba is a suite of applications for Linux that provides connectivity between Linux and Windows machines. This will allow a Windows machine to interact with it just like another PC.

NOTE: This example uses Ubuntu Linux. If you use a different distro, just Google for the specific instructions.

Start out by installing Samba on your Linux machine. Go to the terminal and type the following command:

sudo apt-get install samba smbfs

Samba is installed now, but you need to configure it so that it is accessible. Run the following command to open Samba’s configuration file (smb.conf):

sudo gedit /etc/samba/smb.conf

Scroll down to this section in the file:


samba configuration file

Uncomment the security line (delete the number sign), and add the following line below it, so that it look like this:

security = user

username map = /etc/samba/smbusers

Now, Samba will use the smbusers file to look up the user list.

You need to creat a user that can access the Samba server.

There are two steps to creating a user.

Run the smbpasswd utility to create a samba password for the user. Type the following command (substitute a real user name for “username”):

sudo smbpasswd -a <username>

Next, open up the smbusers file and add that username. Type the followng command:

sudo gedit /etc/samba/smbusers

When the smb users file opens, add the following line, (substitute a real user name for “username”).

<username> = “<username>

The format is <ubuntuusername> = “<samba username>”.

Telling Samba to Share a Linux Directory

Now you can create Samba shares and give access to the user(s) that you create here.

Reopen Samba’s configuration file (smb.conf) by typing the following command:

sudo gedit /etc/samba/smb.conf

Scroll down to the Share Definitions section of the file, and make it match the following:

#======================= Share Definitions =======

# Un-comment the following (and tweak the other settings below to suit)

# to enable the default home directory shares. This will share each

# user’s home directory as \server\username

[homes]

comment = Home Directories

browseable = yes

# By default, \server\username shares can be connected to by anyone

# with access to the samba server. Un-comment the following parameter

# to make sure that only “username” can connect to \server\username

valid users = %S

# By default, the home directories are exported read-only. Change next

# parameter to ‘yes’ if you want to be able to write to them.

writable = yes

Now Windows machines/users will be able to map a drive on windows using the following share format:

\ubuntumachinename\username

For example, if the Ubuntu machine is named linuxshare, and the username is chris, your share path would be \linuxshare\chris

samba shares from windows

Connnecting to a Shared Computer

Now that you have the files on all of your machines shared, you need to connect to them from another machine. You can even “map” these shared drives permanently so that they are always available, just like your computer’s Hard Drive or CD/DVD Drive.

Connecting to a Shared Computer from a Windows Computer

You can locate shared computers on your network from the My Network Places section of Windows Explorer.

Open Windows Explorer (Windows Key + E)

Click the “+” icon to the left of My Network Places in the folders panel. (View> Explorer Bar> Folders)

Click the “+” icon to the left of Entire Network

Click the “+” icon to the left of Microsoft Windows Network

Look for the name of the shared computer/drive Drill down on that compter as if it were a folder on your computer.

Find shared drives in windows

Permanently Mapping to a Shared Drive in Windows

If you want to Window Explorer to remember this shared folder and give it a drive letter (like your C or D drives) you need to “Map” it.

Select Tools> Map Network Drive

Select a letter for this share from the Drive dropdown list

Click the Browse button to the right of the Folder dropdown list

Use the steps above to locate the shared drive/folder that you want to map

Check the Reconnect at Logon box (this will remember the letter/drive mapping)

Click the Finish button

Now, the next time you start the computer the shared folder will appear just like your local hard drive or CD drive with the letter you assigned.

Connecting to a Shared Computer from a Mac Computer

You can locate shared folders on other computers on your network using the Finder application on your Mac. (Applications> Finder)

Click on your Mac, so that you can see the local drives and the Network icon.

mac connecting to a shared drive

You will see any computers that have shared drives/folders on your network.

Click on the shared machine to access its files.

Permanently Mapping to a Shared Drive in Mac

If you want Finder to remember this shared folder just like the ones on your local machine you need to “Add it to the Sidebar”.

Browse to the shared folder and click File> Add To Sidebar.

mac permanently mapping a shared folder

Now it will show up under the Places heading on Finder’s sidebar.

Connecting to a Shared Computer from a Linux Computer

You can locate shared folders on other computers on your network using one of the many file manager applications available in Linux.

NOTE: This example uses Dolphin to navigate Linux’s file system.

Open Dolphin and click the Network icon in the Places panel.

You will see a list of ways to access your Network and the shared folders located on its machines.

linux locate shared folders

Click Network to locate Linux and Mac machines. Click Samba Shares to locate Windows machines.

Permanently Mapping to a Shared Drive in Linux

If you want Linux to remember this shared folder just like the ones on your local machine you need to “Add it to the Sidebar”.

Browse to the shared folder and click File> Add To Sidebar.

Linux map a shared drive

Video Tutorial – See it in Action

See how to perform each of the steps listed above in this video tutorial

Wanna make sure that you don’t miss anything?

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