Excel Video 71 Chart Design Options

Excel Video 71 introduces three chart design options that can help you quickly customize your chart. First we’ll discuss Quick Layout, which offers a variety of preset, chart-type-specific options to customize your chart. These layouts can help you add titles, labels,...

Excel Video 70 Introducing Excel 2007 Charts

Excel Video 70 introduces charts, a powerful tool to convey lots of information in Excel 2007. We’ll start with how to find charts in the Excel 2007 menus and a couple of ideas on how to select data for charts. I expect to have a variety of videos on charting in Excel...

Excel Video 69 VLOOKUP x 2

Truth in advertising. Excel Video 69 is more complicated than most of these videos. I have a detailed table of partner’s equity transactions during the year and want to write one formula to pull specific rows and columns out of the detailed table to get a summary of...

Excel Video 68 Nesting Functions in VLOOKUP

Excel Video 68 shows how to nest functions, or put a function inside another function, in Excel. VLOOKUP is a powerful function, but it is even more powerful if you can combine other Excel functions inside VLOOKUP. In Video 68, we have a table of patients and ICD-9...

Excel Video 67 VLOOKUP in Two Tables

Excel Video 67 is a practical example of how an anesthesiology practice uses VLOOKUP in two different tables to make sure they aren’t missing any patients. Every month the practice compares a hospital report of patients treated to a practice report of patients treated...