YoVDO

Excel 2021 Power User Tutorial

Offered By: Learnit Training via YouTube

Tags

Microsoft Excel Courses Data Analysis Courses VLOOKUP Courses XLOOKUP Courses

Course Description

Overview

Master advanced Excel 2021 techniques in this comprehensive power user tutorial. Dive deep into database functions, including XLOOKUP, VLOOKUP, INDEX, and MATCH. Explore two-way searches with XLOOKUP, manipulate text functions, and create advanced pivot tables. Learn to utilize INDEX MATCH array functions, implement advanced conditional formatting, and design sophisticated Excel charts. Gain an introduction to macros and explore practical macro examples. Designed for experienced Excel users seeking to enhance their skills, this tutorial provides in-depth knowledge on intermixing tools to solve complex problems efficiently and push Excel to its limits.

Syllabus

Start
DB Functions, XLOOKUP, VLOOKUP, INDEX, MATCH
Excel XLOOKUP Two-Way Search
Text Functions
Advanced Pivot Tables
INDEX MATCH Array Function
Advanced Conditional Formats
Excel Charts
Introduction to Macros
Macro Examples
Conclusion


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