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.20 Logical Function(AND)

Next 2.22 Advance Data Validation (Dropdown list)

26 Comments

Emmanuel Ochulor

23/04/2022

This is awesome!

Ademuyiwa

07/05/2022

You are a great man. Keep up the good work

Emmanuel Oluwasegun

13/06/2022

I’m blown away boss, I never knew excel is very powerful like this. You are the best.

Comfort Oye Lartey

20/06/2022

Well explained.Thank you

Jonathan Essel Mensah

21/07/2022

NICE

OKEOWO DAVID ODUMUYIWA

30/08/2022

Thank you…. you made my day!

Cynthia Megbulem

02/11/2022

Thanks for this class. Question, what if you have a cell that contains first and last name. How do you separate them and put first name in one cell and last name in the other cell. in order words what is the opposite of the “concatenate” function

Awesome Emmanuel A.

02/11/2022
Reply

Thanks for the Question.
The opposite of CONCATENATE is SPLIT COLUMN.
I taught how to split column in Power Query lesson.
You will see it when you get there.

There’s also a short cut but I can’t demonstrate it via text here. It needs to be practical.
You can contact me directly on my email address
awesome8emmanuel@gmail.com

Ojo Oluwabankole

05/11/2022

Never knew there was anything like Proper…Lol. Thanks alot Mr Awesome.

Lebechi Ugonna

01/02/2023

Very nice

Moditsa Cordelia Rampya

14/03/2023

very detailed and knowledgeable

Kakuru Peter Gasasira

24/03/2023

great class

Ogah John

29/05/2023

Waw
Well understood

Aliyu Oluwatoyin Yetunde

15/06/2023

You are just a good teacher! Lessons well understood. Thanks.

Abdul Hakeem Musah

07/07/2023

Great classes so far. but I just wish there is a soft copy pdf DAT one can download n make reference to once in a while. not everytime videos.

Awesome Emmanuel A.

07/07/2023
Reply

Lesson Materials was attached to the Course. I guess you didn’t download it. Kindly reach me via mail to get it.
- Awesome Emmanuel A.
  
  07/07/2023
  Reply
  
  awesome8emmanuel@gmail.com

Reginald OKORO

10/09/2023

excellent 👍

Matthew Anthony Edet

25/09/2023

Awesome class 👍😎

Mercy wanjiku

28/09/2023

Excellent

Emmanuel Ford

24/12/2023

Great lessons learned here!

Mivu Jefita

06/01/2024

Your explanation are very simple and on point. I love this.

STEPHEN TEI AMANOR

08/01/2024

This just solved one of my major problems in analyzing data using excel. Thanks

FUNMILAYO ODERINDE

16/01/2024

THANK YOU MR AWESOME,
your explanations were very simple, easy to understand and precise.

Obafemi Rosemary Idowu

31/01/2024

Mr Awesome you are doing great with the tutoring. God bless you sir

FAITH

13/02/2024

Thanks Awesome, your classes are the best

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

26 Comments

Leave A Reply Cancel reply

6 Comments