Excel Power User Beginner Tutorial
Offered By: Learnit Training via YouTube
Course Description
Overview
Dive into an advanced Excel tutorial designed for power users seeking to elevate their spreadsheet skills beyond the basics. Learn to harness the full potential of VLOOKUP, master the intricacies of INDEX and MATCH functions, and explore array formulas for complex data analysis. Discover how to create dynamic named ranges using OFFSET, streamline your workflow with the Name Manager, and apply sophisticated conditional formatting techniques. Gain insights into expediting data analysis, solving time-intensive tasks, and pushing Excel to its limits with innovative problem-solving approaches. Access accompanying exercise files and manuals to practice newly acquired skills throughout this comprehensive 1 hour and 44-minute learning experience.
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
Related Courses
Análisis de datos: Llévalo al MAX()Delft University of Technology via edX Create Charts and Dashboard using Google Sheets
Coursera Project Network via Coursera Data Processing and Analysis with Excel
Rochester Institute of Technology via edX Grab Data Fast with Vertical and Horizontal LOOKUP
Coursera Project Network via Coursera Evaluate Profit Margins with VLOOKUP in Google Sheets
Coursera Project Network via Coursera