Microsoft Excel for Finance
Instructor: The WallStreet School
Validity Period: 180 days
Max Viewing Hours: 35 Hours
₹1990 including 18% GST
Who is this Course for?
The course is not just for people who want to enhance their Excel skills from Beginner to Pro Level, but also for all the candidates who want to specifically to make an entry into Core Finance Job roles.
- Remove the habit of using mouse with keyboard
- Formulas, Shortcuts, Functions, Charts, Dashboards etc
- Linkage of MS Excel with Finance Job Roles in Practice
- Ready made Excel templates for practice and reference
- HD Video content developed by Investment Bankers
- View videos on Android, IOS or Website from anywhere
- Assignments and Quizze at the end of the course
- Essential Job specific skills apart from Just MS Excel
|Basic MS Excel Videos|
|Introduction to Excel|
|Sum, Count, Average, Median, filter, Max, Min, Sort, Advance filters, Transpose, Arrays|
|Text functions, concatenate, cell freezing, sensitivity analysis, Data Table|
|EMI Calculation, introduction to developer tab, goal seek, Use of scroller|
|If condition, Multiple Ifs, If or, If and or, Conditional formatting, date and time formulas|
|If condition examples, Sumif(s), Countif(s), Averageif(s), rank of numeric and alphanumerics, CAGR - Annual, Monthly & Daily data|
|Basic Charting Rules of Bar Chart, Making chart with secondary axis + Cheat sheet for revision|
|Basic MS Excel Working File|
|Basic Excel Working File|
|Advance MS Excel Videos|
|Introduction to Vlookup + Example of Vlookup + CAGR, Usage of exact range, approximate range|
|Advance Usage of Vlookup, introduction match formula, limitation of Vlookup, using a combination of Vlookup +Match, Introduction to Hlookup, combination of Hlookup and Match|
|Complex Usage of Vlookup + Match, Hlookup + Match|
|Introduction to Index, Offset with granular understanding , combination of Index and Offset, Index and Offet superceding Vlookup|
|Advance complexity of Index and Offset in mathematical functions|
|Using Formulas learnt to make dynamic charts, highlighting months with highest and lowest sales, making dynamic doughnut chart using scroller showing product wise sales for multiple years|
|Advance Level Dynamic Charting though the use of formulas, how to compare industry with company products through dynamic charting, use of scroller to control what financial data should be seen and not seen|
|Usage of Choose Formula and making Basic Dashboards for showing financial data dynamically through charting , rebasing of stock price data for parity and comparison|
|Use of formulas learnt above for creation of advance Dashboards and how to use conditional formatting to get the desired results for a blunt data pull|
|Advanced MS Excel Working File|
|Advance Excel Woking File|
|Assessment Test for Advanced Microsoft Excel Certification|
After successful purchase, this item would be added to your courses.
You can access your courses after successfully logging in through any Web browser.
WARNING : The Student will be liable for any -
- Screen capture
- Redistribution of our Content & Videos
The student will have to indemnify The Wallstreet School for the loss sustained.
To Safeguard, we have watermarked each and every video with OTP verified phone number to verify the Student's identity.
NOTE : Single Device Access restriction is applicable. So make sure to Purchase the course when you're on an appropriate device.