Data Analysis with Microsoft Excel – Complete Course → 1.12 Automated Calculator

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 09 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 20
- 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 15 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
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.11 How to Unlock Protected Sheet

Next 1.13 Consolidation

30 Comments

Emmanuel Ochulor

09/04/2022

wow!

Lawal Rukayat Bisola

09/06/2023
Reply

Nice one
Really enjoying the class

Benjamin muyoyo

15/04/2022

am actually enjoying your lecturing,my question on this automated calculator is why are the unit price and Qty are not giving an automatic total price,did I missed somewhere???

ONYILIMBA STANLEY TOCHUKWU

07/06/2022

I have already started to recommend this course to a lot of people

Ezemiwe Wisdom Olaleye

17/06/2022

Soaking in the class pretty well

Princewill Iyire

30/06/2022

Very concise… I love the way things are explained

babayemi okuneye

10/08/2022

very concise. well done sir

Amarachi Joy Chinasu

31/08/2022

am enjoying this class really

ukamaka Orabuche

10/10/2022

thanks a lot. this requires a lot of practice. whew!

Precious Bobade

20/10/2022

The class is really captivating

Ogundipe David Kehinde

03/11/2022

the application is beautiful

Oride Orevaoghene Blessing

24/12/2022

This is amazing as stated!

Patience Soko

30/12/2022

you are awesome instructor.. enjoying all the way through

Esther Adeniji

14/02/2023

I’m feel truly blessed to be here, I can’t believe I’m just coming across this. I’m glad to be learning and you’re a awesome teacher.

Wus Damen Theophilus

10/03/2023

Straight to the point. Enjoying it

Ayoade Aishat Adejumoke

15/03/2023

very concise

Kenneth Ekpete

29/03/2023

loved every second spent watching this tutorial

DAVID ADU

18/05/2023

wow. very interesting

Agbede Matthew

03/06/2023

Thanks alot

Reginald OKORO

01/08/2023

Emmanuel you are too good I am lost but I will catch up

Awesome Emmanuel A.

01/08/2023
Reply

🥰
Please do

Mercy Wanjiku

11/08/2023

This was fun

George Antwi

31/08/2023

Great presentation.
Keep doing the Lord’s work.

Vida Dunee

27/09/2023

I love the delivery of your lesson. Thanks

Mercy wanjiku

27/09/2023

Thank you.

kenneth Joshua Dogo

22/03/2024

beautiful. class well enjoyed.
thank you sir

Cecilia Abisola

07/04/2024

Thank you sir

Goodnews Daniel Okoh

08/04/2024

Again, excel is beautiful… Well-done Mr. Awesome

Goodnews Daniel Okoh

08/04/2024

Again, excel is beautiful… Well-done Mr. Awesome

Olaitan Abdulsalam

26/04/2024

You are really awesome 😎

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 20

Application Class 12

30 Comments

Leave a Reply to DAVID ADU Cancel reply

6 Comments