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
For six months last year, I traveled to Los Angeles every week to consult with a client. I stayed in Pasadena, which was only a few minutes away from Burbank, where Jay Leno taped the Tonight Show at the time. As my project was wrapping up, I thought about getting into the audience of the … Read more
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
I’ve already pledged to read more books this year, and one of the best ways to make headway is by running through my backlog of books I was supposed to read already. Here they are, in no particular order. Good to Great – Jim Collins Master Your Metabolism -Jillian Michaels Slideology -Nancy Duarte Now You … Read more
One of my goals this year was to switch from Microsoft Money Plus to Quicken for my personal financial planning software. I was going to time this with my tax software purchase, so I could get a discount on Quicken at the same time. However, after reviewing the pros and cons, I’ve decided to stick with … Read more
Notes p.31 Retirement as a goal or final redemption is flawed for at least three solid reasons: a. It is predicated on the assumption that you dislike what you are doing during the most physically capable years of your life. This is a nonstarter – nothing can justify that sacrifice. b. Most people will never … Read more
The goals I have this year have never been more important. After going through what was, hopefully, the toughest challenge of my life, I will now define my legacy by how I recover. I’ve separated my goals into three major themes: Restore My Health, Improve My Mind, and Maintain My Finances. Restore My Health The … Read more