• LOGIN
  • No products in the cart.

Course Curriculum

Section 1 - Excel Basic
Intro Excel FREE 00:02:00
1-MS Basic Excel (Menu Bar-intro) 00:13:00
2-Intro for Menu Bar 00:07:00
3-Intro for Menu Bar 00:10:00
4-Mouse Icon Types 00:05:00
Additional Practical (1) FREE 00:08:00
Section 2 - Work with Cells & Workbook
05-Typing the data & Format Worksheet.wmv 00:09:00
06-Adjust Width High 00:05:00
07-Using Insert R & C Delete Function and Merge & Center.wmv 00:08:00
08-Copy & Paste.wmv 00:07:00
09-Transpose Functions 00:05:00
Section 3 - Calculate your data
10-AutoSum & Other 00:10:00
11-Calculation Subtract, Multiply ,Divide.wmv 00:06:00
Additional Practical (2) FREE 00:11:00
12-calculation sheet to sheet.wmv 00:09:00
13-average(1).wmv 00:05:00
Additional Practical (3) 00:04:00
14-Using IF Formula 00:06:00
Additional Practical (4) 00:04:00
15-formula IF -And (1) 00:11:00
16-Using IF+IF Formula 00:08:00
Additional Practical (5) 00:05:00
Section 4 - Format your workbook
17-Creat the Standard Table & Form 00:12:00
18-Format Table 00:05:00
19-Page Setup & Print Setting 00:05:00
20-Typing Text Box.wmv 00:05:00
21-Insert Picture 00:04:00
Section 5 - Add Chart & Graph
22-How to create the chart (seperate) 00:08:00
Additional Practical (6) 00:06:00
Section 6 - Analysis your data
23-Sort & Filter 00:07:00
24-Quick Analysis Tools 00:06:00
25-Goal Seek 00:05:00
26-Lookup Functions 00:06:00
27-Vlookup Functions 00:06:00
28-Remove Duplicate 00:04:00
29-Make the Hyperlink 00:05:00
End Video Excel 00:02:00
© Copyright 2017 - | COURSECOM by UMG IDEALAB TECH INCUBATOR | All Rights Reserved.
X