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

Training on Intermediate Excel

Training by  Perk Group Africa
Inquire Now
On-Site / Training
Mar 18, 2024 - Mar 22, 2024
USD  1,000.00

Details

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.

Outline

Course Outline

Day 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

Day 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

Day 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)

Day 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

Day 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

Special Offer

Group Discount Apply

Schedules

Mar 18, 2024 - Mar 22, 2024
Weekdays 09:00 AM — 05:00 PM
Apr 22, 2024 - Apr 26, 2024
Weekdays 09:00 AM — 05:00 PM
May 27, 2024 - May 31, 2024
Weekdays 09:00 AM — 05:00 PM
Jul 01, 2024 - Jul 05, 2024
Weekdays 09:00 AM — 05:00 PM
Aug 05, 2024 - Aug 09, 2024
Weekdays 09:00 AM — 05:00 PM
Sep 09, 2024 - Sep 13, 2024
Weekdays 09:00 AM — 05:00 PM
Oct 14, 2024 - Oct 18, 2024
Weekdays 09:00 AM — 05:00 PM
Nov 18, 2024 - Nov 22, 2024
Weekdays 09:00 AM — 05:00 PM
No. of Days: 5
Total Hours: 40
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.