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.
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 allocationLearning modules
Excel Fundamentals & Interface Navigation
Data Entry & Cell Operations
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 allocationLearning modules
Data Management & Database Design Principles
Text Functions & Data Parsing
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 allocationLearning modules
Logical Functions & Conditional Calculations
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 allocationLearning modules
Sorting, Filtering & Dynamic Arrays
Financial Functions & What-If Analysis
Conditional Formatting & Visual Data Rules
Data Tools & Productivity Features
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 allocationLearning modules
Reporting, Visualization & Dashboard Design
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.
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.

Jifry Issadeen













