Data Analysis with Microsoft Excel – Complete Course → 3.44 Loan Management System (Home Page)

Beginners Class 19
- Lecture1.1
  
  Introduction to Data Analysis With Ms Excel 03 min
- Lecture1.2
  
  1.1 Introduction to Excel 22 min
- Lecture1.3
  
  1.2 Excel-Formatting 32 min
- Lecture1.4
  
  1.3 Conditional Formatting-1 15 min
- Lecture1.5
  
  1.4 Conditional Formatting-2 07 min
- Lecture1.6
  
  1.5 Formulas Function -1 30 min
- Lecture1.7
  
  1.6 Formulas function-2(Result Analysis) 16 min
- Lecture1.8
  
  1.7 Formulas and Function 3 37 min
- Lecture1.9
  
  1.8 Data validation Drop down 13 min
- Lecture1.10
  
  1.9 Header and Footer 14 min
- Lecture1.11
  
  1.10 Protecting Sheet 10 min
- Lecture1.12
  
  1.11 How to Unlock Protected Sheet 17 min
- Lecture1.13
  
  1.12 Automated Calculator 14 min
- Lecture1.14
  
  1.13 Consolidation 14 min
- Lecture1.15
  
  1.14 Charts 39 min
- Lecture1.16
  
  1.15 Progress Bar Chart 17 min
- Lecture1.17
  
  1.16 Print Setup 25 min
- Lecture1.18
  
  Course Review 01 min
- Quiz1.1
  
  Beginner’s Class Assessment 11 questions
Advance Class 21
- Lecture2.1
  
  Advance Class Intro 01 min
- Lecture2.2
  
  2.17 Sorting 09 min
- Lecture2.3
  
  2.18 Basic Filter 20 min
- Lecture2.4
  
  2.19 Advance Filter 17 min
- Lecture2.5
  
  2.20 Logical Function(AND) 10 min
- Lecture2.6
  
  2.21 Logical Function(Text) 21 min
- Lecture2.7
  
  2.22 Advance Data Validation (Dropdown list) 32 min
- Lecture2.8
  
  2.23 H-Lookup 08 min
- Lecture2.9
  
  2.24 V-Lookup 05 min
- Lecture2.10
  
  2.25 DataBase System 19 min
- Lecture2.11
  
  2.26 Pivot table – 1 24 min
- Lecture2.12
  
  2.27 Pivot Table 2 11 min
- Lecture2.13
  
  2.28 Pivot table 3 09 min
- Lecture2.14
  
  2.29 Power Query 1(Text Dates) 22 min
- Lecture2.15
  
  2.30 Power Query (Finance) 19 min
- Lecture2.16
  
  2.31 Power Query(Web, Dashboard, Slicer) 33 min
- Lecture2.17
  
  2.32 Covid-19 Analysis 18 min
- Lecture2.18
  
  2.33 Data Collection(Google form) 31 min
- Lecture2.19
  
  2.34 Sales Dashboard 33 min
- Lecture2.20
  
  Course Review 01 min
- Quiz2.1
  
  Advance Class Assessment 5 questions
Application Class 12
- Lecture3.1
  
  Application Class Intro 02 min
- Lecture3.2
  
  3.35 Automated Data Entry Form 18 min
- Lecture3.3
  
  3.36 Attendance Register(Clock In & Clock Out) 16 min
- Lecture3.4
  
  3.37 Salary Sheet with Excel 13 min
- Lecture3.5
  
  3.38 Gantt Chart 14 min
- Lecture3.6
  
  3.39 Simple & Compound Interest 23 min
- Lecture3.7
  
  3.40 Loan Payment 07 min
- Lecture3.8
  
  3.41 Drop Down List (3) 33 min
- Lecture3.9
  
  3.42 Loan Management System(Data Base) 31 min
- Lecture3.10
  
  3.43 Loan Management System(Payment Page) 12 min
- Lecture3.11
  
  3.44 Loan Management System (Home Page) 11 min
- Lecture3.12
  
  Last Course Review and more 02 min

This content is protected, please login and enroll course to view this content!

Prev 3.43 Loan Management System(Payment Page)

Next Last Course Review and more

21 Comments

Oguntuwase Temidayo

03/06/2022

THANKS SO MUCH SIR

Ekiru Meya Sunil

15/06/2022

Fabulous.

George Silwimba

29/06/2022

very good and helpful course

Comfort Oye Lartey

05/07/2022

Very Good job Sir

Agunbiade Olaniran Johnson

13/07/2022

Am very greatful sir

chiti nseluka

02/08/2022

This has been a very good program done by our own African true son of the continent. Mr. Awesome, you deserve the best and all the best. This course has been worth doing.

Paulvince Ochieng

31/10/2022

Fabulous course and worth recommending. the knowledge gained is far much than payee

Olubode Bolanle

01/12/2022

Thanks so much, Mr. Awesome for your very valuable training.

Akware Godwill

30/12/2022

It has been a good and nice experience of learning, I
have enjoyed the course and I have gotten the best out of it

Ogbe Becky

08/01/2023

Though I have not been chance to go through all courses but the very few I have watched is awesome. Thanks

Moditsa Cordelia Rampya

08/04/2023

The greatest class for this application class, really had a great time with this one.

Uke vanessa Martha

22/04/2023

I have gotten value and knowledge far more than what I paid for
Thank you Mr Awesome

Damilola Oladipupo

10/05/2023

Had a wonderful experience learning this course….A very big thank you to the instructor for making this worthwhile.

lucky ibitubo

02/06/2023

Thank you sir

Bernard Onosigho

05/06/2023

This course is more like a programming course. Nice job

Agbede Matthew

17/06/2023

weldone boss

AKINOLA RASAQ BOLARINWA

15/10/2023

Thanks so far Mr. Awesome.
This is fabulous and worth recommendation. Training worth more than cost. Thanks once again. God bless you.

Samuel Baidoo

19/11/2023

Dear Awesome,

I have lost my certificate, Please how do I get a new one?

Thank you.

Samuel Baidoo

Richard Terhide Ioryange

12/01/2024

Thank you so much. I learnt quite alot

Jennifer Awele

31/01/2024

thank you so much sir

6 Comments

Anas Yakubu

06/04/2021

I enjoy the program very well I will try to invite most of my friends to enroll for it.

AWESOME EMMANUEL

06/04/2021

My pleasure, Thanks for trusting AQskill

Aminu Saleh

22/04/2021

I truly enjoyed the step by step training and am now better in excel, thank you so much sir.

Otuaga John

27/04/2021

This is indeed great and amazing,I must admit that I have a good value for my money, Honestly the course is well delivered.
Secondly,I truly appreciate how the instructor Mr Awesome is ever ready to respond as quickly as possible to any area that needs more classification during the course of my learning this program on Excel.
Thanks for your effort Mr Awesome,I will recommend this valuable course to my friends …

Otuaga John

27/04/2021

AWESOME EMMANUEL

27/04/2021

The pleasure is mine. Thanks for trusting AQskill.

Beginners Class 19

Advance Class 21

Application Class 12

21 Comments

Leave a Reply to Uke vanessa Martha Cancel reply

6 Comments