Build Excel Models using Advanced Formulas, VBA, Power Query
ExActProBi
Design Robust Excel Models for Accounting and Reporting, learn to Build Automated Dashboards using Power Query and VBA
- 424 students
- Online
- 6 hours · Self-paced
- Certificate(s) included
- Tutor support
...of DATEVALUE function Basics of IF Function Basics of IFS Function (Office 2019 or Microsoft 365) Basics of VLOOKUP Function Basics of MATCH Function Basics of INDIRECT Function Basics of NAMED Ranges (Name Manager) Advanced Version of VLOOKUP Function (All other formulas combined)
…