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 1.8 Data validation Drop down

Next 1.10 Protecting Sheet

31 Comments

Fredrick Chirwa

27/03/2022

So interesting, practice now on my part! Thanks Awesome!

Abdullahi olatunji

13/04/2022

Thank you so much for this eye opening course. moving on to the next

Siyeofori max-karibo

16/05/2022

So amazing

Comfort Oye Lartey

08/06/2022

Well explained.Thanks

Sanyaolu Daniel

14/06/2022

well explained

Albert Polley Mensah

11/07/2022

Thanks very much for this course. I have gained alot

Adeniyi Joshua

30/07/2022

love this

Emeana Okwuchi Assumpta

23/08/2022

nice nice,thank you

Moses Silupya

24/09/2022

nice and very clear.

Chinedu Fortune Agorom

06/10/2022

The clarity of instruction is commendable.

Changu siabasimbi

02/01/2023

Well explained, thank you for the good lessons sir

DAVID ADU

08/01/2023

I am really learning. My students will enjoy most when we get to excel

Thank you
Awesome

Moditsa Cordelia Rampya

21/02/2023

Super clear

reuben oware

14/05/2023

nice one

SAMUEL EDITH

07/07/2023

I’m enjoying the class so far. the class have showed me new features have not been used to before …

Reginald OKORO

01/08/2023

wow you are good man

Oluwasemiloore Adisa

09/08/2023

Please, I need the data to work on

Awesome Emmanuel A.

09/08/2023
Reply

The lesson materials is attached to the first lesson. Click on it to download.
You can also send a request mail
awesome8emmanuel@gmail.com

Barisuka

21/08/2023

Well explained

Oluwakemi Balogun

24/08/2023

The class is so interesting and educative. Also easy to follow. Thank you

Mercy wanjiku

26/09/2023

Understood everything so clearly. Thank you.

Vida Dunee

27/09/2023

I’m glad I came across this course

Lweendo Hamunyangwa

09/11/2023

Well explained 👏

Emmanuel Ford

22/12/2023

Interesting!

DAVID ADU

01/01/2024

Good presentation

Obafemi Rosemary Idowu

04/01/2024

Thanks so much, I have learnt alot.

kenneth Joshua Dogo

21/03/2024

this is really Educative. thank you sir

Cecilia Abisola

29/03/2024

well detailed

Sunday Peace Urebuchi

07/04/2024

pls sir, does the current time takes d time in ur system?

Awesome Emmanuel A.

07/04/2024
Reply

Yes sir

Osinam julius

17/05/2024

Perfect 👍👍👍

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

31 Comments

Leave A Reply Cancel reply

6 Comments