SHORT TERM COURSE
Department BBA and BBA(CA)
Title of Course Advanced Excel 2016
Course Level Certificate
Implementation Year 2019-2020
Preamble of the Syllabus Advanced Excel is very useful for solving difficulties in Accounting work and training in Corporate excel.
Faculty of the Course BBA , BBA(CA) and Commerce
Co- Coordinator Prof. Ms. Prerana Hegade
Duration 3 Months Approx.
Eligibility 12th in any Stream
Maximum strength 40
Total hours of teaching 30
Pattern of the Exam Online Exam
Daily/ weekly Timing 2 days in week (1Hr. lecture)
Objectives/ Skills
1. To enhance practical knowledge
2. To focus on placement assured training to students
Teaching Faculty : Visiting
Curriculum Attached with this
Expected Outcomes Students can get proficient for industrial and market research analysis tools..
Syllabus MS Excel 2016
Sr. No Topics
1. Introduction to MS Excel 2016
2. Conditional Formatting
3. Tables in Excel
4. Advanced Sort and Filter options
5. Creating Charts and Graphics
6. Pivot table and Pivot Chart
7. Data validation , solver
8. Scenario, Goal seek, Data table
9. Working with Formulas and Functions
10. Financial Functions
11. LOOKUP and Reference Functions
12. Database Functions
13. Hyperlinks, Linking and Embedding
14. VBA in Excel 2016
15. Online Exam