Summary
Date Posted: Tuesday, August 18, 2020 , Base Salary: Not Disclosed

JOB DETAILS:
Call for Registration:
ADVANCED EXCEL workshop training & introduction to Models (Financial and non-Financial) using advanced excel
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 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:
LOGICAL 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 TRUE and FALSE
• Using AND
• Using OR
• Using NOT
• SUMIF & SUMIFS
• COUNTIF & COUNTIFS
LOOKUP FUNCTIONS & Project Plan (Gantt Chart) in excel
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
WHAT-IF ANALYSIS
What-If Analysis are another very powerful tool to master when working with large amounts of data. For example, if working with a series including dates and values of a variable, they offer the ability to find certain data and have the formula return the value of that variable on the specific date being search for.
The key topics covered include:
• Scenario Manager
• Goal Seek
• Data Table
FORMULA AUDITING
Formula auditing will help you to discount and see the type of formula used in the excel database. Your work will more accurate once you are sure of the utilized formulas.
The key topics covered include:
• Show formulas
• Errors checking
• Evaluate formula
• Trace precedents
• Trace dependents
• Remove arrows
Solver
• Understanding How Solver Works
• Installing the Solver Add-In
• Setting Solver Parameters
• Adding Solver Constraints
• Performing the Solver Operation
• Running Solver Reports
VALIDATING DATA
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 meet 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
DATA CONSOLIDATION
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 different 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
PIVOT TABLES& DASHBOARD MANAGEMENT
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
• Dashboard Management
TIME SERIES SALES FORECASTING USING ADVANCED EXCEL
• Understanding Time series concept
• Historical sales data management
• Historical data analysis
• Time series plot
• Understand trend components
• The irregular component in time series
• Design with graph quarterly time series forecasts
INTRODUCTION TO MODELS IN EXCEL
• Definition
• Keys Models and Use
• Practical Exercises
Workshop Date & Time & Venue
Date: 24 & 25 August 2020 (Workdays Program)
Date: 28 & 29 August 2020 (Week End Program)
Hours: from 09:00 AM to 5:00 PM
Lunch break (12:00 to 2:00)
Venue: Our Training venue, Kigali Rwanda
Eligibility & Pricing
Training Price: 130,000 RWF
Having your own Computer
Cost components include:
1. Access to training;
2. Certificate;
3. Course hand out;
4. Tea break and lunch are included .

Job Responsibilities: Not Specified

Job Skills: Not Specified

Job Qualifications: Not Specified

Job Education Requirements: Not Specified

Job Experience Requirements: Not Specified

Work Hours: 8

{module 312}

Job application procedure
REGISTRATION GATE:
Get an invitation letter by sending an e-mail to:
erpstatisticslab10@gmail.com  or call us on 0788 26 35 60
DISCOUNT Available to group application as follow:
• Group of 2 people:5%
• Group of 3 People:10%
• Above 3 people:20%

All Jobs

QUICK ALERT SUBSCRIPTION

{module 317}