Training Course on Intermediate Excel
Course Overview
This course is fundamentally designed to improve participants’ skills and knowledge in Microsoft excel. The course will equip participants with the essential skills to boost their productivity, improve data accuracy, and make informed decisions using Excel’s advanced features and functionalities.
The participants will gain a comprehensive understanding of intermediate-level Excel functions and techniques. They will learn how to efficiently manage and manipulate data, perform complex calculations, and create professional-looking spreadsheets.
This course is designed for individuals who have a basic understanding of Excel and want to enhance their proficiency in data analysis, formula building, and data visualization.
Course Duration
Online Training: 6 days
Classroom Training: 5 days
Course Outline
Module 1: Advanced Formulas and Functions
- Review of basic Excel functions and formulas
- Working with logical functions (IF, AND, OR)
- Using lookup functions (VLOOKUP, HLOOKUP, INDEX, MATCH)
- Applying text functions (LEFT, RIGHT, MID, CONCATENATE)
- Introduction to array formulas
Module 2: Data Analysis and Manipulation
- Sorting and filtering data
- Using advanced data validation techniques
- Applying conditional formatting
- Working with data tables and what-if analysis
- Introduction to PivotTables and PivotCharts
Module 3: Working with Advanced Functions
- Working with date and time functions
- Utilizing statistical functions (AVERAGE, COUNT, MAX, MIN)
- Performing mathematical calculations (SUMPRODUCT, ROUND, ABS)
- Using financial functions (NPV, IRR, PMT)
- Customizing and creating user-defined functions (UDFs)
Module 4: Data Visualization and Reporting
- Creating dynamic charts and graphs
- Customizing chart elements and formatting options
- Building interactive dashboards
- Utilizing slicers and timelines
- Generating reports with data visualization techniques
Module 5: Advanced Data Management Techniques
- Working with tables and structured references
- Using data validation and conditional logic
- Advanced filtering techniques
- Data consolidation and linking
- Automating tasks with macros
Note: This outline provides a general structure for a 5-day training program on Intermediate 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 |
---|---|---|---|---|
May 27, 2024 | May 31, 2024 | Nairobi | $ 950 | Register |
Jul 01, 2024 | Jul 05, 2024 | Nairobi | $ 950 | Register |
Aug 05, 2024 | Aug 09, 2024 | Nairobi | $ 950 | Register |
Sep 09, 2024 | Sep 13, 2024 | Nairobi | $ 950 | Register |
Oct 14, 2024 | Oct 18, 2024 | Nairobi | $ 950 | Register |
Nov 18, 2024 | Nov 22, 2024 | Nairobi | $ 950 | Register |
Virtual Training Schedule
Start Date | End Date | Location | Cost | Apply | |||
---|---|---|---|---|---|---|---|
Jun 10, 2024 | Jun 15, 2024 | Online | $ 400 | Register | |||
Jul 15, 2024 | Jul 20, 2024 | Online | $ 400 | Register | |||
Aug 19, 2024 | Aug 24, 2024 | Online | $ 400 | Register | |||
Sep 23, 2024 | Sep 28, 2024 | Online | $ 400 | Register | |||
Oct 28, 2024 | Nov 02, 2024 | Online | $ 400 | Register | |||
Dec 02, 2024 | Dec 07, 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