Diploma in Advanced Microsoft Excel and Dashboard Reporting (Islamabad)

PROGRAM DESCRIPTION

Microsoft Excel is one such application which does not require any preaching to be used. It is the choice of billions of corporate users due to its power, speed & simplicity of use. Most people have a basic understanding of Excel but a few really know where to find the Excel’s most effective & efficient power features. This course contains everything you need to know & learn about Excel. It is designed to fill the void by providing a comprehensive training on Excel’s most powerful features. This course is designed with a practical, easy-to-learn approach toward unleashing the power of Microsoft Excel to build interactive management dashboards and advanced data analysis and reporting features. Promising 72 hours of hands-on learning in 12 days, the course is aimed to train participants from Basic to an Expert!

PROGRAM CONTENTS

• Understanding the Excel Interface
• Navigation & Basic Commands
• Workbook and Worksheet Management
• Data Types and Data Entry Techniques
• Cell, Row, and Column Formatting
• Conditional Formatting
• Real-World Application Exercises
• Essential Math/Stats Functions: SUM, AVERAGE, MIN, MAX, COUNT, LARGE, SMALL, FLOOR
• Essential Text Functions: UPPER, LOWER, PROPER, FIND, TEXT, LEFT, RIGHT, MID
• Date & Time Functions: NOW, DATEDIF, EDATE, NETWORKDAYS, WEEKDAYS, YEAR, MONTH, HOUR, MIN
• Using Logical Functions: IF, IFS, AND, NOT, ISNA, IFERROR, ISBLANK, ISNUMBER
• Using Excel Power Functions: SUMIFS, COUNTIFS, AVERAGEIFS
• Using D-Functions: DSUM, DAVERAGE, DMAX, DMIN, DGET
• Lookup Functions: VLOOKUP, HLOOKUP, INDEX, MATCH, CHOOSE
• Working with Smart Tables
• Using Sparklines for Quick Data Trends
• Using Flash Fill for Data Transformation & Separation
• Setting Validation Rules for Data Accuracy
• Custom Views and Filtering Techniques
• Filtering Data for Specific Criteria
• Creating Basic Pivot Tables
• Summarizing Data by Categories and Fields
• Customizing Pivot Table Layouts
• Slicer & Hyperlinks
• Get & Transform Data: Power Query
• Automating Recurring Tasks with Macros
• Creating & Customizing Charts – Column, Line, Bar, Pie and Combo Charts
• Combination Charts (e.g., Line and Bar)
• Chart Customization for Presentation
• Using Excel Business Modeling Tools: Goal Seek & Data Tables
• Conditional Formatting and loads of Excel Tips & Tricks
• Introduction to Dashboards
• Preparing & Analyzing Dashboard Data
• Building Interactive Dashboards with Forms Control
• Advanced Charting & Formatting Techniques
• Creating Dashboards with Pivot Tables & Slicers
• Using Pivots, Hyperlink, Connections to Create Interactive Dashboards
• Practical Dashboard Building Exercise
• Presenting Data Insights Effectively

LEARNING OUTCOMES

After the workshop, you will be able to:

• Take your Excel proficiency form Basic to
• Become more efficient in data analysis and
• Apply complex Excel functions and tools
• Better able to solve business problems using
• Able to produce high-quality interactive dashboards
• Master the art of charting and visualizations
• Become more proficient in using complex Excel data analysis and reporting features

PROGRAM DURATION/DAYS

The program is of 3 Months duration. Classes will held on Tuesday & Thursday 05 pm to 08 pm.

WHO SHOULD ATTEND?

Ideal Participants for Excel & Dashboard Training

• Accounting and Finance Professionals
• Business Analysts
• Sales and Marketing Professionals
• Small Business Owners and Entrepreneurs
• Human Resources and Recruitment Professionals

FOR DETAILS & REGISTRATION

Plot No. 12-K, Sitara Market, Sector G-7 Markaz, Islamabad
Phone: 0519252651, 0519252652
Fax: (+9251) 9252653
E-mail: pimisb@pim.com.pk, pimislamabad@pim.com.pk