01
Advanced Excel for administrative tracking & reporting
You will learn: Excel: IF, SUMIFS, COUNTIFS, XLOOKUP/VLOOKUP, filters, data validation, conditional formatting, PivotTables and charts for administrative reporting.
02
Advanced Excel for accounting, cash management & financial tracking
You will learn: Excel: cashbook, SUMIFS, balance checks, reconciliation, data validation, PivotTables and charts to track income, expenses and cash position.
03
Advanced Excel for HR, personnel & dashboards
You will learn: Excel: personnel database, date functions, COUNTIFS, drop-down lists, conditional formatting, PivotTables and charts for attendance, leave and HR indicators.
04
Advanced Excel for sales tracking, customers & sales
You will learn: Excel: prospect/customer database, XLOOKUP, SUMIFS, filters, PivotTables, charts and dashboards for pipeline, sales, follow-ups and commercial performance.