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.
Ans. 1. Anyone with finance background like having studied some level of CFA FRM or actuaries can join this program.
Ans.2. Maths Primers and Python Primers have been included in the program, so no previous experience is expected.
Ans 3. This course is quite long & comprehensive only because we have covered the entire curriculum in 3 parts – theory discussion, visualisations in excel, practical implementation through hands-on session in excel & python
Ans.4. To get certificates you need to complete all topic wise assignments, master project and pass the Final exam.
Ans.5. You can take either 1 year access or lifetime access. Please note that lifetime access is chargeable extra
Ans.6 With this website we have integrated a customized P2T player that will allow you to play encrypted classes. There are no limitations on the number of views. Also the software is compatible with Windows, Mac, Android or iPhone
Ans.7. To interact with the trainer we have a dedicated forum ‘D-forum’. Any questions asked on D-forum are expected to be replied within 24 hours by trainers and team of moderators & experts.
Ans. 8. Presently we are conducting exams in Aug mid and Jan mid. You can choose any of the cohort. In case you are not able to pass the exam in one go, you can re-book at a nominal charge
Ans.9. Every class is supported by One note files, Excel sheets & Python notebooks, Assignments and Quizzes, all these are available in the course section only.
Ans. 10. You get Letter of Recommendation physically delivered to you within 60 days of passing the exam. LOR’s also mention the chosen specialisation with the project details.
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.
Ans. 1. Anyone with finance background like having studied some level of CFA FRM or actuaries can join this program.
Ans.2. Maths Primers and Python Primers have been included in the program, so no previous experience is expected.
Ans 3. This course is quite long & comprehensive only because we have covered the entire curriculum in 3 parts – theory discussion, visualisations in excel, practical implementation through hands-on session in excel & python
Ans.4. To get certificates you need to complete all topic wise assignments, master project and pass the Final exam.
Ans.5. You can take either 1 year access or lifetime access. Please note that lifetime access is chargeable extra
Ans.6 With this website we have integrated a customized P2T player that will allow you to play encrypted classes. There are no limitations on the number of views. Also the software is compatible with Windows, Mac, Android or iPhone
Ans.7. To interact with the trainer we have a dedicated forum ‘D-forum’. Any questions asked on D-forum are expected to be replied within 24 hours by trainers and team of moderators & experts.
Ans. 8. Presently we are conducting exams in Aug mid and Jan mid. You can choose any of the cohort. In case you are not able to pass the exam in one go, you can re-book at a nominal charge
Ans.9. Every class is supported by One note files, Excel sheets & Python notebooks, Assignments and Quizzes, all these are available in the course section only.
Ans. 10. You get Letter of Recommendation physically delivered to you within 60 days of passing the exam. LOR’s also mention the chosen specialisation with the project details.
