Certified Excel Professional Program With Power BI Tools – Karachi
Certified Excel Professional Program With Power BI Tools – 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
- Exploring All New Microsoft Power BI 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 Power BI Desktop Application
METHODOLOGY
100% Hands-on through computer lab exercises.
PARTICIPANT PROFILE
This program is hugely beneficial for engineers, project managers, finance and account professionals, business analysts, fresh graduates or anyone who want 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
Rs 36,000/- training investment includes hands-on training, refreshments and business networking.
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-2464634, 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
This site uses Akismet to reduce spam. Learn how your comment data is processed.
₨36,000.00
Duration: Three Months, Sunday Only (10:00 AM to 4:00 PM) |
Lectures: All Hands-on |
PIM Certificate |
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
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