Tumblelog by Soup.io
Newer posts are loading.
You are at the newest post.
Click here to check if anything new just came in.

October 30 2013

Play fullscreen
Reusing an Old PC as a Server Part 2 (update) - YouTube
http://vitamincm.com/reusing-anreusing-an-old-pc-as-a-server Goal: Provide instructions to turn an old computer into a server that you can control remotely a...
Play fullscreen
Reusing an Old PC as a Server Part 2 (update) - YouTube
http://vitamincm.com/reusing-anreusing-an-old-pc-as-a-server Goal: Provide instructions to turn an old computer into a server that you can control remotely a...
Play fullscreen
Controlling Multiple Computers Using Synergy - YouTube
http://www.vitamincm.com/control-multiple-computers-using-synergy Control multiple computers with one Keyboard and Mouse using Synergy. This tutorial shows y...
Play fullscreen
Controlling Multiple Computers Using Synergy - YouTube
http://www.vitamincm.com/control-multiple-computers-using-synergy Control multiple computers with one Keyboard and Mouse using Synergy. This tutorial shows y...

October 23 2013

How to Record your iPhone or iPad’s Screen using AirPlay Mirroring

Display your iPhone or iPad Screen on your Computer using AirPlay Mirroring

Reflector App Tutorial

Reflector App Tutorial

Did you ever have something really cool on your iPhone or iPad that you wanted to see on your computer screen?


Maybe you want to:

  • Play a game
  • Watch a video or photo show
  • Demo cool new apps for people
  • Share a presentation

Well, you can and it’s really easy. I’m going to show how to display everything happening on your iPhone or iPad on your computer in real-time.

If you have an Apple TV, you may have used Airplay to share pictures, movies, or music with your TV. Well, an app called Reflector allows you to do the same thing with your Mac or Windows computer.

Installing Reflector Application on your Computer

Start by going to their website and buying the software ($12.99) from AIRSQUIRRELS.com

Reflector Website to purchase and download Reflector App

Reflector Website to purchase and download Reflector App.

Once you have the software installed and running, you’re ready to go.

Enabling AirPlay Mirroring on your iOS Device

You don’t need to install anything on your iOS device, Airplay mirroring is built right into the operating system.

Connect your iOS device to your wifi network.

Swipe your iOS 7 device up from the bottom of the screen.

Air Play link in iOS 7 Control Center

Air Play link in iOS 7 Control Center

Tap the AirPlay icon toward the bottom of the screen.

You will see a list of available AirPlay devices.

Select AirPlay Mirroring Device in iOS 7

Select AirPlay Mirroring Device in iOS 7

Select the name that you gave your computer in Reflector (Mine is NEW-MBP)

Select AirPlay Mirroring Device in iOS 7

Select AirPlay Mirroring Device in iOS 7

Then, slide the Mirroring switch to the right.

AirPlay Mirroring Enabled from iOS 7 Control Center

AirPlay Mirroring Enabled from iOS 7 Control Center

Tap the Done link.

Now, your device’s screen will appear on your computer.

When it opens up you can see whatever is on your devices screen displayed in real-time on your computer monitor.

If I open an app like Twitter, you can see it in real-time.

If I show a photo or video you can see it on the screen.

If I open up a Slide presentation I can deliver it on screen.

For things like Video or Slides, you will want to switch to Full Screen Mode

Select Device, then Full Screen from the menu.

You can also control how the device frame looks.

Select Device, then Frame Skin from the menu.

See the Reflector App Video Tutorial

The video tutorial below shows how to do all of the steps listed above.

So, that’s Reflector and some of the cool things you can do with it.

October 02 2013

How to Shut Down Background Apps in iOS 7

Save your Battery Life, Data Usage, and Processing Power by Killing Background Apps

Goal:Learn how to shut down applications running in the background in iOS 7.

Shut Down Background Apps iOS 7

Shut Down Background Apps iOS 7

First, the Bad News

When you launch an app on your iPhone, it runs even after you click the Home button to close it. Actually, you really just minimized the app – you didn’t close it. After using several apps (or dozens), you will have a big pile of crap running in the background.

“So what?” you say. Here’s what; many of those apps do a few not-so-great things unbeknownst to you.

  1. They download data
  2. They run background process which use CPU and Memory
  3. They wear your battery down

All of these things make your awesome little friend a lot less awesome.


Here’s What You Can Do About It

You can shut down any apps that are running in the background using the Multitasking menu. Double tap the Home button.

This will open the Multitasking menu. You will see a thumbnail preview of the app you were most recently in, as well the rest of your running applications. Swipe to the left to see the rest of your open apps.

iOS 7 Multitask Screen

iOS 7 Multitask Screen

Closing Running Apps

You can activate the App Killing Mode by holding your finder on one of the app thumbnails for a few seconds.

Swipe an app up and off the screen to fully shut it down. Scroll left and right and repeat the upward swipe to close any or all running apps.

Swipe up to Close an App

Swipe up to Close an App

How to Reboot your iOS Device

Once you kill all of the apps that you want closed, you can/should reboot your device.

Hold down the Home button and the Screen Lock button.

How to Reboot iOS 7

How to Reboot iOS 7

The screen will go black in about 5 seconds, then the Apple icon will appear in another 4 seconds.

iPhone reboot screen

iPhone Reboot Screen

Now you can release the Home and Screen Lock buttons. In a few more seconds you will see your Home screen.

That’s it, all of your background apps are closed and your device should run a little better.

Watch the Video Tutorial to See How it’s Done

The post How to Shut Down Background Apps in iOS 7 appeared first on VitaminCM.com.

July 11 2013

How to Add Reminders in Evernote – Video Tutorial

Goal: Learn how to add reminder notifications in Evernote to manage your to do list tasks.

How to Add Reminders in Evernote

How to Add Reminders in Evernote

Manage your To Do List from Evernote

It’s been a loooong time coming, but Evernote finally added to-do list management capabilities to my favorite software/service.

You can add Notifications to notes and manage them like a typical to-do list. The process is pretty simple:

Create a new note

Click the Notification (alarm clock) icon

Assign a Date and Time for the Notification to go off

That’s it!

When the Notification goes off on your desktop or mobile device, you just open it and view the entire note. Then, you can postpone, complete, and/or delete it. Simple and practical.

View the video tutorial below to see how to create and manage Notifications in Evernote.

How to Add Reminders in Evernote – Video Tutorial

When you get a notification on your mobile device, you can just touch or swipe it to open the entire note.

iPhone Evernote Notification

iPhone Evernote Notification

When the note opens, you can manage the notification.

iPhone Evernote Note - Notification

iPhone Evernote Note – Notification

January 06 2013

Excel Pivot Table Tutorial

Slice and Dice your Excel Data like a Magician

Excel Pivot Table Tutorial

Excel Pivot Table Tutorial


Excel spreadsheets are handy tools for tracking and analyzing data. However, they do have some limitations. If you build a spreadsheet in a certain layout, it will often take a fair amount of time and work to provide alternate views of the data.

That’s where Pivot Tables come to the rescue. Pivot Tables allow you to take a large block of Excel data and slice & dice it in numerous useful ways. The best thing is that you don’t ever have to risk damaging your source data to produce these alternate views.

