
Software EngineeringMeetupFreeOnline
Learn Excel from A to Z: Beginner to Job-Ready, Live
Sat 19 Sept · 05:30
50–200 attendees
About this event
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.
Source: meetup