-
Level 1 0/5
-
Excel Basics 16 minLecture1.1
-
Excel as a Calculator 07 minLecture1.2
-
Error 13 minLecture1.3
-
Sort and Filter 10 minLecture1.4
-
Charts 17 minLecture1.5
-
Formatting 06 minLecture1.6
-
-
Level 2 0/12
-
Aggregate 16 minLecture2.1
-
Function Wizard 18 minLecture2.2
-
Cell Referencing 11 minLecture2.3
-
Logical Functions 13 minLecture2.4
-
Lookup Functions 13 minLecture2.5
-
Index Match Function 24 minLecture2.6
-
Date Time text functions 38 minLecture2.7
-
Nested Functions 18 minLecture2.8
-
Annotating Formulae 07 minLecture2.9
-
Conditional Formatting 10 minLecture2.10
-
Custom Number Formatting 09 minLecture2.11
-
Hyperlink 10 minLecture2.12
-
-
Level 3 0/15
-
Auto Filter 07 minLecture3.1
-
Subtotal 04 minLecture3.2
-
Data Consolidation 08 minLecture3.3
-
Data Validation 11 minLecture3.4
-
Age Calculator 10 minLecture3.5
-
Nested IF 11 minLecture3.6
-
Pivot Tables and Charts 14 minLecture3.7
-
Goal Seek 08 minLecture3.8
-
What If – Scenario Manager 12 minLecture3.9
-
Password Protection 09 minLecture3.10
-
Import Export Data 13 minLecture3.11
-
Amortization of Loan 11 minLecture3.12
-
Sparkline, Trendline, Candlestick Charts 26 minLecture3.13
-
Macros 20 minLecture3.14
-
VBA 25 minLecture3.15
-
SUMIF COUNTIF Functions 31 minLecture3.16
-
Excel Basics
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.