The spreadsheet below tracks product sales by day for a Fruit stand. We’ll see how a Pivot table can give us lots of different insights into this data.

Excel pivot table tutorial 01

Creating the Pivot Table from Existing Data

Go to the Insert tab and click the Pivot Table button.

Excel pivot table tutorial 02

The Create Pivot Table window will open.

Excel pivot table tutorial 03

You can pull  in data from an external source if you want, but typically you will just use the data in the sheet you are on.

You can also put the pivot table in the existing sheet or in a new one. It’s a little bit cleaner to put the pivot table in its own tab.

Click the OK button.

Your Pivot Table will open in a new tab. There will be no data displayed, but all of the fields in your original tab will be displayed in the Pivot Table Field List on the right side of the screen. You can arrange these fields in numerous useful combinations.

Excel pivot table tutorial 04

Drag the fields into their buckets at the bottom of the Pivot Table Field List.

Your Pivot Table’s data will be displayed based on your settings. The image below shows where the fields appear on the actual table.

Excel pivot table tutorial 05

The values in your table may need to have a particular number formatting. This data is money, so I’m going to set the format to Currency.

Click the Sum of Sales field in the Values box.

A menu will appear.

Excel pivot table tutorial 06

Select Value Field Settings from the menu.

The Value Field Settings menu will open.

Excel pivot table tutorial 07

You can change the Values to other formulas (count, average, etc.) if you need to.

Click the Number Format button.

The Format Cells menu will open.

Excel pivot table tutorial 08

Select Currency from the Category  list and click the OK button.

You will see the pivot table

Excel pivot table tutorial 09

Filtering and Sorting Your Data

The data in all of the fields in your new Pivot Table can be filtered and sorted to display or hide any data. Use the dropdown buttons on any field to pull up the Filter options.

Excel pivot table tutorial 10

You can sort the values of a field A to Z or Z to A or use more advanced options. Let’s see the Filtering options.

You will see all of the values for the selected field. You can check and uncheck any combination of values to show or hide those values. The field below contains all of the products in listed. I only want to see results for Apples and Oranges.

Excel pivot table tutorial 11

Check the values that you want to see and click the OK button.

Now you will only see those values (Apples and Oranges) displayed. You will also see the Filter icon displayed on the dropdown button.

Excel pivot table tutorial 12

Rearranging (Pivoting) Your data

You can completely rearrange the layout of the data on report by dragging the fields around the areas of the Pivot Table Fields List in the lower right corner of the screen. I currently have the report displaying Products down the rows and Days across the columns. I want the switch it so that the Days go down the rows and the Products go across the columns.

Excel pivot table tutorial 13

Drag the Day field into the Row Labels box and drag the Products field into the Column Labels field and click the Updated button.

Now you can see the report updated to the new layout.

Excel pivot table tutorial 14

Nesting Fields of Data

You can “nest” one field inside of another field in a pivot table. If you drag more than one field into one of the report areas the lower field will be grouped inside of the higher one.

Let’s see what it looks like if we move the Origin field above the Products field in the Column Labels area.

Excel pivot table tutorial 15

Drag Origin over and above Products and click the OK button.

You will see the values in the Origin field (Imported and Local) with the Imported or Local products grouped below.

Excel pivot table tutorial 16

You can drag the Products field ABOVE the Origin field to reverse the grouping.

Now you will see any Imported and Local data grouped inside of each Product.

Excel pivot table tutorial 17

This technique works the same way on the Row Labels.

Pulling in New Data

If you go back to the original worksheet where your source data is contained, you can make changes to the underlying data. You can have these changes reflected on your Pivot Table very easily.

Go back to the Pivot Table and right click in one of the cells.

An option menu will open.

Excel pivot table tutorial 18

Select Refresh.

The data in your pivot table will update to reflect any changes made in the underlying source data.

See the Video Tutorial for Using Excel Pivot Tables

The following video shows how to create and manipulate a Pivot Table in Microsoft Excel.

 

Fixing the Blown Capacitor in Samsung TV Yourself
Fixing the Blown Capacitor in Samsung TV Yourself
Title
Fixing the Blown Capacitor in Samsung TV Yourself
Runtime
2:33
Keywords
Category
Howto & Style
View count
2,954
How to Move the Home Directory on a Mac to a Different Location
Title
How to Move the Home Directory on a Mac to a Different Location
Runtime
3:34
Keywords
Category
Howto & Style
View count
1,714
Cloning the Hard Drive on a Mac to an External SSD Drive
Title
Cloning the Hard Drive on a Mac to an External SSD Drive
Runtime
4:05
Keywords
Category
Howto & Style
View count
12,528
iPhone Quick Tip - Shutting Down Background Apps
Title
iPhone Quick Tip - Shutting Down Background Apps
Runtime
1:47
Keywords
Category
Science & Technology
View count
12,550
The Fastest Way to Remove the Trial Crapware from a New PC
Title
The Fastest Way to Remove the Trial Crapware from a New PC
Runtime
4:48
Keywords
Category
People & Blogs
View count
2,163
How to Link Cells in Different Excel Spreadsheets
Title
How to Link Cells in Different Excel Spreadsheets
Runtime
5:05
Keywords
Category
Howto & Style
View count
34,978
How to Create an Interactive YouTube Video - Linking Videos Together
Title
How to Create an Interactive YouTube Video - Linking Videos Together
Runtime
4:09
Keywords
Category
Science & Technology
View count
7,254
How to Create an Interactive YouTube Video - Overview
Title
How to Create an Interactive YouTube Video - Overview
Runtime
2:17
Keywords
Category
Science & Technology
View count
9,458
How to Create a Dropdown List in Excel
Title
How to Create a Dropdown List in Excel
Runtime
2:53
Keywords
Category
Howto & Style
View count
6,046
Controlling Multiple Computers Using Synergy
Title
Controlling Multiple Computers Using Synergy
Runtime
8:39
Keywords
Category
Science & Technology
View count
15,932
Create RSS Feed for Static Web Sites
Title
Create RSS Feed for Static Web Sites
Runtime
5:53
Keywords
Category
Science & Technology
View count
12,550
Fix the Annoying Cell Phone Buzz in your Computer Speakers
Title
Fix the Annoying Cell Phone Buzz in your Computer Speakers
Runtime
1:36
Keywords
Category
Science & Technology
View count
30,204

Did you Like this Article?

Sign up for free updates from VitaminCM.com?

Subscribe to VitaminCM.com via RSS Reader

VitaminCM.com Email Feed

Email Address

VitaminCM on YouTube

VitaminCM on Twitter

See some of the other places where you can connect with me out there in the wilds of the internets.

October 16 2012

Fixing Windows 8 – How to Add a Start Button

Getting Rid of Metro and Adding a Start Button

Add start button windows 8

When you get a new computer or upgrade your old one to Windows 8, you are in for a jolt to the interface that you’ve come accustomed to. For starters, you don’t boot up to a Desktop. You start on the Metro screen.

Windows 8 metro screen


The Metro screen uses Tiles that display information and launch applications. If you’re on a phone or tablet with a touch screen, this is a pretty handy way of navigating. However, many people do not like it as a way of navigating a desktop computer with a keyboard and mouse.

