How to Boot Your Mac in Safe Mode

Some puzzling Mac ailments, like crashes or hanging screens at startup, can be treated by booting into Safe Mode or resetting your PRAM (parameter random access memory).

PRAM contains Startup Disk settings that may need a zap to fix some booting issues not related to hardware. Start up your computer holding the Command-Option-P-R keys, then keep them held until your computer restarts and you hear two startup chimes (release them when finished). If your computer boots normally, check your settings in System Preferences—many were probably reset.

Safe Mode doesn’t look different from Regular Mode, but it may get your Mac booting again.

Safe Mode makes a great diagnostic tool, and sometimes it gets sick Macs booting by itself. Start up your Mac holding the Shift key and let go when startup kicks in. OS X will run with a minimum of features and extensions to make troubleshooting easier. Safe Mode also performs a directory check of your startup disk, among other diagnostics, which may be enough to put your patient back on its aluminum feet.

Tech Tips: 15 Ways to Make iTunes Rock

It’s hard to imagine that one could really tweak or improve iTunes in any particular fashion. I say that not because the software is perfect, rather, because it’s completely closed-source. Apple doesn’t have a list of extensions that you can just install into the application at a whim. If anything, iTunes is built for two purposes and two purposes alone: Buying stuff from Apple’s Store and transferring said stuff over to an Apple device of your choosing.

Voila?

Yet, the more I looked into ways that one can extend the iTunes experience, the more I found that yes, Virginia, there are plenty of different tools, add-ons, and techniques you can employ to really make this music application shine. And before you start in the comments, yes, I know that there are better music players than iTunes. However, that’s not to say that iTunes itself is a poor program—with a little tender love and care, you can make it as welcome in your home as any other program you enjoy. Trust me.

Let’s get started!

 

Installing iTunes Sans Bloatware

The best place to start our journey toward iTunes awesomeness is, of course, at the point of installation. If you’ve ever used the application before, you’ll know that Apple—unfortunately—dumps a ton of crap on your system during the course of the iTunes install. This includes calls to startup programs that unnecessarily run behind-the-scenes on your system, a network service you likely don’t even need, browser plugins, et cetera.

Ed Bott over at ZDNet has written a fine how-to for getting past all the annoying junk and installing, quite simply, iTunes. Follow his advice for a bloat-free music application!

 

Punish Ping

For whatever reason, you might not want to jump on-board with Apple’s Ping service. Perhaps your musical tastes are so esoteric that you want to keep your perfectly formatted library all to yourself—no sharing with friends and strangers anything you happen to rock out to and/or enjoy. That’s fine. Apple isn’t twisting your arm to sign up for Ping.

Now, suppose you want to remove all the Ping options from your right-click context menu as well. There used to be a fancy little way to do it via a command prompt window. However, that’s since been replaced by an easier method: Click Edit, select Preferences, find the Parental Control tab, and check the box next to Ping.

 

Double Library Trouble

You ninja you; I would understand your desire to keep your less desirable music (say, the entire Spice Girls collection) out of the easily accessibility of iTunes’ shuffle feature. But there are many more reasons than that for why you might want to build separate iTunes libraries.

Here’s how: Just hold the shift key before you launch iTunes. It’s as simple as that. The software will prompt you to either pick a library or create one. If you do the latter, your two libraries will exist completely independently of each other—which can be a pain if you want to, say, add some MP3s to both. Secrecy has its price!

 

Pretty Up Your Collection

Apple’s iTunes is pretty good about trying to match album artwork to the various songs and albums you have scattered about your library. But it’s not perfect, nor can your esoteric musical tastes (previously including such random bands as The Beatles) always be found in the iTunes store—the source for said artwork.

To better figure out what you have to import manually, make a smart playlist (File > New Smart Playlist). Once the associated window pops up, select “Has Artwork” as the rule and “is false” as the conditional. Once you click “OK,” you’ll have a self-updating list of albums that require your artistic touch!

 

Share Your Library

If you’re running a fairly networked house, then odds are good that you’ll want to be able to access and modify a single iTunes library from any system you can get your grubby little hands on. No sense running multiple libraries across multiple computers with multiple duplicate files, right? As well, dialing into a single iTunes repository on a single system is great for file playback, but not so great for file editing.

