Excel Power Userwww.learnit.com/files

Instructor: Tom Vorves

www.tomvorves.com

Us

Tom

Wish List

Morning Topics Data Mining Techniques Index & Match functions Using Index &

Match Array Functions Creating Dynamic Ranges Advanced Conditional Formatting

Afternoon Topics Creating Waterfall charts Creating charts from a dynamic data source Using a spin control to adjust a chart’s data

source Creating calculated fields and items in a Pivot

Table Creating Pivot Table templates Importing Data from a Web Site Enhancing macros with VBA scripting

Zoomit Drawing tool Google Search for “zoomit” select the technet.Microsoft link Download the zip file drag ZoomIt out of zip file Double click the zoomit.exe file The controls and instructions are in the System

Tray