Designed for accounting and other business professionals, this guide to Microsoft Excel provides information on this feature-rich product that will make users more proficient. Described in detail are the techniques that were introduced since the switch from Lotus to Excel took place in the 1990s. Tips designed to make Excel use more efficient include how to prevent duplicate data entry, deleting unwanted links, importing and refreshing data from the Internet, and adding a running balance column to pivot table. Other advanced techniques include combining the Vlookup function with a combo box to extract data, comparing lists without using formulas, and adding comments to formulas that calculate loan payments, writing a program, and VBA techniques.
I spent twelve years 'in the trenches', working as a financial analyst for finance, accounting, marketing and operations departments of a $500 million company. Armed with a half-rate reporting tool and a spreadsheet, I was responsible for turning large amounts of data into analyses for the board room quickly and accurately. Working originally in Lotus 1-2-3 and then Microsoft Excel, I honed techniques to take massive amounts of data and produce meaningful reports in record time. These techniques are spelled out in Guerilla Data Analysis Using Microsoft Excel.
In 1998, I launched MrExcel.com, which is now one of the three most popular Excel websites with 21 million annual page views. Being MrExcel is now my full-time gig. My team has developed custom applications for hundreds of clients around the world. I enjoy entertaining a room full of accountants with my 'Power Excel' seminar.
When I am not Excelling, you can find me and the family under the stars enjoying a movie at one of the many drive-in theaters that still dot northeast Ohio or kayaking on the Mogadore Resevoir.
