Corporate training · Jifry Issadeen

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.

3 daysStructured learning programme
22 hoursPlanned teaching time
12 modulesFoundations to dashboards

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 teaching

Build 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 / topicKey areas coveredLearning outcomesTime
Excel Fundamentals & Interface NavigationCells, references, navigation, data selection, Go To, Name Box, Name Manager, Formula Bar, Quick Access Toolbar, Status Bar customizationNavigate Excel efficiently using keyboard shortcuts and mouse; customize interface for productivity108 min
Data Entry & Cell OperationsCopy/cut/paste, paste special, fill handle, row/column/sheet operations, find & replace, number sequencesPerform efficient data manipulation; use advanced paste options and fill techniques107 min
Mathematical Functions & Number FormattingArithmetic/comparison operators, SUM, MIN, MAX, AVERAGE, SMALL, LARGE, RANK.EQ, PRODUCT, SUMPRODUCT, rounding functions, number formats, absolute referencesBuild calculation formulas; apply professional number formatting; understand cell reference types158 min
Data Entry & Data ManagementExcel Tables, structured references, data validation (numbers, dates, dropdowns), Get Data from external sourcesCreate structured tables; implement data validation rules; import data from various sources38 min

Day 2: Analysis, formulas & visual rules

4 modules · 7 hours 48 minutes of teaching

Clean 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 / topicKey areas coveredLearning outcomesTime
Text Functions & Data ParsingLEFT, RIGHT, MID, LEN, TEXTSPLIT, TEXTBEFORE, TEXTAFTER, TRIM, UPPER, LOWER, PROPER, Flash Fill, Text-to-Columns, CONCAT, TEXTJOIN, REPT, TEXT, RegExExtractClean and transform messy text data; extract specific information from complex strings; standardize data formats161 min
Conditional Formatting & Visual Data RulesValue comparisons, text/date/duplicate highlighting, Top/Bottom rules, Data Bars, Color Scales, formula-based custom rulesCreate dynamic visual formatting that automatically highlights patterns, exceptions, and key metrics60 min
Date & Time FunctionsDATE, TIME, TODAY, NOW, DAY, MONTH, YEAR, DATEDIF, EOMONTH, EDATE, NETWORKDAYS, WORKDAY, WEEKDAY, custom date formattingPerform accurate date/time calculations; handle business day computations; create age/tenure calculations103 min
Logical Functions & Conditional CalculationsIF, IFS, AND, OR, SUMIF/SUMIFS, AVERAGEIF/AVERAGEIFS, COUNT/COUNTA/COUNTBLANK, COUNTIF/COUNTIFS, IFERROR, advanced absolute referencesBuild automated decision logic; create conditional aggregations; handle errors gracefully; automate commission and discount calculations144 min

Day 3: Advanced reporting & productivity

4 modules · 7 hours 21 minutes of teaching

Connect 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 / topicKey areas coveredLearning outcomesTime
Lookup & Reference FunctionsVLOOKUP (exact/approximate match, multiple columns), XLOOKUP (multiple lookups, nested), INDEX-MATCH-XMATCH combinations, practical invoice applicationsRetrieve data from any table structure; connect data across worksheets; build automated lookup systems146 min
Sorting, Filtering & Dynamic ArraysFilter feature, SUBTOTAL, FILTER function, SORT/SORTBY, CHOOSECOLS/CHOOSEROWS, TAKE/DROP, UNIQUE, SEQUENCE, spill ranges, # operatorCreate dynamic, auto-updating data extractions; filter and sort data with formulas; leverage modern array capabilities120 min
Productivity Tools & Data UtilitiesCheckboxes, print setup (titles, orientation, scaling), duplicate handling, Consolidate, Group/Ungroup, Freeze Panes, Sheet ProtectionStreamline daily tasks; prepare professional printouts; protect and organize workbooks effectively53 min
Dashboard Design & VisualizationSparklines (Line, Column, Win/Loss), Slicers, Pivot Tables (creation, configuration, Field List), Pivot Charts, interactive dashboard design with linked slicersCreate professional interactive dashboards; build dynamic reports with Pivot Tables; design compelling data visualizations122 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.

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.