BOOTCAMP New AGE Excel

No content

Sn Topics
01 Concept of Arrays and calculation engine behind it 
02 Comparison - Legacy Excel vs Excel 365 
03 Spill behaviour in Excel 365 
04 Maximize the Power of dynamic arrays with Tables 
05 Exhaustive 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
07 LAMBDA & FUNCTIONAL PROGRAMMING IN EXCEL
 -  LAMBDA, SCAN, REDUCE, BYROW, BYCOL, MAP
 -  MAKEARRAY, ISOMITTED
 -  RECURSION IN LAMBDA
 -  Advanced Formula Environment
08 Legacy Excel Functions with Dynamic Arrays
 - FREQUENCY, TRANSPOSE, MMULT, LINEST
 - SWITCH, IFS, SUMIFS, OFFSET, INDEX, MATCH, INDIRECT, TEXTJOIN
09 Dynamic Dropdowns 
10 Dynamic Charts
11 Rich Data Types, STOCKHISTORY FUNCTION
12 Conditional Formatting 
ABOUT THE TRAINER

Karan is a highly skilled & knowledgeable Corporate trainer with 5+ years of total work experience spanning across Financial Modelling & Data Analytics. Known for having a knack for problem solving, thought leadership, highly analytical mindset, intrapreneurship, solid fundamentals & learning aptitude. Spearheaded several solution accelerators and spreadsheet based prototypes in Risk and Analytics space.

No content

Sn Topics
01 Concept of Arrays and calculation engine behind it 
02 Comparison - Legacy Excel vs Excel 365 
03 Spill behaviour in Excel 365 
04 Maximize the Power of dynamic arrays with Tables 
05 Exhaustive 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
07 LAMBDA & FUNCTIONAL PROGRAMMING IN EXCEL
 -  LAMBDA, SCAN, REDUCE, BYROW, BYCOL, MAP
 -  MAKEARRAY, ISOMITTED
 -  RECURSION IN LAMBDA
 -  Advanced Formula Environment
08 Legacy Excel Functions with Dynamic Arrays
 - FREQUENCY, TRANSPOSE, MMULT, LINEST
 - SWITCH, IFS, SUMIFS, OFFSET, INDEX, MATCH, INDIRECT, TEXTJOIN
09 Dynamic Dropdowns 
10 Dynamic Charts
11 Rich Data Types, STOCKHISTORY FUNCTION
12 Conditional Formatting 

Karan is a highly skilled & knowledgeable Corporate trainer with 5+ years of total work experience spanning across Financial Modelling & Data Analytics. Known for having a knack for problem solving, thought leadership, highly analytical mindset, intrapreneurship, solid fundamentals & learning aptitude. Spearheaded several solution accelerators and spreadsheet based prototypes in Risk and Analytics space.