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

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


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

Microsoft Does Google Docs

Recently, I came across the features link for the next version of Excel, Excel 2010, here. Here’s bullet point number five from the webpage: “Connect, share, and accomplish more when working together. Co-authoring through the Microsoft Excel Web App makes it possible for you to edit the same spreadsheet with others simultaneously from different locations. … Read more

Excel Tip: Change Startup File

If you’re like me, you do a lot of formatting to the Book1.xls file that Excel initially opens up.  However, if you find yourself making the same changes over and over again, you might just want to automate the whole startup formatting process. Implementing this is actually a really simple task.  Open up Excel as … Read more