Excel for Mac Level 1 class ON SALE for $149

Excel for Mac

Excel for Mac Level 1 class on Saturday, September 3rd, 2016 is on sale for $149! (reduced from $199).

We offer the most practical Excel group classes and private training in NYC.

Excel for Mac group class concentrates on the most common topics we see NYC businesses using on a daily basis. By the end of the Excel training course, you will feel confident managing Excel lists, databases, charts, common formulas, formatting, shortcuts and printing. This Excel class is perfect for those who are new to Excel, have been using Excel without any training or need to gain a solid grasp of how to use it effectively. We currently use Excel 2011 for Mac.
Visit us at www.training-nyc.com or call 212-658-1918 to enroll while the price is hot!

[SOLVED]- Can’t install the software for the HP Photosmart C4200 series because it is not currently available from the Software Update server.

If you get this message, then here is the solution. It took me forever to figure this out, so wanted to help out. This will work for most HP drivers.

Can’t install the software for the HP Photosmart C4200 series because it is not currently available from the Software Update server.


Download and install this: http://support.apple.com/kb/DL907

Restart your Mac.

How to Change Mac Mouse Pointer

How to Change Mac Mouse Pointer

It’s in System Preferences > Accessibility > Highlight Display on the left > move Cursor Size Slider.

Screen Shot 2012-09-18 at 9.48.15 PM.png

Create Keyboard Shortcut for Anything on a Mac

Create Keyboard Shortcut for Anything on a Mac

Click the Keyboard Shortcuts tab and then the plus sign. This will provide you with a little panel that will let you override a keyboard shortcut for a specific application or all applications. All you have to do is type in the exact menu title of the command in the panel and the new keyboard shortcut you want to assign to it. When you’re done, click add, and it’ll immediately be the active keyboard shortcut for the command you specified.

Screen Shot 2013-10-21 at 2.15.18 PM

How to Open Search in iOS 7

How to Open Search in iOS 7

Swipe down in the middle of any page of your home screen to reveal the search bar.

How to View Network Connection Speed on a Mac

How to View Network Connection Speed on a Mac

Using Option-Click

As pointed out by anon in the comments, you can simply hold down the Option key while clicking on the menu bar icon for your Airport, and it will show you the extended information in the popup display.

Very useful. Thanks!

Using the Network Utility

You can use the Network Utility by using Cmd+Space to pull up the Spotlight search box and typing it in, or you can navigate through your Applications -> Utilities folder to find it.

Once you’re there, you can see the current connection speed by looking at the Link Speed, which will show the actual data rate that you’re using. This rate will change as you move around your house, so if you’re far away from the router, the rate will change, and if you’re closer, it will get higher.

How to View Network Connection Speed on a Mac

Using the System Profiler

You can open up the System Profiler application from Spotlight search, or through Applications -> Utilities. Once you’re there, navigate down to Network -> AirPort (assuming you’re using a recent MacBook), and you’ll see the current connection over on the right. In my case, I’m indeed using Wireless-N.

When I first moved into my new house a few days ago, something didn’t seem quite right with the new Verizon router—it just wasn’t as fast as it should have been. After searching around, I was able to figure out that even though the router was set to Wireless G or N, it was defaulting to G instead of N, so I was losing a ton of speed. After upgrading the firmware, everything was fine.

Fix iPhoto from crashing

Fix iPhoto from crashing

Fix #1

1 – launch iPhoto with the Command+Option keys held down and rebuild the library.


2 – run Option #4 to rebuild the database.

Fix #2

Fix iPhoto from crashing

Using iPhoto Library Manager  to Rebuild Your iPhoto Library

1 – download iPhoto Library Manager and launch.

2 – click on the Add Library button and select the library you want to add in the selection window..

3 – Now that the library is listed in the left hand pane of iPLM, click on your library and go to the Library ➙ Rebuild Library menu option.

4 – In the next  window name the new library and select the location you want it to be placed.

5 – Click on the Create button.

Note: This creates a new library based on the LIbraryData.xml file in the library and will recover Events, Albums, keywords, titles and comments.  However, books, calendars, cards and slideshows will be lost. The original library will be left untouched for further attempts at fixing the problem or in case the rebuilt library is not satisfactory.

Watch Netflix on Your iPad From Any Country

How To Watch Netflix In Your iPad From Any Country In The World [How To]

Cult of Mac

How To Watch Netflix In Your iPad From Any Country In The World [How To]Oh yes… COME to daddy.

