Brainberg
Learn Excel from A to Z: Beginner to Job-Ready, Live
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