Exam ACCA

NEW AGE EXCEL

Analytics & Modeling
By Karan Aggarwal
5 (6254)

~20 Hours

Description

SnTopics
01Concept of Arrays and calculation engine behind it 
02Comparison - Legacy Excel vs Excel 365 
03Spill behaviour in Excel 365 
04Maximize the Power of dynamic arrays with Tables 
05Exhaustive List of NEW Functions 
 -SEQUENCE, UNIQUE
 -RANDARRAY, SORT, SORTBY
 -FILTER, XLOOKUP, XMATCH
 - LET 
 - TOROW, TOCOL
 - VSTACK, HSTACK
 - CHOOSEROWS, CHOOSECOLS
 - DROP, TAKE
 - EXPAND, TEXTAFTER, TEXTBEFORE, TEXTSPLIT
 - WRAPROWS, WRAPCOLS
07LAMBDA & FUNCTIONAL PROGRAMMING IN EXCEL
 - LAMBDA, SCAN, REDUCE, BYROW, BYCOL, MAP
 - MAKEARRAY, ISOMITTED
 - RECURSION IN LAMBDA
 - Advanced Formula Environment
08Legacy Excel Functions with Dynamic Arrays
 -FREQUENCY, TRANSPOSE, MMULT, LINEST
 -SWITCH, IFS, SUMIFS, OFFSET, INDEX, MATCH, INDIRECT, TEXTJOIN
09Dynamic Dropdowns 
10Dynamic Charts
11Rich Data Types, STOCKHISTORY FUNCTION
12Conditional Formatting 

Other Info

  • Duration : ~20 Hours
  • ₹ 12000

Validity
Views
Video Delivery
Books
Karan Aggarwal
Author
Karan Aggarwal