Welcome Note

Introduction to the Course

Before we begin...

Module-1: Welcome to the Course

Module-2: Introduction

Lesson-1: Creating & Opening Workbooks

Lesson-2: Excel User Interface

Lesson-3: Saving and Sharing Workbooks

Lesson-4: Essential Worksheet Operations

Lesson-5 (Part-1): Working with Cell and Ranges - Introduction

Lesson-5 (Part-2):  Understanding Cells, Ranges and Reference Style

Lesson-5 (Part-3): Cell Content

Lesson-5 (Part-4): Find, Replace and other Functions

Lesson-6 (Part-1): Worksheet Formatting - Introduction

Lesson-6 (Part-2): Formatting Tools

Lesson-6 (Part-3): Cell Styles Number Formatting and Document Themes

Lesson-7 (Part-1): Introduction to Tables

Lesson-7 (Part-2): Creating and Modifying Tables

Lesson-7 (Part-3): Sorting and Filtering a Table

Lesson-8 (Part-1): Printing, Finalizing and Protecting Workbooks - Introduction

Lesson-8 (Part-2): Print Your Work

Lesson-8 (Part-3): Finalizing and Protecting Workbooks

Lesson-9: Track Changes and Comments

Lesson-10: Keyboard Shortcuts

Module-2: Getting Started with Excel

Module 3: Introduction

Lesson-1 (Part-1): Introducing Formulas and Functions - Understanding Excel Formula Anatomy

Lesson-1 (Part-2): Understanding Cell References

Lesson-1 (Part-3): Difference between formula and function

Lesson-1 (Part-4): Understanding Excel Name Ranges

Lesson-1 (Part-5): Excel Error Values

Lesson-1 (Part-6): Copy Formula Without Changing Cell References

Lesson-2: Text Functions (Part-1)

Lesson-2: Text Functions (Part-2)

Lesson-2: Text Functions (Part-3)

Lesson-2: Text Functions (Part-4)

Lesson-2: Text Functions (Part-5)

Lesson-2: Text Functions (Part-6)

Assignment: Text Functions

Lesson-3: Dates and Times Functions (Part-1)

Lesson-3: Dates and Times Functions (Part-2)

Lesson-3: Dates and Times Functions (Part-3)

Lesson-3: Dates and Times Functions (Part-4)

Lesson-3: Dates and Times Functions (Part-5)

Assignment - Date and Time Functions 

Lesson-4: Math and Trig Functions (Part-1)

Lesson-4: Math and Trig Functions (Part-2)

Lesson-4: Math and Trig Functions (Part-3)

Lesson-4: Math and Trig Functions (Part-4)

Lesson-4: Math and Trig Functions (Part-5)

Lesson-4: Math and Trig Functions (Part-6)

Lesson-4: Math and Trig Functions (Part-7)

Lesson-4: Math and Trig Functions (Part-8)

Lesson-4: Math and Trig Functions (Part-9)

Assignment: Math & Trig  Functions 

Lesson-5: Statistical Functions (Part-1)

Lesson-5: Statistical Functions (Part-2)

Lesson-5: Statistical Functions (Part-3)

Lesson-5: Statistical Functions (Part-4)

Lesson-5: Statistical Functions (Part-5)

Lesson-5: Statistical Functions (Part-6)

Assignment: Statistical Functions

Lesson-6: Lookup & Reference Functions (Part-1)

Lesson-6: Lookup & Reference Functions (Part-2)

Lesson-6: Lookup & Reference Functions (Part-3)

Lesson-6: Lookup & Reference Functions (Part-4)

Lesson-6: Lookup & Reference Functions (Part-5)

Lesson-6: Lookup & Reference Functions (Part-6)

Lesson-6: Lookup & Reference Functions (Part-7)

Lesson-6: Lookup & Reference Functions (Part-8)

Lesson-6: Lookup & Reference Functions (Part-9)

Lesson-6: Lookup & Reference Functions (Part-10)

Lesson-6: Lookup & Reference Functions (Part-11)

Lesson-6: Lookup & Reference Functions (Part-12)

Lesson-6: Lookup & Reference Functions (Part-13)

Lesson-6: Lookup & Reference Functions (Part-14)

Assignment: Lookup & Reference Functions 

Lesson-7: Logical & Information Functions (Part-1)

Lesson-7: Logical & Information Functions (Part-2)

Lesson-7: Logical & Information Functions (Part-3)

Lesson-7: Logical & Information Functions (Part-4)

Lesson-7: Logical & Information Functions (Part-5)

Assignment: Logical & Information Functions

Lesson-8: Financial Functions (Part-1)

Lesson-8: Financial Functions (Part-2)

Lesson-8: Financial Functions (Part-3) 

Lesson-8: Financial Functions (Part-4) 

Assignment: Financial Functions

Lesson-9: New 365 Excel Functions (Part-1)

Lesson-9: New 365 Excel Functions (Part-2)  0 Discussions 0Discussions Enable fullscreen

Lesson-9: New 365 Excel Functions (Part-3)

Lesson-9: New 365 Excel Functions (Part-4)

Lesson-9: New 365 Excel Functions (Part-5)

Lesson-9: New 365 Excel Functions (Part-6)

Lesson-9: New 365 Excel Functions (Part-7)

