1) COMMITMENT
2) INTRODUCTION TO MS-EXCEL
Video Click Here
Video Click Here
Video Click Here
Video Click Here
Video Click Here
Video Click Here
Video Click Here
3) CONDITIONAL FORMATING IN MS-EXCEL
4)APPLYING FILTER IN MS-EXCEL
5) BASIC FORMULAS USED IN MS-EXCEL
6) ADVANCED FORMULAS USED IN MS-EXCEL
7) FORMULAS USED IN STUDENT MARKSHEET
8) CREATION OF STUDENT MARKSHEET
9) CREATING MASTER SEATING PLAN FOR EXAMINATION HALL
10) USE OF LOOKUP FORMULA
11) USE OF VLOOKUP FORMULA
12) USE OF HLOOKUP FORMULA
13) CREATION OF BAR CHARTS AND LINE CHARTS
14) CREATION OF PIE CHARTS
15) CREATION OF PIVOT TABLE
16) CREATION OF PIVOT CHART
17) CREATION OF ATTENDANCE SHEET
18) CALCULATING STAFF SALARY
19) CALCULATING WORKERS SALARY ACCORDING THEIR TIME
20) EXPLANATION OF INVOICE IN MS-EXCEL
21) CREATING INVOICE WITH FORMULAS
22) PURCHASE REPORT, EXPENSE REPORT, WEEKLY TIME SHARE IN MS-EXCEL
