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

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