We've noticed this is not your region.
Redirect me to my region
What do you want to learn today?

Training on Advanced Excel

Training by  Perk Group Africa
Inquire Now
On-Site / Training

Details

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.

Outline

Course Outline

Day 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

Day 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

Day 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

Day 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

Day 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

Special Offer

Group Discounts Apply

Schedules

Oct 21, 2024 - Oct 25, 2024
ENDED
Weekdays 09:00 AM — 05:00 PM
Nov 25, 2024 - Nov 29, 2024
Weekdays 09:00 AM — 05:00 PM
Reviews
Be the first to write a review about this course.
Write a Review

Perk Group Africa is a capacity development, and consultancy center, a leading destination for organizations, groups, and individuals seeking to advance their skills in the many domains within our scope.

Our expertise includes Socio-economic Research, training, and consultancies on Spatial technologies, Climate change (Environmental Sustainability), Gender Inclusivity, Data Management and Statistics, Project Cycle Management, Enterprise Development, Governance, Organizational Development, and Personal Productivity.

PGA has a tradition of work excellence, we are privileged to have a pool of highly experienced and motivated consultants, all of whom are recognized as industry leaders in their respective fields.

Our aim is to ensure that our services contribute to the public good through sharing knowledge for the benefit of society.

Sending Message
Please wait...
× × Speedycourse.com uses cookies to deliver our services. By continuing to use the site, you are agreeing to our use of cookies, Privacy Policy, and our Terms & Conditions.