Our friends at Lifehacker have written up a fairly comprehensive (trust us; it’s a lot of steps) guide to maintaining a single, editable library across all of your networked systems. Take that, duplicity!


“Share” Your Library

Here’s the deal–if you do happen to be in the situation where different computers on your network have different music files on them, it’s possible to grab the exact songs you want from any other networked iTunes application using a third-party piece of software. The app’s called Aethyr, and it’s an Adobe Air-based program that lets you “rip” music, as it were, from any other iTunes you can find on your network.

We suppose this would be considered the “Holy Grail” of applications for one on a college dorm room network, but what you’re thinking about is illegal and wrong. Shame on you.

 

Dump Your iTunes to the Web

This one’s a little esoteric, so hear us out. The Web app “Moof” allows you to upload your library file to its servers and it, in turn, gives you the opportunity to jam to your files no matter your physical location.

Huh?

No, you don’t upload every MP3 (or whatnot) to the service. Nor do you have to pay any money to get access to the jams that Moof recognizes via your uploaded library file. Instead, this service uses the power of YouTube—specifically, videos featuring your songs found on YouTube—to give you an on-demand radio of sorts that, itself, is based on your iTunes library.

That’s a mouthful… and a clever workaround to having to carry your entire musical collection on a portable hard drive wherever you go.

For the most advanced tips of all, read on!

Remote Rock

I often find myself envious of Apple fans, as they get access to all sorts of neat little tricks within iTunes—remote speakers, controlling playback via their handheld iPhones and what-have-you, other cool stuff like that. Well, worry not Windows user, for a fun little application called Airfoilallows you to set up a portable rock station anywhere in your apartment, house, or dwelling.

So long as Airfoil is running on two networked computers, it’s super-easy to pump the sounds of one to the other. Because nothing’s more fun than DJ’ing a party from the comfort of your home office–or, for that matter, Rickrolling your friends unexpectedly. The program slaps noise into your broadcast after 10 minutes unless you buy the paid-for version… so if you’re really concerned about that, then try the freeware alternative Speakershare.

 

Let iTunes Lull Yourself to Sleep

Pardon the German, but it’s been a real pain to try and find a working timer application that lets you use the power of iTunes to gently drift yourself off to slumber. The app Sweet Dreams does just that, reducing the volume of your system over a period of time that you specify until, ideally, you’ve finally succumbed to sleep.

Better still, this app will even shut off your system when the timer reaches the big fat zero—perfect for those that would like a gentle night’s sleep without the glare of a monitor pervading their room. So what’s this app’s major downfall? German. Still, with such few options to choose from, I’m willing to venture that you don’t need a few years’ language skills in your repertoire just to know what to do to enable a simple timer. Right? Gut.

 

The Simpler Timer

If you really, truly can’t stand the thought of having to comprehend German to make your system’s sounds expire at a given time, here’s an easier solution: ClickWhen. This app, written by Lifehackers’ own Adam Pash, is simple in its execution. Launch it, then select a spot on your display that you want to click in a given time period from this very moment—like, say, the “pause” button on your iTunes screen. Then input a time.

That’s it.

Once the timer runs out, your mouse will magically click itself on the point you previously selected. It’s as easy as that. Yes, this app seems silly, but it’s always a perfect way to, say, give yourself 30 minutes of rocking before you have to go leave the house to do something, or switch over to a brand new playlist once your party has hit the three-hour mark. And yes, you can even have the app perform double-clicks as well. Two functions for the price of none!

 

Sync Android to iTunes

How do I love thee, doubleTwist? Let me count the ways: one. You let me synchronize my Android phone with my iTunes library, which is almost a cats-and-puppies-as-friends kind of situation that, at first glance, should seem impossible.

But I’m here to tell you that it isn’t. Grab the client application, grab the associated Android application, and you’re good to go. Soon, wireless synchronization of your songs will be within your grasp!

