Learn to use Excel more effectively in your accounting work.
Overview
Syllabus
Introduction
- Being good at Excel
- Absolute and relative references
- Using references to build spreadsheets
- Loan and financial functions
- Date functions
- How time works in Excel
- IF formulas
- Using XLOOKUP
- Importance of VLOOKUP
- PivotTables
- COUNTIF and SUMIF
- COUNTIFS and SUMIFS
- SUMIF(S) for accounting and finance
- Charts and graphs
- Error checking
- Excel best practices
- Common problems and troubleshooting
- Let's get started
Taught by
Steve Friedman and Madecraft
