Pakistan Institute of Management · Developing management excellence since 1954
Karachi · Lahore · Islamabadinfo@pim.com.pk
Get in Touch
PIM PROGRAM

Certified MS Excel and Power BI Professional Program

Become a data-driven professional with PIM's **Certified MS Excel & Power BI Professional Program**. This comprehensive, hands-on training equips participants with advanced Excel skills, powerful data analysis techniques, interactive dashboard development, Power Query, data modeling, and Power BI visualization capabilities. Learn to transform raw data into meaningful business insights, automate reporting, and make informed decisions through practical exercises and real-world business scenarios. Ideal for executives, managers, analysts, finance professionals, and anyone looking to enhance their data analytics and business intelligence skills.

About this program

Certified MS Excel and Power BI Professional Program

Program Overview:

This program will help you to master all the essential functions, tools, and features of Microsoft Excel and Power BI, taking your data analysis and visualization efficiency from basic to advanced level. Microsoft Excel & Power BI allows users to store, analyze, and visualize big data. Learn these game-changing technologies to analyze massive business data with ease. This program is designed with a practical, easy-to-learn approach toward unleashing the clout of Microsoft Excel & Power BI.

Learning Outcomes:

  •  Set yourself apart as an MS Excel & Power BI expert
  • Demonstrate data analysis & reporting mastery at the workplace
  • Build credibility through proof of skills
  • Possess professional credentials
  • Prepare you for Microsoft’s Online Exams

Program Outline:

  • Fundamentals of Excel
    • Formula Basics & Cell References, Auto Fills / Flash Fill / Custom Lists, Working with Basic Excel Functions, Using Smart Tables, Working with Conditional Formats, Working with Charts
  • Advanced Excel Features
    • Using Array Formula, Working with Named Ranges, Using Complex Excel Functions, Using Multi-sheet Formulas, Using Advanced Filters, Data Validation & Protection, Consolidation & List Management, Automating with Macros
  • Advanced Reporting & Dashboards
    • Business Reporting with Pivot Tables, Working with Slicers, Advanced Charting & Visualizations, Using Spark-line Charts, Creating Interactive Dashboards using Form Controls
  • Mastering Power Excel Tools (Power Query/Power Pivot)
    • Get and Transform Data using Power Query, Analyze your BIG data using Power Pivot
  • Using Power BI Desktop to Create Amazing Dashboards
    • Fundamentals of BI
      • Introduction to BI and Big Data Analysis, Power BI Key Features
    • Get & Transform Data with Power Query
      • Getting Data with External Sources, Transforming Malformed Data, Merging & Appending Queries
    • Modeling Big Data with DAX & PowerPivot
      • Introduction to Data Modeling, Creating Calculated Columns, Measures & KPIs, Working with DAX
    • Unleashing Power BI Visualizations
      • Creating Charts Visualizations, Tables, Matrices, KPI & Cards, Slicers & Timeline Slicers, Scatter & Bubble Charts & Play Axis, Drill Down/Up Charts
    • Publishing and Sharing Dashboards
      • Power BI Cloud Service Setup, Setting Up Workspaces, Publishing Dashboard to PBI service cloud
    • Synchronizing and Refreshing Datasets
      • Setting up Gateways, Setting Refresh Schedule of Datasets

Methodology:

100% Hands-on through computer lab exercises.

Who Must Attend:

This program hugely benefits engineers, project managers, finance and account professionals, business analysts, fresh graduates, or anyone who wants to boost their spreadsheet analysis and reporting skills.

Program Duration / Days / Timings:

The Program is of three-month duration. Classes will be held on Sundays (10:00 am to 04:00 pm).

Learning Investment:

The fee for the entire program is Rs- 51,000 /- (Fees are Exclusive of All Taxes).

For details and registration please contact the Diploma Office,

Diploma Office, Management House, Shahrah Iran, Clifton, Karachi
Voice Dir: (+9221) 99251 669 EPABX: (+9221) 9925 1711-14 Fax: (+9221) 9925 1715-16
Cell: 03432499855, 03337326730, 03122464635, 03333028660

E-mail: diplomakhi@pim.com.pk  or aleem@pim.com.pk

Meet your instructor

Upcoming sessions