-
Beginners Class 19
-
Introduction to Data Analysis With Ms Excel 03 minLecture1.1
-
1.1 Introduction to Excel 22 minLecture1.2
-
1.2 Excel-Formatting 32 minLecture1.3
-
1.3 Conditional Formatting-1 15 minLecture1.4
-
1.4 Conditional Formatting-2 07 minLecture1.5
-
1.5 Formulas Function -1 30 minLecture1.6
-
1.6 Formulas function-2(Result Analysis) 16 minLecture1.7
-
1.7 Formulas and Function 3 37 minLecture1.8
-
1.8 Data validation Drop down 13 minLecture1.9
-
1.9 Header and Footer 14 minLecture1.10
-
1.10 Protecting Sheet 09 minLecture1.11
-
1.11 How to Unlock Protected Sheet 17 minLecture1.12
-
1.12 Automated Calculator 14 minLecture1.13
-
1.13 Consolidation 14 minLecture1.14
-
1.14 Charts 39 minLecture1.15
-
1.15 Progress Bar Chart 17 minLecture1.16
-
1.16 Print Setup 25 minLecture1.17
-
Course Review 01 minLecture1.18
-
Beginner’s Class Assessment 11 questionsQuiz1.1
-
-
Advance Class 20
-
Advance Class Intro 01 minLecture2.1
-
2.17 Sorting 09 minLecture2.2
-
2.18 Basic Filter 20 minLecture2.3
-
2.19 Advance Filter 17 minLecture2.4
-
2.20 Logical Function(AND) 10 minLecture2.5
-
2.21 Logical Function(Text) 21 minLecture2.6
-
2.22 Advance Data Validation (Dropdown list) 32 minLecture2.7
-
2.23 H-Lookup 08 minLecture2.8
-
2.24 V-Lookup 05 minLecture2.9
-
2.25 DataBase System 19 minLecture2.10
-
2.26 Pivot table – 1 15 minLecture2.11
-
2.27 Pivot Table 2 11 minLecture2.12
-
2.28 Pivot table 3 09 minLecture2.13
-
2.29 Power Query 1(Text Dates) 22 minLecture2.14
-
2.30 Power Query (Finance) 19 minLecture2.15
-
2.31 Power Query(Web, Dashboard, Slicer) 33 minLecture2.16
-
2.32 Covid-19 Analysis 18 minLecture2.17
-
2.33 Data Collection(Google form) 31 minLecture2.18
-
2.34 Sales Dashboard 33 minLecture2.19
-
Course Review 01 minLecture2.20
-
-
Application Class 12
-
Application Class Intro 02 minLecture3.1
-
3.35 Automated Data Entry Form 18 minLecture3.2
-
3.36 Attendance Register(Clock In & Clock Out) 16 minLecture3.3
-
3.37 Salary Sheet with Excel 13 minLecture3.4
-
3.38 Gantt Chart 14 minLecture3.5
-
3.39 Simple & Compound Interest 23 minLecture3.6
-
3.40 Loan Payment 07 minLecture3.7
-
3.41 Drop Down List (3) 33 minLecture3.8
-
3.42 Loan Management System(Data Base) 31 minLecture3.9
-
3.43 Loan Management System(Payment Page) 12 minLecture3.10
-
3.44 Loan Management System (Home Page) 11 minLecture3.11
-
Last Course Review and more 02 minLecture3.12
-
Leave a Reply to reuben oware Cancel reply
-
Anas Yakubu06/04/2021I enjoy the program very well I will try to invite most of my friends to enroll for it.
-
AWESOME EMMANUEL06/04/2021My pleasure, Thanks for trusting AQskill
-
-
Aminu Saleh22/04/2021
I truly enjoyed the step by step training and am now better in excel, thank you so much sir.
-
Otuaga John27/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 John27/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 …
Thanks to AQ Skill-
AWESOME EMMANUEL27/04/2021The pleasure is mine. Thanks for trusting AQskill.
-

70 Comments
very well explained,, thanks Sir
I have really learnt alot in a short while.
Thank you Sir
Thank you sir…well detailed
I appreciate this… It’s very well explained
Thank you very much sir, well explained.
we detailed.. keep up the good work
The Lecture is Awsome
Wonderful very detailed
very helpful
I’m really enjoying course.
Kudos to you guys
well detailed
well digested
Thank you Sir.
You made mention of handling vlookup separately somewhere.
This course is superb
Quite lucid
Well explained. Thank you.
I love this
well explained…
very well explainatory.
Well understood
This is insightful
Very detailed
You are a good Teacher. Your explanation is so clear and insightful
Well detailed
i am enjoying these lessons
Countif keeps returning 0 in my excel
Hello friend, you can reach me via mail to help you fix it
awesome8emmanuel@gmail.com
Loving every lesson learned. They are discernible.
thank you for this detailed lesson. I noticed in the concatenation that my mine was “;” instead of “,” in adding the space.
well detailed, thank you.
well detailed
Thank u
the more we go the more tougher, but the teacher is awesome as the the awesome
Thank you ❤️
The lessons keep getting interesting.
I’m loving it
Nice presentation
nice presentation
Thanks for the class. i have learnt a lot
Thanks
this is great. I am progressively learning
Enjoying every bit of the lecture, thanks
Time well spent. very detailed. Thank you.
🔥🔥🔥🔥🔥🔥
This is well explained thanks a lot
very detailed
Very clear and understandable
can we use IF statement for formating a date. example
A1
23
80
28
4
7
6
can i say =IF( A1=Odd num “yes,”, “No”,)
You can use the ISODD function instead
=ISODD(A1)
Enter
If A1 is Odd it returns True else it return’s False.
Well detailed the class. Thanks very much
well explained
well taught
very detailed and easy to understand
well detailed lesson, but does this concatenate work for numbers?
Yes. It works for both numbers and letters
Your lectures are awesome 👍 I have learnt alot.
Course is very interesting.
Thank you. So far so good.
very well explained.
Thank you sir for such a knowledgeable class.
Thank you for the detailed explanations
good
Very nice delivery I must say
I really love the delivery but I want to ask something. Can I download a full class courses at once without downloading course by course?
Secondly, will there be certificate issuance at the end of all assessment?
This is awesome 😎