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
Mahapola Ports & Maritime Academy

Mahapola Ports & Maritime Academy - Workshop On Making Teamwork

Mahapola Ports & Maritime Academy - Workshop On Making Teamwork

clock-img

Duration

One Day

Medium

English

Physical
BIMT Colombo Campus

Diploma in Customer Relationship Management

Diploma in Customer Relationship Management

clock-img

Duration

Medium

English

Physical
CINEC Metro Campus

Basic Hydraulics Course

Basic Hydraulics Course

clock-img

Duration

05 Days

Medium

English

Physical
ETMA Campus

Solar Training

Solar Training

clock-img

Duration

0.5 Month

Medium

English

Physical
Braintree Campus

Certificate in business studies

Certificate in business studies

clock-img

Duration

1.5 years

Medium

English

Physical
CINEC Metro Campus

Engineer Officer Cadet Foundation Training Course

Engineer Officer Cadet Foundation Training Course

clock-img

Duration

06 Months

Medium

English

Ask from Mahapola Ports & Maritime Academy