Country dropdown
Don't have an account yet? Register Now!

Sign in to your account

Advanced Processing and Management of data with CSPro


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 teachings. 


2 Weeks


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.


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


  • 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



The participants are required to have a good command of the English language and reasonable computing skills.


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.


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


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 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: +250 789 621 067 

Tel: 020 211 3814


Payment should be transferred to IRES account through bank on or before Monday, 27th July 2020..

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


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 03-08-2020
Event End Date 14-08-2020
Cut off date 27-07-2020
Individual Price(rwanda franc) R₣ 1,112,000
Individual Price (International) EUR 1,771
Individual Price(International in Dollars) USD 1,999
Location Kigali,Rwanda
We are no longer accepting registration for this event
Share this event:

Contact Us

+250 789 621 067
[email protected]
Kamukina KG 501 Gate
Kigali, Rwanda

IRES Facebook Feeds

IRES Twitter Feeds

©2020 Indepth Research Institute. All Rights Reserved.


Don't have an account yet? Register Now!

Sign in to your account