Country dropdown

Intermediate Microsoft Excel Training Course

INTRODUCTION

This intermediate Microsoft Excel training course is suitable all version of Excel from 2007. The course will assist participants in expanding their data management, computation and analysis knowledge and skills. By the end of this course, a participant will be able to create charts, use basic functions effectively and work with the Excel list/database features. This course will be delivered by seasoned Microsoft Excel trainers who will ensure exchange of lots of key practical skills.

This course will involve the use of numerous examples and exercises in a workshop environment in order to allow plenty of time to practice and consolidate the learnings. The course training will involve version 2013 which is almost identical to 2007, 2010 and 2016.

DURATION

5 days

OBJECTIVES OF THE COURSE

By the end of this course, students will be able to create and format charts, work effectively with multiple sheets in workbooks,  use productivity tools, copy and paste data in the format you want it in, quick analysis tools and work with the Excel list/database features.

COURSE OUTLINE

Formulas and Functions

  • Understanding functions
  • Summing non-contiguous ranges
  • Calculating an average
  • Maximum and minimum functions
  • Common error messages

Worksheet Techniques

Being able to manipulate and control worksheets is a key skill in Excel. This will show you how to make your worksheets do exactly what you want them to, and also how to format them to make working with them clearer. It also covers hiding and unhiding rows and columns within a worksheet.

The key topics covered include:

  • Renaming, Inserting And Deleting Worksheets
  • Copying And Moving Worksheets
  • Hiding And Unhiding A Worksheet
  • Copying a worksheet to new and other workbooks
  • Changing Worksheet Tab Colours
  • Grouping Worksheets
  • Hiding and Unhiding Rows And Columns
  • Freezing Rows And Columns
  • Splitting Windows

Data Linking

As you become a more proficient Excel user it is very likely that your spreadsheets will contain more than one worksheet. This means that you then need to be able to link data from one worksheet to another worksheet, and potentially from one workbook to another workbook. This lesson leads you through how to do that quickly and simply.

The key topics covered include:

  • Understanding Data Linking
  • Linking Between Worksheets
  • Linking Between Workbooks
  • Updating Links Between Workbooks

Creating Charts

The ability to quickly and simply create a chart or graph to illustrate the data in your spreadsheet is one of the most used parts of Excel. The chart wizard offers a huge number of potential chart types and presentation options. This session shows you how to create a simple chart and the basics of how to work with it.

The key topics covered include:

  • Understanding The Charting Process
  • Choosing The Chart Type
  • Creating A New Chart
  • Working With An Embedded Chart
  • Resizing The Chart
  • Dragging A Chart
  • Printing An Embedded Chart
  • Creating A Chart Sheet
  • Changing The Chart Type
  • Changing the Chart Layout
  • Changing The Chart Style
  • Printing A Chart Sheet
  • Embedding A Chart Into A Worksheet
  • Deleting A Chart

Charting Techniques

  • Understanding chart layout elements
  • Adding a chart title
  • Adding axes titles
  • Positioning the legend
  • Showing data labels
  • Showing a data table
  • Modifying the axes
  • Showing gridlines
  • Formatting the plot area
  • Showing the plot area
  • Adding a trendline
  • Adding error bars
  • Adding a text box to a chart
  • Drawing shapes in a chart

Special Pasting

Cutting and pasting in Excel can be tricky when working with different data types. As ever, Excel offers a number of options to ensure that it all works smoothly. This session will make sure that you get it right first time.

The key topics covered include:

  •  understanding pasting options
  •  pasting formulas
  •  paste values
  •  pasting without borders
  •  paste as a link
  •  paste as a picture
  • Transposing ranges
  • Copying comments
  • Copying validations
  • Copying column widths
  • Performing arithmetic with paste special
  • Copying formats with paste special
  • Add values and multiply values

Conditional Formatting

Excel offers the ability to only change the formatting of cells meeting certain criteria. This can make finding key data in a large spreadsheet very quick and simple. This session shows you how to set the criteria that you are looking for and also how to format those cells to ensure that you can easily see them.

The key topics covered include:

  • Understanding conditional formatting
  • Highlighting cells containing values
  • Highlighting cells containing text
  • Highlighting duplicate values
  • Using top and bottom rules
  • Using data bars
  • Using colour scales
  • Using icon sets
  • Creating custom rules
  • The conditional formatting rules manager
  • Managing rules
  • Clearing rules
  • Using Sparklines

Hyperlinks

  • Hyperlinking within a workbook
  • Using a hyperlink
  • Hyperlinking to a range
  • Hyperlinking between applications

Sorting Data

  • Understanding lists
  • Performing an alphabetical sort
  • Performing a numerical sort
  • Sorting on more than one column
  • Sorting numbered lists
  • Sorting by rows

Working With Tables

  • Creating a table
  • Inserting or deleting table records
  • Removing duplicates
  • Modifying a table
  • Sorting data in a table
  • Filtering data in a table
  • Adding and removing table columns
  • Naming tables
  • Resizing tables
  • Playing with table styles
  • Converting a table to a range
  • Deleting a table

Filtering Data

  • Understanding filtering
  • Applying and using a filter
  • Clearing a filter
  • Creating compound filters
  • Multiple value filters
  • Creating custom filters
  • Using wildcards

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

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 training centre or at a convenient location.

For further inquiries, please contact us on Tel: +254 715 077 817, +254 (020) 211 3814 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. 8th July 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 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 5 Days
Event Date 15-07-2019
Event End Date 19-07-2019
Cut off date 08-07-2019
Individual Price(Kenyan) KES 69,000
Individual Price (International) EUR 790
Individual Price(International in Dollars) USD 920
Location Nairobi, Kenya
Share this event:

Contact Us

+254 715077817 | +254 792516000
outreach@indepthresearch.org
Westlands, Rhapta Road
Njema Court, Suite R2

Search