Back to Courses

Introduction to Excel

ENDED

Workshop by Indepth Research Institute (IRES)

Inquire Now

On-Site / Workshop

USD 1,100.00

Inquire Book Now

RESPONSE RATE

Details
Outline
About the Provider

Book Now

Inquire

Details

Introduction

Excel has powerful tools that enable busy users to set up systems that simplify data analysis and interpretation. Effectively using Excel allows users to devote their time more profitably to making decisions about and acting on results, with more effective outcomes.

Participants will actively learn through a series of practical simulations which ensures that they maximize their learning and can use the tools immediately when they return to the office. In addition to the practical component, all participants also receive a manual describing all the techniques learned.

Outline

Training Content

Introduction to Microsoft Excel

What is a spreadsheet?

Getting Started

Starting Excel
The Excel screen and The Ribbon
Quick Access Toolbar and shortcut keys
Formula bar and name box
Sheet tabs and the status bar
Active cell, column and row headers
Moving around the spreadsheet
Exiting Excel

Spreadsheet Basics

Creating a new workbook
Data types
Entering and editing data
Entering dates and times
Deleting data
Undo
Selection techniques
Saving and closing a workbook
Opening a workbook
File Formats and Working in Compatibility mode

Cut, Copy and Paste

The clipboard
Using cut, copy and paste
Drag and drop
AutoFill
Custom lists and Excel Options

Entering Basic Calculations

Entering calculations
AutoSum
Auto Complete
Statistical functions

Formatting the Worksheet

Home and Page Layout Tab
Working with columns and rows
Number formats
Date and time formats
Alignment and orientation
Borders and patterns
Cell Styles
Format painter

Printing

Print preview
Page Layout View
Page setup
Page breaks
Print titles
Headers and footers
Printing

Working with Larger Spreadsheets

Splitting the screen
Freezing panes

Introduction to Charting

Creating a chart
Printing a chart

Speaker/s

IRES TEAM

Reviews

Be the first to write a review about this course.

Write a Review

Indepth Research Services (IRES) is a global institutional capacity building, technical and management consultancy firm with its head office in Nairobi, Kenya.

IRES offers technical and management consultancy services as well as education and training services designed for individuals’ and groups from organizations working in public, not for profit and private sectors.

IRES Kenya has identified itself with a niche market that largely comprises of Government ministries, departments and agencies (MDA’s) and UN agencies, Non-Governmental Organizations, from Africa, Europe, Asia, Middle-East and the Caribbean. We have also served academic institutions, international research organizations, financial institutions and private companies from across the globe. As at 2018 we offer our services in more than 15 locations globally.

Our technical and management consultancy services are in the areas of Agriculture, Education, Energy, Oil and gas, Health, Environment and natural resources, ICT for development, spatial planning, Governance, Management and leadership, communication, transport, revenue management, marketing development and environment among others.
Our education and training services are aimed helping individuals improve their professional knowledge, competence, skill, and effectiveness and enable the institutions to get the best out of their workforce. This is achieved through conducting high impact professional diploma and certificate courses, short courses, conferences, workshops and seminars. ...

View Complete Profile

Statistics and Data Science