YoVDO

Excel Power User Beginner Tutorial

Offered By: Learnit Training via YouTube

Tags

Microsoft Excel Courses Data Mining Courses Data Analysis Courses VLOOKUP Courses INDEX function Courses MATCH function Courses

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

Social Network Analysis
University of Michigan via Coursera
Intro to Algorithms
Udacity
Data Analysis
Johns Hopkins University via Coursera
Computing for Data Analysis
Johns Hopkins University via Coursera
Health in Numbers: Quantitative Methods in Clinical & Public Health Research
Harvard University via edX