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.9 Header and Footer

Next 1.11 How to Unlock Protected Sheet

27 Comments

Fredrick Chirwa

27/03/2022

So clear! Thanks!

Alor Chisom Loretta

28/06/2023
Reply

I love this.
The class is so clear

Ayodele Toluwalope Victor

21/04/2022

clarity is the word

Oguntuwase Temidayo

13/05/2022

NICE CLASS, SO CLEAR

Dolabomi Olorunyomi

22/05/2022

Hi, i have just Microsoft Office Excel 2007 on my PC and while practicing, i couldn’t hide and unhide sheet by just right clicking. please, what other options do i have?

Aaron Okiti

29/05/2022

thanks for this wonderful tutorials

Comfort Oye Lartey

08/06/2022

Good work Sir

Udoh Imedinyene Elijah

21/06/2022

kudos to you sir

Agunbiade Olaniran Johnson

12/07/2022

wow, i like this

Oluwatosin Eunice Olaniru

26/09/2022

Thank you

Tanimowo Israel

28/09/2022

Love the way you take each lessons from the scratch and make sure anyone irrespective of their foreknowledge can grab and gain.
God bless You

Egbeahie, Whitney Ehiluonamhen

05/01/2023

Wow nice

Itoro Abraham George

26/02/2023

Protecting sheet is a bomb. Thank you sir

Moditsa Cordelia Rampya

27/02/2023

great class

Wus Damen Theophilus

10/03/2023

Self explanatory. Thank you

BAKO, VICTOR ETA

15/03/2023

Quite interesting. Thank you

OKEKE, CHINELO GODGIVE

15/03/2023

Well explained, thank you sir

Yusif Mus-Ab

25/04/2023

thank you

IGWEGBE CHINAZA HENRY

15/07/2023

How can I access the dataset used this program

Awesome Emmanuel A.

15/07/2023
Reply

There’s a link attached to the FIRST VIDEO, click on it to download the lesson materials or you can send me a ma on awesome8emmanuel@gmail.com

Reginald OKORO

01/08/2023

amazing

Mercy wanjiku

27/09/2023

well explained

Toju Boyo

11/11/2023

I should have started this course a lot sooner.

Obafemi Rosemary Idowu

04/01/2024

weldone sir…..

Obafemi Rosemary Idowu

04/01/2024

weldone sir

kenneth Joshua Dogo

21/03/2024

This was edifying …thank u sir

Goodnews Daniel Okoh

08/04/2024

Mehn, excel is sweet ooo. A whole lot can be done with it. It’s the definition of what we call “small but mighty”.

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