Title of the Seminar
The tittle of the seminar is ‘Seminar on Microsoft Excel – Advanced’
Overview
This is a fully-fledged practical seminar that helps to learn advanced Excel techniques.Microsoft Excel 2016 will be used to learnto: find a value with VLOOKUP; create and format Pivot Tables; record basic Macros, and Data; and optimisation, analysis, transformation, and validation.Sharpening these techniqueswill assists the participants in improving their study and/or work productivity &accuracy. 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 workshop 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, 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 3000 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 intermediate and advance knowledge of spreadsheet concepts.
- To provide the knowledge in analysing business data.
- To produce capable personnel in office applications, to the present job market.
Learning outcomes
After completing this seminar, the participants should be able to:
- Use essential formula, including Dates and Time.
- Use advance formulas, including the use ofFormula Auditing, Temporal Functions, and VLOOKUP.
- Use data: optimisation, analysis, transformation, and validation.
- Use data visualization.
Course Outline
- Essential Formula Knowledge
1.1 Understanding Dates
1.2 Understanding Time
- Intermediate Formula Knowledge
2.1 Formula Auditing
2.2 Temporal Functions
2.3 VLOOKUP with Approximate Match
2.4 VLOOKUP with Exact Match
2.5 Other Lookup Methods
- Optimizing Data
3.1 Naming Ranges
3.2 Excel Tables
3.3 Recording Macros
- Data Analysis
4.1 Creating PivotTables
4.2 Formatting PivotTables
4.3 Calculated Fields in PivotTables
4.4 What-If Analysis
- Getting and Transforming Data
5.1 Unpivoting Data
5.2 Importing Data from a Text File
5.3 Appending Tables
- Presenting and Reporting
6.1 Outlining
6.2 Custom Number Formats
6.3 Conditional Formats with Built-In Rules
6.4 Conditional Formats with Custom Rules
6.5 Building Combination Line and Area Charts
- Validating and Updating
7.1 Data Validation
7.2 Data Validation Lists
7.3 Styles
- Preparing to Deploy