Food Security and Agriculture

Training Course on Advanced Excel

Course Overview

This Advanced Excel course offers a practical approach to mastering the advanced features and functionalities of Microsoft Excel.

Through a combination of hands-on exercises, real-world examples, and advanced techniques, participants will explore the powerful capabilities of Excel. They will learn how to effectively analyze complex data sets, automate tasks with macros, create dynamic reports and dashboards, and utilize advanced functions and formulas.

This course is designed for individuals who already have a solid foundation in Excel and want to elevate their skills to an advanced level.

Course Duration

Online Training: 6 days

Classroom Training: 5 days

Course Outline

Module 1: Advanced Functions and Formulas

  • Review of essential functions and formulas
  • Working with advanced mathematical and statistical functions
  • Exploring logical functions and nested formulas
  • Using advanced lookup functions for data retrieval and manipulation
  • Protecting data with Excel’s data protection features

Module 2: Data Analysis and Visualization

  • Advanced data sorting and filtering techniques
  • Utilizing advanced data analysis tools (Solver, Goal Seek, Scenario Manager)
  • Creating dynamic and interactive charts and graphs
  • Customizing chart elements and formatting options
  • Building visually appealing and interactive dashboards

Module 3: Data Manipulation and Automation

  • Working with advanced data manipulation techniques (Text to Columns, Flash Fill)
  • Using advanced filtering and conditional formatting
  • Importing and exporting data from different sources (CSV, text files, databases)
  • Introduction to Excel macros and automation
  • Creating and running macros to automate repetitive tasks

Module 4: Advanced Data Modeling and Analysis

  • Working with PivotTables for advanced data analysis and reporting
  • Utilizing PivotTable features (grouping, calculated fields, data slicers)
  • Creating dynamic PivotCharts for visual analysis
  • Protecting and securing data in Excel workbooks
  • Auditing formulas and resolving errors using formula auditing tools

Module 5: Advanced Reporting and Macros

  • Creating advanced reports with PivotTable slicers, timelines, and sparklines
  • Recording and editing macros to automate complex tasks
  • Importing and exporting data between Excel and other applications
  • Applying advanced data validation techniques
  • Protecting sensitive data and implementing data security measures

Note: This course outline provides a general structure for a 5-day training program on Advanced Excel. The specific content, activities, and duration of each session may be adjusted based on the target audience, learning objectives, and available time.

Classroom Training Schedule

Start Date End Date Location Cost Apply
Mar 25, 2024 Mar 29, 2024 Nairobi $ 950 Register
Apr 29, 2024 May 03, 2024 Nairobi $ 950 Register
Jun 03, 2024 Jun 07, 2024 Nairobi $ 950 Register
Jul 08, 2024 Jul 12, 2024 Nairobi $ 950 Register
Aug 12, 2024 Aug 16, 2024 Nairobi $ 950 Register
Sep 16, 2024 Sep 20, 2024 Nairobi $ 950 Register
Oct 21, 2024 Oct 25, 2024 Nairobi $ 950 Register
Nov 25, 2024 Nov 29, 2024 Nairobi $ 950 Register

Virtual Training Schedule

Start Date End Date Location Cost Apply
Mar 04, 2024 Mar 09, 2024 Online $ 400 Register
Apr 08, 2024 Apr 13, 2024 Online $ 400 Register
May 13, 2024 May 18, 2024 Online $ 400 Register
Jun 17, 2024 Jun 22, 2024 Online $ 400 Register
Jul 22, 2024 Jul 27, 2024 Online $ 400 Register
Aug 26, 2024 Aug 31, 2024 Online $ 400 Register
Sep 30, 2024 Oct 05, 2024 Online $ 400 Register
Nov 04, 2024 Nov 09, 2024 Online $ 400 Register
Dec 09, 2024 Dec 14, 2024 Online $ 400 Register

Registration Process

Enrolling in our training programs is effortless! Upon submitting your details on the course registration link, a representative will get in touch with the relevant information.

Group Discounts

Boost your team's skills and maximize value with our attractive group discounts. Enroll 3 or more participants and enjoy significant discounts on any of our training programs.

Course Language

This Training course is offered in ENGLISH . Please indicate the language of choice during registration.

Training Approach

Our instructor-led trainings use well guided presentations, practical exercises, and group acivities. Participants are encouraged to bring any data relevant to their job responsibilities. Training manuals and additional reference materials are provided to the participants.

Certification

Upon completion of training, the participant will be issued with a certificate of Completion.

Post Training Support

Our commitment our clients success extends beyond the training program. We offer ongoing 3 months support through Q&A sessions, online forums, and access to our expert instructors.

Tailor-Made Course

We design customized training programs and inhouse workshops to meet specific training needs and organizational goals. Contact us to find out more: training@perk-gafrica.com