This course is designed for advanced Excel users looking to enhance their skills beyond typical Excel tools and processes. Participants will learn to intermix tools in Excel to accomplish time-intensive tasks, develop a deeper understanding of data mining tools like VLOOKUP, INDEX, MATCH, and OFFSET functions, expedite data analysis through dynamic ranges, and push Excel to its limits with new problem-solving perspectives. The teaching method includes a tutorial format with practical exercises. The intended audience for this course are individuals who have completed Excel 2016 training or are proficient in the skills covered in those courses.
Overview
Syllabus
Start
VLOOKUP
Range Lookup
Autofilling Lookup
Defining Names
Using Named Ranges to Retrieve Data
INDEX
MATCH
INDEX & MATCH Part 1
INDEX & MATCH Part 2
INDEX & MATCH Part 3
Introduction to Array Formula
Array Formula
Array Function
Dynamic Named Ranges Offset
OFFSET Function
Name Manager
Basic Conditional Formatting
Building New Rules and Troubleshooting
Expanding Conditional Formatting Fields
Text Search Conditional Formatting
Data Validating Conditional Formatting
Taught by
Learnit Training
