Job Description

Course level: Intermediate Excel Course

Course Overview

This intermediate certification course bridges the gap between basic spreadsheets and dynamic data analysis. Students will build practical, job-ready skills to manipulate data, automate tasks, and generate professional reports.

Certification Requirements

• Prerequisites: Basic understanding of Excel, cell referencing, and simple functions (SUM/AVERAGE).
• Assessment: Practical exercises and a final multiple-choice or project-based assessment.
• Completion: Certificate of achievement awarded upon successful passing of the final assessment.

Format

Over the course of 5 days, you will be immersed in a dynamic on site/ Online learning journey, featuring expert-led classrooms, curated visual, and collaborative problem-based learning activities, all facilitated by skilled and experienced instructors in the field. Practical, hands-on assignment and/or a short multiple-choice quiz.

Experiences and Qualifications

The Training will cover the following Content

Module 1: Advanced Formulas & Functions

Moving beyond basic math to make spreadsheets "smarter" and automate logic.

• Logical Functions: Using IF, IFS, AND, OR, and NOT.
• Lookup & Reference: Mastering VLOOKUP, XLOOKUP, and INDEX + MATCH and XLOOKUP
• Mathematical & Statistical: Utilizing SUMIFS, COUNTIFS, and AVERAGEIFS.

Module 2: Data Management & Cleaning

Tools and techniques to organize, clean, and validate large datasets.

• Advanced Sorting & Filtering: Multi-level sorting, using AutoFilter, and extracting filtered rows.
• Data Validation: Creating drop-down lists and setting custom data entry rules.
• Data Cleanup: Using Flash Fill to auto-extract text and removing duplicate values.

Module 3: Data Analysis & Summarization

Tools to aggregate large volumes of raw data into digestible business metrics.

Excel Tables: Creating, formatting, and using structured references.

• Subtotals & Outlines: Grouping rows/columns and creating summary outlines.
• PivotTables: Creation, modification, layout design, and creating Calculated Fields.

Module 4: Data Visualization & Formatting

Presenting your data clearly using professional charts and dynamic visual tools.

Dynamic Charts: Creating and customizing bar, line, pie, and combination charts.

• Conditional Formatting: Highlighting data based on cell values or using custom formula rules.
• Sparklines: Inserting mini-charts directly into single cells for quick visual trends

Skills Required

Follow us on social media