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