Data Analysis with Microsoft Excel - Complete Course

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 2.32 Covid-19 Analysis

Next 2.34 Sales Dashboard

27 Comments

Tunde S Jimoh

28/03/2022

Appreciate, Interesting Class. more grace to you

Taiwo Adekeye

28/03/2022

this is indeed one of the best classes I’ve attended,I’ve been looking for someone to put me through in how to use Google form, God bless Mr awesome

Saeed Adekunle Adebisi

17/04/2022

This is truly interesting, actually, I have never used a google form before, thus this class made sense to me.

Ayodele Toluwalope Victor

26/04/2022

Thanks for keeping it simple bro.

Benjamin muyoyo

02/05/2022

awesome awesome class ever ,you are great sir ,I think and feel that data collection is important for us analysts

Oluchi Loveline Clark

24/05/2022

Well explained

Oguntuwase Temidayo

30/05/2022

Appreciate, Interesting Class. more grace to you

Emmanuel Oluwasegun

20/06/2022

Great and we’ll delivered.

Agunbiade Olaniran Johnson

12/07/2022

Well understood

OKEOWO DAVID ODUMUYIWA

19/09/2022

This is getting better every day

Ibrahim Otolorin A.

24/09/2022

What a tutor! Awesome it is it 👍

Raheemot Olayemi Shiyanbola

06/11/2022

Very interesting. I really enjoyed this particular lesson. Thank you sir.

Blessing

08/11/2022

Just like your name, this is awesome

Shaibu Eleojo Sunday

04/12/2022

very interesting

Samuel Kioko Mulili

14/12/2022

Best lesson so far

Akware Godwill

28/12/2022

Thank you, it was amazing.

Aiyelabola Olumide

31/01/2023

Well explained

Aaron Apronti

07/02/2023

Very Insightful. Thank you Sir

Moditsa Cordelia Rampya

28/03/2023

Very interesting, easy to grasp and understand.

Adenike Oseni

25/09/2023

So simple to understand. Thank you

Mercy wanjiku

09/10/2023

The best thing learnt today.

Vincent Edah

17/11/2023

Thank you for including this important lesson. Well explained.

Emmanuel Ford

30/12/2023

This is very interesting, thanks a lot!

FAITH

13/02/2024

i have always wonder how goggle form is created. a big hug for you Awesome

TEDDY KYALO MUTIA

26/02/2024

Wooow…I swear I have always been looking for such an amazing lesson about Google form that is so resourceful. Didn’t know its this interesting. Thank you Mr. AWESOME

Olutaiwo Ayobami

10/03/2024

THANKS FOR THIS!

Chukwurah Gloria Chidinma

21/05/2024

Great lesson, thank you for completing the last class here.

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

27 Comments

Leave A Reply Cancel reply

6 Comments