Total Duration- 5 Hours

Learning Objective-

1. To get acquainted with basic utility of MS Excel

2. To understand the basic functionalities of MS Excel

3. To assimilate the intermediate functionalities of MS Excel

Learning Outcomes-

1. Students will be able to develop in depth understanding about utility of MS Excel

2.Students will be able to utilize basic & intermediate functionalities while maintaining large

databases in Excel at their workplace.

Syllabus

Module No

Particulars

Hours allocated

1

Understanding Utility of Excel & File Tab, Home Tab

1

2

Learning Insert & Page layout

1

3

Learning use of Formulas

1

4

Learning Data, Review & View Tabs

1

Assessment-

Total 50 marks assessment will be conducted.

Assessment will be of 1 hour.

Participants have to complete following tasks successfully to secure 25 marks out of

50 marks for passing.

1

Applying Pivot

20

2

Applying Filter

10

3

Using formulae of Sum, Multiplication

10

4

Sorting the data

10

Total

50