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

19 - 23 Dec, 2022  5 days

Follow Event

  

USD 2,990

Venue: Mombasa

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.

Mombasa Dec 19 - 23 Dec, 2022
USD 2,990.00
USD 1,000.00
(Convert Currency)

DUNCAN KARIUKI +254723360025

DATA-AFRIQUE CONSULTANCY
NST PPC Advert

Related Courses

Training on Solar Panel Installation Training on Solar Panel Installation

5 days, 19 - 23 Dec, 2022 

2022-12-19 12:12:00 2022-12-19 12:12:00
Kenya

Data-Afrique Consultants

This 5-day solar installation training course will provide you with a solid grounding in solar technology, the terminology associated with the industry, what makes up solar installation, the key ...

Mobile Data Collection for M and E using ODK and Kobotoolbox Mobile Data Collection for M and E using ODK and Kobotoolbox

5 days, 19 - 23 Dec, 2022 

2022-12-19 12:12:00 2022-12-19 12:12:00
Kenya

Data-Afrique Consultants

Data collection and monitoring and evaluation (M and E) have always been an integral part of development work. In the past, these tasks were performed with paper and pen, which made them prone to ...

Training on Women Empowerment, Leadership and Professional Development Training on Women Empowerment, Leadership and Professional Development

5 days, 19 - 23 Dec, 2022 

2022-12-19 12:12:00 2022-12-19 12:12:00
Kenya

Data-Afrique Consultants

According to the World Bank: Empowerment is the process of increasing the capacity of individuals or groups to make choices and to transform those into desired actions and outcomes. Women empowerment ...

Training on Monitoring and Evaluating for Human Rights Programmes Training on Monitoring and Evaluating for Human Rights Programmes

12 days, 12 - 23 Dec, 2022 

2022-12-12 12:12:00 2022-12-12 12:12:00
Kenya

Data-Afrique Consultants

Monitoring and evaluation (M and E) skills are fundamental to the process of designing and implementing programs that impact human beings positively, analyzing and using data, and conducting advocacy ...