Excel 2021 Expert Tutorial
Offered By: Learnit Training via YouTube
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 2010Mirí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