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