MIS Basic to Advance Excel Course

Download Now


Files Included :

1 MIS Executive Role & Skill Requirements.mp4 (43.37 MB)
MP4
2 Excel Overview.mp4 (31.59 MB)
MP4
1 SUM Function.mp4 (13.56 MB)
MP4
10 HLOOKUP Function.mp4 (25.42 MB)
MP4
11 XLOOKUP Function.mp4 (27.92 MB)
MP4
13 IF Function.mp4 (37.18 MB)
MP4
14 IFS Function.mp4 (30.6 MB)
MP4
15 AND Function.mp4 (29.18 MB)
MP4
16 OR Function.mp4 (53.54 MB)
MP4
17 CONDITIONAL FORMATTING.mp4 (42.59 MB)
MP4
2 SUMIF Function.mp4 (21.48 MB)
MP4
3 SUMIFS Function.mp4 (22.77 MB)
MP4
4 SUMPRODUCT Function.mp4 (17.18 MB)
MP4
6 COUNT Function.mp4 (11.94 MB)
MP4
7 COUNTIF Function.mp4 (19.47 MB)
MP4
8 COUNTIFS Function.mp4 (25.35 MB)
MP4
9 VLOOKUP Function.mp4 (58.78 MB)
MP4
1 Data Cleaning.mp4 (148.41 MB)
MP4
2 Pivot Tables & Charts.mp4 (74.87 MB)
MP4
1 Use Case 1 Calculate Count of the letter in Excel.mp4 (24.11 MB)
MP4
10 Use Case 10 Modify Phone Numbers using Custom Formatting.mp4 (20.11 MB)
MP4
2 Use Case 2 Calculate Total marks based on Students First and Last Name.mp4 (32.81 MB)
MP4
3 Use Case 3 Calculate PassFail column based based on multiple condition.mp4 (34.23 MB)
MP4
4 Use Case 4 Calculate Commission as per Commission table.mp4 (26.24 MB)
MP4
5 Use Case 5 Calculate Employee Attendance.mp4 (21.99 MB)
MP4
6 Use Case 6 Calculate Age of an Employee using VLOOKUP.mp4 (22.01 MB)
MP4
7 Use Case 7 Calculate Full name using VLOOKUP & XLOOKUP function.mp4 (37.57 MB)
MP4
8 Use Case 8 Calculate Number of working days for months.mp4 (17.82 MB)
MP4
9 Use Case 9 Create Pivot table and calculate different KPIs.mp4 (48.62 MB)
MP4