ABOUT THE COURSE:

Unleash the Power of MS Excel to master all the essential functions, tools and features taking your efficiency from Basic to Advance level.

Upon completion of this course, participants will become competent to use the features of the Micro- soft Excel, making them an invaluable resource for their companies; accelerate their productivity; and improve organizational performance.

Achieve confidence by joining this course and attract new career opportunities by entering in to the world of Business Intelligence with Data Visualisation.

WHAT YOU WILL LEARN

    Leverage tools and functions to format and prepare data in MS Excel

    Represent data by highlighting trends using Pivot Tables

    Use data security features to protect and distribute MS Excel files

    Construct interactive power dashboards by applying business intelligence tools to make data-driven decisions

    Present dashboards with impact using MS PowerPoint Presentation

COURSE OUTLINE:

    1.1 Overview (Interface/Tools/Options)

    1.2 Security (Editing/Restricted sharing/ Book-Sheet-Cell Production)

    1.3 Tips & Tricks (Short Keys/ Techniques)

    2.1 Cleaning Formulas (Text/Trim/IsText/Right/Left/Mid/Upper/Lower/Proper/Len/Clean/Find)

    2.2 Conditional Formatting

    2.3 Subtotal/Aggregate

    2.3 Flash Fill/Fill Series

    2.4 Text to Column (Fixed/Delimated)

    2.5 Remove Duplicate (By Conditional Formatting)

    2.6 Tips & Tricks (Short Keys/ Techniques)

    3.1 Data Validation

    3.2 Group/UnGroup Data

    3.3 Conditional Formatting (Simple/Advance)

    3.4 Data Consolidations

    3.5 Filtering (Simple/Advance)

    3.6 Tips & Tricks (Short Keys/ Techniques)

    4.1 Time Intelligence (Dateif/Now/Today/Workday/Networkdays

    4.2 Logical Operation Functions (IF/IFS/OR/NOT/AND/SUMIFS/COUNTIFS/AVGIFS/MAXIFS/MINIFS/SWITCH)

    4.3 Look-Ups (Vlook-up/Hlook-up/Index/Match)

    4.4 Troubleshoot Formulas

    4.5 Tips & Tricks (Short Keys/ Techniques)

    5.1 What if Analysis (All 3 functions)

    6.1 Power Query - ETL (Extract/Transform/Load) Automate Daily Task

    6.2 Table/pivot Tables/Power Tables

    6.3 Tips & Tricks (Short Keys/ Techniques)

    7.1 Theory Discussion on Types of Visuals (KPS's Card/Chart's/Visuals/Slicer/Timeliner)

    7.2 Create Automated System

    7.3 Create Automated Dashboards

    7.3 Tips & Tricks (Shortkeys/Techniques)

TRAINER PROFILE

Uzair Rasheed Baig

Advanced MS Excel: Business Intelligence with Data Visualization

Experienced business and data analyst consultant, associated with many industries like FMCG, Retail, Textile, HR, IT, Telecommunication, Banking, and NGO

He is currently associated with Hilal Food Group Pvt Ltd, in the capacity of Associate Manager – Business Intelligence, further also serving as a seasonal consultant in Arthur Lawrence Group LLC (USA) as a Business Analyst.

DURATION

24 Hours

PRE-REQUISITE

Anyone can join

VALUE ADDED SERVICES

  • Experienced professional trainers with practical field exposure
  • 100% job and business oriented training
  • Certificate of completion recognized from Trade Testing Board, Government of Pakistan
  • Claim Continuing Professional Development (CPD) hours for the training
  • Video recorded session with personalized Learning Management System (LMS) access login id
  • Lifetime access to exclusive YouExcel alumni via WhatsApp and Facebook groups
  • Fully equipped training center venue for on-campus trainings readily available with laptops, projectors and air-conditioning
  • Virtual training facility available
  • Guest speaker sessions for latest market insights from business leaders

CAREER-PATHS

  • You can enter in any career once you learn and apply MS Excel