## GMAT Study Update: The MGMAT OG Tracker is Awesome!

Even though I’mÂ alreadyÂ in my third week of study for my Manhattan GMAT online course, I still haven’t explored all the resources available to me on the Manhattan website.Â  Last night I signed up for office hours with one of the Manhattan GMAT instructors and she informed about Manhattan’s Official Guide Tracker.Â  I downloaded the file … Read more

## Tracking My Blood Pressure Over Time

As I’ve indicated on this blog before, I developed kidney problems after being laid off from my company last year.Â  My latest visit with my nephrologist indicated that my kidneys were functioning at 70%.Â  It sounded really bad to me at first, but the doctor indicated that 70% is a perfectly fine functionality for someone’s … Read more

## Excel QuickTip: Use Scroll Button to Navigate Ribbon

Here’s a quick Excel 2007 tip I found just by accidentally playing with my mouse.Â  It’s a little clunky at first if you’ve never used it before.Â  But over time, this will make you faster at navigating the Ribbon. Simply place your cursor over the Ribbon and scroll up and down with your middle mouse … Read more

## Formula Validation: A Better Way to Do Data Validation

Data validation is one of the most popular features in Excel. For those unaware of what Data Validation is, you’ve probably seen it before. It usually takes the from of those drop down boxes you see, limiting the inputs available to you for a particular cell. You can also limit inputs without a drop down … Read more

## Top 3 Reasons Why My VLOOKUP Isn’t Working

1.Â  You Have Your Numbers Formatted as Text 2.Â  You Have a Trailing Space at the End of Your Values 3.Â  You Forgot to Reference Lock Your Arrays During my days as the spreadsheet guy (oh wait, I still am the spreadsheet guy) I’d often get pinged by other analysts about why their VLOOKUP formulas … Read more

## How to Use INDEX MATCH

Any legitimate Excel user has used VLOOKUP and knows the syntax by heart.Â  (Lookup Value, Array, Column, etc.)Â  But many of these same users have never used INDEX MATCH before.Â  INDEX MATCH is one of several lookup formulas available in Excel. Â It has certain features that make it superior to VLOOKUP in many situations.Â  Regardless … Read more