Advanced Excel workshop Training

Average: 3.9 (44 votes)

We are a leading Training Center of Accounting & Statistical Softwares in Rwanda registered under company law of Rwanda. We are specialized in providing best-in-class technical and corporate training and certifications on all popular ERP and statistical Packages Accounting and technologies available globally. We offer several innovative learning methods and delivery models to cater the unique requirements of a global customer base.

We have a team of Certified Trainers with minimum 10+ years of Industry background. Our courses are for individuals as well as for corporate. We also undertake customization of the courses as per client requirement.

ADVANCED EXCEL workshop training

Workshop objective

This course is designed to help QuickBooks users from non- profit organizations to discover some challenges and Different settings of MS Advanced Excel:

This course is designed to help MS Excel users to get enough skills to fulfill the Data Management &accounting responsibilities.

Target audience

Finance managers, Accountants, Auditors, analysts, consultants, HR Specialists who want to master the skills of Advanced Excel.


The first session of this course reviews the concept of creating and using names for cells which is covered in our Intermediate Excel Course. In doing so it also quickly reviews formulas and selections.

The key topics covered include:


This section of the course introduces logical functions. This is a key part of more advanced Excel use. It focuses on the use of IF functions and how they can be combined to produce Nested IF functions and also combined with AND, NOT or OR in more complicated situations.

The key topics covered include:

  • Understanding Logical Functions
  • Using IF With Text
  • Using IF With Numbers
  • Nesting IF Functions
  • Using IFERROR
  • Using TRUE and FALSE
  • Using AND
  • Using OR
  • Using NOT


When working with large amounts of data the ability to validate data using Excel is critical. This is especially true when working in combination with logical formulas which require that all data is in the appropriate format to work. This session covers both data validation, which is checking that the data in the cells meets certain criteria and also the ways that you can then highlight data that does not meet the criteria.

The key topics covered include:

  • Validating Data
  • Understanding Data Validation
  • Creating a Number Range Validation
  • Testing a Validation
  • Creating an Input Message
  • Creating an Error Message
  • Creating a Drop Down List
  • Using Formulas as Validation Criteria
  • Circling Invalid Data
  • Removing Invalid Circles
  • Copying Validation Settings


Lookup functions are another very powerful tool to master when working with large amounts of data. They allow individual items in a list to be found and then the corresponding value from another column or row in the same data table. For example, if working with a series including dates and values of a variable, they offer the ability to find a certain data and have the formula return the value of that variable on the specific date being search for.

The key topics covered include:

  • Understanding Data Lookup Functions
  • Using CHOOSE
  • Using VLOOKUP
  • Using VLOOKUP for Exact Matches
  • Using HLOOKUP
  • Using INDEX
  • Using Match
  • Understanding Reference Functions
  • Using ROW and ROWS
  • Using COLUMN and COLUMNS
  • Using ADDRESS
  • Using INDIRECT
  • Using OFFSET


Excel contains a number of features that allow you to very quickly summarise large amounts of data. This shorter session will show you how to very quickly use these features to create sub-totals and other summary statistics.

The key topics covered include:

  • Creating Subtotals
  • Using a Subtotalled Worksheet
  • Creating Nested Subtotals
  • Copying Subtotals
  • Using Subtotals With AutoFilter
  • Creating Relative Names for Subtotals
  • Using Relative Names for Subtotals


Worksheets with a lots of content can become unwieldy and difficult to navigate around. To deal with this, Excel gives you the option to organize your data in groups. These allowing you to easily show and hide different sections of your worksheet. You can also summarize different groups using the Subtotal command and create an outline for your worksheet.

The key topics covered include:

  • Creating An Automatic Outline
  • Working With An Outline


PivotTables are one of Excel’s most powerful functions. They are extremely versatile and make it very easy to extract information from large tables of data without the use of formulas. They are also very quick to use as by moving or pivoting, fields of data from one location to another using drag and drop functionality they allow you to look at the same data in a number of different ways.

The key topics covered include:

  • understanding Pivot Tables
  • Recommended Pivot Tables
  • Creating Your Own PivotTable
  • Defining the PivotTable Structure
  • Filtering a PivotTable
  • Clearing a Report Filter
  • Switching PivotTable Fields
  • Formatting a PivotTable
  • Understanding Slicers
  • Creating Slicers
  • Inserting a Timeline Filter


The session builds on the previous PivotTable session which introduced the concept. This takes the use of PivotTables one step further and leads delegates through summarising, grouping, sorting and names the data held in the PivotTable that they have created. This session demonstrates how powerful Excel can be when used correctly. Thousands of data records can be quickly and simply manipulated, analysed and presented using PivotTables in a matter of minutes.

The key topics covered include:

  • Using Compound Fields
  • Counting in a PivotTable
  • Formatting PivotTable Values
  • Working With PivotTable Grand Totals
  • Working With PivotTable Subtotals
  • Finding the Percentage of Total
  • Finding the Difference From
  • Grouping in PivotTable Reports
  • Creating Running Totals
  • Creating Calculated Fields
  • Providing Custom Names
  • Creating Calculated Items
  • PivotTable Options
  • Sorting in a PivotTable


Excel’s Consolidate feature allows you to merge and summarize values from multiple workbooks. It’s a great tool for combining data when several users work with different instances of the same file but can also be used when the data to be consolidated is held in differernt formats.

The key topics covered include:

  • Understanding Data Consolidation
  • Consolidating Data with Identical Layouts
  • Creating a Linked Consolidation
  • Consolidating Data with Different Layouts
  • Consolidating Data Using the SUM Function

Workshop Date & Time & Venue

Date:28 & 29 December 2019 (Work days Program)

Hours: from 08:00 AM to 5:00 PM

Lunch break (12:00 to 2:00)

Venue: Our Training venue, Kigali Rwanda

Eligibility & Pricing

Training Price: 118,000 RWF

Having own Computer

Cost components include:

  1. Access to training;
  2. Certificate;
  3. Course hand out
  4. Tea break (10h:00 to 10:30)

Note: Lunch is inclusive


Get an invitation letter by sending an e-mail to: or call us on 0788 26 35 60

DISCOUNT Available to group application as follow:

  • Group of 2 people:10%
  • Group of 3 People: 15%
  • Above 3 people:20%