-
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!
Next
2.23 H-Lookup
5 Comments
This was very interesting and I learnt something new
”I wanted to take a moment to express my appreciation for your excellent tutoring skills. You have a remarkable ability to explain complex topics in a simple and understandable manner, making it easy for me to grasp the concepts. Your guidance has been invaluable, and I have learned a lot under your instruction.
Additionally, I would like to request some assistance from you. I am working on a payroll summary for about 50 employee and would love your help using data validation drop down lists for easy data entry. This would streamline the process and ensure accurate input. Thanks in advance for your continued support!”
”I wanted to take a moment to express my appreciation for your excellent tutoring skills. You have a remarkable ability to explain complex topics in a simple and understandable manner, making it easy for me to grasp the concepts. Your guidance has been invaluable, and I have learned a lot under your instruction.
Additionally, I would like to request some assistance from you Awesome. I am working on a payroll summary for about 50 employee and would love your help using data validation drop down lists for easy data entry. This would streamline the process and ensure accurate input. Thanks in advance for your continued support!”
”I wanted to take a moment to express my appreciation for your excellent tutoring skills. You have a remarkable ability to explain complex topics in a simple and understandable manner, making it easy for me to grasp the concepts. Your guidance has been invaluable, and I have learned a lot under your instruction.
I am working on a payroll summary for about 50 employee and would love your help using data validation drop down lists for easy data entry. This would streamline the process and ensure accurate input. Thanks in advance for your continued support!”
This course is very helpful and loaded with information. Thank you sir
Sir Please can you share this sheets of states and local govt sir🙏
My email: chimmychris@gmail.com
I appreciate sir