Description
In this course, you will :
- learn the most essential Excel Skills for Accounting and Financial Professionals - Skills that will enhance you career
- Logical tests and IF statements
- VLOOKUP, INDEX & MATCH and XLOOKUP
- Sum with conditions (SUMIF SUMIFS)
- Tables for efficiency
- Pivot tables
- Dynamic Arrays
Syllabus :
Introduction
- Logical tests
- IF Statements
- VLOOKUP
- INDEX and MATCH
- S is for Super Power (summing with conditions attached)
- Efficiency with Tables
- Explaining Pivot tables in 10 minuites
- Introducing Dynamic Arrays
- Pivot table alternative using Dynamic Arrays (UNIQUE SORT AND TRANSPOSE)
- The FILTER function
- XLOOKUP