Certified MS Excel & Power BI Professional Program – Karachi
Certified MS Excel & Power BI Professional Program – Karachi
₨36,000.00
Duration: Three Months, Sunday Only (10:00 AM to 4:00 PM) |
Lectures: All Hands-on |
PIM Certificate |
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

Reviews
Average Rating
Detailed Rating
Stars 5 |
|
0 |
Stars 4 |
|
0 |
Stars 3 |
|
0 |
Stars 2 |
|
0 |
Stars 1 |
|
0 |
Add a review Cancel reply
₨36,000.00
Duration: Three Months, Sunday Only (10:00 AM to 4:00 PM) |
Lectures: All Hands-on |
PIM Certificate |
Akhtar Husnain (verified owner)
Interested and want to enroll myself
Amir Ali
Please contact Diploma Office 021-99251669
Tanveer
Any Discount Plan ?
Aisha Naqvi
Is this course is already started ?
siteadmin
Just intro class, starting from 26th Sep.
Mohamed Dahir (verified owner)
please can I learn this course in an online mode
siteadmin
Sorry but this is an in-person in-class program.
Adnan
I am banker and want to know that online classes are available?
siteadmin
Physical classes. In case of ban on physical classes by govt, may switch to online temporarily.
Thanks
Shehzad Muhammad Khan
Hi,
Has this course started ?
Thanks,
siteadmin
Yes.
Faheem Khan
Hi, Could you please tell me classes will be online or Physical?
siteadmin
Physical classes with SOPs – Mask, Social Distance and Sanitizer.
Muzzammil Khan
Please share the address where class will conduct.
siteadmin
PIM, Adjacent to Park Towers, Clifton.
Abdal Munawwar
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??
siteadmin
Please contact diploma office at 021-99251669 ?(Mr Wasi). Thanks
Humna Sajid
last date to apply?
siteadmin
02-Jun-2021
Kashif Ali Qazi
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.
Sania Nisar
Are you offering it online due to covid 19
siteadmin
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.
Khurram Iftikhar
Is this going to run in Lahore???
siteadmin
No, only in Karachi, till now.
KIRAN
Unable to download Registeration Form.
siteadmin
Fixed now, please check. Thanks for informing!
Syed Asif Hidayat
It will be good
siteadmin
IA. Do join please!
Hafeezullah Shaikh (verified owner)
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.
siteadmin
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.
Zubair Ahmed Khan
Really it’s Excellent. But seriously fees is to high. Management have to take decisions Adjust and revise fee structure.
maanansarii (verified owner)
Extremely effective course but Expensive, I am interested Can i get discount?
Amir Ali
Please Contact 021-99251669
Babar Sufyan
What are the prerequisites for the course?
muhammad mahmood alam
course seems good but rate is high , emailed at “dimlomakhi@pim.com.pk”
but got no reply.
Amir Ali
Please Call 021-9925169, 0333-3028660
imran Khalid
i am in Lahore and wants to take this course kindly advise.
Amir Ali
Please Contact 021-99251669 E-mail: diplomakhi@pim.com.pk
Anus Rais
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?
Amir Ali
Please contact Diploma Office 021-99251669 Email; diplomakhi@pim.com.pk
Jamal Hassan
When will you start again?
Amir Ali
14 October, 2018
abbas
Aren’t we getting the full detailed contents on the tools of Power BI desktop and view ?
Amir Ali
Please contact 021-99251669
noshad
fee is so high . I hardly can afford 12000
Amir Ali
Please contact Diploma Office 021-99251669
Zia Ahmed
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
pim_admin
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
Bilal BUtt
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.
pim_admin
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.
pim_admin
Please contact diploma office at diplomakhi@pim.com.pk
Thanks
Hasan qaiser
Its a very good course, but very expensive. Im interested. But can i get some discount i cant afford this fee? Pls
Amir Ali
Please contact Diploma office 021-99251669
pim_admin
Please contact diplomakhi@pim.com.pk
Sohail
Excellent but class timings are not proper
pim_admin
Please contact diploma office diplomakhi@pim.com.pk and discuss with them.
pim_admin
Please contact diplomakhi@pim.com.pk