Training Course on Advanced Excel Formula and Functions

Advanced Excel Formula and Functions course focuses on those aspects that are important in everyday day operation of organization. It covers the in-depth topics of Complex Charts, PivotTables, Pivot Charts and management Dashboards. The partakers will be equipped with complex functions within Excel, including tools for analyzing, linking and exporting data.

The course is based on a participatory, active learning approach, with an emphasis on critical reflection and peer-to-peer learning. The course instructor will provide individualised feedback where appropriate. Participants will do the required readings, prepare interim and final assignments and participate in group discussions.

Please note that this course can be adapted to a specific theme like Finance, M&E, or HR dashboards among other specializations.

Participants who successfully complete the course will receive Certificate of Participation.

OBJECTIVES

By the end of the course, the participant should be able to;

• Understand the Functions in Excel used in business
• Analyze bulky data
• Automate and Customize data entry forms
• Comprehend Multiple Variable styles
• Generate Reports
• Assess control of forms, Buttons and Drop-down menus
• Know and understand Special Commands
• Use forms for data entry and report generation control.

DURATION

This course will approximately take 5 days

WHO SHOULD ATTEND?

This course eyes all excel users so as to improve their skills to match their todays’ organizational needs.

COURSE OUTLINE

Day 1:

• Introduction to Excel Formulas
• Conditional Statements & Logical Operators
• Statistical Functions
• lookup/Reference Functions
• Text Functions

Day 2:

• Date & Time Functions
• Formula-Based Formatting
• Array Formulas
• Functions
• Advanced IF Statements

Day 3:

• Advanced Lookup Functions
• Complex Logical and Text Functions
• Formula Auditing
• What-If Analysis Tools
• Worksheet and Workbook Protection

Day 4:

• Advanced Use of PivotTables and Power Pivot
• Automating with Macros
• Working with Form Controls
• Ensuring Data Integrity
• Managing & Enriching Data
• Data Analysis
• Presentation

Day 5:

• Custom Views in Excel
• Scenario
• Auditing and Troubleshooting Formulas
• Pivot Tables and charts
• Goal Seek and Solver and data tables
• Macros

GENERAL NOTES

• The instructor led trainings are delivered using a blended learning approach and comprises of presentations, guided sessions of practical exercise, web-based tutorials and group work. Our facilitators are seasoned industry experts with years of experience, working as professional and trainers in these fields.
• The participants should be reasonably proficient in English as all facilitation and course materials will be offered in English.
• Upon successful completion of this training, participants will be issued with a certificate.
• The training will be held at Kincaid Training Centre. The course fee covers the course tuition, training materials, two break refreshments and lunch.
• All participants will additionally cater for their, travel expenses, visa application, insurance, and other personal expenses.
• Accommodation and airport pickup are arranged upon request. For reservations contact the Training coordinator at Email: training@kincaiddevelopmentcenter.org or Tel: +254 724592901
• This training can also be customized to suit the needs of your institution upon request. You can have it delivered in our Kincaid Training Centre or at a convenient location.

For further inquiries, please contact us on Tel: +254 724592901 or send mail to training@kincaiddevelopmentcenter.org

Payments are due upon registration. Payment should be sent to our Bank account before commencement of training and proof of payment sent to training@kincaiddevelopmentcenter.org