-
Beginners Class 18
-
Introduction to Data Analysis With Ms Excel 03 minLecture1.1
-
1.1 Introduction to Excel 22 minLecture1.2
-
1.2 Excel-Formatting Copy 32 minLecture1.3
-
1.3 Conditional Formatting-1 15 minLecture1.4
-
1.4 Conditional Formatting-2 07 minLecture1.5
-
1.5 Formulas Function -1 30 minLecture1.6
-
1.6 Formulas function-2(Result Analysis) 16 minLecture1.7
-
1.7 Formulas and Function 3 37 minLecture1.8
-
1.8 Data validation Drop down 13 minLecture1.9
-
1.9 Header and Footer 14 minLecture1.10
-
1.10 Protecting Sheet 10 minLecture1.11
-
1.11 How to Unlock Protected Sheet 17 minLecture1.12
-
1.12 Automated Calculator 14 minLecture1.13
-
1.13 Consolidation 14 minLecture1.14
-
1.14 Charts 39 minLecture1.15
-
1.15 Progress Bar Chart 17 minLecture1.16
-
1.16 Print Setup 25 minLecture1.17
-
Course Review 01 minLecture1.18
-
-
Advance Class 19
-
Advance Class Intro 01 minLecture2.1
-
2.17 Sorting 09 minLecture2.2
-
2.18 Basic Filter 20 minLecture2.3
-
2.19 Advance Filter 17 minLecture2.4
-
2.20 Logical Function(AND) 10 minLecture2.5
-
2.21 Logical Function(Text) 21 minLecture2.6
-
2.22 Advance Data Validation (Dropdown list) 32 minLecture2.7
-
2.23 H-Lookup 08 minLecture2.8
-
2.24 V-Lookup 05 minLecture2.9
-
2.25 DataBase System 19 minLecture2.10
-
2.26 Data Cleaning 15 minLecture2.11
-
2.27 Pivot Table – 1 24 minLecture2.12
-
2.28 Pivot Table 2 11 minLecture2.13
-
2.29 Pivot Table 3 09 minLecture2.14
-
2.30 Power Query 1 22 minLecture2.15
-
2.31 Power Query 2 04 minLecture2.16
-
2.32 Sales Dashboard 33 minLecture2.17
-
Capstone Project – Worked Project 47 minLecture2.18
-
Course Review 01 minLecture2.19
-
-
Application Class 11
-
Application Class Intro 02 minLecture3.1
-
3.35 Automated Data Entry Form 07 minLecture3.2
-
3.36 Attendance Register(Clock In & Clock Out) 07 minLecture3.3
-
3.37 Salary Sheet with Excel 07 minLecture3.4
-
3.38 Simple & Compound Interest 23 minLecture3.5
-
3.39 Loan Payment 03 minLecture3.6
-
3.40 Drop Down List (3) 08 minLecture3.7
-
3.41 Loan Management System(Data Base) 31 minLecture3.8
-
3.42 Loan Management System(Payment Page) 12 minLecture3.9
-
3.43 Loan Management System (Home Page) 11 minLecture3.10
-
Last Course Review and more 02 minLecture3.11
-
This content is protected, please login and enroll course to view this content!
6 Comments
I enjoyed this class, I have learnt so much on formulas
please where can we access data sheets like the ones you are working on.
thanks.
The download link is attached to the first video. Check the first video description for it or you can send me a mail
awesome8emmanuel@gmail.com
Detailed explanation, much lessons obtained
Well understood.
I have learnt a lot. Thank you Sir Awesome.