Udemy - Excel 2019 Advanced (2022) torrent

Excel 2019 Advanced (2022)
https://DevCourseWeb.com

Published 05/2022
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch
Genre: eLearning | Language: English + srt | Duration: 26 lectures (1h 32m) | Size: 706.1 MB

Unlock the true potential of Excel with powerful tools like lookups, error-handling, macros, and scenario analysis

What you'll learn
Use database functions like VLOOKUP(), SUMIF(), and AVERAGEIF()
Fix errors using auditing or handle inevitable errors with backup values
Apply data cleanup and isolation/consolidation techniques
Find optimal values for a single cell or a set of inter-related cells
Create and run basic macros to automate repetitive tasks
Add macros to the Excel ribbon

Requirements
Familiarity with Excel's primary features
Recommended: Completion of our Excel 2019 Intermediate course