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

 

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 certified by the National Industrial Training Authority (NITA).

TRAINING VENUE

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

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

ACCOMMODATION AND AIRPORT PICKUP

Accommodation and airport pickup are 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

TAILOR- MADE

This training can also be customized to suit the needs of your institution upon request. You can have it delivered in our IRES Training Centre or at a convenient location.

For further inquiries, please contact us on Tel: +254 715 077 817.

Mob: +254 792516000+254 792516010 or mail This email address is being protected from spambots. You need JavaScript enabled to view it.

PAYMENT

Payment should be transferred to IRES account through bank on or before C.O.B. 23rd November 2020

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

Event Properties

Event Duration 10 Days
Event Date 07-12-2020
Event End Date 18-12-2020
Cut off date 23-11-2020
Individual Price(Kenyan) KES 150,000
Individual Price (International) EUR 1,817
Individual Price(International in Dollars) USD 1,999
Location Nairobi, Kenya
Share this event:

Search