Nigerian Seminars and Trainings

Search all upcoming seminars, conferences, short management courses and training in Nigeria and around the World

business logo

Advanced Excel Formulas and Functions Course

By: Data-Afrique Consultants

Kenya

03 - 07 May, 2021  5 days

Follow Event

  

USD 1,000

Venue: Data-Afrique Training Centre, Nairobi, Kenya

The course focuses on those aspects that are important in everyday day operation of organization. Intermediate users will also benefit from this course as it covers the in-depth topics of Complex Charts, PivotTables, Pivot Charts and management Dashboards.

Who Should Attend?

The course is targeted excel uses to improve their Skills for today’s organization’s needs. It will equip participant with complex functions within Excel, including tools for analysing, linking and exporting data.

Course Objective:

  • Functions in Excel mostly used in business
  • analysing large data
  • Management dashboards
  • Automate and Customize data entry forms
  • Multiple Variable styles
  • Custom Formulas/Functions
  • Generate Reports
  • Control of forms, Buttons and Drop-down menus
  • Special Commands
  • Using forms for data entry and report generation control.
  • Course content
  • Introduction
  • Excel Formulas
  • Conditional Statements and Logical Operators
  • Statistical Functions
  • lookup/Reference Functions
  • Text Functions
  • Date and Time Functions
  • Formula-Based Formatting
  • Array Formulas
  • Functions
  • Advanced IF Statements
  • Advanced Lookup Functions
  • Complex Logical and Text Functions
  • Formula Auditing
  • What-If Analysis Tools
  • Worksheet and Workbook Protection
  • Advanced Use of PivotTables and Power Pivot
  • Automating with Macros
  • Working with Form Controls
  • Ensuring Data Integrity
  • Managing and Enriching Data
  • Data Analysis
  • Presentation
  • Custom Views in Excel
  • Scenario
  • Auditing and Troubleshooting Formulas
  • Pivot Tables
  • Pivot Charts
  • Goal Seek and Solver and data tables
  • Macros
  • Basic Visual Basic

General Notes

This course is delivered by our seasoned trainers who have vast experience as expert professionals in the respective fields of practice. The course is taught through a mix of practical activities, theory, group works and case studies.

Training manuals and additional reference materials are provided to the participants.

 Upon successful completion of this course, participants will be issued with a certificate.

Data-Afrique Training Centre, Nairobi, Kenya May 03 - 07 May, 2021
USD 1,000.00
(Convert Currency)

DUNCAN KARIUKI +254723360025

DATA-AFRIQUE CONSULTANCY

Related Courses

Training on Project Information Management System For Development Organizations and NGOs Training on Project Information Management System For Development Organizations and NGOs

5 days, 07 - 11 Jun, 2021 

2021-06-07 12:06:00 2021-06-07 12:06:00
Kenya

Data-Afrique Consultants

The goal of information management is to ensure that the right information reaches the right stakeholders at the right time. Project stakeholders, donors, partners, and beneficiaries depend on good ...

Training on Research Design, Mobile Data Collection, Mapping and Data Analysis Using NVivo and Python Training on Research Design, Mobile Data Collection, Mapping and Data Analysis Using NVivo and Python

12 days, 07 - 18 Jun, 2021 

2021-06-07 12:06:00 2021-06-07 12:06:00
Kenya

Data-Afrique Consultants

New developments in data science offer a tremendous opportunity to improve decision-making. In the development world, there has been an increase in the number of data gathering initiative such as ...

Training Course on Non-Governmental Organizations NGOS Management Training Course on Non-Governmental Organizations NGOS Management

12 days, 07 - 18 Jun, 2021 

2021-06-07 12:06:00 2021-06-07 12:06:00
Kenya

Data-Afrique Consultants

This course offers participants with relevant information on non-governmental organization management. It focuses on the key issues in the management of NGOs emphasizing organizations working on ...

GIS Mapping Visualization and Analysis Using QGIS Training GIS Mapping Visualization and Analysis Using QGIS Training

12 days, 07 - 18 Jun, 2021 

2021-06-07 12:06:00 2021-06-07 12:06:00
Kenya

Data-Afrique Consultants

It’s a known fact that information is processed from facts and figures; we also agree that if data is not well managed it can be overwhelming. Giving a spatial dimension to data and performing ...