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!
Next HEADER AND FOOTER
11 Comments
GREAT LESSONS
it was indeed awesome and precise
Great lesson.. I’m learning a lot
great
I already have much knowledge about excel, but i must admit i enjoy starting all over game, nice vidoes and presentations. thanks
Great work
good job, I’m unable to watch the videos over again
great lesson
Great 👍. I now know much on excel.
Awesome!! not you sir but the tutorial!!
Awesome!