You can access the “Desktop” of Windows 8 by clicking the Desktop tile.

Windows 8 Does Not Have a Start Button

Once you reach the Desktop you will also be surprised to know that there is one very familiar thing missing. The Start button!

Windows 8 no start button

You’re not setting things, it’s just GONE. This is nuts. It drives me (and millions of others) crazy. I know that they wanted to break the mold, but some things have been around forever because they work.

How to Add a Start Button Back to Windows 8

Fortunately, there’s a quick, easy, free way to add that old familiar Start button back to Windows 8. Download ClassicShell from their website and install it on your computer.

Once you have ClassicShell installed, you can configure it to your liking.

Classicshell start button

Click the Start button to begin.

The Settings menu will open.

Classicshell start menu tab

Start by selecting the style of your Start menu.

Then, click the Basic Settings tab.

Classicshell skip metro screen

There are many settings that you can make on this tab. Scroll to the bottom to Enable the Start Button. You can also check the Skip Metro screen box if you want to bypass it altogether. (My choice)

Then, click the Skin tab.

Classic shell skin tab

Configure the look and feel of the new Start menu.

Click the OK button.

That’s it, you have a fully functional Start button/menu just like previous versions of Windows.

Classicshell start menu

See the Video Tutorial to See it in Action

The video tutorial below shows how to install, configure, and use ClassicShell to add a Start button back to Windows 8 and skip the Metro screen on Startup.

What do you think?

How do you feel about Windows 8 Metro screen and No Start Menu?

Did you Like this Article?

Sign up for free updates from VitaminCM.com?

Subscribe to VitaminCM.com via RSS Reader

VitaminCM.com Email Feed

Email Address

VitaminCM on YouTube

VitaminCM on Twitter

See some of the other places where you can connect with me out there in the wilds of the internets.

August 07 2012

Setting up a VPN – Guest Post

 vpn set up a vpn networking cloud computing

How to Set Up a VPN

Setting up a VPN might be the only solution for travelers in Asia who want to safely and

securely access websites. Many websites are blocked by regional Internet service providers or by

the host(s) of the sites themselves. Location based IP blocking places geographic restrictions on

the internet for both residents and travelers alike. An Asian VPN solution essentially solves these

problems by creating a digital tunnel through which data will filter and flow in both directions.

Understanding how the system works is crucial to determining whether a Chinese VPN is right

for you.


It’s all about security: How it all works

A China VPN solution establishes a secure connection with a server in a remote country.

Instead of routing all traffic through the normal path a local ISP provides, the traffic is

routed to and from the remote server. Since the virtual tunnel that routes the data from the

computer to the remote terminus is encrypted, it provides a strong additional layer of security.

Additional security is also gained because data no longer flows through potentially compromised

equipment.

Data is encrypted and flows through a network that will report its location as the terminus so

location-aware websites (such as banking and corporate-secured networks) will not automatically

reject and/or disable a login. Sites view the user of an Asian VPN as a local user and grant

access.

Added bonus: No more censors

Finally, the alternate path that the data takes completely circumvents ISP and government

roadblocks designed to filter content or disallow access to specific services. This means a

Chinese VPN restores access to everything from news to social media sites and more.

By contrast, life abroad without a VPN solution in place can be a very limiting experience, and

it is far from safe. Hackers can steal information when you use your mobile device in public

hotspots or on unsecured Wifi. A VPN will thwart these hackers’ attempts and keep all of your

personal data secure. Premium VPN providers offer 256 bit encryption and multiple protocol

options including PPTP, L2TP/Ipsec, and OpenVPN. Combined, these options allow for secure

access on both desktops and mobile devices. Access your favorite websites safely from anywhere

in the world.

About the Author

Jessica Black writes articles about VPN security and the Android OS. Using the VPN above she is able

to access his favorite sites securely, even on public Wifi. Her articles help explain issues concerning

technology and security.

Share and Enjoy

FacebookTwitterStumbleUponRSSPinterestGoogle Plus


July 31 2012

Sharing a Printer Using Google Cloud Print – Guest Post

google cloud print tutorial 525x373 sharing printers mobile printing google cloud print tutorial google cloud print cloud printing

Google Cloud Printing Tutorial

Today printers are a necessity for both office and home uses, and there are many types of printers offered to meet varied uses, such as the Dell inkjet printers and wireless printers. However, there are cases when you want to have something printed, but printers are not available at hand. The good news is that this problem might be solved with Google Cloud Print. Google Cloud Print brings a revolution in printer sharing. With this awesome technology you can not only share the printer with your friend, family members and colleagues over the Internet, but you can also use your own printer remotely. You can connect your home and office printers to Google Cloud Print and let the others print what they want. Google Cloud Print is available for your smartphone, tablet computer, desktop PCs and laptop computers including Chromebook. If you have other devices that can be connected to the web and can send a printable file over the web, then Google Cloud Print will also work on that device.


Google Cloud Print has made the printer sharing over the Internet quite easy. Now we will talk about how to take advantage of this technology for your benefits.

Using Google Chrome To Setup A Cloud Print

We will be using Google Chrome to setup Google Cloud Print. First of all launch Google Chrome and click the wrench on the top-right. Choose “options” and the options page will open. In the left sidebar, click “Under the Hood”. A new page will open, then find Google Cloud Print at the lower part of that page. Click on “Sign into Google Cloud Print”. After that you will be prompted to register your PC’s printers with your Google Account. This step may require verification. It is very good to see that Google account requires verification before any of our information is retrieved or related to our Google Account.

Sharing Printer With Your Friends, Family Members Or Colleagues

Once you have clicked the “Finish printer registration” at the end of the previous step, then you will be able to see ‘Manage Your Printers’ link. If you don’t see this button click on the top-right wrench of the Google Chrome, then find “options”, then “Under the hood” and scroll down the page to see it.

After that you will be taken to the Google Cloud Print administration area where you can see Print Jobs and Printers in the left sidebar. Click Printers and you will be able to see all the printers connected to your PC. Now, you can share your printer by simply clicking the green “share” at the top of the list.

A dialogue box will open. Here enter the name of the people to whom you want to share the printer. Simply start typing the name and it will show you the suggestions through retrieving the contacts from your Gmail.

How To Accept Shared Printer And Send A Print Job

That was all you have to do to share your printer with your friends. Now, we will move on to how to accept a printer and send a print job to your printer.

  1. Once your friend has shared a printer then you need to visit Google Cloud Print website.
  2. You will see that you have a printer request in the left sidebar.
  3. Click on “Printers” and you will be able to see theprinter request.
  4. Click on “Accept” to accept the printer.

Now you have a printer!

To send a print job to your friend’s printer click on the (red) Print button and then click upload file to print. Currently Google Cloud Print supports only PDF and DOC formats. Choose a file and upload it.

Besides using web, applications of Google Cloud Printer are also available for Android, iOS, Windows and Mac.

