Welcome to the Course

Lesson-1: Basic Charting Techniques

Module-1: Excel Charting Techniques

Lesson 1: Creating Combination Charts

Lesson 2: Pareto and Histogram Charts

Lesson 3: Tree Map Chart

Lesson 4: Sunburst, pie and doughnut charts

Lesson 5: Creating picture charts

Lesson 6: Creating Sparkline graphics

Module-2: Mastering Basic Charts

1 Conditional formatting presets

Lesson 2: Conditional formatting rule

Lesson 3: Conditional formatting criteria

Lesson 4: Conditional formatting formula

Lesson 5: Custom number format basics

Lesson 6: Custom number format examples

Lesson 7: Dynamic WordArt Bar Chart

Lesson 8: Dynamic Fill Color of WordArt using VBA

Module-3: Visualizing with Conditional Formatting, Custom Number Formats and Shapes

Lesson 1: Build Impressive Infographics Charts in Excel

Lesson 2: Male and Female Info-graphics Bar Chart

Lesson 3: Male and Female Info-graphics Fill Chart

Module-4: Infographics Chart

Lesson 1: Creating a Simple Gantt Chart

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

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

Module-5: Excel Gantt Chart

Lesson 1: Excel Variance Charts Displaying Conditional Colors

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

Lesson 3: Excel Variance Chart

Module-6: Excel Variance Chart

Lesson 1: Creating a Chart with Actual and Target Values

Lesson 2: Create Dynamic Target Line in Excel Bar Charts

Lesson 3: Creating a Bullet Chart in Excel

Lesson 4: Charting Survey Results

Module-7: Excel for Comparing Performance

Lesson 1: Thermometer Chart

Lesson 2: Gauge Chart

Lesson 3: Creating a Speedometer Chart

Lesson 4: Progress Chart

Module-8: Excel for Progress Chart

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

Lesson 2: Creating Waterfall Chart

Lesson 3: Step Chart in Excel

Lesson 4: Step Chart in Excel using Error Bars

Lesson 5: Dynamic Map Chart

Module-9: Next Level Custom Advanced Charts

Assignment-1: Dynamic Target Line Chart

Assignment-2: Survey Chart

Assignment-3: Dynamic Pareto Chart

Assignment-4: Info-graphics Bar Chart

Assignments

50+ MCQ

Final Examination

<h2 id="624bd160-bf3f-4120-8c94-7d7e192fb98d" data-toc-id="624bd160-bf3f-4120-8c94-7d7e192fb98d" style="font-size: 24px; font-weight: 600; line-height: 1.2;"><strong>What's Included In Our Premium Course?</strong></h2><p>Premium Course Language - Urdu / Hindi</p><h3 id="7fe75789-5c9e-4705-8cbb-fc24c2eaa157" data-toc-id="7fe75789-5c9e-4705-8cbb-fc24c2eaa157" style="font-size: 20px; font-weight: 600; line-height: 1.2;"><strong>MS Excel - Practical Data Visualization Application &amp; Training</strong></h3><p>It encompasses basic to advanced Microsoft Excel charting tools and techniques. Using raw data, you will be able to extract meaningful insights for the key decision-making. Likewise, 24/7 Mentorship support by our Master Trainer is one of the many perks of this training pack</p><h3 id="757e64c8-0980-4891-a915-45f24e2eef7b" data-toc-id="757e64c8-0980-4891-a915-45f24e2eef7b" style="font-size: 20px; font-weight: 600; line-height: 1.2;"><strong>15+ Case Studies &amp; Simulation Exercises</strong></h3><p>We feel pride in delivering state-of-the-art 15+ case studies and 5+ simulation exercises of concerned MS Excel visualization tools and techniques.</p><h3 id="6b5769d7-590d-4bd5-8acc-059cc0e8eaee" data-toc-id="6b5769d7-590d-4bd5-8acc-059cc0e8eaee" 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 (Bilal Global Management Consulting) will be issued to the participant, which can be vetted by any employer or university if needed.</p><hr><h2 id="1fb32151-1912-4fad-b4ca-b79f2452b4f7" data-toc-id="1fb32151-1912-4fad-b4ca-b79f2452b4f7" 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="9b7c4e0e-17b1-408a-be9e-882bb9bc588e" data-toc-id="9b7c4e0e-17b1-408a-be9e-882bb9bc588e" 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="2ae36b29-8c12-4eb3-9834-b6c71e4b88a5" data-toc-id="2ae36b29-8c12-4eb3-9834-b6c71e4b88a5" 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="d0de333f-50ec-4aca-9e79-9d8f02cf8df2" data-toc-id="d0de333f-50ec-4aca-9e79-9d8f02cf8df2" 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="1679d41c-ced1-46db-8864-3b1b3f58d8ad" data-toc-id="1679d41c-ced1-46db-8864-3b1b3f58d8ad" style="font-size: 24px; font-weight: 600; line-height: 1.2;"><strong>Become Internationally Accredited</strong></h2><p style="text-align: left;">Certified Data Visualization Expert Using Microsoft Excel</p><p>We feel pride in delivering the internationally Accredited credential, issued by BGMC EXCELCEupon successful exam completion.</p><img src="https://import.cdn.thinkific.com/389944%2Fcustom_site_themes%2Fid%2FHHyoU22TdySLJFOLgZvF_White%20and%20Blue%20Welcome%20to%20the%20Team%20Greeting%20Instagram%20Post.jpg" 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 a Data Visualization Expert using Microsoft Excel

Certified Data Visualization Expert Using Microsoft Excel

BGMC Group

Course content

Course Description

FAQ

This Course Includes