-
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!
3 Comments
Hello, can I have the excel files you’re using to teach.
How are you doing, hope you are great?
Apologies for the challenge encountered.
Kindly click on the WhatsApp link below to get your issue resolved.
https://wa.me/message/WMMO7TI7LCBHH1
+234 813 294 1277
I Personally appreciate the effort you put in each of these classes. i have learnt alot.