Things You Should Know:

  • The request from the person (to whom you shared the printer) will first come to the Google Cloud Print, then it will go to your Google Chrome web browser and then it will be passed to the printer.
  • If your printer is turned on but your computer is turned off or Google Chrome is not running on your computer, then the requests won’t proceed from Google Cloud Print to your printer. Not only your computer must be turned on but Google Chrome must also be running in order to pass the print jobs from Google Cloud Print to your printer.
  • If your PC is turned off or Chrome is not running, the print jobs will not be wasted. They will be queued at Google Cloud Print. Whenever you turn your PC on and launch Google Chrome the print jobs will start moving to your printer.
  • It is very interesting to see that few printers come with built-in support for Google Cloud Print, so you just need to connect them with the Internet. More information on that could be found on the Google Cloud Print website.

Google Cloud Print provides an easy way to allow your friends to remotely use your printer. This also helps you in remotely using your printer. As we can see that Google Cloud Print is in beta but still it is very useful. We hope to see more features in the future. While there are applications for Windows and Mac PC users, a bad news for Linux PC users is that they can’t share their printer with Google Cloud Print. Currently there is no official support for Linux. We hope to see its support for Linux in the future.

About the Author

Edwin Sun is a devoted technology and gadgets blogger, and has written articles on various topics, such as cell phones, tablets, laptops, printers and monitors. I am always willing to share ideas with those who want to learn more about the new cool gadgets.

Share and Enjoy

FacebookTwitterStumbleUponRSSPinterestGoogle Plus


July 10 2012

Master the Excel VLookup with this Simple Tutorial

Become an Office Hero with the Vlookup Function in Excel

excel vlookup tutoria vlookup tutorial how vlookup works excel vlookup tutorial Excel vlookup excel tutorial

Over the years I have been the Excel tips guy in my office. There are so many amazing things that Excel can do, but the one thing I get asked more than every other feature combined is: “How do I do a Vlookup”. Mastery of the Vlookup seems to be the one Excel trick that people use to separate experts from novices. Well, guess what? It’s really not hard at all.

What Exactly is a Vlookup?

The Vlookup function in Excel is used to see if a value in one cell (or list of cells) is in another group of cells. (“V” is for vertical – you can use th Hlookup function to check horizontally too) Looks for a value in the leftmost column of a table, and then returns a value in the same row from a column you specify. Take a look at the data below. Column A has a list of people who have already paid their bill. Column B has a list of customers who received services. We want to find out which customers have paid and which still owe payments. This is a typical Vlookup scenario: compare two lists and identify the differences.


Naming a Range in Excel

Before you actually create your Vlookup formula, you should create a “Named Range”. Excel can take a range of cells and assign a name to it that can be referenced in functions and formulas throughout the workbook.

Select the range of cells that contain the values that you want to check against.

excel vlookup tutorial 15 vlookup tutorial how vlookup works excel vlookup tutorial Excel vlookup excel tutorial

TIP: If you have a list of values that may be added to, select a range that is bigger than your existing list. This way, when the list grows, the new values will still be included in your named range. After you select your range of cells, you are ready to give it a name. Right click on the highlighted cells and select Name a Range from the menu.

The New Name menu will open. Type a name in the Name field. You can modify the actual range of cells (now or later) in the Refers to field.

excel vlookup tutorial 131 vlookup tutorial how vlookup works excel vlookup tutorial Excel vlookup excel tutorial

Click the OK button.

Now you can refer to this range (Paid) anywhere in this workbook.

Creating the Vlookup Formula

Now that we have a range of data to check against, we are ready to build our formula.

Click to the right of the first value that you want to check.

Click the formula builder button (fx) to search for the Vlookup function.

excel vlookup fx button vlookup tutorial how vlookup works excel vlookup tutorial Excel vlookup excel tutorial

Select the Lookup & Reference category and scroll down to the VLOOKUP function.

Click the OK button.

The Function Arguments wizard will open.

excel vlookup tutorial lookup value vlookup tutorial how vlookup works excel vlookup tutorial Excel vlookup excel tutorial

The Function Arguments wizard lists what the overall function does below the fields. When you click in one of the fields an explanation of what goes into that field is displayed. There are four fields to populate:

  • Lookup Value
  • Table Array
  • Column Index
  • Number Range Lookup

Click in the Lookup Value field and enter the cell for the value that you want to check against the range (B2 – Allan).

excel vlookup tutorial 10 vlookup tutorial how vlookup works excel vlookup tutorial Excel vlookup excel tutorial

Click in the Table Array field and enter the name of the range that we want to search for the Lookup Value.

Type “paid” in the Table Array field to reference the named range of values. Notice how the values in the named range appear to the right of the Table Array field.

Click in the Column Index Number field.

The range that we named contained all of the values in one column (A). If we had a range of data that resided in more than one consecutive column, we could specify which column’s value that we wanted to return to the formula cell. Since we only have one column, type “1” in the field.

excel vlookup tutorial 09 vlookup tutorial how vlookup works excel vlookup tutorial Excel vlookup excel tutorial

Click in the Range Lookup field.

There are two values that you can use in the Range Lookup field: TRUE or FALSE. True will find the “closest” value in the range and False will only find EXACT matches. Typically I want an exact match.

excel vlookup tutorial 08 vlookup tutorial how vlookup works excel vlookup tutorial Excel vlookup excel tutorial

Type “FALSE” in the field and click the OK button.

If the value is in the range the value from column 1 will be displayed in our cell.

excel vlookup tutorial 07 vlookup tutorial how vlookup works excel vlookup tutorial Excel vlookup excel tutorial

Extending the formula down the rest of the list

Just copy and paste the formula you built (C2) and paste it down the rest of the list.

excel vlookup tutorial 101 vlookup tutorial how vlookup works excel vlookup tutorial Excel vlookup excel tutorial

All of the remaining values will be checked against the range.

If a value is not found “#NA” will be displayed. In our case, we will know that those people did not pay yet.

Since we made our named range a little bigger that the existing data, we can add more data to the empty cells in the range and have them rechecked.

The example below shows that as long as we type into the range that we created it will be included in the formulas that reference it.

excel vlookup tutorial 121 vlookup tutorial how vlookup works excel vlookup tutorial Excel vlookup excel tutorial

Using a Multi Column Named Range to Extend your Vlookup

We used a single column range in the example above. Multi Column named ranges allow you to do some more interesting things with your Vlookups. I added an extra column to the spreadsheet that lists the amount that each person paid.

Then, I edited the range (Formulas tab> Name Manager> Select Paid> Edit button> Change range from “A29” to B29”)

This included the Amount column as the second column in the range. You can add several columns if you like. Now, when I find someone that already paid, I don’t want to return their name (I already know their name) I want to know how much they actually paid. (Column 2)

Reopen the Function Arguments wizard and click in the Column Index Number field.

Type “2” in the field and click the OK button.

excel vlookup tutorial 132 vlookup tutorial how vlookup works excel vlookup tutorial Excel vlookup excel tutorial

Re-copy the formula down the list.

Now, you’ll see who paid, how much they paid, and who still owes money.

excel vlookup tutorial 14 vlookup tutorial how vlookup works excel vlookup tutorial Excel vlookup excel tutorial

That’s it – you can do the Vlookup with the rest of the Excel gurus out there.

Excel VLOOKUP Video Tutorial

