MS EXCEL ESSENTIALS

MS EXCEL ESSENTIALS

Course Overview

This course is designed to introduce learners to the fundamentals of Microsoft Excel. Participants will develop essential skills in data entry, manipulation, analysis, and presentation.

Course Objectives

Upon completion of this course, participants will be able to:

  • Create and manage Excel worksheets
  • Enter and format data effectively
  • Utilize basic formulas and functions
  • Create charts and graphs for data visualization
  • Apply data filtering and sorting techniques

Course Outline

Module 1: Introduction to Excel (2 hours)

  • Excel interface and basic navigation
  • Creating and saving workbooks
  • Understanding worksheets and cells
  • Data entry and editing

Module 2: Data Formatting (4 hours)

  • Cell formatting (number formats, alignment, fonts)
  • Conditional formatting
  • Data validation
  • Autofill and series

Module 3: Formulas and Functions (6 hours)

  • Basic arithmetic operators
  • Cell referencing (relative, absolute, mixed)
  • Built-in functions (SUM, AVERAGE, COUNT, etc.)
  • Creating and using formulas

Module 4: Data Analysis (4 hours)

  • Sorting and filtering data
  • Data analysis tools (subtotal, pivot table)
  • What-if analysis (goal seek, data tables)

Module 5: Charts and Graphs (4 hours)

  • Creating various chart types (column, line, pie, etc.)
  • Customizing chart elements
  • Chart formatting and layout

Assessment

  • Practical exercises and assignments
  • Hands-on projects

Target Audience

This course is suitable for individuals with basic computer skills who want to learn how to use Excel for data management and analysis. It is beneficial for students, professionals, and anyone who works with numerical data.

Course Materials

  • Microsoft Excel software
  • Course handouts or digital materials

Note: The duration of each module can be adjusted based on the participants’ learning pace and the depth of coverage desired.

Total Fees: 20,000/=
Total Duration: 20 Hours (2 hours  x  10 Classes)
Training Mode: Individual Training, your own timetable

Live Online Classes  or Face to Face Direct Classes with our expert trainers.
Call +94 (0) 722000999 / +94 (0) 755123111 www.iss.lk. Medium : සිංහල / தமிழ் / English