Title of the Workshop

The tittle of the workshop is ‘One Day Workshop on Microsoft Excel – Basic’

 

Overview

This workshop is designed to give a solid foundation in the Microsoft Excel. This is a fully-fledged practical workshop complies with Microsoft Excel 2016. This workshop lessons help to: use math, statistical, logic and text functions; organise data sorting and filtering; effectively present the data in several chart formats; find a value with VLOOKUP; create and format Pivot Tables; record basic Macros, and Data; and optimisation, analysis, transformation, and validation. Sharpening these skills on will assists the participants in improving their study and/or work productivity and accuracy. At the end of the workshop, Microsoft Excel will no longer just be a skill in the participant’ s curriculum 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, business professionals, and workers from government and non-organisation.

 

Duration and Schedule

One day workshop, 8 Hours on Saturday – 9am to 5pm

 

Fee Per Participant

Rs 2750 for Students and Rs 3500 for workers/ staff

 

Medium of Instruction

This workshop 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 workshop will be delivered in a combination of lectures, computer laboratory practical sessions, and group works.

Objectives of the workshop

The objective of the workshop 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

  • 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.
  • Use essential formula, including Dates and Time.
  • Use advance formulas, including the use of Formula Auditing, Temporal Functions, and
    VLOOKUP.
  • Use data: optimisation, analysis, transformation, and validation.
  • Use data visualization.

Course Outline

1.     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

2.     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

3.     Intermediate Formula Knowledge

3.1  Conditional Math

3.2  External Links

4.     Optimizing Data

4.1 Sorting

4.2 Filtering

4.3 Contiguous Data

4.4 Excel Tables

5.     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

6.     Validating and Updating

6.1 Comments & Notes

7.     Help features

7.1 Access help features.

8.     Essential Formula Knowledge

8.1 Understanding Dates

8.2 Understanding Time

9.     Intermediate Formula Knowledge

9.1 Formula Auditing

9.2 Temporal Functions

9.3 VLOOKUP with Approximate Match

9.4 VLOOKUP with Exact Match

9.5 Other Lookup Methods

10.  Optimizing Data

10.1 Naming Ranges

10.2 Excel Tables

10.3 Recording Macros

11.  Data Analysis

11.1 Creating PivotTables

11.2 Formatting PivotTables

11.3 Calculated Fields in PivotTables

11.4 What-If Analysis

12.  Getting and Transforming Data

12.1 Unpivoting Data

12.2 Importing Data from a Text File

12.3 Appending Tables

13.  Presenting and Reporting

13.1 Outlining

13.2 Custom Number Formats

13.3 Conditional Formats with Built-In Rules

13.4 Conditional Formats with Custom Rules

13.5 Building Combination Line and Area Charts

14.  Validating and Updating

14.1 Data Validation

14.2 Data Validation Lists

14.3 Styles

15.  Preparing to Deploy

15.1 Custom Views

15.2 Page Setup Options

15.3 Security Considerations