📚MICROSOFT EXCEL 5-DAY CORPORATE TRAINING PROGRAM
As the founder and lead trainer at LearnNow.lk, Jifry Issadeen specializes in corporate Excel training, financial modeling, and Microsoft 365 applications tailored for professional teams. His programs combine real-world finance expertise with the latest Excel technology, ensuring participants gain both skill and confidence to apply what they learn effectively at work.
Jifry Issadeen (ACMA, CGMA) is a finance professional and corporate Excel trainer with over 15 years of experience in financial management and data analytics. Having served in multiple finance roles across leading organizations, he brings deep practical insight into how Microsoft Excel drives accuracy, efficiency, and better business decisions.
COURSE CATEGORIES & COVERAGE
| Course Category & Coverage | |
|---|---|
| 🎯 |
Excel Essentials
Master the fundamentals that power every Excel expert. Learn to navigate Excel with confidence—from understanding cells, rows, and columns to mastering keyboard shortcuts that save hours. Build a rock-solid foundation in data entry, selection techniques, and workbook management that accelerates everything you do in Excel.
|
| 📊 |
Formula Mastery
Unlock the power of calculations and number formatting. Transform raw data into meaningful insights using essential mathematical functions like SUM, AVERAGE, MIN, MAX, and ROUND. Master number formats, percentage calculations, and the art of building formulas that work every time.
|
| 🗃️ |
Data Design & Structure
Build bulletproof databases that scale. Learn the golden rules of data architecture, avoid common mistakes that break spreadsheets, and harness Excel Tables for automatic data management. Create smart dropdowns using data validation and import data from virtually any source.
|
| 🧠 |
Smart Decision Functions
Let Excel make intelligent decisions for you. Master IF statements, nested logic, and conditional functions that automate complex decision-making. From commission calculations to multi-criteria analysis, build formulas that think.
|
| 🔍 |
Data Lookup & Retrieval
Find any data instantly—no matter where it lives. Master VLOOKUP, XLOOKUP, and INDEX-MATCH to retrieve information across multiple sheets and workbooks. Build dynamic invoices, automated reports, and real-time data connections.
|
| ⚡ |
Dynamic Arrays & Filtering
Experience the future of Excel with dynamic arrays. Use FILTER, SORT, UNIQUE, and SEQUENCE to create formulas that automatically expand and adapt. Build self-updating reports that respond to your data in real time.
|
| 💰 |
Financial Analysis Tools
Make smarter financial decisions with Excel. Build loan amortization schedules, calculate NPV and IRR, forecast future trends, and run powerful what-if scenarios used by analysts and business leaders worldwide.
|
| 🎨 |
Visual Data Formatting
Make your data tell a story at a glance. Apply conditional formatting rules that highlight trends, outliers, and key metrics automatically. Use data bars, color scales, and icon sets to turn numbers into visual insights.
|
| 🛠️ |
Productivity & Efficiency
Work smarter, not harder. Streamline workflows using SmartArt, checkboxes, data consolidation, and protection features. Print perfectly every time and keep workbooks organized, secure, and professional.
|
| 🤖 |
AI-Powered Excel
Supercharge productivity with AI. Use Flash Fill, intelligent forecasting, recommended charts, and Copilot features to automate repetitive tasks and solve problems faster than ever.
|
| 📈 |
Dashboard & Reporting
Create stunning interactive dashboards. Master PivotTables, PivotCharts, slicers, and timelines to build professional reports that update automatically and communicate insights at a glance.
|
| 🚀 |
Advanced Formula Techniques
Push Excel to its limits with LET, LAMBDA, RegEx, VSTACK/HSTACK, and modern functions that solve complex problems elegantly. Build custom functions and automate sophisticated workflows.
|
📅 DAY 1: BUILDING YOUR EXCEL FOUNDATION – “From Zero to Excel Hero”
| Section & Topics Covered | |
|---|---|
| 🎯 |
Excel Essentials
Excel Fundamentals & Interface Navigation
Excel Essentials
Data Entry & Cell Operations
Formula Mastery
Mathematical Functions & Number Formatting
• 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 You’ll Learn: By the end of Day 1, you’ll confidently navigate Excel, enter and manipulate data efficiently, and perform essential calculations. You’ll understand cell references, master copy-paste techniques, and apply professional number formatting.
⏱️ Total Hours: ~7.5 hours
|
📅 DAY 2: DATA MANAGEMENT & TEXT MASTERY – “Structure, Parse, and Transform Your Data”
| Section & Topics Covered | |
|---|---|
| 🗃️ |
Data Design & Structure
Data Management & Database Design Principles
Formula Mastery
Text Functions & Data Parsing
Formula Mastery
Date & Time Functions
• 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 You’ll Learn: Day 2 transforms you into a data architect. You’ll learn to design clean, error-free databases, validate user input with smart dropdowns, and master text manipulation functions. You’ll also become proficient with date and time calculations.
⏱️ Total Hours: ~7 hours
|
📅 DAY 3: LOGIC, DECISIONS & DATA RETRIEVAL – “Build Smart Formulas That Think”
| Section & Topics Covered | |
|---|---|
| 🧠 |
Smart Decision Functions
Logical Functions & Conditional Calculations
Data Lookup & Retrieval
Lookup & Reference Functions
• 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 You’ll Learn: Master conditional logic to automate decisions and unlock the power of lookup functions to connect data across sheets and workbooks, building dynamic invoices and automated reports.
⏱️ Total Hours: ~6.5 hours
|
📅 DAY 4: DYNAMIC DATA, FINANCE & VISUAL INTELLIGENCE – “Analyze, Format, and Automate Like a Pro”
| Section & Topics Covered | |
|---|---|
| ⚡ |
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
• 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 You’ll Learn: Master dynamic arrays, build financial models, apply visual formatting, and leverage AI features and productivity tools for maximum efficiency.
⏱️ Total Hours: ~7.25 hours
|
📅 DAY 5: DASHBOARDS, REPORTING & ADVANCED TECHNIQUES – “Create Professional Dashboards & Master Modern Excel”
| Section & Topics Covered | |
|---|---|
| 📈 |
Dashboard & Reporting
Reporting, Visualization & Dashboard Design
Advanced Formula Techniques
Advanced Formulas & Modern Excel Functions
• 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 You’ll Learn: Build professional, interactive dashboards, master PivotTables, charts, and slicers, and explore advanced functions like LAMBDA and LET for custom formulas.
⏱️ Total Hours: ~8.25 hours
|
