Country dropdown

Microsoft Excel Essentials Course

Introduction
Excel is our most popular series classes. A green flag beside a date on the right means that a session has met the minimum enrollment levels and is running. However, it is common for dates for this course to fill several weeks in advance. Even if a date has a green flag, you might not be able to get into that session if it is full. To avoid disappointment, it is best to register for this class at least three weeks in advance.

Overview
Learn the basics of creating spreadsheets in Excel. Enter data, formulas, format and print workbooks.

Target Student
This course is for individuals whose job responsibilities include creating, inputting and printing basic spreadsheets.

Prerequisites
Basic Windows, keyboarding and mouse skills.

Course Objective
If you do well in this unit, you should be able to:

  • Indicate the names and functions of the Excel interface components.
  • 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

 

Course Outline

Getting Started
Starting Excel
Opening a Workbook
Understanding the Display Screen
Working with the Ribbon
Exploring the File Tab
Working with the Quick Access Toolbar
Working with the Status Bar
Switching Between Opened Workbooks
Using Excel Help

Entering Data
Moving the Cell Pointer
Selecting a Range of Cells
Creating a New Workbook
Inserting, Renaming, and Deleting Worksheets
Entering Constant Values
Using Auto Fill to Enter Data
Saving a Workbook
Editing Cell Contents
Clearing Cell Contents
Working with Undo and Redo
Closing a Workbook

Using Formulas
Entering Formulas
Using Auto Fill with Formulas
Using the SUM Function
Summing Columns or Rows Automatically
Using Statistical Functions
Working with the Range Finder
Using Formula Error Checking

Working with Constant Values and Formulas
Copying and Pasting Constant Values and Formulas
Cutting and Pasting Constant Values and Formulas
Using Collect and Paste

Formatting Worksheets
Formatting Numbers
Changing the Font Format
Aligning Cell Contents
Merging Cells
Adding Borders
Applying Cell Styles

Modifying Columns and Rows
Changing Column Width
Changing Row Height
Inserting and Deleting Columns or Rows
Hiding Columns or Rows

Editing Workbooks
Working with AutoCorrect
Checking Spelling
Using Find and Replace

Printing Worksheets
Using Print Preview
Working with Print Settings
Using Page Setup Tools
Working in Page Layout View
Creating a Header and Footer
Using Page Break Preview
Printing a Worksheet
Exiting Excel

 

TAILOR- MADE

This training can also be customized for your institution upon request to a minimum of 4 participants. You can have it delivered in our IRES Training Centre or at a convenient location.

For further inquiries, please contact us on 

Tel: +254 (020) 211 3814.

Mob: +254 715 077 817, +254 731 240 802, +254 735 331 020.

Email: This email address is being protected from spambots. You need JavaScript enabled to view it..

REQUIREMENTS

Participants should be reasonably proficient in English. Applicants must live up to Indepth Research Services (IRES) admission criteria.

METHODOLOGY

The instructor led trainings are delivered using a blended learning approach and comprises of presentations, guided sessions of practical exercise, web based tutorials and group work. Our facilitators are seasoned industry experts with years of experience, working as professional and trainers in these fields.

All facilitation and course materials will be offered in English. The participants should be reasonably proficient in English.

ACCREDITATION

Upon successful completion of this training, participants will be issued with an Indepth Research Services (IRES) certificate.

TRAINING VENUE

The training is residential and will be held at IRES Training Centre. The course fee covers the course tuition, training materials, two break refreshments, lunch, and study visits.

All participants will additionally cater for their, travel expenses, visa application, insurance, and other personal expenses.

ACCOMMODATION

Accommodation is arranged upon request. For reservations contact the Training Officer.

Email: This email address is being protected from spambots. You need JavaScript enabled to view it..

Mob: +254 715 077 817

Tel: 020 211 3814

PAYMENT

Payment should be transferred to IRES account through bank on or before C.O.B 2nd December 2019.

Send proof of payment to This email address is being protected from spambots. You need JavaScript enabled to view it..

CANCELLATION POLICY

Payment for the all courses includes a registration fee, which is non-refundable, and equals 15% of the total sum of the course fee.

  1. Participants may cancel attendance 14 days or more prior to the training commencement date.
  2. No refunds will be made 14 days or less to the training commencement date. However, participants who are unable to attend may opt to attend a similar training at a later date, or send a substitute participant provided the participation criteria have been met

Please Note: The program content shown here is for guidance purposes only. Our continuous course improvement process may lead to changes in topics and course structure.

Event Properties

Event Duration 10 Days
Event Date 09-12-2019
Event End Date 20-12-2019
Cut off date 25-12-2019
Individual Price(Kenyan) KES 139,000
Individual Price (International) EUR 1,200
Individual Price(International in Dollars) USD 1,390
Location Nairobi, Kenya
Share this event:

Search