See how to do all of the steps listed above in this video tutorial:

Did you Like this Article?

Sign up for free updates from VitaminCM.com?

rss 1281 vlookup tutorial how vlookup works excel vlookup tutorial Excel vlookup excel tutorial

mail subscribe1 vlookup tutorial how vlookup works excel vlookup tutorial Excel vlookup excel tutorial

Email Address

youtube 1281 vlookup tutorial how vlookup works excel vlookup tutorial Excel vlookup excel tutorial

twitter follow1 vlookup tutorial how vlookup works excel vlookup tutorial Excel vlookup excel tutorial

See some of the other places where you can connect with me out there in the wilds of the internets.

Share and Enjoy

FacebookTwitterStumbleUponRSSPinterestGoogle Plus


June 25 2012

Why Apple Came up with a Less Creepy Way of Tracking App Use?

apple tracking ios apps iphone app tracking ios apps ios apple app tracking

Why Apple came up with a less creepy way of tracking App use

Known as something of a technological control freak, Apple is famed for the rigid nature of the software platforms which it creates for its devices, but could it be ready to relax the reins a little following the news that it is making changes to the use of app tracking on the iPhone and iPad?

Current Tracking Methods

At the moment each Apple device running the iOS platform and thus each user, is endowed with a 40 character Unique Device Identification (UDID) code.

The UDID serves a number of purposes, but it is possible for third-party application developers and Apple itself to track the ways in which specific users harness applications.

This information is incredibly useful as it allows firms to develop software and experiences based on how apps are being used rather than simple guesswork. This adds plenty of value for developers who have to pay a license fee to create software for iOS.

However, from the point of view of the users there is an argument that this kind of tracking is a little bit creepy and invasive. If a firm is aware of precisely what aUDID is doing at all times it will build up a detailed picture of how you are using your iOS gadget. This raises the obvious concern that users’ privacy could be breached.

It is worth pointing out that Apple never officially sanctioned the use of UDIDs in this way, because it gives the impression that developers have free reign over the information provided to them automatically when users access their applications.

CNET notes that Apple did not always enforce its calls for firms to stop tracking usage, which suggests that it was not as interested in protecting user privacy as it might appear on the surface.


Realistic Expectations

The Wall Street Journal reported in early June that Apple is actively seeking to change the UDID system in order to make it easy to deliver app tracking to its developers while still giving users the extra privacy and security that they require to use its devices in confidence.

This news emerged ahead of the World Wide Developers’ Conference 2012, which is one of the major events hosted by Apple each year and is generally used as a launch pad for major products and services.

While iOS 6 was unveiled during the event, the promise of a less stringent and easy-to-track UDID system did not come to fruition.

Apple did not shy away from discussing the UDID complaints held by some, as it said that it would not be allowing apps through its approval process unless the developers confirmed that they would not be tracking users via this method.

Overall, it talked down the importance of UDID and the tracking issues, which means that it could go either way in the future in relation to this topic.

Potential Solutions

Many users were hopeful that Apple would be able to get rid of UDIDs, which in even their most innocuous form could be harnessed by less honorable developers to track and essentially spy on users. While this has not been forthcoming at the time of writing, there are various proposals covering just how Apple might implement an alternative system.

Some believe that Apple could easily create an anonymous user ID, by which individual devices and users would not be identifiable while still giving the company away of differentiating between each of the products which it produces.

As you might imagine, this would ultimately result in developers not being given specific information about those who are downloading and using their apps, thus removing the temptation to misuse this data.

In the end it is necessary for anyone who picks up a connected device to part with some personal information, divulging their usage habits and preferences via the internet to any number of companies. If you read more on high speed internet on the Broadband Expert website, you might discover that even your browser will keep a record of your history, which it is down to you to delete or manage.

Apple is not alone in lacking principles when it comes to privacy, but individuals should be aware of the risks they face and the price they have to pay for using technology.

About the Author:

Roxanne is a blogger and writer who gets behind tech issues associated with the smartphone market and portable computing in general. You can read more on high speed internet on the Broadband Expert website and also get information on breaking industry news through his work.

Share and Enjoy

FacebookTwitterStumbleUponRSSPinterestGoogle Plus


May 01 2012

Using Parallels to Ease the Transition from Windows to Mac

Parallels Windows Virtualization Needed for the New Mac User

parallels run windows on mac tutorial2 windows virtualization virtual machine run windows on mac parallels paralells tutorial mac utilities

How to Run Windows Software on a Mac Using Parallels

So you’ve upgraded to a Mac. You’ve been sworn into the revered fraternity of Apple. Now what? How do you function in a world so captivated by Microsoft? How do you use your old Word documents, your Excel files, and your PowerPoint presentations? What happens to all the Microsoft software you’ve poured your money into over the years? Do you have to just buy everything all over again?

Not at all; for this very reason the computer virtuosos of the universe created Parallels windows virtualization virtual machine run windows on mac parallels paralells tutorial mac utilities . What the heck is Parallels? Parallels is a way to use Windows software on your Mac. It is a program that deciphers what you already have set up on your Windows computer and makes it available to use on your new Mac. Using this program, both Mac and Windows software can run concurrently.


Not only does Parallel allow you to conserve your software, it also allows you become gradually adapted to your new Mac. There are many alterations in Mac software versus Windows,and Parallel allows you to incorporate new learning experiences gradually instead of being immediately swamped by all new software. This will permit you to maintain your productivity,even in the chaos of such a radical change.

Additionally, Parallels are vital when it comes to matters like virtual private networks. VPNs often run with Windows-only software, so owning a Mac could cut you out of the loop. Avoid this issue by adding Parallels to your arsenal.

How to Install a Windows Virtual Machine – Video Tutorial

One of the paybacks of having a Mac with Parallels is the facility to run the beloved Mac OS,Snow Leopard, and have the capacity to run others, such as most versions of Linux and really all versions of Windows. Sure, you can use Boot Camp, which has been distributed as part of the Mac OS for some time, and merely load Windows separately; however, a lot of the time it makes more sense to run Windows and OS X simultaneously. Times like when the Mac version of Adobe’s CS suite is running, and perhaps some Mac exclusive software, but you still need to work with Windows only software, such as Visio, Visual Studio, or SQL.

There are different types of compatibility programs, besides Parallels, with VMware Fusion windows virtualization virtual machine run windows on mac parallels paralells tutorial mac utilities being the most popular. VMware does get the job done; however it does have problems. If you useMicrosoft’s Virtual PC (for Windows), and have to transfer virtual images into your Mac so you can work and search at home or on the go, you would be incapable of moving the images and using them with VMware. Parallels, however, is able to identify and receive images that have been used with Virtual PC without any issues. Parallels accepts every single OS and configuration without problems; the only thing you might uncover is that many of the virtual images request to be reactivated or, at times, even for the product key; which is not a problem since you should already have that information.

Not only is Parallels able to recognize those virtual images, but it also takes advantage of more of the Mac’s hardware, such as the GPU (graphics) therefore causing improved CPU performance, without slowing down the virtual machine nor the native OS.

