-
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 OLIPAH NAKAMBA NAYAME 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.
-

43 Comments
The class has been amazing so far and I have learn a lot.
Pls, when is it necessary to fix (f4) when writing a formular ???
please what shortcut did you use to repeat the process for the comment during the grading in formulas and function 2?
Amazing class
so interesting
It’s been so wonderful. Keep up the good work.
This was a bit complex at first, i had to rewatch it again. Great class.
Nice class
NICE ONE IT HAS HELP ME TO SEE HOW I CAN PROGRAM MY CLOSING DATE FOR CUSTOMER
@AQSkill/Awesome Emmanuel, pls how do I get the data for the practicals? am finding it hard to really follow cus I don’t have data for practice. if I can get website to download relevant data, it will be appreciated.
There’s a download link attached to the first lesson to download the lesson materials. However, you can reach out to me via email to get it
awesome8emmanuel@gmail.com
Amazing and very interesting. Learnt a handful already!
Thanks Mr Awesome
Highly interesting
Highly educative.
Good lesson
Thank you for this class. great lesson
Is this software available on lap top?
I have been using my phone since.
thanks
Whaooo, nice class
The amount I paid and the knowledge am getting don’t match. The knowledge is worth a bigger amount for sure. Alhamdulillah.
Thank you Mr Awesome. Pls I have a question. After getting the result for the rank, is there a formulary that can bring the first person to the top?
Secondly, when working on Aggregate, when I changed the values to letters, it ignored it n added the remaining values but there was no error message. Pls why is that?
You can Sort it.
There’s a lesson for Sorting ahead.
Keep learning
This is fantastic. I am an industrial engineer but I have always been looking for how have a skill on a remote job but this is really preparing me. I will have to do more courses after this Data analysis stuff. Thank you Mr Awesome.
This has been awesome. Had to rewatch to have a proper grasp.
Thank you sir, you are really doing great job. I wish if you some excel sheet with data to practice thank you again.
amazing 😍
This is so good and helpful. Your teaching style is very good too. Thank you!
This is very help but the Round formula has really challenged me.
The class is super Amazing
I’m enjoying every part of the class
The class amazing. please, what are the keys you in getting your less than and greater than.
Thanks for the compliment.
I use this key < for less than and > for greater than.
You can locate the keys beside the right side of the Space bar key.
i am enjoying the formulas and function 3
Please how do you highlight cells on a vertical line and delete the data all at once without having to right-click and then click on ‘delete’.You seem to get it done a lot faster
As soon as you highlight the cells, just hit the delete key on the keyboard
knowledge is power. i am enjoying this course
Thank. Although, i am not aware if the data you are using, for instance, from 1.6 could be made available. I am sure it will facilitate the opportunity for participants to replicate exactly what you have thought.
The dataset is available. Check the first video lesson to download it.
You can also request for it via mail
awesome8emmanuel@gmail.com
Good day sir, please I’m having difficulties in getting “End of month”.
Having written the formula, it gives me a whole number instead of date
It’s simple. Click(select) the number, Change the format from Number to Short Dare.
To change Format, go to the home menu. The Default Format of all cells is General. Click on that General Drop-down and select Short Date.
Best Regards
Done