Title of the Seminar
The tittle of the seminar is ‘Seminar on Microsoft Excel – Basic’
Overview
This seminaris designed to give a solid foundation in the basics of Microsoft Excel. This is a fully-fledged practical seminarthat complies with Microsoft Excel 2016. The learns helpsto: use math, statistical, logic and text functions; organise data sorting and filtering;and effectively present the data in several chart formats.Learning these skills on Microsoft Excel will assists the participants to improve the study and/or work productivity andaccuracy. At the end of the seminar, Microsoft Excel will no longer just be a skill in the participant’scurriculum vitae but a value addition to their professional life.
In completion a ‘Participation Certificate’ will be awarded IT Centre, Vavuniya Campus of the University of Jaffna.
Target Group
This seminar is designed for school students in age 15 or above, school leavers from GCE Ordinary Level as well as GCE Advanced Level,students from undergraduates as well as postgraduates, business professionals, and workers from government and non-organisation.
Duration and Schedule
3 Hours – on Wednesday, from 2pm to 4pm OR Saturday, from 9am to 12noon.
Fee Per Participant
Rs 1500 for Students and Rs 2000 for workers/ staff
Medium of Instruction
This seminar is conducted in bilingual languages including English and Tamil. Participants can use both English and/or Tamil in the lecture discussions.
Method of Teaching and Learning
The seminar will be delivered in a combination of lectures, computer laboratory practical sessions, and group works.
Objectives of the seminar
The objective of the seminar is:
- To provide the basic knowledge of spreadsheet concepts.
- To provide the practical skill in using the Microsoft Excel 2016 software.
- To produce capable personnel in office applications, to the present job market.
Learning outcomes
After completing this seminar, the participants should be able to:
- Indicate the names and functions of the Excel interface components.
- Enter and edit data.
- Format data and cells.
- Construct formulas, including the use of built-in functions, and relative and absolute references.
- Create and modify charts.
- Preview and print worksheets.
- Use the Excel online Help feature.
Course Outline
- Getting to Know Excel
1.1 The Ribbon
1.2 The Work Surface
1.3 Navigation
1.4 First File
1.5 Formatting
1.6 Basic Math
- Essential Formula Knowledge
2.1 Formula Anatomy
2.2 Cell Referencing
2.3 Function Anatomy
2.4 Math Functions
2.5 Basic Statistics
2.6 Logic Functions
2.7 Text Functions
- Intermediate Formula Knowledge
3.1 Conditional Math
3.2 External Links
- Optimizing Data
4.1 Sorting
4.2 Filtering
4.3 Contiguous Data
4.4 Excel Tables
- Presenting and Reporting
5.1 Cell Formatting
5.2 Building Column Charts
5.3 Building Bar Charts
5.4 Building Pie Charts
5.5 Building Line Charts
- Validating and Updating
6.1 Comments & Notes
- Help features