VMwre and Parallels both get the job done. However if you’re in the technology industry and need to move virtual images from computer to computer repeatedly, than Parallels would be the top choice. A parallel is a very useful instrument for new Mac owners, particularly if you’ve never had or used a Mac before. Do your research and uncover which system will work best for your new Mac’s needs.

About the Author

This Guest post is by Christine Kane, a graduate of Communication and Journalism. She enjoys writing about a wide-variety of subjects including internet service for different blogs. She can be reached via email at: Christi.Kane00 @ gmail.com


March 09 2012

March 08 2012

Making a Mackbook Pro that Kills Apple’s for $790 Less – Part 3 Finishing Up

Moving your Mac’s Home Directory to another Hard Drive

upgrade macbook pro for hundreds less tutorial part 3 system preferences move mac home directory move home directory mac maintenance

This is the 3rd article of a 3-part series on Making a Mackbook Pro that Kills Apple’s for $790 Less

Read the entire series:

  1. Buying Your Macbook Pro for Far Less Money
  2. Adding an SSD Drive and Upgrading your Memory to your Macbook Pro
  3. Moving your Mac’s Home Directory to another Hard Drive

OK, so you have your new hard drives and ram in your computer, so you’re done right? Almost, but not yet. The SSD drive has fairly limited space, so you probably don’t want to store your data there. You’re going to need to move the Home directory to the mechanical hard drive.

  1. Turn your computer back on.
  2. Open Finder and copy the Users folder from the SSD drive to the SATA drive.
  3. Open your System Preferences app.
  4. Click on the Users & Groups icon under the System heading.
  5. Click the Lockicon in the lower left corner of the menu to unlock this user profile
    1. You will need to enter your system password to continue
  6. Right click on your profile and select Advanced Options.
  7. Click the Choose button next to the Home Directory field.
  8. Browse to the Users folder that you just pasted to the SATA drive.
  9. Click the OK button.
  10. You will be prompted to restart your computer. Do this.
  11. When your computer comes back on, your Home drive will be relocated.
  12. One last thing, delete the old Home drive from the SSD drive.

Video Tutorial – See it in Action

The video tutorial below shows you all of the steps listed above.

This is the 2nd article of a 3-part series on Making a Mackbook Pro that Kills Apple’s for $790 Less

Read the entire series:

  1. Buying Your Macbook Pro for Far Less Money
  2. Adding an SSD Drive and Upgrading your Memory to your Macbook Pro
  3. Moving your Mac’s Home Directory to another Hard Drive

Did you Like this Article?

Sign up for free updates from VitaminCM.com?

rss 128 system preferences move mac home directory move home directory mac maintenance



mail subscribe system preferences move mac home directory move home directory mac maintenance

Email Address


youtube 128 system preferences move mac home directory move home directory mac maintenance

twitter follow system preferences move mac home directory move home directory mac maintenance

See some of the other places where you can connect with me out there in the wilds of the internets.


March 07 2012

Making a Mackbook Pro that Kills Apple’s for $790 Less – Part 2 Installing the Upgraded Components

Adding an SSD Drive and Upgrading your Memory to your Macbook Pro

upgrade macbook pro for hundreds less tutorial part 2 upgrade mac ram upgrade mac memory upgrad mac hard drive tutorial replace hardware apple

This is the 2nd article of a 3-part series on Making a Mackbook Pro that Kills Apple’s for $790 Less

Read the entire series:

  1. Buying Your Macbook Pro for Far Less Money
  2. Adding an SSD Drive and Upgrading your Memory to your Macbook Pro
  3. Moving your Mac’s Home Directory to another Hard Drive

Step 1 – Cloning the Hard Drive to the SSD Drive

Now that you have your new Macbook Pro and all of your upgraded components, you are ready to get your hands dirty. You will learn how to replace the hard drive, add a second drive, and replace the memory chips.

Here are the specs before we get started.

specs 1 upgrade mac ram upgrade mac memory upgrad mac hard drive tutorial replace hardware apple

specs 2 upgrade mac ram upgrade mac memory upgrad mac hard drive tutorial replace hardware apple

Before your install the SSD drive, you’ll need to clone the Operating System from the Hard Drive (boot drive).

  1. Start up your new Mac and install SuperDuper, the FREE backup/cloning software. (Free hard drive cloning software.)
  2. Connect the SSD drive to your computer using a SATA to USB cable upgrade mac ram upgrade mac memory upgrad mac hard drive tutorial replace hardware apple . (You can get a Cable for about $15 or a USB External Enclosure upgrade mac ram upgrade mac memory upgrad mac hard drive tutorial replace hardware apple $15.)
  3. Make a clone of the entire Hard Drive to the SSD drive using SuperDuper.
    1. SuperDuper Main upgrade mac ram upgrade mac memory upgrad mac hard drive tutorial replace hardware apple
  4. Shut your computer down and unplug the power cable.

Video Tutorial – See it in Action

The video tutorial below shows you all of the steps listed above.

Step 2 – Swapping the Hard Drivies

  1. Open your laptop’s case.
    1. Flip it over
    2. Unscrew the 10 screws around the case’s perimiter
    3. Lift off the case bottom
  2. Before you touch anyting, REMOVE THE BATTERY CABLE.
  3. Remove the Hard Drive.
    1. Unscrew the mounting bracket
    2. Remove the SATA cable
  4. Connect the SSD where the Hard Drive used to be.
    1. Reattach the SATA cable.
    2. Place the drive in the empty space.
    3. Screw the mounting bracket back on.
  5. Remove the DVD drive.
    1. Remove the three cables attached and push them back out of the way.
    2. Unscrew the three phillips screws
    3. Unscrew the three torque screws
    4. Pull the DVD drive caddy out.
  6. Place the Hard Drive into the mounting caddy upgrade mac ram upgrade mac memory upgrad mac hard drive tutorial replace hardware apple ($15 +/-) and connect it where the DVD was located.
    1. Place the old hard drive into the caddy
    2. Attach it to the SATA adapter
    3. Place the caddy into the empty space
    4. Screw the caddy back down to the case.
    5. Reattach the three cables.

Step 3 – Upgrading the Memory in your Macbook Pro

Now that the drive are in place, you’re ready to install the new memory chips.

  1. Open your laptop’s case.
    1. Flip it over
    2. Unscrew the 10 screws around the case’s perimiter
    3. Lift off the case bottom
  2. Remove the two existing Memory chips.
    1. Pop the clips off the sides of the chips
    2. Gently tilt the chips up on a 45 degree angle.
    3. Slide the chips out of their slots.
  3. Place the two new Memory chips into the empty slots.
    1. Check for the alignment slits.
    2. Gently slide the chips into the empty at a 45 degree angle.
    3. Push them down flat.
    4. Clamp the side clips back down.
  4. Reattach the battery cable.
  5. Close the case back up and Restart the machine.

Video Tutorial – See it in Action

The video tutorial below shows you all of the steps listed above.

Here are the specs when we are done.

specs 4 upgrade mac ram upgrade mac memory upgrad mac hard drive tutorial replace hardware apple

specs 5 upgrade mac ram upgrade mac memory upgrad mac hard drive tutorial replace hardware apple

What Should You Do Next?

This is the 2nd article of a 3-part series on Making a Mackbook Pro that Kills Apple’s for $790 Less