If you don’t want an entirely new song client, however, then your best bet is to stick with good ol’ iTunes and a little app called iTunes Sync. So long as you flip your Android phone over to disk drive mode, you’ll be able to pull it up directly within iTunes—but more importantly, you’ll be able to use iTunes to manage the playlists that synchronize to your Android phone as well.

 

Your iTunes Needs a Friend

Thus enters the application iTuner, a self-proclaimed “iTunes Companion” that, indeed, adds a ton of functionality within an easy-to-access button on your taskbar: “automated library maintenance, playlist exporting, playlist sychronization with MP3 players, global keyboard control, lyric discovery, and track and playback control. C#, WPF, MusicBrainz, iTunes APIs, and more,” reads the app’s official site.

I only listed that as I did because there’s just too much that iTuner does to say it in any way other than a simple data dump. From automatically nuking missing and duplicate tracks in your library, to deleting empty folders within your main “music” directory, to global hotkeys that you can use to control iTunes regardless of whatever program is in your foreground… the list of that-which-iTuner-can-do is long and extensive.

To be honest, it’s also an excellent replacement for the default iTunes Mini Player that now looks anemic by comparison.

 

Global Hotkeys Beckon

If the thought of global hotkeys mentioned in the above description for iTuner got you salivating, great! I’m not sure why this would be the case, but suppose you don’t really need or want the various features that said iTuner app provides—you just want hotkeys and vanilla iTunes. That’s it. Alright. Check out HKTunes, an open-source application that does just that: It adds global hotkeys to your system such that you can control iTunes without actually having to have the app running in the foreground.

Playing World of Warcraft and want to stop your jams to concentrate on a specific boss fight? Easy. Want to jump tracks back and forth while writing up an article about iTunes? Totally possible. Need to change the iTunes volume on the fly? Get a multimedia keyboard… or memorize your HKTunes hotkey combination!

 

Browse with Firefox and Rock with iTunes

Alright, Firefox users. Here’s one of the times when you get to do a little gloating over your Chrome-using compatriots. That’s because there’ s really no way to go about controlling what’s going on in iTunes via some kind of toolbar within Chrome. Firefox users get the awesome add-onFoxyTunes to do just that: You can see what’s playing, jump tracks back and forth, seek out specific parts of a song, and do all the sorts of things you’d expect to find on the iTunes Mini Player… right within your browser.

Seriously. If you’re a Firefox aficionado, there’s no reason why you would ever want to use the default iTunes Mini Player over this full-featured extension. And as a super-fun bonus, FoxyTunes even comes with both an alarm clock and a sleep timer—perfect for the times when you want to take a little nap to the sweet sounds of Nine Inch Nails or something while a huge download finishes. Mmm.

 

Who’s Listening to my iTunes?

Assuming you’ve enabled all the various music sharing mechanisms within iTunes, have you ever actually been curious to find out who’s connected to (and rocking out with) your system? While you can’t pull that much detail on the actual users attached to your iTunes via your network connection, you can at least see who has come into the jam session of your digital living room.

Head on over to Microsoft’s site and grab the application TCPView. Once you’ve done that, fire it up and scroll on through until you find the iTunes listings—and, yes, the program automatically updates when connections drop on and off. If you don’t recognize the IP address or local address, which means it’s not your system’s name or “localhost,” then you have a fan who’s listening to your iTunes as we speak. If you want to pull the person’s plug, right-click on the corresponding line and select “End Connection.”

Whoops!

Still Rocking Windows XP? Start Planning an Upgrade

ll things eventually come to an end, and for Windows XP and its legion of holdouts, the end is nigh. It’s a dead OS walking and the governors at Microsoft aren’t going to pick up the phone at the last moment and give it yet another stay of execution. Microsoft general manager for Windows Commercial marketing, Rich Reynolds, confirmed as much in an interview with InformationWeek.

He said flat out “there’s absolutely no chance” of Microsoft extending support for Windows XP beyond its end-of-life date in April, 2014. That still seems a long ways off, especially for an OS that officially turned 10 years old today, but if businesses don’t get on the ball soon, Reynolds fears they’ll find themselves scrambling around at the last minute.

“What we’re concerned about is organizations that haven’t started yet,” Reynolds said. “It takes anywhere from 12 to 14 months to do the planning and application remediation.”

