Call for Application for ADVANCED EXCEL workshop training

Rating: 
Average: 4.1 (19 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.

Title: Call for Application for ADVANCED EXCEL workshop training.

Workshop objectives

This course is designed to help MS Excel users to discover some challenges and Different settings of MS Advanced Excel and to get enough skills to fulfill the Data Management & accounting and statistical responsibilities.

Target audience

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

WORKSHOP COURSE OUTLINES:

The key topics covered include:

LOGICAL FUNCTIONS

The key topics covered include:

  • Understanding Logical Functions
  • Using IF With Text
  • Using IF With Numbers
  • Nesting IF Functions
  • Using IFERROR
  • Using AND
  • Using OR
  • Using NOT
  • SUMIF
  • SUMIFS
  • COUNTIF
  • COUNTIFS

VALIDATING DATA

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

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

SUMMARISING AND SUBTOTALLING

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

PIVOTTABLES

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

DATA CONSOLIDATION

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

WHAT IF ANALYSIS

The key topics covered include:

  • What-if Analysis
  • Goal Seeking
  • Understanding Goal Seek Components
  • Using Goal Seek
  • Data Table
  • Scenarios Manager

FORMULA AUDITING IN EXCEL

  • Error checking
  • Show formulas
  • Evaluate formula
  • Trace Dependents
  • Trace Precedents

Workshop Venue & Date

ERP-STATISTICS LAB Training Venue, Kigali – Rwanda

Date of 02 & 03 May 2019 (2 Days)

Eligibility: Training Fees: 118.000 RWF per Person & having own laptop computer

Benefits: Training certificate at completion;

Registration process:

e-mail toinfo@erp-statisticslab.com

or call:(+250) 788 30 39 75