Read the entire series:

  1. Buying Your Macbook Pro for Far Less Money
  2. Adding an SSD Drive and Upgrading your Memory to your Macbook Pro
  3. Moving your Mac’s Home Directory to another Hard Drive

Did you Like this Article?

Sign up for free updates from VitaminCM.com?

rss 128 upgrade mac ram upgrade mac memory upgrad mac hard drive tutorial replace hardware apple

 

mail subscribe upgrade mac ram upgrade mac memory upgrad mac hard drive tutorial replace hardware apple

Email Address

 

 

youtube 128 upgrade mac ram upgrade mac memory upgrad mac hard drive tutorial replace hardware apple

twitter follow upgrade mac ram upgrade mac memory upgrad mac hard drive tutorial replace hardware apple

See some of the other places where you can connect with me out there in the wilds of the internets.


Making a Mackbook Pro that Kills Apple’s for $790 Less

upgrade macbook pro for hundreds less tutorial upgrade memory upgrade macbook pro upgrade hard drive save hundreds on mac refurbished mac customize macbook pro

Everybody knows that the Macbook Pro is the most beautiful, powerful, and stable laptop in the world (for Mac or Windows). The problem is that they are not cheap and Apple’s limited upgrades are ridiculously overpriced.

If you’re willing to invest a few hours and a little elbow grease, you can get yourself a real Macbook Pro that will crush anything that Apple sells and save hundreds of dollars.

The best specked Macbook Pro that you can buy from Apple has the following: (I’m pricing the 15 inch model because the 17 inch model is barely a portable laptop.)

CPU: 2.5 GHz Quad-core Intel Core i7

Memory: 8 GB 1333MHz DDR3 SDRAM — 2x4GB

Storage: 256 GB Solid State Drive

Display: 15-inch Hi-Res Antiglare Widescreen Display

Price: $3,299.00 (Yikes!!!)

macbook pro pricing 11 upgrade memory upgrade macbook pro upgrade hard drive save hundreds on mac refurbished mac customize macbook pro

The system I’m going to build has the following specs:

CPU: 2.5 GHz Quad-core Intel Core i7

Memory: 16 GB 1333MHz DDR3 SDRAM — 2 x 8GB (Twice as much as Apple offers.)

Storage: 128 GB Solid State Drive + 750GB Serial ATA Drive (That’s right, TWO hard drives.)

Display: 15-inch Hi-Res Antiglare Widescreen Display

Price: $2,509.00 (That’s $790 less!)

There are three keys to saving all of this money:

  1. Buy a Refurbished Macbook Pro (More on this below)
  2. Buy the Superior upgraded components from a better, cheaper vendor
  3. Install the upgraded components yourself

price chart upgrade memory upgrade macbook pro upgrade hard drive save hundreds on mac refurbished mac customize macbook pro

Step 1 – Buying your Machine

Isn’t Buying a Refurbished Computer Risky?

No, not at all. Apple’s refurbishing program is amazing. They reinstall the Operating System, replace any worn out parts, and fully inspect the entire machine. Then, they cover it with the exact same one year warranty that the ones in the store get. You can purchase Apple Care (extended warranty) too; if you’re a worry wart.


So what’s missing?

The super cool, cardboard Apple box and about 30% of the price. Seriously, that’s it. If you can possibly stand to skip that magical 10 seconds of unboxing, you get a great deal.

Step 2 – Buying the Upgraded Components

Once you have the machine, you need to order your upgraded components. You can shop around, but save yourself some time and go to either NewEgg.com or Amazon.com. They have the best combination of price and selection you’ll probably find.

Memory – Apple maxes out at 8 GB for a $200. You can buy a 16 GB kit for $140 upgrade memory upgrade macbook pro upgrade hard drive save hundreds on mac refurbished mac customize macbook pro . (Twice the memory for $60 less.)

Storage – Apple includes a 750 GB mechanical hard drive, but will upgrade you to a 256 GB SSD for a whopping $500. Here’s where we’ll get creative. You can buy a 128 GB SSD upgrade memory upgrade macbook pro upgrade hard drive save hundreds on mac refurbished mac customize macbook pro . But 128 gigs is not enough storage, right? No, it’s not. Don’t forget, we still have the 750 GB drive that came with the machine. (If you let Apple do the upgrade, they keep the original parts.) We’re going to use the SSD for the Operating System and Applications and put the mechanical Hard Drive in place of the DVD drive. This gives us the speed of the SSD and the massive Hard Drive storage for a fraction of the cost.

What Should You Do Next?

This is the 1st article of a 3-part series on Making a Mackbook Pro that Kills Apple’s for $790 Less

Read the entire series:

  1. Buying Your Macbook Pro for Far Less Money
  2. Adding an SSD Drive and Upgrading your Memory to your Macbook Pro
  3. Moving your Mac’s Home Directory to another Hard Drive

Did you Like this Article?

Sign up for free updates from VitaminCM.com?

rss 128 upgrade memory upgrade macbook pro upgrade hard drive save hundreds on mac refurbished mac customize macbook pro



mail subscribe upgrade memory upgrade macbook pro upgrade hard drive save hundreds on mac refurbished mac customize macbook pro

Email Address

 


youtube 128 upgrade memory upgrade macbook pro upgrade hard drive save hundreds on mac refurbished mac customize macbook pro

twitter follow upgrade memory upgrade macbook pro upgrade hard drive save hundreds on mac refurbished mac customize macbook pro

See some of the other places where you can connect with me out there in the wilds of the internets.


January 31 2012

Create a Windows, Mac, Linux Super Computer Using Synergy

This tutorial will show you how to use Synergy to Control Multiple Computers with One Keyboard and Mouse

control multiple computers using synergy

OVERVIEW: You will learn how to use Synergy, a free software application to control multiple computers with one keyboard and mouse. These computers can all be running different operating systems.

What Is Synergy?

Synergy is an open source software application used for sharing a single keyboard and mouse between multiple computers. One user can control several computers in the same physical area, with a monitor connected to each. The “server” software runs on the computer with the keyboard and mouse connected and the “client” software runs on the computers that are being controlled. Synergy can run on all of the popular operating systems (Windows, Mac, Linux, and UNIX) at the same time. This means that you can move your cursor from your Windows desktop to control a Mac, and a Linux machine without batting an eye.


Why I Use Synergy

I constantly need to use and document applications in Windows, Mac, and Linux environments. This requires me to have at least one machine set up running each of those operating systems. I currently have three laptops on the desk in my office running each of those systems. Synergy allows me to line them up next to each other and use my mouse to bounce back and forth between them as if I was using a single, very diverse computer. The best part of it is that there is a common clipboard that allows me to copy pictures and text from any machine and paste it on any other machine, as if I was pasting from MS Word to PowerPoint on the same computer. (Regardless of which operating systems.) I could also see this being powerful for someone running a computer room at a data center.

Getting Synergy on your Computers

If you’ve read this far, I’m assuming that this sound kind of interesting to you. Well, enough sales, let’s see how to make it happen. Start off by downloading and installing the software on all of your machines. FYI – there are a few different variations of the Synergy software/project available, but they all play fairly well together, so just pick one that you’re happy with.

