Welcome to the Course

Module-1: Introduction

Lesson-1: Introduction to Combing & Import Data

Lesson-2: Copy Paste

Lesson-3: Load from File

Lesson-4: Combine CSV

Lesson-5: Combine Script

Lesson-6: Data Types

Module-2: Combing & Import Data

Lesson-1: Index Match for Complex Lookups

Lesson-2: Index for Dynamic List Selection

Lesson-3: Index for Dependent Drop-down Lists

Lesson-4: Handle Multiple Criteria (Part-1)

Lesson-4: Handle Multiple Criteria (Part-2)

Lesson-4: Handle Multiple Criteria (Part-3)

Lesson-5: Searchable Drop-Down List

Lesson-6: Multiple Dependent Drop-Down Lists

Lesson-7: Picture Lookup

Lesson-8: INDIRECT function for Flexible References

Lesson-9: Multiple Matches

Lesson-10: OFFSET function

Lesson-11: CHOOSE function

Lesson-12: Excel T and N Functions for Tracking

13. ROW(), ROWS(), COLUMN(), COLUMNS()

Lesson-14:  Excel Top N Report

Lesson-15: 3D Formula

Module-3: Dashboard Formula Toolbox

Lesson-1: Introduction

Lesson-2:  Excel Pivot Tables Inside Out

Lesson-3: Excel Pivot Chart and Slicer

Lesson-4: Excel Slicer using Symbols

Lesson-5:  Excel Pivot Tables Tips and Tricks

Lesson-6: Handling Dates in Pivot Tables

Module-4: Data Exploration

Lesson-2: Tree-Map Chart

Lesson-3:  Sunburst, pie and doughnut charts

Lesson-4: Build Impressive Infographics Charts in Excel

Lesson-5: Thermometer Chart

Lesson-6: Gauge Chart

Lesson-7: Excel Variance Charts Displaying Conditional Colors

Lesson-8: Excel Dynamic Chart with Series Selection Check-box

Lesson-9: Creating Waterfall Chart

Lesson-10: Creating a Simple Gantt Chart

Lesson-11: Advanced Gantt Chart (Actual, Planned and Percentage)

Lesson-12: Advanced Gantt Chart (Plan, Actual and Progress in single view)

Lesson-13: Creating a Chart with Actual and Target Values

Lesson-14: Create Dynamic Target Line in Excel Bar Charts

Lesson-15: Color Negative Chart Data Labels in Red with a downward arrow

Lesson-16: Excel Variance Chart

Lesson-17: Highlighting the Maximum and Minimum Values in Line Chart

Lesson-18: Creating Dynamic Pareto Chart.

Lesson-19: Creating a Bullet Chart in Excel

Lesson-20: Creating a Speedometer Chart

Lesson-21: Progress Chart

Lesson-22:  Hidden Chart in Excel

Lesson-23: Male and Female Info-graphics Bar Chart

Lesson-24: Male and Female Info-graphics Fill Chart

Lesson-25: Charting Survey Results

Lesson-26: Dynamic WordArt Bar Chart

Lesson-27: Dynamic Fill Color of WordArt using VBA

Lesson-28: Step Chart in Excel

Lesson-29: Step Chart in Excel using Error Bars

Lesson-30: Dynamic Map Chart

Module-5: Dashboards Charts Toolbox

Lesson-2: Option Button Control Example 1

Lesson-3: Option Button Control Example 2

Lesson-4: Excel Checkboxes Example 1

Lesson-5: Excel Checkboxes Example 2

Lesson-6: Excel Combo Box Control

Lesson-7: Excel List Box Control

Lesson-8: Excel Scrollbar and Spin Control

Lesson-9: Roll Over Effect in Excel Charts

Lesson-10: Recording Your First Macro

Lesson-11: Assigning a Macro to a Button Example 1

Lesson-12: Assigning a Macro to a Button Example 2

Lesson-13: Assigning a Macro to a Button Example 3

Lesson-14: Dependent Combo Box Example

Module-6: Adding Interactive Controls to Your Dashboard

Lesson-2: Power Queries and Trendlines

Lesson-3: Importing Data from Web Pages

Lesson-4: Importing and Combining Multiple Excel Files into One File From Folder

Lesson-5: Get Data from Pdf

