Advanced Microsoft Excel Functions & Formulas (Bangla)

Wishlist Share
Share Course
Page Link
Share On Social Media

About Course

Excel has 450+ functions that can do a range of awesome things. If you’ve used Excel even for a few days, I am sure you have heard of functions like VLOOKUP, SUMIF, COUNTIF, and so on.

With a combination of functions, you can create some advanced Excel formulas that can do some incredibly advanced things with a press of a key.

If you want to learn how to best use the VLOOKUP function and PivotTable and master the advanced MS Excel functions and formulas, check out our comprehensive course! Enhance your Excel skills with our engaging online classes.

Show More

What Will You Learn?

  • Advanced Balance Formatting
  • Using Arrays for Dynamic Data Integrity
  • Create Dynamic Data Sheet with
  • PivotTables Using
  • Working with Multiple Consolidation
  • Calculated PivotTable field & PivotTable data in a formula
  • VLOOKUP For Dynamically Data Searching
  • Wildcard in VLOOKUP formula
  • Using MATCH and INDEX for Advance Filter
  • Working with sales sheet

Course Content

All Videos Step By Step

  • 01 – Getting started with Excel Interface
    06:58
  • 02 – Advanced Balance Formatting With Nearest digit
    11:14
  • 03 – Using Arrays for Dynamic Data Integrity
    15:11
  • 04 – Create Dynamic Data Sheet with PivotTables
    16:28
  • 05 – Working with Multiple Consolidation
    09:30
  • 6 – Calculated PivotTable field PivotTable data in a formula
    10:40
  • 07 – VLOOKUP For Dynamically Data Searching
    11:01
  • 08 – Wildcard in VLOOKUP formula
    11:38
  • 09 – Using MATCH and INDEX for Advance Filter
    09:49
  • 10 – Exercise – Salary Sheet
    18:14
  • 11 – Conclusion and what’s next
    02:00

Exercise Files

Student Ratings & Reviews

No Review Yet
No Review Yet

Payment Platform

paypal-secured-icon

Address

Rize Capital Ltd
Registered in England and Wales.
Registration # 12039916
53 Rodney Crescent, Filton,
Bristol BS34 7AF
United Kingdom

Copyright © 2019 – 2024  Rize Capital Ltd

Want to receive push notifications for all major on-site activities?

Contact Support