Windows: Synergy, Synergy-Plus, Synergy KM, Quick Synergy

Mac: Synergy, Synergy-Plus, Synergy KM, Quick Synergy

Linux: Go to your distribution’s Applications installer, then search for and install Synergy and Quick Synergy. (Synergy is the service and Quick Synergy is the GUI that let’s you configure the service.)

The steps differ slightly based on the specific software installed on each operating system, but the concepts are the same. I will include links for each application’s specific instructions below.

Configuring Synergy

Once you have the software installed on all of your machines, you are ready to begin configuring your systems. The biggest decision is which computer will have the keyboard and mouse physically connected. This will probably be based on some sort of unique personal preferences. The computer with the keyboard and mouse physically connected will be the “Server”.

selecting the synergy server

Before you go any further, find the Internal IP Address and Computer Name of all of the machines that you are going to control.

Configuring the Server (Computer sharing its keyboard and mouse)

You need to tell the server which computers it is going to be controlling and where they will be physically located (to the left, right, above, diagonally above, etc.).

Enter the computer names of each machine and place them where they belong. As you can see in the image below, I have three computers set up, with “christopher” in the center, “Laptop” on the left, and “cm-mac” on the right.

synergy sever client machine arrangement

The interface will look slightly different on each OS, but they are conceptually alike.

Configuring the Clients (Computers “borrowing” the Server’s keyboard)

Now that your server knows about the other clients and where they are located, you need to tell the clients to allow the server to take control of them.

Select the Use Another Computer’s Keyboard and Mouse option on the client machine. Then, add in the Server’s Internal IP Address. If you set a password on the Server, enter it on each client machine. (Use the Advanced button below.)

configuring synergy client machine

Once you have your client(s) configured, click the Start button to give control to the Server’s keyboard and mouse. That’s it! Now, just move your cursor across the edge of your monitor onto the next machine. The cursor will instantly start to move on the client machine and anything that you type will be happening on the client machine. If you want, you can select and copy text on that machine and then move your cursor to one of the other machines and paste it in seamlessly. Pretty cool and simple, right?

See Synergy in Action

The following video shows how to configure Synergy to share a keyboard across Windows, Mac, and Linux computers. It also shows you a simple example of what you can do once you have everything set up.

Alternatives

There are of course a several available options for working with multiple operating systems. I actually do use a few of them when the situation lends itself, but none of them give you the most power and features of each OS all at the same time. Let’s take a look at some of the alternatives and their pros and cons.

Option Description Tools Pros Cons VNC Virutal Network Computing- Use VNC to remotely connect to and control other computers (typically not in the same physical location). Chicken of the VNC, RealVNC, Remote Desktop Protocol, TightVNC, UltraVNC, Virtual private network, X Window System, X11vnc,  Comparison of remote desktop software Can connect from anywhere in the world.
Uses very little resources on either machine. Can’t copy and paste between machines.
Multiple computers share one monitor’s space.
Can be a “glitchy” user experience. Virtual Machine This creates additional “virtual” computers on a computer so that multiple computers and operating systems can run on the same machine. Parallels, VMware Fusion, VirtualBox, Windows Virtual PC You only need to have one machine.
Cheap and space efficient. Puts a HEAVY bourdon on your computer.
Physical and Virtual systems run slow.
Two machines sharing one monitor’s space.
Takes up a lot of one machine’s hard drive. Dual Boot/Multi Boot Partition the hard drive on one computer so that multiple operating systems can be installed. When the machine is started, you can select which operating system to “boot”. Boot Camp (Mac), Dual Boot Runs at the machine’s full speed. Can’t work simultaneously on multiple OS’s.
Too much time watching the rebooting screens.
Takes up a lot of one machine’s hard drive.

What are your thoughts?

What do you do when you need to work on multiple machines and operating systems? Please let me know in the comments. If you have a cool solution, I would love to feature it in a future article.

Did you Like this Article?

Sign up for free updates from VitaminCM.com?

Subscribe to VitaminCM.com via RSS Reader



VitaminCM.com Email Feed

Email Address


VitaminCM on YouTube

VitaminCM on Twitter

See some of the other places where you can connect with me out there in the wilds of the internets.


January 26 2012

Prevent Computer Registry Pollution with these Easy Guidelines – Guest Post

Keep registry clean

The Windows registry is an important part of the operating system. This particular database contains all of the preferences, settings, and information about the software running on the computer, in addition to data regarding components of the operating system. When the registry becomes corrupted by a virus, new settings may cause malware to run constantly in the background, which can in turn lead to several different issues including identity theft, hard drive corruption, and phishing. Fortunately, there are several steps that can be taken to avoid registry pollution and keep your system running smoothly without any outside interference.

All computer users who spend time on the Internet need to develop a shield for their PC. While viruses can also enter a computer via corrupted media on CDs and USB keys, the primary source of viral infection is through Internet browsing and downloads. Antivirus software is the best bet for consumers looking to protect their computers from malicious attacks.


Several different kinds of antivirus protection are available to today’s consumers. Top brands in the industry sell software suites that not only protect from viruses and malware, but also include tools like parental controls and spam filters. These suites generally require an annual licensing fee to be paid to the manufacturer. In addition to paid options, there are also many freeware solutions available. Microsoft offers a proprietary virus solution, Microsoft Security Essentials, which is available free of charge to anyone operating a Windows machine. Other solutions include those available from AVG, and other third-party developers.

If malicious files have already had the opportunity to enter your system, you will need to take steps to eliminate the problem. Viruses that place false entries in a computer’s registry are difficult to eradicate, as the registry is a very sensitive part of a computer’s infrastructure. If the wrong items are inadvertently deleted from the registry, your software may stop functioning, and your computer may begin to behave bizarrely. For this reason, it is generally not advisable to attempt to manually clean the computer’s registry without outside assistance.

One solution is to use a registry cleaner to remove inappropriate entries. These applications will safely clean the registry, deleting problematic files, and optimizing existing software as it works. This can lead to better overall system performance. Furthermore, registry cleaning can help prevent the system from crashing that is caused by system errors.

It is important to carefully vet any registry cleaners before installing them on a computer, as some malware may hide behind the facade of a legitimate registry cleaner. Once the application has been installed on your computer, it begins to wreak havoc behind the scenes, causing further issues with your operating system. The best way to make certain you are downloading a real piece of software is to look for the recommendations of third parties. You may also want to purchase a registry cleaner, rather than trying your luck with a free solution.

Keeping the computer registry free of pollution can be a real challenge. Fortunately, using the many different software solutions intended to keep your system safe, it is possible to eliminate the threat of viral attacks. Furthermore, by using registry cleaners and antivirus applications, your system will stay optimized and running efficiently.

About the Author

Jesse is a freelance writer known for her superb articles on registry clean-up, online virus scan and data recovery tips. More material to follow!


Older posts are this way If this message doesn't go away, click anywhere on the page to continue loading posts.
Could not load more posts
Maybe Soup is currently being updated? I'll try again automatically in a few seconds...
Just a second, loading more posts...
You've reached the end.

Don't be the product, buy the product!

Schweinderl