Lesson-6: Importing Data from a Formatted Excel Report

Lesson-7: Transform Text in Excel using Power Query

Lesson-8: Convert Columns to Rows using UNPIVOT in Power Query

Lesson-9: Unpivot the Multiple Headers Data

Lesson-10: Time Transformations with Power Query

Lesson-11: Repeat Values using Power Query

Lesson-12: Power Pivot and Data Model

Lesson-13: Creating a Hierarchy of Fields and Drill Up-Down into Data

Lesson-14: Use Power Map to Display Customer Locations

Lesson-15: Use Custom Map Instead of a Globe

Lesson-16: OLAP & DAX - Data Cubes and Cubes Functions

Lesson-17: OLAP & DAX - Visualizing Data using Cube Functions

Lesson-18: Understanding DAX CALCULATE Function

Lesson-19: Creating and Formatting Measures

Lesson-20: Using Advanced DAX Functions

Module-7: Analyzing Data with Business Intelligence

Case Study-1: Hourly Production Dashboard

Case Study-2: After Sales Service Center Dashboard

Module-8: Building Your own Business Dashboard-1

Lesson-1: Hotel Dashboard Overview

Lesson-2: Importing and Cleaning

Lesson-3: Initial Visualization

Lesson-4: Adding Missing Data Fields 

Lesson-5: Adding other Data Trends

Lesson-6: Adding some Measures in Table

Lesson-7: Adding Service Trend

Lesson-8: Calculating Hotel Revenue

Lesson-9: Calculating Top 3 Bookings

Lesson-10: Dashboard Theme and Layout Construction

Lesson-11: Adding Hyperlinks

Lesson-12: Its Time to Refresh Your Data

Lesson-13: Adding Dynamic Table into the Dashboard

Lesson-14: Adding Trends and Charts

Lesson-15: Adding Summary Information

Lesson-16: Adding More Control of Services

Lesson-17: Visualizing the Revenue Data Values

Lesson-18: Adding Revenue Summary

Lesson-19: Adding Interactive Control

Lesson-20: Finalizing and Sharing your Dashboard

Module-9: Building Your own Business Dashboard-II

Advanced Pivot Table Tips and Techniques

Advanced Pivot Table Tips and Techniques- Data 

Module-10: Advanced Pivot Table Tips and Techniques (Bonus Section)

Book 1: Excel Dashboards and Reports

Book 2 Microsoft Excel Pivot Table Data Crunching.pdf

Book 3: Analyzing Data with Power BI and Power Pivot for Excel

Reference Materials 

Module-11: Reference Books and Readings (Bonus Section)

Dashboard Charting Toolbox: Assignments

Data Exploration: Assignments

Adding Interactive Controls to Your Dashboard: Assignments

Analyzing Data with Business Intelligence: Assignments

Case Studies: Sample Dashboard Data Sets 

Assignments

