Certified MS Excel Professional With Power BI Tools – Karachi
MS Excel / IT
Certified MS Excel Professional With Power BI Tools – Karachi
₨36,000.00
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,
Pakistan Institute of Management, Management House, Shahrah Iran, Clifton, Karachi
Telephones: (021) 99251669 EPABX 99251711-14 Fax Nos: (021) 99251715 & 99251716
Website: www.pim.com.pk, E-mail: diplomakhi@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.
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