-
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 SULE SUNDAY OBAGU 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.
-

75 Comments
Very nice lectures
Enjoying the lectures
Very educative
Thank you so much for this lesson.
It is so concise and educative.
Well-done
Thank you for taking your time in breaking down this class into the barest level to comprehend. I have a question regarding the conditional formatting. For Example, after selecting Top 10 or average percentage, Do we have to count the cells selected manually or is there a ribbon button to figure out the total number of such command? Thank you!
hello Awesome, your material is well detailed. I have an issue with conditional formatting. what do you mean by top 10? is it top repeated numbers/
Wow, great job on conditional formatting
conditional formatting looking like its going to be a very usefull tool
Nice one
very useful. on to the next class
This is very understandable
waoooo I love the class
More useful than I taught. I LOVE THIS
This is awesome.
Thanks so much
The lectures are charming
Great class. very insightful
You’re amazingly amazing
very interesting class. i like the calmness of your voice. very explicit class!
Well understood… I’ve always been wondering how these things are been done.
Im glad I’m now exposed to it.
Wow! This is beautiful.
ALREADY GETTING INTERESTING
Nice lecture
thanks the lesson is very clear.
very interesting. But I am not getting the notes. That will help for easy referencing.
well understood, thank you
Good session. clear explanation
Nice one
👏👏
Thanks sir
with the simplicity in which you teach this course, am beginning to fall in love with it… thanks Mr Awesome 👍
Interesting. A very useful tool
Thank you awesome, Is really getting more interesting.
thanks I now have a deeper understanding
I enjoyed this lesson.
very clear lesson
very easy to understand..thank you
very easy to understand..thank you sir
Nice class. I really joined for a good course.
I learned a lot of new things even though I though I knew Excel already
I can’t access the material for practice please how do I access
Reach out to me via mail
awesome8emmanuel@gmail.com
Pls sir…How do I get numbers to be located in the middle of the cells….the numbers actually move to the end of the cells after I type them
Check the first lesson on formatting
Lesson fully learnt and understood. Good job!
Learning so much content with each class.
The content delivery is on point, makes it easy to follow through.
GOOD JOB
morning..
how do you arrange data by date from newest to oldest that as already been entered with mixed up dates?
Good morning
Right click on any of the dates,
You will see Sort,
Move your cursor on it, you will see
Newest to Oldest
Oldest to Newest
I like the way the explanation is, very simple and clear 🙏
I enjoyed every bit of this class, very interesting thank you.
Interesting lesson
Good lesson.
Please how do I access free resources to work with as the lesson progresses.
Send a mail
awesome8emmanuel@gmail.com
Am loving the sessions so far. Thank You Emmanuel, it is awesome.
Very clear
can I have the complete data set for the training .
The lesson materials is attached to the first lesson. Click on it to download.
You can also send a request mail
awesome8emmanuel@gmail.com
awesome material my understanding is being broaden concerning the excell
sir please can we use conditional formatting to compare numbers in column or row like say if the number in the column is greater than the other number do this or that just like the if and else statement in programming
I understand your question. Conditional formatting is just for a column or row. It can’t be used for comparison just like the If statements.
Thank you so much
More knowledge.
Very easy to learn.. Good instructions
Why was it not taught like this in my secondary school and university?
Fun and interesting 💯
😊😊😊
Thank you! It is getting interesting
never knew this thanks a lot
Thanks very much Sir, indeed you’re Awesome 👍👍
excellent 👌
this is informatively revealing
Fantastic
On conditional Fomatting after getting the numbers highlighted can we filter them out to seperate from the rest
I already had a prior knowledge of excel but this training has taught me more productive workflows.
i love how you explained everything