According to Reynolds, only about a quarter of enterprise systems are locked and loaded with Windows 7, however the vast majority have a plan to upgrade.

Are you still using Windows XP?

How to Protect Your Boot Drive with BitLocker

When it comes to protecting the data on your computer, you can’t do better than strong encryption. Properly encrypted, your files are safe even if a ne’er-do-well gains access to your computer, either physically or through a network. In the past, we’ve discussed how to use various encryption tools to encrypt individual files or create virtual, encrypted drives. Now, we’ll look at how to get maximum security by encrypting your boot disk using the BitLocker full-drive encryption system that’s built into Windows 7 Ultimate and Enterprise.

Step 1: Assess Your System

Ideally, you have a motherboard with a Trusted Platform Module (TPM) chip. A TPM chip securely stores cryptographic keys, which BitLocker uses to access your boot drive before Windows even loads. The TPM also detects any early boot files that have been modified, protecting you from rootkits and other low-level malware. You can check with your motherboard manufacturer to see if you have a TPM, or you can just attempt to go straight to Step 3. If you don’t see a message that looks like the image below, you’re good to go. Otherwise, you don’t have a TPM and you’ll need to continue to Step 2.

You’ll also need an additional, small partition on any boot drive you wish to encrypt in order to use BitLocker. Windows creates this extra partition by default during installation, but even if you don’t have one, the BitLocker software can create it for you.

Step 2: Enable USB Key Storage

By default, BitLocker requires a TPM chip to work. To change this, open the group policy editor by bringing up the Run menu (press Win + R) and then typing gpedit.msc.

Navigate through the hierarchy on the left side of the group policy editor, selecting the following folders, in order: Computer Configuration > Administrative Templates > Windows Components > BitLocker Drive Encryption > Operating System Drives (image below). Once you’ve found the right folder, double-click “Require additional authentication at startup” to edit that policy entry.

In the policy editor, all you need to do is click the radio button marked Enabled. In the bottom‑left, a checkbox labeled “Allow BitLocker without a compatible TPM” should already be checked. If it isn’t, check it. Click OK and exit the group policy editor.

Step 3: Enable BitLocker

The actual process of enabling BitLocker is straightforward: You can right-click a drive in Explorer and click Turn On BitLocker, or you can go to the BitLocker section of the control panel and enable it on any drive from there.

As long as you’ve followed the previous two steps, you should see a screen asking you for your BitLocker startup preferences. If you have a TPM, you have three options. If you select “Use BitLocker without additional keys” your startup process will be basically unchanged. Someone with access to your computer will be able to get at your data, but you’ll be protected from rootkits and from people accessing your data remotely. Alternatively, you can choose to enter a PIN every time you log in.

If you’re using the USB method, you only have access to the last option, “Require a Startup key at every startup.” With this method, you’ll only be able to boot your computer while you have a USB drive with a startup key inserted in the machine.

Once you select an option, you’ll be asked to insert a USB drive to use as the key, and you’ll choose where to store your recovery key, which you’ll need if you want to decrypt your data on a different computer, or if the TPM detects a problem. It will take some time for BitLocker to encrypt your drive, but once it’s finished, your data is safe. Anyone attempting to boot from your drive without the proper key won’t even get to the Windows boot screen (image above).

Cheat Sheet: 12 Tips and Tricks for Microsoft Excel

Excel isn’t the sexiest application in the world–it has an unfortunate association with the type of Milton-esque office drones we all wish we weren’t. All the same, it’s a program that most people will end up having to use at some point in their life, and it’s one with a lot of arcane secrets. Read on for 10 quick Microsoft Excel tips and tricks that will get you accounting like a pro in no time flat.

Time to Pivot

Pivot Tables are one of Excel’s most useful—and misunderstood—features. Here’s a quick lesson: Click within a chunk of data, click Insert, and select “Pivot Table.” Excel should automatically pick the entire range of said data (provided you don’t have any blank columns interrupting your dataset), and convert this into an editable, table-as-you-go kind of setup.  You can use the various “fields” on Excel’s new sidebar to basically create new tables of information (and calculations) on-the-fly.

Let’s Lookup!

