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
Документы и презентации в LaTeX (Introduction to LaTeX)Higher School of Economics via Coursera Excel Avanzado
Miríadax Excel aplicado a los negocios (Nivel Avanzado)
Universidad Austral via Coursera Excel Skills for Business: Intermediate II
Macquarie University via Coursera Diseño de sistemas de información gerencial para intranet con Microsoft Access
Universidad del Rosario via edX