Instructor: The WallStreet School
Validity Period: 180 days
Max Viewing Hours: 35 Hours
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.
Looking for MS Excel + VBA & Macros? - Enroll here
|Basic MS Excel Videos|
|Introduction to Excel|
|Basic Shortcuts in Excel 1|
|Basic Excel Shortcuts_TWSS_File to be downloaded|
|Basic Shortcuts in Excel 2|
|Basic Excel 2 Shortcuts File|
|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|
|Excel For Finance|
|Rebasing the Stock Price_TWSS_Raw Data|
|How to Rebase Stock Price_MS Excel for Finance|
|How to use Indirect Function for Extracting Data from Multiple Sheets|
|TWSS File_Raw Data_How to Extract Data from Multiple Sheets|
|Basic Excel Test|
|Basic Excel Test|
|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|
|Understanding IRR, NPV and MIRR|
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 -
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 : Following access restrictions are applicable due to security reasons -
- You can login to the portal through 1 web browser and 1 Mobile Application (Android or IOS)
- You'll have to contact our support to change the devices once you have logged in. So make sure to purchase the course when you're on an appropriate device