Maximize your investment in Microsoft Excel by learning advanced techniques that most users don't even know exist. In this practical, hands-on course, you will learn how to use scenarios and data tables to quickly perform multiple what-if analyses. You will discover a variety of advanced pivot table techniques, like creating calculated fields and calculated items. You will be able to use validation to protect the integrity of your worksheets from other, less experienced users. You will become adept at consolidating and importing data, and you'll master the art of conditional formatting to highlight duplicate entries and other common worksheet problems. Impress your co-workers by learning how to add functional and eye-catching controls to any worksheet, and find out how to nest one function inside another to accomplish just about anything Excel has to offer.
Continuing Education Level
Continuing Ed - Open Classes