MS Excel 59
- Introduction to Excel 16 minLecture1.1
- Introduction to Functions 07 minLecture1.2
- Cell Referencing 13 minLecture1.3
- Paste Special Tool 10 minLecture1.4
- Working with Ranges 17 minLecture1.5
- Formatting in Excel 06 minLecture1.6
- Conditional Formatting 16 minLecture1.7
- Status Bar 18 minLecture1.8
- Mathematical Functions 11 minLecture1.9
- Conditional Functions Part 1 13 minLecture1.10
- Conditional Functions Part 2 13 minLecture1.11
- Lookup Functions 24 minLecture1.12
- Match Function 38 minLecture1.13
- Lookup with Match 18 minLecture1.14
- Offset Function 07 minLecture1.15
- Index Function 10 minLecture1.16
- Index Match Function 09 minLecture1.17
- Logical Functions Part 1 (IF,AND) 10 minLecture1.18
- Logical Functions Part 2 (OR,NOT) 07 minLecture1.19
- Logical Functions Part 3 (NESTED IF,AND, OR) 04 minLecture1.20
- Date Functions Part 1 08 minLecture1.21
- Date Functions Part 2 11 minLecture1.22
- Time Functions 10 minLecture1.23
- Text Functions Part 1 11 minLecture1.24
- Text Functions Part 2 14 minLecture1.25
- IS Functions 08 minLecture1.26
- Reference Functions 12 minLecture1.27
- Indirect Function 09 minLecture1.28
- What If Analysis (Goal Seek) 13 minLecture1.29
- Printing in Excel 11 minLecture1.30
- Sub Total 26 minLecture1.31
- Working with Data Part 1 (Sorting) 20 minLecture1.32
- Working with Data Part 2 (Filtering) 25 minLecture1.33
- Information Functions 31 minLecture1.34
- Text Function- Case StudyLecture1.35
- Charts Part 1 (Bar Chart)Lecture1.36
- Charts Part 2 (Column Chart)Lecture1.37
- Charts Part 3 (Line Graph and Scatter Plot)Lecture1.38
- Charts Part 4 (Pie Chart)Lecture1.39
- Miscellaneous FunctionsLecture1.40
- ErrorsLecture1.41
- TablesLecture1.42
- Statistical Functions Part 1Lecture1.43
- Statistical Functions Part 2Lecture1.44
- Data TableLecture1.45
- Scenario ManagerLecture1.46
- SolverLecture1.47
- Collaboration ToolsLecture1.48
- Auditing WorkbooksLecture1.49
- Text to ColumnLecture1.50
- Data from WebLecture1.51
- Data ValidationLecture1.52
- Data ConsolidationLecture1.53
- Array FunctionsLecture1.54
- HyperlinkLecture1.55
- Beginning with MacrosLecture1.56
- Pivot Tables and Pivot ChartsLecture1.57
- Wildcard In ExcelLecture1.58
- Password ProctectionLecture1.59
Financial Modeling 5
- Cycle Manufacturer- XYZ Inc 01 hour 25 minLecture2.1
- Fast Food Chain- Burgerzz 02 hour 19 minLecture2.2
- Hospitality- Vintage Hotels Part 1 56 minLecture2.3
- Hospitality- Vintage Hotels Part 2 01 hour 28 minLecture2.4
- DEL Constructors 57 minLecture2.5
Company Valuations 3
- IT Industry 01 hour 35 minLecture3.1
- Chemical Industry- Part 1 56 minLecture3.2
- Chemical Industry Part 2 (Dilution Effect) 30 minLecture3.3
Company Profiling 1
- IB_Company Profiling (FMCG Sector: Dabur) 58 minLecture4.1
Hospitality- Vintage Hotels Part 2
Subscribers who have purchased the course should email us at cc@wkvedu.com. Please remember to include the following details in the email:
1. Name
2. Mob No.
3. Email
4. Course(s) Purchased
5. Machine ID
Important instructions:
1. Course Videos, Video Player, Study Material, Files etc can be downloaded from Curriculum Page by clicking ‘Download Video’.
2. Please use the Video Player to generate the Machine ID
Steps to Generate Machine ID
1. Open player according to your Operating System. We provide players for both Windows & Mac.
2. Click on ‘Select Files’ on the Dialogue Box.
3. Select any encrypted video (Encrypted videos have extension as ‘.wkvedu’)
4. Click on the Machine ID displayed by the player. It will get copied automatically.