Excel 365 Dynamic Array Functions

Series-1

৳   ৳

This course includes

  • 3 Hours
  • 1 lectures
  • Advance Level
  • Certificate of Completion
Apply Now Download Course Outline

What you'll learn:

  • How to Solve Business Cases by MS Excel 365 Dynamic Array Functions

Course content

1 lectures
3 Hours

Requirements

Concept of Writing Functions of Excel Older Version

Description

In this course, 20 business cases will be solved with following Excel 365 Dynamic Array Functions:

1. Sequence             6. Filter                           11. Textafter              16. Textjoin/Concat/Arraytotext

2. Textsplit                7. Hstack/Vstack            12. Groupby              17. Drop/Take

3. Tocol/Torow          8. Reduce                       13. Pivotby               18. Choosecol/Chooserow

4. Let                        9. Xlookup                      14. Byrow/bycol        19. Wrapcols/Wraprows

5. Map                      10. Textbefore                15. Scan                    20. Sortby/Unique