This hands-on course will advance your data massaging, modeling, integration and automation skills to new levels. You will also expert normalization and massaging of noisy data, preparation of reports, analysis and reconciliation.  This course is Excel based allowing you to develop an exclusive level of expertise and adding immediate value to your job and company.

Section 1: Fundamentals of Business Analysis

• Difference between database and Reports
• Turning Numbers into Better Business Decisions

Section 2: The Business Analyst’s Excel Toolbox

• Essential Excel for Business Analysis
• Professional Tools for Business Analysts

Section 3: Collecting and Managing Business Data

• Importing and Exporting Data
• Power Functions for Managing Business Data

Section 4: Communicating Your Message

• Your Stakeholders and Their Needs
• Data Presentation Formats That Work

Section 5: Winning Charts for Business Communication

• Professional Charting
• Dynamic Charts
• Some Special Charts for Business Analysis

Section 6: Looking Inside Your Data (Analysis)

• Analyzing Data with Pivot Tables & Charts
• Managing Pivot Tables Output
• Creating Dashboard Report

Section 7: Comparing Business Scenarios

• Decision Making with Compared Scenarios
• The Scenario Manager

Section 8: Looking Outside Your Data (Forecasting)

• Time Series and Forecasting
• Working with Moving Averages

Ms. Sumaira Ghauri

She is the First Female Microsoft Office Corporate Trainer in Pakistan and Certified Microsoft Office Specialist (MOS) Expert Level
She is a Corporate Trainer, Course Facilitator, Lecturer and Public Speaker. She has more than 10 years’ experience working in the Human Resource and General Administration fields holding progressively more challenging positions from HR Generalist to Manager Training

For registering this course, please fill and submit the following form.