Don’t use a computer any more? Hate “pirating” TV shows and movies? Wish that your country had something as awesome as Netflix so you could pay and stream everything to your iPad mini? Read on, because you can do just that, and it is dead easy – all you need is a credit card and maybe a half hour to get things set up.

I use BitTorrent. I admit it. I pay for music, and I watch movies in the cinema, but here in Spain the TV show offering is terrible. ITunes will sell me the latest U.S movies, but they’re dubbed into Spanish, and there still aren’t any TV shows in Apple’s store. I could wait for the DVDs, but I don’t have a DVD player. I guess I could get a pre-paid U.S credit card and buy shows from the U.S iTunes Store but…

I’m cheap. I’m not going to make any kind of political or ideological excuses here. I just don’t want to pay $2 or whatever iTunes charges for a single episode of a TV show, when – for my entire life – I have watched those shows free on a TV set. So I torrent them.

However, with my (almost) iPad-only lifestyle, I don’t really want to keep big media files on my iPad’s 64GB drive. Which led me to NetFlix.

Netflix Overseas
How To Watch Netflix In Your iPad From Any Country In The World [How To]Thanks Netflix. No, really… Thanks a lot.

Netflix is amazing. You can watch zillions of movies and (non-current season) TV shows on demand, instantly, and for like $7 per month. If you live in the U.S (or in place like the UK which have their own Netflix outposts). Anywhere else and you’re stuck with a crappy local offering or – more likely – nothing at all. This is because Netflix checks where you are, and only serves you if you are geographically inside the United States. Or rather, if your IP address is inside the United States. And here’s the crack in the system.

It’s possible to use VPNs and tunnel your way through to a stateside IP address, but this usually results in slow, low-bandwidth streams, and it also affects all your internet traffic.

UnoDNS is a clever paid service which uses DNS to spoof your location. But the clever part is that it only diverts the packets needed to make Netflix believe you’re a local customer.

All the heavy lifting – the actual movies streams and so on – come over your regular pipes. So if you have a fast 100MB fiber-to-the-bedroom connection like me, then you’re golden. Shiny, sparkly golden, to be precise.

What You’ll Need

  • A U.S iTunes Store account (free)
  • A NetFlix account ($8 per month)
  • A valid credit card
  • An UnoDNS account (from $5 per month)
How To Watch Netflix In Your iPad From Any Country In The World [How To]These are Google’s DNS numbers, but you can type in anything you like, even on your iPad.

What is DNS?

DNS is the internet’s phone book. When you type www.cultofmac.com into your browser, a DNS server (usually at your ISP) will translate that URL into the actual hard numbers that point to our site. UnoDNS replaces your ISP’s server with its own, allowing it to redirect some packets. The key is that it only redirects the packets needed to get your Netflix (or another streaming service) and routes all the rest through Google’s DNS servers.

To use the service, it’s best to follow the device-specific instructions on the site. There is an eight-day trial available so you can see if you like it, and you can combine this with a Netflix trial to test everything out.

UnoDNS needs some configuration to be done on setup (mostly telling the service what your home router’s IP address is), but after that you need to do just one thing: change the DNS server on your device. You can do this for individual devices, or for your whole home by changing the DNS server used by your router.

I have a TextExpander snippet containing the UnoDNS’ DNS server address, so I can quickly add it in whenever I need it. To swap back to my ISP’s server, I just delete the number and my ISP’s numbers are automatically repopulated.

Why? Security. I have no reason whatsoever to think that Uno is doing anything but provide a great service. But I’m paranoid. And I’m also speed-hungry – Uno’s nearest DNS server is in Italy, but my ISP’s nearest server is presumably in Barcelona (where I live) or at least in Spain. In the world of millisecond pings, that distance can make a difference. So I only use Uno’s DNS when I’m actually watching things. It takes just a second to switch over.


Netflix signup is easy. You just give the site your details and a credit card, and your trial will commence (you’ll only be billed once the trial ends). You’ll need to set up the UnoDNS before Netflix will actually let you into its site, but once that’s done you can use a credit card from anywhere to sign up – not just a U.S credit card (I thought I needed a U.S card to do this, which is why I have left it so long).

Now, you’re almost done. In fact, if you watch Netflix using a computer then you’re done. Enjoy your new-found TV channel (complete with subtitles!). If you’re on an iPad, there’s on more step.

How To Watch Netflix In Your iPad From Any Country In The World [How To]This used to be way harder.

