Lesson-1-Welcome to the Course

Welcome to the Course

Lesson 1: Understanding Excel Formula Anatomy

Lesson 2: Understanding Cell References

Lesson 3: Difference between formula and function

Lesson 4: Understanding Excel Name Ranges

Lesson 5: Excel Error Values

Lesson 6: Copy Formula Without Changing Cell References

Module-1: Introducing Formulas and Functions

Lesson 1: CONCATENATE(), REPLACE() Text Functions

Lesson 2: PROPER(), UPPER(), LOWER() Text Functions

Lesson 3: REPT() Text Function

Lesson 4: SUBSTITUTE() Text Function

Lesson 5: TEXT() Text Function

Lesson 6: Some Other Text Functions

Assignment-1: Text Functions

Module-2: Working with Text Functions

Lesson 1: DATE() and DATEVALUE() functions

Lesson 2: Some Basic Date and Time Functions

Lesson 3: NETWORKDAYS(), NETWORKDAYS.INTL Functions

Lesson 4: WORKDAY(), WORKDAY.INTL() Functions

Lesson 5: WEEKDAY(), YEARFRAC(), EDATE()

Assignment-2: Date and Time Functions

Module-3: Working with Dates and Times Functions

Lesson 1: INT(), MOD(), RAND(), RANDBETWE()

Lesson 2: SUM(), SUMIF(), SUMIFS()

Lesson 3: ROUND(), ROUNDUP(), ROUNDDOWN()

Lesson 4: MROUND()

Lesson 5: SUMPRODUCT()

Lesson 6: Some Basic Functions

Lesson 7: SUBTOTAL()

Lesson 8: MMULT()

Lesson 9 SUMXMY2(), SUMX2MY2(), SUMX2PY2():

Assignment-3: Math & Trig  Functions

Module-4: Working with Math &Trig Functions

Lesson 1: AVERAGE(), AVERAGEIF(), AVERAGEIFS()

Lesson 2: Count Functions

Lesson 3: LARGE(), SMALL()

Lesson 4: MAX(), MIN()

Lesson 5: Rank()

Lesson 6: MAXIFS(), MINIFS()

Assignment-4: Statistical Functions

Module-5: Working with Statistical Functions

Lesson 1: ROW(), ROWS(), COLUMN(), COLUMNS()

Lesson 2: VLOOKUP() – Part-1

Lesson 3: VLOOKUP() – Part-2

Lesson 4: Problems using VLOOKUP()

Lesson 5: HLOOKUP(), LOOKUP()

Lesson 6: INDEX(), MATCH()

Lesson 7: INDEX() and MATCH() function combined (Part-1)

Lesson 8: INDEX() and MATCH() function Combined (Part-2)

Lesson 9: INDEX() and MATCH() function combined (Part-3)

Lesson 10: Multiple Matches

Lesson 11: OFFSET()

Lesson 12: INDIRECT()

Lesson 13: CHOOSE()

Lesson 14: Picture Lookup

Lesson 15: Index for Dynamic List Selection

Lesson 16: Index for Dependent Drop-down Lists

Lesson 17: Searchable Drop-Down List

Lesson 18: Multiple Dependent Drop-Down Lists

Assignment-5: Lookup & Reference Functions

Module-6: Working with Lookup & Reference Functions

Lesson 1: AND(), OR(), NOT()

Lesson 2: TRUE(), FLASE()

Lesson 3: IF()

Lesson 4: IFERROR(), IFNA()

Lesson 5: IS()

Assignment-6: Logical and Information Functions

Module-7: Working with Logical and Information Functions

Lesson 1: NPV()

Lesson 2: PV()

Lesson 3: FV()

Assignment-7: Financial Functions

Module-8: Working with Financial Functions

Lesson 1: XLOOKUP()

Lesson 2: UNIQUE()

Lesson 3: FILTER()

Lesson 4: SORT(), SORTBY()

Lesson 5: SEQUENCE()

Lesson 6: Excel FILTER Function for Non-adjacent columns

Lesson 7: LET()

Module-9: Working with New 365 Excel Functions

Lesson 1: Auditing tools

Lesson 2: Circular references and how to locate them

Lesson 3: Watch window

Lesson 4: The Insert Function command

Module-10: Working with Excel Formula Tools

<h2 id="b70dc1dc-3bfd-4cd9-8b29-d0414dda32e2" data-toc-id="b70dc1dc-3bfd-4cd9-8b29-d0414dda32e2" style="font-size: 24px; font-weight: 600; line-height: 1.2;"><strong>What's Included In Our Premium Course?</strong></h2><p></p><h3 id="3836b818-93a5-410a-9f46-1a0747ca27a9" data-toc-id="3836b818-93a5-410a-9f46-1a0747ca27a9" style="font-size: 20px; font-weight: 600; line-height: 1.2;"><strong>MS Excel - Practical Formulas and Functions Training</strong></h3><p>It encompasses basic to advanced Microsoft Excel formulas and functions modules. 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="a19d0ca6-0023-475c-9d57-c3084e6ab96b" data-toc-id="a19d0ca6-0023-475c-9d57-c3084e6ab96b" 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 25+ case studies and 5+ simulation exercises of concerned MS Excel formulas and functions in this training.</p><h3 id="8a439225-6b68-4398-ae61-b7ccc9155093" data-toc-id="8a439225-6b68-4398-ae61-b7ccc9155093" 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="ce0e38da-ffa6-4cd7-9313-d471f5d94619" data-toc-id="ce0e38da-ffa6-4cd7-9313-d471f5d94619" 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="34b0caff-f703-40be-a181-2ce8c20d4778" data-toc-id="34b0caff-f703-40be-a181-2ce8c20d4778" 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="62d844cd-ce53-4d92-b355-fe62e84c714e" data-toc-id="62d844cd-ce53-4d92-b355-fe62e84c714e" 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="941a882e-5d3f-4f0c-942f-8eb75bc62982" data-toc-id="941a882e-5d3f-4f0c-942f-8eb75bc62982" 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="8a2b42f1-7d27-4b74-be59-8b7a8dd2c739" data-toc-id="8a2b42f1-7d27-4b74-be59-8b7a8dd2c739" 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 Formulas &amp; Functions Specialist</p><p>We feel pride in delivering the internationally Accredited credential, issued by BGMC upon successful exctraining and examination completion.</p><p></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 Certified Microsoft Excel Functions &amp; Formulas  Specialist. 

Certified Microsoft Excel Functions & Formulas Specialist

BGMC Group

Course content

Course Description

FAQ

This Course Includes