-
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 Omowunmi Olusada Cancel reply
-
Anas Yakubu06/04/2021
I 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.
-

45 Comments
The knowledge I’ve acquire thus far is mindblowing. Data validation and most of these logical functions has been of interest to me because of my career. I had no prior knowledge. Thank you Awesome!
This is Awesome, well explained and a very interesting topic for management reporting. well learn and I will study the video more and understand it better. Thank you
Thanks for showing how to combine my old and new knowledge in excel to a practical use
This is huge. Learning this is very interesting.
Knowledge is power u have real empower me. Thanks
Am happy I got to this point, was very interesting and understandable. Thank you
This class is interesting and educative.
This is great and we’ll delivered.
thank you, you have really empowered me.
you have changed my perception
MR AWESOME YOU’VE BEEN AWESOME, THE VIDEOS ARE CLEAN, STIMULATING AND INTERESTING….EASY TO UNDERSTAND. KUDOS SIR
Simply Great! Thank you Awesome 👌….You’ve indeed change my perception about Excel…..It’s a powerful tool
THANK YOU SO FAR FOR THIS COURSE.
Thank you,… i have learnt a lot
brief and straight to points. .
Have learnt a lot.
thanks.
Excel is alot! You make it easy 👌
Thank you, thank you. I can’t thank you enough for these lessons. God bless you
Mr Awesome has done awesomely well.
Thank you for the step by step teachings
Wow. I completed the Advance Class… I’m so so Happy. Thanks Mr Awesome. let me get to work
Its soo awesome.
So Interesting
highly interesting
Brilliantly delivered. Welldone Mr Awesome
Awesomely delivered, i can now practice perfectly with excel
Mind blowing Insight: Getting to know that what is done in PowerBi is also possible with EXCEL.
Great Job!
WOW..AM VERY EXCITED WITH THE LESSONS, THANK YOU SO MUCH SIR AWESOME
thank u Mr Awesome for this mind blowing lessons.
Woow!! You’re actually the of tutor’s I have ever met on online platforms. I can now brag and call myself a data analyst😄…May Allah the Almighty reward you more and grant you more wisdom.
Very interesting and easy to follow and understand. There was so much to learn
you are too much that is all I can say for now. thank you for giving us more value than we paid for
excellent job. I learnt alot. it’s an eye opener
I’m really wawed on how you’ve demystified excel functions, I was almost thinking we’re using power bi. Indeed excel is a Grandfather
Thank you so so much Mr. Awesome
excellent work Mr Awesome
I’m so glad I took this advanced class. It’s been challenging but rewarding, and I feel like I’ve come a long way. Thank you for your excellent teaching, Mr. Awesome.
Thank you, Mr. Awesome, for this lecture. I must confess the value of the course is worth more than the amount paid for this. my capacity building is getting better.
It’s my pleasure.
Thank you this lesson its very educative.
It’s been an amazing time learning from your deep and insightful teachings. Thank you so much for bringing this together and for your exceptional coaching.
Meanwhile, you promised in one of your videos that you will be making some videos on some of your projects like the School Progress Report you did for a school. I’m humbly looking forward to that.
Thank you very much!
Thanks for the compliment.
Here’s the link to download my other projects
https://tinyurl.com/3yhv87am
wow
Impressive & Very Rich Course; Thanks
The class are beyond imagination. Thanks to AQ Skills
You’re welcome
thank you for selling this depth of Knowlegde in Excel so cheap. God Bless You.
Thank you Mr Awesome, it’s well detailed.