Home / Diploma Courses / PIM Karachi Certified MS Excel Professional Program With Power BI Tools Course 2019

PIM Karachi Certified MS Excel Professional Program With Power BI Tools Course 2019

PIM Karachi Certified MS Excel Professional Program With Power BI Tools Course 2019

Starting From 17 March, 2019
@ PIM, Karachi.

PROGRAM DESCRIPTION

Microsoft Excel is the leading & most demanding tool used in the industry for data analysis and reporting. Excel has hundreds of formulas & functions, dozens of data analysis & reporting tools and thousands of hidden tips & 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 the completion of this course, participants are qualified to use the full features of the Microsoft Excel, making them an invaluable resource for their companies, accelerate their productivity and improve organizational performance

PIM Karachi Certified MS Excel Professional Program With Power BI Tools Course 2019

SALIENT FEATURES

Vastly experienced and certified trainers.
State of the art fully air-conditioned computer labs with multimedia projectors.
Individual guidance & support to every participant during lab sessions.
Up-to-date course material & manual.
Thousands of MS Excel productivity tips & tricks.

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 Reporting & Dashboards
Business Reporting with Pivot Tables
Working with Slicers
Advanced Charting & Visualizations
Using Spark-line Charts
Creating Interactive Dashboards using Form Controls
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 Map

ALSO READ  University of Karachi CSS Course Preparations 1-2019 Batch

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
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

TARGET AUDIENCE

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.

For Details & Registration

PAKISTAN INSTITUTE OF MANAGEMENT

Shahrah-e-Iran, Clifton Karachi: Tel: (021) 99251711-14, 99251669, FAX: 99251715-16

E–Mail: diplomakhi@pim.com.pk

About Instructors

Muhammad Aleem Habib

IT, General & Project Management

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

Fees: 36,000.00

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

Check Also

Pakistan Cotton Standards Institute PCSI Sukkur Cotton Selectors Training Course 2019

Pakistan Cotton Standards Institute PCSI Sukkur Cotton Selectors Training Course 2019

Pakistan Cotton Standards Institute PCSI Sukkur Cotton Selectors Training Course 2019

Leave a Reply

Your email address will not be published. Required fields are marked *