This advanced Excel course is designed for users proficient in Excel tools and processes, aiming to enhance problem-solving skills and efficiency. Participants will learn to intermix tools in Excel for time-intensive tasks, delve into data mining tools like VLOOKUP, and explore advanced functions like INDEX, MATCH, and OFFSET. The course emphasizes expediting data analysis through dynamic ranges and pushing Excel's capabilities with new problem-solving perspectives. The teaching method includes hands-on exercises and practical examples. The course is intended for advanced Excel users seeking to enhance their skills and efficiency in data analysis and problem-solving.
Overview
Syllabus
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
Taught by
Learnit Training
