Advanced Excel & Power Automate for Business

Wishlist Share

About Course

Work faster with advanced Excel (XLOOKUP, pivot tables, Power Query) and automate routine tasks with Power Automate.

Who this training is for

  • Finance, HR, sales and operations teams
  • MIS executives

Syllabus

  1. Module 1: Formulas — XLOOKUP, IFs, dynamic arrays
  2. Module 2: Pivot tables — Analysis and dashboards
  3. Module 3: Power Query — Clean and combine data
  4. Module 4: Power Automate — Flows, approvals, notifications

🏢 Training your team?

This course is available as live online batches, onsite workshops at your office, or self-paced access for your employees with progress reports for HR. The syllabus can be tailored to your systems and projects.

🎁 Book a free demo for your team Corporate plans

Show More

What Will You Learn?

  • Use XLOOKUP, dynamic arrays and pivot tables
  • Clean data with Power Query
  • Build simple dashboards
  • Automate approvals and emails with Power Automate

Course Content

Module 1: Formulas
XLOOKUP, IFs, dynamic arrays

Module 2: Pivot tables
Analysis and dashboards

Module 3: Power Query
Clean and combine data

Module 4: Power Automate
Flows, approvals, notifications

Student Ratings & Reviews

No Review Yet
No Review Yet
Scroll to Top