In this practical and information-packed course, you will see how to maximize Excel's functions and capabilities. Most organizations rely heavily on Excel to consolidate, analyze and report financial information. Yours is probably no exception. By learning these advanced techniques, you will become more valuable to your organization. Learn how to work with the additional analysis tools provided by Excel add-ins and become skilled in using validation to protect the integrity of your worksheets from less-experienced users. Impress your coworkers by learning how to add functional and eye-catching custom controls to any worksheet and how to use scenarios and data tables to quickly perform "what-if" data analysis.