Lesson-10: Excel Formula Tools (Part-1)

Lesson-10: Excel Formula Tools (Part-2)

Lesson-10: Excel Formula Tools (Part-3)

Lesson-10: Excel Formula Tools (Part-4)

Module-3: Excel – Formulas & Functions

Module 4: Introduction

Lesson-1: Basics of the Excel charts- A Quick start

Lesson-2: Creating Combination Charts

Lesson-3: Pareto and Histogram Charts

Lesson-4: Tree Map

Lesson-5: Sunburst, Pie & Doughnut Charts

Lesson-6: Creating picture charts

Lesson-7: Creating Sparkline Graphics

Lesson-8: Build Impressive Infographics Charts in Excel

Lesson-9: Thermometer Chart

Lesson-10: Gauge Chart

Lesson-11: Excel Variance Charts Displaying Conditional Colors

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

Lesson-13: Creating Waterfall Chart

Lesson-14: Shapes and Smart-art Graphics

Lesson-15: Working with other Graphic Types

Lesson-16: Conditional Formatting Presets

Lesson-17: Conditional Formatting Rule

Lesson-18: Conditional Formatting Criteria

Lesson-19: Conditional Formatting Formula

Lesson-20: Custom Number Format Basics

Lesson-21: Custom Number Format-Examples

Module-4: Charts & Graphics for Effective Communication of Data

Lesson-1: Why formulas are not for analysis

Lesson-2: Pivot tables – The basics

Lesson-3: Pivot tables – More Rows and Value Field Setting

Lesson-4: Pivot tables – Adding Columns to the Mix

Lesson-5: Multiple Tables

Lesson-6: Secretly PowerPivot

Lesson-7: Power Map

Pivot Tables and Power Map: Practice Exercise

Module-5: Bonus Section – Pivot Tables and Power Map

Practice Exercise-1

Practice Exercise-2

Practice Exercise-3

Practice Exercise-4

Practice Exercise-5

Practice Exercise-6

Practice Exercise-7

Practice Exercise -8

Module-6: Practice Exercises

Microsoft Office Specialist: Examination Details

Module-7: Microsoft Excel (Office 2016) – Microsoft Office Specialist (MOS) Exam

Final Notes

Before you go...

Module-8: Final Notes

Final Quiz

Module-9: Final Quiz

<h2 id="4b019346-daa6-4846-8eb6-e699e570becc" data-toc-id="4b019346-daa6-4846-8eb6-e699e570becc" style="font-size: 24px; font-weight: 600; line-height: 1.2;"><strong>What's Included In Our Elite "Certified Microsoft Excel Essentials" Course?</strong></h2><h3 id="cd1d017d-afaa-4a96-bf89-a5254cf2352e" data-toc-id="cd1d017d-afaa-4a96-bf89-a5254cf2352e" style="font-size: 20px; font-weight: 600; line-height: 1.2;"><strong>MS Excel - Practical Application &amp; Training</strong></h3><p>8 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="8d457dbe-3e66-4304-ba94-2f913ec7b805" data-toc-id="8d457dbe-3e66-4304-ba94-2f913ec7b805" 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 11+ case studies and 9+ simulation exercises of concerned tools and techniques.</p><h3 id="02f94b6b-f290-42f0-9e6f-08f08b4d145c" data-toc-id="02f94b6b-f290-42f0-9e6f-08f08b4d145c" 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 Bilal Consultancy Limited England will be issued to the participant, which can be vet by any employee or university if needed.</p><hr><h2 id="84dbf97f-0792-4aa4-a6bc-853f65ba8713" data-toc-id="84dbf97f-0792-4aa4-a6bc-853f65ba8713" 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="f8e18b12-06a1-4451-861f-afee589ce5bf" data-toc-id="f8e18b12-06a1-4451-861f-afee589ce5bf" 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="8f37ea55-f19f-480c-941b-b26f0f8c6f2f" data-toc-id="8f37ea55-f19f-480c-941b-b26f0f8c6f2f" 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="bde96158-f4ad-42e2-9aa3-9e6a2743e91d" data-toc-id="bde96158-f4ad-42e2-9aa3-9e6a2743e91d" 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="95c5e12a-709b-4c29-aa19-033a67a826a4" data-toc-id="95c5e12a-709b-4c29-aa19-033a67a826a4" 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 Essentials</p><p>We feel pride in delivering the internationally Accredited credential, issued by 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;">

Microsoft Excel 2019/ 365 is like a room full of toolbox; it is an enormous resource for doing many kinds of jobs that involve information. In this course you will learn the most important time-saving tools and shortcuts and data reporting expertise.

Certified Microsoft Excel Essentials (Level 1) Professional

BGMC Group

Primary Menu

Certified Microsoft Excel Essentials (Level 1) Professional

BGMC Group

What you will learn

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

How to choose the right tool for the job at hand, and how to use each tool quickly and efficiently.

Maintain large sets of Excel data in a list or table.

Learn the most common Excel functions used in the Office.

Understand WHEN, WHY, and HOW to use different chart types in Excel.

Understand how to design a customized charts in Excel.

Create dynamic reports by mastering one of the most popular tools, PivotTables.

Course content

Course Description

FAQ

This Course Includes