Excel Power User Advanced Tutorial

Dive into advanced Excel techniques with this comprehensive tutorial designed for power users seeking to elevate their skills beyond typical tools and processes. Learn to intermix Excel functions for efficient problem-solving, develop a deeper understanding of data mining tools like VLOOKUP, and master advanced solutions such as INDEX, MATCH, and OFFSET functions. Explore dynamic range charts, pivot table enhancements, web data importing, and macro creation. Discover how to expedite data analysis through dynamic ranges and push Excel to its limits with new perspectives on tackling challenging problems. Gain hands-on experience in creating dynamic named ranges, using calculated fields and items, grouping pivot items, and editing VBA code. Perfect for those who have completed basic Excel training and are ready to take their skills to the next level.

Start
Introduction to Dynamic Range Charts
Dynamic Range Chart Data
Defining Dynamic Named Ranges
Defining Dynamic Legend Entries
Defining Dynamic Category Labels
Dynamic Offset
Updating Dynamic Named Ranges
Enabling the Developer Tab
Inserting Spinner Buttons
Linking Spinner Buttons
Outside Formulas in Pivot Tables
Calculated Fields
Calculated Items
Removing Calculated Fields and Items
Grouping Pivot Items
Showing Values As
Importing Web Data
Recording Macros
Running Macros and Selecting Fields of Data
Editing VBA Code