Learn Excel from A to Z: Beginner to Job-Ready, Live
Details
Do registration for this event by filling up this form.
What you'll walk away with:
- KPI Derivation: Practise calculating real business metrics—units per transaction, average order value, click-through rate, conversion rate, and repeat purchase rate—directly from raw transaction data.
- Formulae: Hands-on practice with SUM, AVERAGE, RANK(), RANK.EQ(), COUNTIF/COUNTIFS, SUMIF/SUMIFS, VLOOKUP/XLOOKUP, INDEX-MATCH, and nested IF—applied to build the metrics above, not just isolated examples.
- Pivot Tables: Break down these metrics by region, product, or time period, and rank top and bottom performers instantly.
- Power Query: Clean and merge raw sales/marketing data (removing duplicates, fixing formats, combining sheets) before calculating any of the above.
- Dashboards: Combine all the metrics into one interactive dashboard with rankings, trends, and filters—built live and reusable for your own reports.
Related topics
Business Analytics
Data Analytics
Data Visualization
Power BI
Microsoft Excel
