Workshop Training on Data Analysis with Advanced Excel & Advanced Power Point

Rating: 
Average: 4.2 (18 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:

WORKSHOP TRAINING on DATA ANALYSIS with ADVANCED EXCEL & ADVANCED POWERPOINT 

Duration

2 full days (8:00 AM – 5:00 PM)

Thursday 20 December 2018: 8:00 AM – 5:00 PM

Friday 21 December 2018: 8:00 AM – 5:00 PM

 Workshop venue

Our Training Venue, Kigali - Rwanda

Contact: +250 788 30 39 75

ATTENDANCE REQUIREMENTS:

  • Workshop Training Fees: 100,000 RWF per Person;
  • Having own laptop computer

 BENEFITS:

  1. Training certificate at the completion;
  2. Tea breaks (2) per day
  3. Lunch (1) per day

Workshop objectives

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 and advanced Powerpoint.

WORKSHOP COURSE OUTLINES:

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:

TOPIC No.1: DATA Cleaning

  • Using UPPER, LOWER, PROPER AND TRM
  • Using LEFT, MID, AND RIGHT
  • Using CONCATENATE
  • Using ROUNDUP
  • Using ROUNDDOWN
  • Managing ERROR EDIT
  • Managing BLANKS in the table
  • Checking DUPLICATES in database
  • Perform CONDITIONAL FORMATING

TOPIC No.2: LOGICAL, DATE & lookup FUNCTIONS

 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 SUMIF Function
  • Using TRUE and FALSE
  • Using AND
  • Using OR
  • Using NOT
  • Understanding Dates Functions
  • Understanding Data Lookup Functions
  • Using VLOOKUP
  • Using VLOOKUP for Exact Matches
  • Using HLOOKUP
  • Using INDEX
  • Using Match
  • Understanding Reference Functions
  • Using ROW and ROWS
  • Using COLUMN and COLUMNS

TOPIC No.3: VALIDATING DATA & DATA CONSOLIDATION

  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
  • Understanding Data Consolidation
  • Consolidating Data with Identical Layouts
  • Creating a Linked Consolidation
  • Consolidating Data with Different Layouts
  • Consolidating Data Using the SUM Function

Topic No.4: PIVOTTABLES

 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

Topic No.5 DATA VISUALIZATION & DASHBOARD PRESENTATION

Creating Combination Charts

Creating a Combo Chart with Secondary Axis

Discriminating Series and Category Axis

Chart Elements and Chart Styles

Creating a dashboard from multiple charts.

Topic No.6 ANIMATED POWERPOINT PRESENTATION

  • Create multiple slides
  • Importing Data from MS Excel
  • Animation of slides
  • Save Powerpoint presentation show

Registration Guideline:

Register by sending an e-mail to info@erp-statisticslab.com or Call +250 78830 39 75