|
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
|
|
|
|
Understanding IRR_NPV_MIRR
|
|