<h2 id="cc0bddb4-292b-4782-8535-8857e7426fa7" data-toc-id="cc0bddb4-292b-4782-8535-8857e7426fa7" style="font-size: 24px; font-weight: 600; line-height: 1.2;"><strong>What's Included In Our Elite "Certified Microsoft Excel Expert (Level-2) Professional" Course?</strong></h2><h3 id="ba57d97c-a96c-4e66-bc00-23b4cf9fdbb8" data-toc-id="ba57d97c-a96c-4e66-bc00-23b4cf9fdbb8" style="font-size: 20px; font-weight: 600; line-height: 1.2;"><strong>MS Excel - Practical Application &amp; Training</strong></h3><p>12 Elite Modules encompass the detailed training of basic till advanced concepts of Microsoft Excel along with practical simulation exercises. Likewise, 24/7 Mentorship support by our Master Trainer is one of the many perks of this training pack</p><h3 id="47365799-f494-41f7-9130-87a6edfb95f4" data-toc-id="47365799-f494-41f7-9130-87a6edfb95f4" style="font-size: 20px; font-weight: 600; line-height: 1.2;"><strong>20+ Case Studies &amp; Simulation Exercises</strong></h3><p>We feel pride in delivering state-of-the-art 15+ case studies and 12+ simulation exercises of concerned tools and techniques.</p><h3 id="bb91041b-b74b-4c4c-b480-f82b7a5123fe" data-toc-id="bb91041b-b74b-4c4c-b480-f82b7a5123fe" style="font-size: 20px; font-weight: 600; line-height: 1.2;"><strong>Globally Verifiable Credential</strong></h3><p>Upon successful completion of the final exam, a globally verifiable credential endorsed by BGMC UK(Bilal Consultancy Limited England) will be issued to the participant, which can be verified by any employee or university if needed.</p><hr><h2 id="be643637-ee00-4a4a-b43b-0e49a69839e3" data-toc-id="be643637-ee00-4a4a-b43b-0e49a69839e3" style="font-size: 24px; font-weight: 600; line-height: 1.2;"><strong>Why Us?</strong></h2><p>Apart from being trained by our Internationally Acclaimed Trainers, our Participant will have the following perks after an enrollment in the course;</p><h3 id="680ead3d-b0b0-4cb5-9be0-6aa6e9867442" data-toc-id="680ead3d-b0b0-4cb5-9be0-6aa6e9867442" style="font-size: 20px; font-weight: 600; line-height: 1.2;"><strong>Globally Verifiable Certificate</strong></h3><p>After the thorough training &amp; examination completion, the participant will be eligible for the distinction award. This Certificate is globally verifiable and acceptable across the world.</p><h3 id="51eb7e2a-24cd-4fcf-89f2-cbaeb051a7c1" data-toc-id="51eb7e2a-24cd-4fcf-89f2-cbaeb051a7c1" style="font-size: 20px; font-weight: 600; line-height: 1.2;"><strong>Practical Learning With Powerful Case Studies</strong></h3><p>With the Practical and Factual prone approach, our premium course is loaded with the diversified case studies which will enable you to learn and implement the findings in a real-time scenario.</p><h3 id="1210ccf3-4678-4622-9b4e-a38b99830a4f" data-toc-id="1210ccf3-4678-4622-9b4e-a38b99830a4f" style="font-size: 20px; font-weight: 600; line-height: 1.2;"><strong>Lifetime Mentoring</strong></h3><p>With an aim to establish the largest operational excellence leaders community, you will be part of the futuristic league. You will have lifetime mentoring support from our Master Trainers. Once enrolled, you will be added into the community which is connected via email &amp; WhatsApp for the 24/7 support assurance to our end participant.</p><hr><h2 id="711f1d3c-8139-4ecd-94e3-d26cd9c9fb4e" data-toc-id="711f1d3c-8139-4ecd-94e3-d26cd9c9fb4e" style="font-size: 24px; font-weight: 600; line-height: 1.2;"><strong>Become Internationally Accredited</strong></h2><p style="text-align: left;">Certified Microsoft Excel Expert (Level-2) Professional</p><p>We feel pride in delivering the internationally Accredited credential, issued by BGMC UK (Bilal Consultancy Limited England) upon successful exam completion.</p><img src="https://import.cdn.thinkific.com/389944%2Fcustom_site_themes%2Fid%2FYdIBlfBIS8GHKIed5mXJ_White%20and%20Blue%20Welcome%20to%20the%20Team%20Greeting%20Instagram%20Post.png" alt="" style="box-sizing: inherit; border-style: none; margin-top: 0px; display: block; width: 562.312px; height: auto; align-self: center; border-radius: 0px;">

This course will enable you to become an MS Excel Expert. In this course, you will
learn the most important tools and techniques that can be used in creating a basic to an advanced effective dashboard. 

Certified Microsoft Excel Expert (Level-2) Professional

BGMC Group

Primary Menu

Certified Microsoft Excel Expert (Level-2) Professional

BGMC Group

What you will learn

Upon successful completion of this course, participants will be able to:

Combine and Import invoice

How to use Excel formulas to add interactivity to your reports

How to analyze a data with Excel PivotTables and Pivot Charts

How to use Excel Power Query for data cleaning and transformation.

How to use Power Pivot to manage huge rows of data without breaking down

How to use DAX measures to speed up analysis

How to build responsiveness in your spreadsheet

How to build Pivot Table-based Hotel Management dashboards for easy interactivity

How to build non-standard Excel charts using smart techniques.

How to create a professional Hourly Production Stats dashboard from scratch.

Course content

Course Description

FAQ