Members save on registration & get special perks. Learn More
In this hands-on workshop, you'll learn how to use scenarios and data tables to quickly perform multiple what-if analyses. You'll discover a variety of advanced pivot table techniques, like creating calculated fields and calculated items. You'll 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. Completion of Intermediate MS Excel 2003 or equivalent experience is required.