PIM Karachi Certified MS Excel Professional Program With Power BI Tools Course 2019
Starting From 17 March, 2019
@ PIM, Karachi.
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
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.
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
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
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
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.
Duration: Three Months, Sunday Only (10:00 AM to 4:00 PM)
Lectures: All Hands-on