YoVDO

Excel 2021 Expert Tutorial

Offered By: Learnit Training via YouTube

Tags

Microsoft Excel Courses Data Cleaning Courses Pivot Tables Courses Macros Courses Data Organization Courses

Course Description

Overview

Master advanced Excel 2021 techniques in this comprehensive tutorial designed for users of all levels. Explore nested functions, database operations, and powerful lookup tools like XLOOKUP. Learn to manipulate data efficiently with UNIQUE, SORT, SORTBY, and FILTER functions. Dive into the LET function for complex calculations and discover how to consolidate data from multiple sources. Gain an introduction to macros and learn how to record and play them to automate repetitive tasks. Enhance your spreadsheet skills and boost productivity with hands-on exercises and expert guidance throughout this hour-long video course.

Syllabus

Start
Introduction
Nesting Functions
Database Functions
XLOOKUP
UNIQUE
SORT and SORTBY
FILTER
LET
Consolidate
Introduction to Macros
Recording and Playing Macros
Conclusion


Taught by

Learnit Training

Related Courses

Excel 2010
Miríadax
Excel Avanzado
Miríadax
Problem Solving with Excel
PwC via Coursera
Excel: gestión de datos
Universitat Politècnica de València via edX
Excel によるデータの分析と可視化
Microsoft via edX