by Nate Moore | Jun 30, 2010 | Charts
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,...
by Nate Moore | Jun 28, 2010 | 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...
by Nate Moore | Jun 23, 2010 | VLOOKUP
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...
by Nate Moore | Jun 21, 2010 | 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...
by Nate Moore | Jun 16, 2010 | VLOOKUP
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...