You’re going to need a U.S iTunes Store account to get the Netflix app. This is pretty simple, as the app is free, and Apple provides instructions on setting up an account without a credit card on its support pages.

The short form is that you sign out of your own account, head to the U.S store, tap on a free app to download it and then follow the prompts to make a new account. You can do this on a computer or an iDevice, making this entire project iPad-only if you want it to be.

Once you have the Netflix app installed, just make sure you’re on the UnoDNS before launching it. Sign in and you’re off. I totally love using this on my iPad mini, and I’m not losing anything over using the Retina iPad (apart from sheer screen size) as Netflix doesn’tyet stream in hi-def to iOS devices.

One tip: if your Netflix app tells you that you’re outside of its home territories even though your UnoDNS is on, try force-quitting it and launching: It seems it only checks on a cold launch, not a relaunch.


Now I’m a happy Netflix user, for just $13 per month. I still can’t get TV shows as they air (BitTorrent can take care of that), but I do have a catalog of gazillions of TV shows and movies in my back pocket, including all the shows I should have watched the first time around (hello Firefly!).

Now, if some smart company would make a subscription service that would show me first-run TV shows, on the day of airing, for a flat monthly fee, I’d be in. I’m totally willing to pay a fair rate (and not a few dollars per episode, dammit). Until then, I’ll have to keep this Mac around running Transmission.

Sync Adobe Lightroom Across Multiple Computers Mac OSX

Sync Adobe Lightroom Across Multiple Computers Mac OSX

Sync Your Lightroom Across All Your Macs With Dropbox [How To]


It’s not just for Lightroom/Dropbox nerds either: Using this method, you can keep pretty much anything in Dropbox and sync it between computers, even if the folders involved absolutely have to stay in a certain place on your hard drive, like your ~/Library folder.


What and Why

We’re going put all Lightroom’s files in Dropbox, and then link them back to the places Lightroom is expecting to find them.

If you have more than one computer, you will likely want to use Lightroom on all of them.
Lightroom – like most Adobe apps – spreads itself all over your hard drive. Your catalog files, your rendered previews, your develop presets, your preferences and – finally – your actual photos are all kept in specific places. What we’re going to do is put these all in one central location – Dropbox – and then link the files back to the places Lightroom is expecting to find them. Some of these fils can be anywhere – you just have to tell Lightroom where you put them. Others need a little more finessing.

To do this, we’re going to use Symbolic Links. These are just like aliases, in that they let you make a shortcut to a file, only Symbolic Links are like super aliases, able to fool apps into thinking that they are the real, original file. This is good because we have to fool both Lightroom and Dropbox.

You can make Symliinks in the terminal, and its pretty easy if you’re a terminal kind of guy. We’re going to do it the human way, using Automator to make a plugin for the Finder. Don’t worry – it’s easy. It’ll also be handy in the future, as you can just right click on any file and make a Symlink for it.


First, download these Automator Actions from Junecloud (the folks behind the awesome Deliveries app) and install the Create Symbolic Link action (just double-click on it unless, like me, you have a Symlink to your Services directory in your Dropbox…).

Then, start up Automator. It’s in your Applications folder


Auto1The scope selector selects the scope. Got it?

Launch Automator and pick Service from the box that pops up. This will let use make a System Service that can be accessed from the Finder. Then configure the drop down options to say “Service receives selected” files or folders in Finder (see picture). This tells the service when and where to show up.

Auto2That green blob is Dropbox’s badge to tell me this file is synced, too. Recursive? Yes.

Now drag in the previously-installed “Create Symbolic Link” action from the list on the left (it’s filed under the Finder’s list of actions), click “Options” at the bottom of its box and check “Show this action when the workflow runs.” This will force the Finder to show a dialog so you can choose where to save the resulting link. Tip: The Symlink can be dragged around in the Finder after you make it, so you can just save it to the desktop and move it later if you like.

Auto3This is your Finder’s contextual services menu.

That’s it. Save it, give it a name (mine’s called Create Symbolic Link) and you’re done. Now you can right-click on any file or folder in the Finder

Now we’ve done that, the easy part starts. Yup, it’s even easier! You can work two ways with Dropbox and Symlinks: you could keep the files outside of Dropbox and put the link inside Dropbox, or vice versa. We’re just going to put everything in Dropbox and go from there. This makes Dropbox our central repository. But first, a few notes about how Lightroom stores things.

Lightroom’s Folders

