BSC IT
Theory & Practical for Full year syllabus
Language : English
What will I Learn?
What will I Learn?
Master the skills of Microsoft Excel
Master the skills of Microsoft Excel
Improve efficiency in analytics
Improve efficiency in analytics
Have a great satisfaction of achieving new skills
Have a great satisfaction of achieving new skills
Includes access till course completion
Includes access till course completion
Access on Mobile
Access on Mobile
Exclusive user
Exclusive user
MS-Excel
MS-Excel
Knowledge of
Knowledge of
Basic Excel
Basic Excel
15
15
Days
Days
2 per day
2 per day
(30 Assignments)
(30 Assignments)
1 Final test
1 Final test
(100 Marks)
(100 Marks)
Advance Excel
Advance Excel
Completion
Completion
Requirements
Requirements
- You need to have latest version of Microsoft Excel loaded on your machine.
- You just need to have basic knowledge of Microsoft Excel
- We recommend Microsoft Excel 2016
Who is the target audience?
Who is the target audience?
- Anyone who is interested to shape up their knowledge in Microsoft Excel
Course Content:
Course Content:
1. Excel (Home tab, Charts, Formula)
2. If, Conditional Formatting, Nested If
3. Filter, Subtotal, Data Validation
4. Pivot Table & Charts, Vlookup, Freeze, Split
5. Goal Seek
6. Scenario
7. Macro