Corporate training · Jifry Issadeen

Microsoft Excel: 5-day corporate training

A practical learning journey from Excel foundations to business analysis, interactive dashboards and modern formulas. Give your team time to build skills through clear explanations, guided examples and hands-on activities.

5 daysStructured learning journey
12 areasFoundations to advanced techniques
36.5 hoursProposed teaching allocation

What the programme covers

Twelve connected learning areas, with practical applications for everyday work.

Excel Essentials

Navigate workbooks, use shortcuts, enter data and manage worksheets with confidence.

Formula Mastery

Build calculations, use mathematical functions and apply number formats.

Data Design & Structure

Organise reliable datasets with Excel Tables, validation, dropdowns and imports.

Smart Decision Functions

Use logical tests and conditional calculations to apply business rules.

Data Lookup & Retrieval

Retrieve information across sheets and workbooks with lookup formulas.

Dynamic Arrays & Filtering

Create flexible extracts and reports using modern sorting and array functions.

Financial Analysis Tools

Explore loan calculations, investment functions, forecasting and what-if analysis.

Visual Data Formatting

Highlight trends, exceptions and key figures with conditional formatting.

Productivity & Efficiency

Organise, consolidate, print and protect workbooks more effectively.

AI-Powered Excel

Explore intelligent assistance, forecasting, recommended charts and Copilot features.

Dashboard & Reporting

Bring together charts, PivotTables, slicers and timelines in interactive reports.

Advanced Formula Techniques

Explore LET, LAMBDA, RegEx and modern functions for more complex solutions.

Tailored to your team: we discuss existing skill levels, software and business priorities before delivery. Some modern functions, data types and AI features depend on the Excel version, subscription and access available. Confirm these before booking.

Your team’s five-day learning journey

Start with a strong foundation, then connect the skills through practical reporting.

Planning note: the supplied daily allocations total approximately 36.5 teaching hours. Breaks and the daily start/finish times are agreed separately; timing and emphasis may be adjusted for the group.

Day 1: Building your Excel foundation

Approximately 7 hours 30 minutes · proposed allocation

Learning modules

Excel Essentials

Excel Fundamentals & Interface Navigation

Excel Essentials

Data Entry & Cell Operations

Formula Mastery

Mathematical Functions & Number Formatting

Key topics and practical work

  • Workbook vs. Worksheet structure, cells, ranges, and navigation
  • Keyboard shortcuts and time-saving techniques (Ctrl+Enter, Go To, Name Box)
  • Copy, cut, paste special, fill handle, and drag operations
  • Row, column, and sheet management
  • SUM, AVERAGE, MIN, MAX, SMALL, LARGE functions
  • Number formatting, absolute cell references, and RANK

What your team will practise: Navigate Excel, enter and manipulate data efficiently, perform essential calculations and apply professional number formatting.

Day 2: Data management, text & dates

Approximately 7 hours · proposed allocation

Learning modules

Data Design & Structure

Data Management & Database Design Principles

Formula Mastery

Text Functions & Data Parsing

Formula Mastery

Date & Time Functions

Key topics and practical work

  • Common database mistakes to avoid
  • Excel Tables and structured references
  • Data validation and dropdown lists (simple & dependent)
  • LEFT, RIGHT, MID, LEN, TRIM, UPPER, LOWER, PROPER
  • TEXTSPLIT, TEXTBEFORE, TEXTAFTER, CONCAT, TEXTJOIN
  • Flash Fill and Text to Columns
  • Date/Time construction, formatting, and calculations
  • DATEDIF, NETWORKDAYS, EOMONTH, WEEKDAY

What your team will practise: Organise clean datasets, validate user input, transform text and perform practical date and time calculations.

Day 3: Logic, decisions & data retrieval

Approximately 6 hours 30 minutes · proposed allocation

Learning modules

Smart Decision Functions

Logical Functions & Conditional Calculations

Data Lookup & Retrieval

Lookup & Reference Functions

Key topics and practical work

  • IF, IFS, nested IF statements
  • AND, OR, NOT logical operators
  • SUMIF, SUMIFS, COUNTIF, COUNTIFS, AVERAGEIF
  • MAXIFS, MINIFS, IFERROR
  • VLOOKUP (single & multiple results)
  • XLOOKUP (modern replacement with advanced features)
  • HLOOKUP and INDEX-MATCH combinations
  • Approximate match lookups

What your team will practise: Apply conditional logic and retrieve data across sheets and workbooks to support invoices, calculations and automated reports.

Day 4: Dynamic data, finance & visual analysis

Approximately 7 hours 15 minutes · proposed allocation

Learning modules

Dynamic Arrays & Filtering

Sorting, Filtering & Dynamic Arrays

Financial Analysis Tools

Financial Functions & What-If Analysis

Visual Data Formatting

Conditional Formatting & Visual Data Rules

Productivity & Efficiency

Data Tools & Productivity Features

AI-Powered Excel

AI-Powered Features & Intelligent Assistance

Key topics and practical work

  • FILTER, SORT, SORTBY, UNIQUE, SEQUENCE functions
  • CHOOSECOLS, CHOOSEROWS, TAKE, DROP
  • Spill ranges and the # operator
  • PMT, PV, FV, NPV, IRR, RATE functions
  • Loan amortization schedules
  • Goal Seek, Data Tables, Scenario Manager
  • Conditional formatting rules (highlight, data bars, color scales)
  • Custom formula-based formatting
  • SmartArt, checkboxes, print setup, protection
  • Flash Fill, Forecasting, Recommended Charts
  • Copilot features and LLM assistance

What your team will practise: Practise dynamic arrays, financial models, visual formatting and productivity tools, and explore how AI can assist with Excel tasks.

Day 5: Dashboards, reporting & advanced techniques

Approximately 8 hours 15 minutes · proposed allocation

Learning modules

Dashboard & Reporting

Reporting, Visualization & Dashboard Design

Advanced Formula Techniques

Advanced Formulas & Modern Excel Functions

Key topics and practical work

  • Shapes, alignment, and design principles
  • Hyperlinks and navigation systems
  • Charts: Column, Bar, Line, Pie, Donut, Combo, Map
  • Sparklines for in-cell visualization
  • PivotTables: creation, customization, and analysis
  • Slicers and Timelines for interactive filtering
  • Complete Dashboard Project (hands-on)
  • Formula-based dashboards with UNIQUE and SUMIFS
  • IMAGE function for dynamic images
  • Geography data types
  • LET, LAMBDA for custom functions
  • VSTACK, HSTACK, TOCOL, TOROW
  • WRAPCOLS, WRAPROWS, BYROW, BYCOL
  • RegExExtract for pattern matching

What your team will practise: Build an interactive dashboard using PivotTables, charts and slicers, and explore advanced formulas including LET and LAMBDA.

Plan Excel training for your team.

Share your team size, current Excel knowledge and preferred dates. We’ll discuss the right pace, priorities and schedule for your organisation.

Jobbees Business Academy 4.9/560 Google reviewsRead Google reviews Checked: 07/11/2026

Figures checked: 07/11/2026

Jifry Issadeen

Corporate Trainer · Founder of LearnNow.lk

CIMA qualified, with over 14 years of experience in finance, analysis and leading finance departments in Sri Lanka and the Middle East.

As the founder of LearnNow.lk and lead trainer at Jobbees Business Academy, I bring practical workplace experience into training in Microsoft Excel, Copilot for Excel, PowerPoint, Customer Service and Practical AI.

I deliver training in English, Sinhala and Tamil, using real-world business examples and hands-on activities to help participants build confidence, improve productivity and apply their learning at work.