Beginners Class 12
- 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
Advance Class 14
- 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
Application Class 5
- 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
This content is protected, please login and enroll course to view this content!
Prev PIVOT TABLE 1
Next PIVOT TABLE 3
2 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