How to Remove Album Art from Audio Files

Here's a great illustrated tutorial that explains how to remove album art from audio files such as mp3s.  The article explains how to get rid of album art either by deleting hidden album art files in residing in the same folder as the audio file or manually removing embedded art through an editor such as the free mp3tag.

To bulk remove embedded album art that you couldn't get rid of by deleting hidden files, use an editor like mp3tag.  Here are the directions on how to do so using mp3tag:
  1. Actions
  2. Quick Actions
  3. Select Remove Fields
  4. Type in PICTURE in the Remove Fields textbox

Make a Second Monitor Display Full Screen When Hooked Up by HDMI

Sometimes when running a dual monitor setup off a laptop, the image on the larger monitor doesn't take up the full screen.  Here is the fix, at least for a laptop with an ATI graphic card.  Though the interface is a bit different now than what is shown in the article, the instructions worked for me and I was able to get the image to take up the entire screen on the second monitor.

How to Solve Headphones Jack Moves, Music Pauses Problem

Does your media player pause when you move your headphones even slightly?

If so, the problem is likely due to lint and dust that has built up in the headphone jack.  You need to clean out the debris. The easiest way is to use some scotch tape.  Simply roll up a little bit of scotch tape into a long, pointy cylindrical shape and stick into the jack and move it around.  Then remove and note the amount of dust and lint removed.  Do this a couple of times with fresh tape each time.  Once the tape comes out clean, you've likely solved the problem.  To verify that you have, plug in your headphones, move them around, and see if the player no longer pauses as a result of the slightest movement of the phones. 

If you want to prevent this from happening again, try buying some headphone jack covers from Amazon.

Excel Tip: How to Easily Remember the Index-Match Formula

Lots of experts tout Index-Match as a better look up formula than venerable Vlookup.  However, it's a little hard to remember its formula (which is a mash up of the Index and Match formulas).

Here's how I do it:

=INDEX(Range with values I don't have, (MATCH(Look-up value, Range with values I do have, “0″))

Everything I have goes in MATCH; what I don't have goes in INDEX.  For example:
  • Range with values I don't have = Range of product IDs
  • Look-up value = Product Name
  • Range with values I do have = Range of product names
The 0 at the end of the formula means you're looking for an exact match.  Check out the Index-Match article linked above for a fuller explanation.

How to Bold a Cell in Excel Based on Another Cell's Contents

Ever want to bold a cell in Excel based on the contents of another cell?  Here's how...

Say you need cells in column P to be bolded if column A contains the word "total."  To do this you'd:
  1. First, select the cells that you want to which you want to apply conditional formatting.
  2. Then click Conditional Formatting from the top ribbon.
  3. Next select New Rule.
  4. Then click "Use a formula to determine which cells to format."
  5. Enter this formula in "Format values where this formula is true": =ISNUMBER(SEARCH("total",A1))=TRUE 
  6. Select your format; in this example, you'd use bold.
After this all the cells that have the word "total" in them cells against them will be bolded.

If you want to learn more about conditional formatting in Excel based on values in other cells, check out this excellent in-depth article at AbleBits.  If you want to add to that knowledge on how to format a cell conditionally based on its own text, check out this Microsoft Office article.