Microsoft Excel: 3-day corporate training
A practical programme covering Excel foundations, business formulas and interactive reporting. Help your team handle everyday data tasks with greater confidence through guided examples and exercises.
Is this the right programme for your team?
From a stronger foundation to more confident analysis and reporting.
Who it is for
Corporate staff, finance teams, business analysts and administrative professionals who use Excel to manage, calculate or report on data.
How the programme is shaped
We discuss your team’s current knowledge, software and priorities before delivery. The pace and emphasis can be adapted to the group and the time available.
What the programme covers
- Navigation, shortcuts and everyday productivity
- Data entry, validation and structured tables
- Mathematical, text, date and logical formulas
- Conditional formatting and visual analysis
- Lookups, filtering and dynamic arrays
- Pivot Tables, charts, slicers and dashboards
Before booking: confirm the Excel versions available to participants. Some modern functions and features depend on the installed version. Session durations below are a proposed teaching allocation; breaks and the daily timetable are agreed separately.
Day 1: Excel foundations & data handling
4 modules · 6 hours 51 minutes of teachingBuild confidence with navigation, cell operations, calculations and structured data. By the end of the day, participants practise navigating Excel, creating calculations, formatting results and managing data in tables.
| Session / topic | Key areas covered | Learning outcomes | Time |
|---|---|---|---|
| Excel Fundamentals & Interface Navigation | Cells, references, navigation, data selection, Go To, Name Box, Name Manager, Formula Bar, Quick Access Toolbar, Status Bar customization | Navigate Excel efficiently using keyboard shortcuts and mouse; customize interface for productivity | 108 min |
| Data Entry & Cell Operations | Copy/cut/paste, paste special, fill handle, row/column/sheet operations, find & replace, number sequences | Perform efficient data manipulation; use advanced paste options and fill techniques | 107 min |
| Mathematical Functions & Number Formatting | Arithmetic/comparison operators, SUM, MIN, MAX, AVERAGE, SMALL, LARGE, RANK.EQ, PRODUCT, SUMPRODUCT, rounding functions, number formats, absolute references | Build calculation formulas; apply professional number formatting; understand cell reference types | 158 min |
| Data Entry & Data Management | Excel Tables, structured references, data validation (numbers, dates, dropdowns), Get Data from external sources | Create structured tables; implement data validation rules; import data from various sources | 38 min |
Day 2: Analysis, formulas & visual rules
4 modules · 7 hours 48 minutes of teachingClean text, highlight important information and build date-based and conditional calculations. Participants work through text extraction, conditional formatting, business-day calculations and formulas that apply business rules.
| Session / topic | Key areas covered | Learning outcomes | Time |
|---|---|---|---|
| Text Functions & Data Parsing | LEFT, RIGHT, MID, LEN, TEXTSPLIT, TEXTBEFORE, TEXTAFTER, TRIM, UPPER, LOWER, PROPER, Flash Fill, Text-to-Columns, CONCAT, TEXTJOIN, REPT, TEXT, RegExExtract | Clean and transform messy text data; extract specific information from complex strings; standardize data formats | 161 min |
| Conditional Formatting & Visual Data Rules | Value comparisons, text/date/duplicate highlighting, Top/Bottom rules, Data Bars, Color Scales, formula-based custom rules | Create dynamic visual formatting that automatically highlights patterns, exceptions, and key metrics | 60 min |
| Date & Time Functions | DATE, TIME, TODAY, NOW, DAY, MONTH, YEAR, DATEDIF, EOMONTH, EDATE, NETWORKDAYS, WORKDAY, WEEKDAY, custom date formatting | Perform accurate date/time calculations; handle business day computations; create age/tenure calculations | 103 min |
| Logical Functions & Conditional Calculations | IF, IFS, AND, OR, SUMIF/SUMIFS, AVERAGEIF/AVERAGEIFS, COUNT/COUNTA/COUNTBLANK, COUNTIF/COUNTIFS, IFERROR, advanced absolute references | Build automated decision logic; create conditional aggregations; handle errors gracefully; automate commission and discount calculations | 144 min |
Day 3: Advanced reporting & productivity
4 modules · 7 hours 21 minutes of teachingConnect data, streamline reporting and bring information together in an interactive dashboard. Participants practise lookups, dynamic filtering and workbook utilities before creating reports with Pivot Tables, charts and slicers.
| Session / topic | Key areas covered | Learning outcomes | Time |
|---|---|---|---|
| Lookup & Reference Functions | VLOOKUP (exact/approximate match, multiple columns), XLOOKUP (multiple lookups, nested), INDEX-MATCH-XMATCH combinations, practical invoice applications | Retrieve data from any table structure; connect data across worksheets; build automated lookup systems | 146 min |
| Sorting, Filtering & Dynamic Arrays | Filter feature, SUBTOTAL, FILTER function, SORT/SORTBY, CHOOSECOLS/CHOOSEROWS, TAKE/DROP, UNIQUE, SEQUENCE, spill ranges, # operator | Create dynamic, auto-updating data extractions; filter and sort data with formulas; leverage modern array capabilities | 120 min |
| Productivity Tools & Data Utilities | Checkboxes, print setup (titles, orientation, scaling), duplicate handling, Consolidate, Group/Ungroup, Freeze Panes, Sheet Protection | Streamline daily tasks; prepare professional printouts; protect and organize workbooks effectively | 53 min |
| Dashboard Design & Visualization | Sparklines (Line, Column, Win/Loss), Slicers, Pivot Tables (creation, configuration, Field List), Pivot Charts, interactive dashboard design with linked slicers | Create professional interactive dashboards; build dynamic reports with Pivot Tables; design compelling data visualizations | 122 min |
What your team can take back to work
Practical skills to support more efficient, accurate and confident Excel use.
Navigate with confidence
Use shortcuts, efficient selection techniques and customised interface tools.
Organise data effectively
Work with cell operations, tables, validation and practical data-management tools.
Build useful formulas
Apply mathematical, text, date/time and logical functions to business calculations.
Make information clearer
Use number formats and conditional formatting to highlight patterns and exceptions.
Connect and filter data
Practise VLOOKUP, XLOOKUP, INDEX-MATCH and modern dynamic array functions.
Create interactive reports
Bring together Pivot Tables, charts and slicers in a professional dashboard.
Plan Excel training for your team.
Share your team size, current Excel knowledge and preferred dates. We’ll discuss how this three-day programme can fit your requirements.
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