When you first ran Lightroom, you chose where to store the catalog and photos. Most likely it’s in your ~/Pictures folder in your home directory. The quickest way to find it (assuming that you don’t already know) is to open Lightroom, go to Lightroom>Catalog Settings… in the menu (⌥⌘, with the keyboard), choose the “General” tab and read off the location from the top of that window. You can even click the button to take you to the folder in the Finder.

Moving Your Catalog
LrcatLightroom manages to hide its confusing Adobe origins, but the preferences are as bad as anything the company has ever done.

This folder contains your catalog file (the database that describes your Lightroom catalog), plus your previews and other files. You want all of them. Go ahead and move this to your Dropbox (close Lightroom first). I suggest creating a Lightroom folder at the root level of your Dropbox and putting it in there. Now you can just double-click the LRCAT file to open it, or you can launch Lightroom and tell it where the file now resides (if Lightroom can;t find the catalog it’s expecting, it throws up a neat file browser on launch. Make sure to check the box to always open this same file).

In theory, you can stop now. Your Catalog is now stored on your Dropbox and, once it has synced, you can access it from any computer running Lightroom. But this only contains the previews and the metadata. If you want to access your presets, too, then follow along.

Next up, the Symlinks.

Application Support

Go find your Lightroom Application Support Folder. It’s in your ~/Library/Application Support/Adobe folder. Your Library folder is hidden in Mountain Lion. To get there you can either copy the path above, hit ⇧⌘G in the Finder and paste it in, or hold down the ⌥ key when you click the Go menu in the Finder, which will reveal you Library folder so you can navigate to it manually.

symlnknLook ma! No terminal!

Once there, copy the Lightroom folder to your Dropbox. Now, the clever part (to be done with Lightroom closed): Right-click on this newly moved folder and select the Create Symbolic Link action from the “Services” part of the contextual menu. Choose to save this back inside the ~/Library/Application Support/Adobe folder from where you just moved the original. Don’t type anything in the name section of your action – leave it empty and the original file name will be used.

You should now be the proud owner of a Symlink in the ~/Library/Application Support/Adobe folder which points to the actual Lightroom folder in your Dropbox. Wait for Dropbox to stop spinning and launch Lightroom. It should look exactly as it did before.

Now, on your other computer(s), just repeat the Symlink step (deleting or overwriting the ~/Library/Application Support/Adobe/Lightroom folder first, remembering that you should probably make a copy just in case something goes wrong), and tell Lightroom to use the same Catalog folder.

Smart previews will let you edit all your photos on a MacBook without attaching a drive containing the originals.

crapCheck, check, check.

One note: Do not store your actual photo files in Dropbox. You can store them on an external drive and hook it up to whichever computer you’re using at the time. If you’re using the LR5 beta then you can leave the photos on your big computer, and use your MacBook Air to access only the Catalog and Previews folders. That is, just do exactly what we have done in this tutorial but make sure to generate the new “Smart Previews” when you import photos into Lightroom on your iMac. These smart previews will let you edit all your photos on the MacBook without attaching the drive containing the original photos. And because those edits are stored with the catalog on Dropbox, the next time you open up LR on the big Mac, all your edits will be synced up with the original files.

Other Apps

Countless applications store their info in hard-coded locations, usually the Application Support folder. If you move these support files, then the app ail will just make new, empty ones. Using Symlinks will let you keep these folders in Dropbox instead. Symlinks can also be used to keep normally local files on external drives, but as this can break things if a drive is even temporarily disconnected, then you should probably think carefully before doing it.

In the case of Lightroom, the catalog files, previews and and photo library can all be kept pretty much anywhere. As we saw, this capability is built in – you just have to tell Lightroom where everything is. By keeping the catalog and previews on Dropbox, we can access them from anywhere. By sym-linking the Application Support folder to Dropbox, we also mirror our presets on all our machines. And with Lightroom 5, you don’t even need the original files to edit them.

One final note: Don’t sync Lightroom’s actual preferences files (in ~/Library/Preferences) between machines, unless your computers are identical. These prefs remember everything, down to window size, which could be pretty annoying if you’re moving from a 27-inch iMac to and 11-inch Air.

Stream to MAC (or PC) to Multiple Airport Express & Apple TV’s (Mac OSX Training)

Stream Pandora, Songza or any music from your MAC or PC to Airport Express & Apple TV’s (Mac OSX Training)

The simple answer is use Airfoil. Works perfectly. It’s $25 and totally worth it for me. I have speakers in the living room, bathroom, bedroom and outside.


Stream Pandora, Songza or any music from your MAC or PC to Airport Express & Apple TV’s (Mac OSX Training)