Data Analysis with Microsoft Excel – Complete Course → 1.16 Print Setup

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.15 Progress Bar Chart

Next Course Review

53 Comments

Josphat Mutuku

15/04/2022

Hello Awesome,

Thank you for the good work you are doing. I am kindly asking if we can be provided with some of data you use in your session so as to work on it and see if we can provide the same results.

Thank you,
Josphat Mutuku; Student-Kenya

Fadahunsi Ayotomiwa

25/11/2022
Reply

Thank you for the lesson

No I am no longer a novice

I was really an awesome time learning

Tunde S Jimoh

10/05/2022

Thanks for the Good job

Oguntuwase Temidayo

23/05/2022

really enjoyed this lesson. thank so much sir

Onyekwere Ikechukwu Justin

05/06/2022

Thank you so much. The class is worth it.

Comfort Oye Lartey

13/06/2022

I really enjoyed all your presentation.welldone see you At the advance class

Lawal Ayokunnumi Oluwasegun

18/06/2022

Thanks for the good job you doing

OLUMIDE OLANREWAJU

23/06/2022

amazing job

John Ebei

11/07/2022

Thank you awesome for the prodigious work you doing

Agunbiade Olaniran Johnson

12/07/2022

this thing has truobled me many time.
its true they said “what you dont know, you dont know”.
so simplified

Labilwa Jeremiah Amos

13/07/2022

thankyou for the great lessons. More wisdom to you on how to get more and do more

Loveness Chiboola

20/07/2022

Amazing Experience!!!

Ebube Emenike

21/07/2022

thank you for teaching in such a simplified manner…

Adeosun Miracle

30/07/2022

I enjoyed the lesson. I have learnt alot. Thanks I do appreciate.

Bello Sheriff

24/08/2022

Nice one Mr awesome

Prisca

20/09/2022

I enjoyed every lesson 😊

ukamaka Orabuche

10/10/2022

wow

Osanujor Kingsley

09/11/2022

Every lesson is well explained.

Dzifa Saskia Heh

23/11/2022

wow!
The Instructor is articulate in his delivery.

Moses Tampuori

29/12/2022

Great delivery. Thank you for the opportunity.

Olawoyin Rasheed Olawale

04/01/2023

The lessons have been well explanatory. More power to your elbow

TAIWO TOLULOPE MOSES

07/01/2023

it has indeed been a wonderful journey through out the beginners level. A lot has been learnt and still open-minded to learn more at the greater levels. Thumbs up Mr. Awesome

Nora Omoarukhe Imologomhe

11/01/2023

Enjoying these classes

Vincent Oluoch Juma

30/01/2023

It’s been an amazing class. Let’s see what the Advanced Class has in store.

Ruth

02/02/2023

Very educative. Thanks for the good work Mr Awesome.

Ruth

02/02/2023

Very detailed and educative. Thanks for d good work Mr Awesome.

Oluwatobi akingboye

13/02/2023

nice setup

Moditsa Cordelia Rampya

27/02/2023

perfect

Wus Damen Theophilus

12/03/2023

So great. Honestly enjoyed the all the sessions. Thank you sir

Uke vanessa Martha

16/04/2023

Great job Mr Awesome 👌 👏
thanks for the opportunity

Odoagbo Hillary Osita

20/04/2023

Thank you Engr. Awesome Emmanuel, I really enjoyed the class.

Azeez Khadijat Romoke

23/04/2023

I enjoyed this course, thank you and God bless you

Awesome Emmanuel A.

23/04/2023
Reply

Amen
You’re welcome

Mbasuen Terkule Joel

08/05/2023

Your teaching is very impressive and well interesting

Nobapuo Cornelius

05/06/2023

Though I was never a novice, I have added on more.
Wishing to learn more going forward.

Halidu Alimatu Sadia

08/06/2023

Good job Mr Awesome.

Fasina Olamide

29/06/2023

I would like to express my appreciation to the course creator for the invaluable knowledge he has imparted to me. This beginner’s class has given me a solid foundation in data analysis techniques and has equipped me with the skills. The course content is well-structured, easy to follow. Thank you for sharing your expertise and helping me to become a better data analyst.

James Okechukwu

23/07/2023

This has solidify my foundation in excel

Mercy Wanjiku

11/08/2023

Enjoyed myself and it feels so good to know what some of these functions actually mean. Love it

ENEH RAPHAEL I.

17/08/2023

Thank you very much for this awesome course, it was well detailed and comprehensive..

Barisuka

21/08/2023

Thank you. Very detailed.

Awesome Emmanuel A.

26/08/2023

You’re welcome

Mercy wanjiku

28/09/2023

Thank you for the well explained.

Aliu Adeniyi Lawal

11/10/2023

Awesome class

Muyalwa Simbao

26/12/2023

Thanks for sharing this knowledge, but I really feel you should be sharing data to make it easy for us to follow.

Mivu Jefita

03/01/2024

I have really enjoyed the class. Can’t wait to start the advance class. Thank you!

Obafemi Rosemary Idowu

19/01/2024

Thank you so much, i’m really impressed. more wisdom to you

Dauda Labran Agama

03/02/2024

This is absolutely incredible. I’m enjoying the class

Akin Adeniran

13/02/2024

Interesting & Very Thorough Tutorials

Irechukwu Chigozie

07/03/2024

the experience has been awesome sir and I learnt a whole lot, thank you very much

kenneth Joshua Dogo

25/03/2024

wow, Amazing

kenneth Joshua Dogo

25/03/2024

I love the knowledge here

Goodnews Daniel Okoh

10/04/2024

I’m glad I enrolled for this. I sure have a solid foundation after this. Thanks so much Mr. 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 21

Application Class 12

53 Comments

Leave A Reply Cancel reply

6 Comments