-
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 Emmanuel Ford 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.
-

27 Comments
This is awesome!
You are a great man. Keep up the good work
I’m blown away boss, I never knew excel is very powerful like this. You are the best.
Well explained.Thank you
NICE
Thank you…. you made my day!
Thanks for this class. Question, what if you have a cell that contains first and last name. How do you separate them and put first name in one cell and last name in the other cell. in order words what is the opposite of the “concatenate” function
Thanks for the Question.
The opposite of CONCATENATE is SPLIT COLUMN.
I taught how to split column in Power Query lesson.
You will see it when you get there.
There’s also a short cut but I can’t demonstrate it via text here. It needs to be practical.
You can contact me directly on my email address
awesome8emmanuel@gmail.com
Never knew there was anything like Proper…Lol. Thanks alot Mr Awesome.
Very nice
very detailed and knowledgeable
great class
Waw
Well understood
You are just a good teacher! Lessons well understood. Thanks.
Great classes so far. but I just wish there is a soft copy pdf DAT one can download n make reference to once in a while. not everytime videos.
Lesson Materials was attached to the Course. I guess you didn’t download it. Kindly reach me via mail to get it.
awesome8emmanuel@gmail.com
excellent 👍
Awesome class 👍😎
Excellent
Great lessons learned here!
Your explanation are very simple and on point. I love this.
This just solved one of my major problems in analyzing data using excel. Thanks
THANK YOU MR AWESOME,
your explanations were very simple, easy to understand and precise.
Mr Awesome you are doing great with the tutoring. God bless you sir
Thanks Awesome, your classes are the best
This is great, your teaching are very apt, thank you very much.