Part 1 10
- 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 FormattingLecture1.7
- Status BarLecture1.8
- Mathematical FunctionsLecture1.9
- Conditional Functions Part 1Lecture1.10
- Conditional Functions Part 2Lecture1.11
Part 2 33
- Lookup Functions 16 minLecture2.1
- Match Function 18 minLecture2.2
- Lookup with Match 11 minLecture2.3
- Offset Function 13 minLecture2.4
- Index Function 13 minLecture2.5
- Index Match Function 24 minLecture2.6
- Logical Functions Part 1 (IF,AND) 38 minLecture2.7
- Logical Functions Part 2 (OR,NOT) 18 minLecture2.8
- Logical Functions Part 3 (NESTED IF,AND, OR) 07 minLecture2.9
- Date Functions Part 1 10 minLecture2.10
- Date Functions Part 2 09 minLecture2.11
- Time Functions 10 minLecture2.12
- Text Functions Part 1Lecture2.13
- Text Functions Part 2Lecture2.14
- IS FunctionsLecture2.15
- Reference FunctionsLecture2.16
- Indirect FunctionLecture2.17
- What If Analysis (Goal Seek)Lecture2.18
- Printing in ExcelLecture2.19
- Sub TotalLecture2.20
- Working with Data Part 1 (Sorting)Lecture2.21
- Working with Data Part 2 (Filtering)Lecture2.22
- Information FunctionsLecture2.23
- Text Function- Case StudyLecture2.24
- Charts Part 1 (Bar Chart)Lecture2.25
- Charts Part 2 (Column Chart)Lecture2.26
- Charts Part 3 (Line Graph and Scatter Plot)Lecture2.27
- Charts Part 4 (Pie Chart)Lecture2.28
- Miscellaneous FunctionsLecture2.29
- ErrorsLecture2.30
- TablesLecture2.31
- Statistical Functions Part 1Lecture2.32
- Statistical Functions Part 2Lecture2.33
Part 3 14
- Data Table 07 minLecture3.1
- Scenario Manager 04 minLecture3.2
- Solver 08 minLecture3.3
- Collaboration Tools 11 minLecture3.4
- Auditing Workbooks 10 minLecture3.5
- Text to Column 11 minLecture3.6
- Data from Web 14 minLecture3.7
- Data Validation 08 minLecture3.8
- Data Consolidation 12 minLecture3.9
- Array Functions 09 minLecture3.10
- Hyperlink 13 minLecture3.11
- Beginning with Macros 11 minLecture3.12
- Pivot Tables and Pivot Charts 26 minLecture3.13
- Wildcard In Excel 20 minLecture3.14
- Password Proctection 25 minLecture3.15
Introduction to Excel
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.