Certified MS Excel & Power BI Professional Program – Karachi

MS Excel / IT

Certified MS Excel & Power BI Professional Program – Karachi

Teachers
Muhammad Aleem Habib
Category:
Active/ Diploma/ Diploma at Karachi/ Upcoming Diploma/ Upcoming Diploma at PIM Karachi/
₨41,000.00
60 Reviews

₨41,000.00

Duration: Three Months, Sunday Only (10:00 AM to 4:00 PM)
Lectures: All Hands-on
PIM Certificate

Starting From 21 May, 2023

@ PIM, Karachi.

Download Registration Form

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 advance 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 a 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
  • Business Modeling & Data Analysis
    • Using What-If-Analysis Tools: Goal Seek, Data Table, Scenario Manager, Solving Complex Problems with Solver
  • 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 is hugely beneficial for 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 (09:00 am to 03:00 pm).

Learning Investment:

The fee for the entire program is Rs- 41,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: 0312-2464635 0333-3028660 & 0333-3143609

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

About Instructors

Muhammad Aleem Habib
Working as a Deputy General Manager at PIM. His areas of specialization are IT, Project and General Management.

Reviews

Average Rating

4.6
₨41,000.00
30 Ratings

Detailed Rating

Stars 5
0
Stars 4
0
Stars 3
0
Stars 2
0
Stars 1
0

  • No, only at Clifton.

  • 3 out of 5

    is this program also available for online platform ?

    • No, its in-class physical program.

  • 4 out of 5

    Interested and want to enroll myself

    • Please contact Diploma Office 021-99251669

  • 5 out of 5

    Any Discount Plan ?

  • 5 out of 5

    Is this course is already started ?

    • Just intro class, starting from 26th Sep.

  • 4 out of 5

    please can I learn this course in an online mode

    • Sorry but this is an in-person in-class program.

  • 5 out of 5

    I am banker and want to know that online classes are available?

    • Physical classes. In case of ban on physical classes by govt, may switch to online temporarily.
      Thanks

  • 5 out of 5

    Hi,

    Has this course started ?

    Thanks,

    • Yes.

  • 4 out of 5

    Hi, Could you please tell me classes will be online or Physical?

    • Physical classes with SOPs – Mask, Social Distance and Sanitizer.

  • 4 out of 5

    Please share the address where class will conduct.

    • PIM, Adjacent to Park Towers, Clifton.

  • 5 out of 5

    Can i get a discount.. I need to learn this course.. but i am a student and i am facing many problems durings data validation and all .
    36000 is very big amount.. I am a student. Can i get a discount and pay fee in three installment after discount??

    • Please contact diploma office at 021-99251669 ?(Mr Wasi). Thanks

  • 4 out of 5

    last date to apply?

    • 02-Jun-2021

  • 5 out of 5

    I am interested in this program specially in Power BI because I have to consume a lot of my time in data analysis and reporting. Please allow me to ask if this diploma is also being offered online because I am based in Sialkot.

  • 5 out of 5

    Are you offering it online due to covid 19

    • Yes, current batch classes are shifted to online since lock-down. For this new batch, If situation and government allows, then we will have physical classes otherwise online.

  • 5 out of 5

    Is this going to run in Lahore???

    • No, only in Karachi, till now.

  • 5 out of 5

    Unable to download Registeration Form.

    • Fixed now, please check. Thanks for informing!

  • 5 out of 5

    It will be good

    • IA. Do join please!

  • 5 out of 5

    Great Course but very costly i am interested but 12 or 13 classes very costly course, any discount available b/c it is more than income range.

    • 12 classes of 6 hours each i.e 12 X 6 = 72 Hours of hands-on Excel. We provide you lunch and tea, individual PCs for each participant (not asking for your personal laptop like others), course material, mineral water for drinking and all the amenities in a peaceful learning environment under the guidance of certified and experienced trainers.
      Program covers almost all areas of Excel that others offers in Pieces. So compare the fee in totality with other offerings!
      Thanks for contacting us.

  • 5 out of 5

    Really it’s Excellent. But seriously fees is to high. Management have to take decisions Adjust and revise fee structure.

  • 5 out of 5

    Extremely effective course but Expensive, I am interested Can i get discount?

    • Please Contact 021-99251669

  • 4 out of 5

    What are the prerequisites for the course?

  • 4 out of 5

    course seems good but rate is high , emailed at “dimlomakhi@pim.com.pk”
    but got no reply.

    • Please Call 021-9925169, 0333-3028660

  • 5 out of 5

    i am in Lahore and wants to take this course kindly advise.

  • 4 out of 5

    Extremely effective course and i am very much interested but it’s expensive I hardly pay 12000 for this course can i get some sort of discount?

  • 5 out of 5

    When will you start again?

    • 14 October, 2018

  • 4 out of 5

    Aren’t we getting the full detailed contents on the tools of Power BI desktop and view ?

    • Please contact 021-99251669

  • 5 out of 5

    fee is so high . I hardly can afford 12000

    • Please contact Diploma Office 021-99251669

  • 5 out of 5

    I am interested to join this course, please advice last date of form submission than i will visit and submit the form timely.

    Regards

    Zia Ahmed

    • Last date is 5th July, 2018 but don’t wait for last date as seats are limited. You can download and submit the form through email (diplomakhi@pim.com.pk)

      Thanks

  • 5 out of 5

    Course is very intresting but as usuall the fees is too much high which is out of range. I would appreciate if PIM managament look into the fees structure for needy persons.

    • Keeping the contents coverage, facilities, instructor and the level at which we cover the contents make it incomparable to similar program offered by other institutes.

  • Please contact diploma office at diplomakhi@pim.com.pk

    Thanks

  • 5 out of 5

    Its a very good course, but very expensive. Im interested. But can i get some discount i cant afford this fee? Pls

    • Please contact Diploma office 021-99251669

    • Please contact diplomakhi@pim.com.pk

  • 5 out of 5

    Excellent but class timings are not proper

  • Please contact diploma office diplomakhi@pim.com.pk and discuss with them.

  • Please contact diplomakhi@pim.com.pk

Add a review

This site uses Akismet to reduce spam. Learn how your comment data is processed.