Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

YouTube

Excel Power User Beginner Tutorial

Learnit Training via YouTube

Overview

Save Big on Coursera Plus. 7,000+ courses at $160 off. Limited Time Only!
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

Reviews

Start your review of Excel Power User Beginner Tutorial

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.