Advanced MS 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, check out this detailed tutorial on this advanced course.

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:57
  • 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
20-22 Wenlock Road, London N1 7GU
United Kingdom

Copyright © 2019 – 2024  Rize Capital Ltd

Contact Support