Another widely used, but often confusing feature of Excel is Vlookup—the function by which one looks at data A, finds data A and data B in another spreadsheet, and slaps data B somewhere into the original spreadsheet. It’s tricky to explain, but easy to use: You’re basically using the contents of a single cell as an anchor for referencing information from one location to another. Master the command, and you’ll find a new use for it every day!

Conditional Formatting is your Friend

If formulas aren’t your thing, here’s an easy way to duplicate data between two columns. Highlight the columns and select Excel’s Conditional Formatting feature on the Home tab. Then, select the “Highlight Cells Rules” listing and pick whatever option fits your style. Duplicate values, for example, would highlight all repeated instances with a given color.

Insta-Jump to a Cell

Did you ever stop and wonder if you can actually modify the cell listing that appears to the left of the Excel’s formula bar?  You know, the one that automatically changes to tell you exactly row and cell you’re on at any given moment?  Guess what: You can.  Click on it, and then type in a given row name and column number—you’ll jump right to that cell as if you just hopped through a magical portal.  Really, it’s that fun.

Get Set for Macros

Trying to discuss Excel macros in a tiny paragraph is like trying to stuff an elephant into a car.  However, the first step toward being able to use Macros is an easy one: Open up Excel’s options (Jewel button > Excel Options) and select “Customize Ribbon.”  Click on the unchecked “Developer” box that’s on the right-side of the options window, and you’ll gain access to the “hidden” section of Excel that’s a quick shortcut to the almighty macro.

Why Not Numbers?

From time to time, Excel will foolishly store numbers like a “0” as text instead of a numeral, which can be a real pain if you’re trying to do anything with said information. So how do you fix 23,414 rows of the same error? Insert a new column and type a “1” into an empty cell. Select it, copy it to your clipboard, then select the range of numbers you’re looking to fix. Click on the drop-down menu under the Paste icon, click “Paste Special,” and select the options “Values” and “Multiply.”

Why Not Empties?

Dovetailing off the previous tip, Excel also has a nasty habit whereby information you’ve modified such that a cell should be empty… isn’t.  The cell has no values in it per se, but it still doesn’t register as empty for uses of the Count command or things like that. The easy way to fix this is to simply sort your affected columns in A-to-Z order, then manually select the range of “blank” cells starting at the bottom of the listing all the way down to Excel’s final row. Now, hit “Delete.”

Delete Blank Rows

If you have a bunch of data that’s separated out by blank rows of cells for whatever reason, it’s easy to just nuke these out of your dataset forever without having to do any kind of crazy sorting. Select a column, hit F5, click on Special, then select the “Blanks” option. With said blank rows now targeted, click over to Excel’s Home tab, select “Delete,” and choose the option for eliminating said rows.

Show Thy Formulas

This one’s quick, but super-effective: If you have a spreadsheet full of formulas and you want to see exactly how you’ve built all of your constructions, you can do this by hitting CTRL+~, which will instantly transform your spreadsheet from values to the formulas that constructed them.

Double-Click to Freedom!

Double-clicking various parts of the Excel interface can automate a number of functions, including: double-clicking on the Jewel to close Excel, selecting multiple columns and double-clicking on the separators to auto-adjust the widths of all, double-clicking on the tabs of Excel’s ribbon menu to minimize the whole thing, double-clicking the lower-right corner of a cell to Fill Down its contents based on the contents of the column to its left… the list goes on!  When in doubt, double-click.

Adding Multiple Lines of Text

It’s frustrating to try to add multiple lines of text to a given cell. How the hell do you do it? The answer is so easy, it’s almost shocking. When you want to insert a line break in a cell to split your text up in a more readable fashion, just hold down Alt and hit Enter. Technically, you’re also turning on “Wrap Text” for the affected cell as well.

Email… Anything!

Check out the Excel plugin RDBMail if you want to super-charge your ability to quickly email portions of a worksheet to an Outlook recipient. It adds a new tab to your Ribbon that you can use as a single-click utility for emailing your entire worksheet to a person or the pertinent parts that you’ve selected. You can also toggle between sending the worksheet as-is—formulas included—or sending off only the values of what you’ve been working on.