Beginners Class 13
- INTRODUCTION 09 minLecture1.1
- FORMULAS AND FUNCTION 1 22 minLecture1.2
- FORMULAS AND FUNCTIONS 2 12 minLecture1.3
- DATA VALIDATION AND DROP DOWN LIST 10 minLecture1.4
- HEADER AND FOOTER 11 minLecture1.5
- FORMATTING 12 minLecture1.6
- PROTECTING SHEET 08 minLecture1.7
- AUTOMATED CALCULATOR 08 minLecture1.8
- CONDITIONAL FORMATTING 1 09 minLecture1.9
- CONDITIONAL FORMATTING 2 05 minLecture1.10
- CONSOLIDATION 12 minLecture1.11
- CHARTS 12 minLecture1.12
- ASSESSMENT 2 questionsQuiz1.1
Advance Class 15
- FILTERING DATA 12 minLecture2.1
- ADVANCE FILTER 16 minLecture2.2
- LOGICAL FUNTION (AND) 09 minLecture2.3
- LOGICAL FUNTION (TEXT) 22 minLecture2.4
- VLOOKUP 11 minLecture2.5
- HLOOKUP 06 minLecture2.6
- PIVOT TABLE 1 22 minLecture2.7
- PIVOT TABLE 2 08 minLecture2.8
- PIVOT TABLE 3 05 minLecture2.9
- POWER QUERY(TEXT, NUMBERS AND WORKING DAYS) 23 minLecture2.10
- POWER QUERY (FINANCE AND AGE) 29 minLecture2.11
- DATA ANALYSIS 11 minLecture2.12
- PIVOT TABLE AND PROGRESS CHARTS 1 26 minLecture2.13
- PIVOT TABLE AND PROGRESS CHARTS 2 08 minLecture2.14
- ASSESSMENT 1 questionQuiz2.1
Application Class 8
- SCORE ANALYSIS 12 minLecture3.1
- AUTOMATED SCORING BOARD 20 minLecture3.2
- AUTOMATED DATA ENTRY FORM 06 minLecture3.3
- SALARY SHEETS 22 minLecture3.4
- DIGITAL CLOCK 09 minLecture3.5
- Course Review 03 minLecture3.6
- ASSESSMENT 1 questionQuiz3.1
- How to Unlock Protected SheetLecture3.7
This content is protected, please login and enroll course to view this content!
Prev ADVANCE FILTER
6 Comments
I enjoy the program very well I will try to invite most of my friends to enroll for it.
My pleasure, Thanks for trusting AQskill
I truly enjoyed the step by step training and am now better in excel, thank you so much sir.
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 …
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
The pleasure is mine. Thanks for trusting AQskill.