Certified MS Excel & Power BI Professional Program – Karachi

MS Excel / IT

Certified MS Excel & Power BI Professional Program – Karachi

Teachers
Muhammad Aleem Habib
Category:
Diploma/ Diploma at Karachi/ Upcoming Diploma/ Upcoming Diploma at PIM Karachi/
₨36,000.00
57 Reviews

₨36,000.00

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

Starting From 28 August, 2022

@ PIM, Karachi.

Download Registration Form

INTRODUCTION

Microsoft Excel is the leading and most demanding tool used in the industry for data analysis and reporting. Excel has hundreds of formulas and functions, dozens of data analysis and reporting tools and thousands of hidden tips and tricks to take care of all of your professional spreadsheet analysis needs!

This course will help you to master all the essential functions, tools, and features of Microsoft Excel, taking your Excel efficiency form Basic to Advance level. On completion of this course, participants are competent to use the full features of the Microsoft Excel, making them an invaluable resource for their companies, accelerate their productivity and improve organizational performance.

OBJECTIVES

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

PROGRAM CONTENTS:

  • Fundamentals of Excel
    • Understanding Ribbon Interface
    • Formula Basics & Cell References
    • Auto Fills / Flash Fill / Custom Lists
    • Working with Basic Excel Functions
    • Using Smart Tables
    • Sorting & Filtering Data
    • Working with Conditional Formats
    • Working with Charts
  • Advanced 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
    • Using Form Controls
  • 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

 

  • Creating Macros & Functions
    • Writing Customized Macros
    • Creating Custom Excel Functions
    • Working with Excel Addins

 

  • Mastering Power Excel Tools
    • Get and Transform Data using Power Query
    • Analyze your BIG data using Power Pivot
    • Create Amazing Visualizations in a flash with Power View
    • Visualize and Animate your Geo-Spatial Data using 3D Power Maps

 

  • Exploring Latest Version of Power BI Desktop
    • Get/Transform and Analyze your data from any source
    • Using DAX Functions
    • Create Drill Down Charts with Reports View
    • Share your reports online

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

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- 36,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, 0343-2499855 & 0333-3028660

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.7
₨36,000.00
29 Ratings

Detailed Rating

Stars 5
0
Stars 4
0
Stars 3
0
Stars 2
0
Stars 1
0
  • 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