|
Basic MS Excel Videos
|
|
|
|
Introduction to Excel
|
|
|
|
Basic Shortcuts in Excel 1
|
|
|
|
Basic Excel 1 Shortcuts File
|
|
|
|
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
|
|
|
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
|
|
|
Learning VBAs & Macros
|
|
|
|
VBA Macros Overview
|
|
|
|
Macro Recorder
|
|
|
|
Record Macro File
|
|
|
|
VBA MCQ Quiz 1
|
|
|
|
Getting started with sub-procedure
|
|
|
|
Ways to run sub-procedure
|
|
|
|
Square roots of 2 numbers file
|
|
|
|
VBA MCQ Quiz 2
|
|
|
|
Creating a user defined function
|
|
|
|
Nested Conditions
|
|
|
|
User Defined Function File
|
|
|
|
VBA MCQ Quiz 3
|
|
|
|
Loops Part 1 - Overview _ For Next Loop
|
|
|
|
Loops Part 2 - Do While Loop
|
|
|
|
Circular Reference in Financial Model File
|
|
|
|
Loops Part 3 - For Each Loop
|
|
|
|
For Each Loop File
|
|
|
|
Protecting Codes With Password
|
|
|
|
Protecting VBA Codes with Password File
|
|
|
|
VBA MCQ Quiz 4
|
|
|
|
Event Triggered Codes Part 1 - Overview
|
|
|
|
Event Triggered Codes Part 2 - Application
|
|
|
|
Event Triggered Codes File
|
|
|
|
Export or Import VBA Codes
|
|
|
|
VBA MCQ Quiz 5
|
|
|
Getting Stock Prices In Excel
|
|
|
|
Getting Stock Prices In Excel
|
|
|
|
Getting Stock Prices in Excel File
|
|
|
VBA Practice Questions with Solutions
|
|
|
|
Sales Commission Mode
|
|
|
|
Display Fixed Deposit Rates based on Tenure
|
|
|
|
Discount Calculations based on Nested Conditions
|
|
|
|
Insert Current Date
|
|
|
|
Compute Factorial
|
|
|
|
Sum of Square Roots
|
|
|
|
Logic Based Bonus Computation
|
|
|
|
Squared Sum of Series
|
|
|
Assessment Test for Advanced Microsoft Excel Certification
|
|
|
Understanding IRR, NPV and MIRR
|
|
|
|
Understanding IRR_NPV_MIRR
|
|
Launch your Graphy