-
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 my Google Excel doesn’t have the format cells, and I tried the clt+1 of shift +F and I still didn’t get it, kindly help
The control 1 is a feature in Microsoft Excel. Not available in Google Sheet
Sir can you share me the work sheet via email, ajieferdinand@gmail.com
Thanks as await your response