Other

Mahapola Ports & Maritime Academy - Course On Advanced Microsoft Office Excel 200x

Course Overview


To provide advanced knowledge and develop competencies on Windows Based Electronic Spread Sheet Application using Microsoft Excel


CONTENTS


  • Introduction to Electronic Spread Sheet Packages and its behaviours
  • Introduction to Microsoft Excel
  • Creating a Data Sheet
  • Formatting a Worksheet / Data Sheet
  • Create Formulas and use Built-in Functions
  • Practice Sorting methods
  • Calculate Sub totals
  • Apply Conditional Formatting Concepts
  • Practice Logical AND / OR / NOT operators
  • Practice Advanced Filtering events
  • Data Analysis using Pivot Tables
  • Data export and import among Separate Sheets in Work Book
  • Data export and import among Separate Work Books
  • Practice to create and Activate Macros
  • Print a Work Sheet
  • Create, Modify and Print a Graph


METHODOLOGY

All the sessions will be Lectured followed by practical sessions, discussions, assignments

Duration

14 days

Category

Other

Course Level

Other

Related Courses

Physical
IIBM Campus

Diploma in Business Management

Diploma in Business Management

clock-img

Duration

Medium

English

Physical
Sri Lanka Institute of Development Administration

Diploma Land Administration

Diploma Land Administration

clock-img

Duration

Medium

English

Physical
GISM - Graduate Institute of Science and Management

Bachelor of Science

Bachelor of Science

clock-img

Duration

Medium

English

Physical
Campus Direct

Campus Direct - Summer Intensive - Certificate

Campus Direct - Summer Intensive - Certificate

clock-img

Duration

2 Years

Medium

English

Physical
Aquinas College of Higher Education

Diploma in Floriculture & Landscaping

Diploma in Floriculture & Landscaping

clock-img

Duration

2 Years

Medium

English

Physical
Management & Science Institute

Diploma in Computer Science

Diploma in Computer Science

clock-img

Duration

16 Months

Medium

English

Ask from Mahapola Ports & Maritime Academy