📊 MICROSOFT EXCEL 3-DAY CORPORATE TRAINING PROGRAM
PROGRAM OVERVIEW
This comprehensive 3-day Excel corporate training program by Jifry Issadeen is designed to transform corporate professionals into proficient Excel users capable of handling complex data tasks with confidence. The curriculum covers the complete spectrum of Excel functionality—from foundational navigation and data entry techniques through advanced analysis, automation, and professional dashboard creation.
- Target Audience: Corporate staff, business analysts, administrative professionals, finance teams, and anyone seeking to maximize productivity through Excel mastery.
- Key Skills Participants Will Gain:
- Master Excel’s interface, navigation shortcuts, and productivity features
- Perform efficient data entry, validation, and management operations
- Apply mathematical, text, date/time, and logical functions for business calculations
- Create dynamic conditional formatting rules for visual data analysis
- Build powerful lookup formulas (VLOOKUP, XLOOKUP, INDEX-MATCH)
- Utilize dynamic arrays and modern filtering functions
- Design interactive dashboards with pivot tables, charts, and slicers
- Program Duration: 22 hours total (approximately 7–8 hours per day)
📅 DAY 1 – EXCEL FOUNDATIONS & DATA HANDLING
Day Overview: Day 1 establishes the essential foundation for Excel proficiency. Participants begin by mastering the Excel interface, learning efficient navigation techniques, and developing keyboard shortcut fluency. The day progresses through core data entry operations, mathematical functions, and professional number formatting. By the end of Day 1, participants will confidently navigate Excel, perform calculations, manage data effectively, and apply professional formatting to their work.
| Session / Topic | Key Areas Covered | Learning Outcomes | Duration |
|---|---|---|---|
| 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 1 Total Training Time: 411 minutes (6.85 hours)
📅 DAY 2 – ANALYSIS, AUTOMATION & VISUALIZATION
Day Overview: Day 2 elevates participants from basic users to analytical professionals. The day focuses on text manipulation functions essential for data cleaning, visual formatting techniques for impactful presentations, and the critical date/time and logical functions that power business automation. Participants will learn to parse complex text data, create visually compelling conditional formatting, perform date calculations, and build decision-making formulas for automated business logic.
| Session / Topic | Key Areas Covered | Learning Outcomes | Duration |
|---|---|---|---|
| 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 2 Total Training Time: 468 minutes (7.80 hours)
📅 DAY 3 – ADVANCED REPORTING & PRODUCTIVITY
Day Overview: Day 3 transforms participants into Excel power users capable of building professional-grade solutions. The day covers the essential lookup functions that connect data across worksheets and workbooks, modern dynamic array functions for sophisticated data manipulation, productivity features for streamlined workflows, and culminates in dashboard creation. By the end of Day 3, participants will possess the complete skill set to build interactive, professional dashboards that deliver actionable business insights.
| Session / Topic | Key Areas Covered | Learning Outcomes | Duration |
|---|---|---|---|
| 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 |
Day 3 Total Training Time: 441 minutes (7.35 hours)
PROGRAM OUTCOMES & VALUE
- ✅ Interface Mastery — Navigate Excel with speed and confidence using keyboard shortcuts, customized toolbars, and efficient selection techniques.
- ✅ Data Operations Excellence — Perform complex data entry, manipulation, and organization tasks with professional efficiency.
- ✅ Formula & Function Proficiency — Build calculations using mathematical, text, date/time, and logical functions to automate business processes.
- ✅ Visual Data Presentation — Apply conditional formatting, number formats, and visual rules that make data insights immediately apparent.
- ✅ Advanced Lookup Capabilities — Connect and cross-reference data using VLOOKUP, XLOOKUP, and INDEX-MATCH for any table structure.
- ✅ Dynamic Array Expertise — Leverage modern Excel functions (FILTER, SORT, UNIQUE, etc.) for powerful, auto-updating data solutions.
- ✅ Dashboard Development — Create interactive, professional dashboards using Pivot Tables, Charts, and Slicers that communicate insights effectively.
Contact & Booking
📞 Phone / WhatsApp: +94 777 576 887
📧 Email: jifry@jobbees.lk
🌐 Facebook: facebook.com/jifryissadeenlive
🎵 TikTok: tiktok.com/@jifryissadeen
