🗓 MS Excel Basics Time Table for Data Entry Operators
(5-Day Plan)
Day Time Slot Topic Concepts Covered Practice Activity
Day 10:00 AM – Introduction to Workbook, Worksheet, Open and explore
1 11:00 AM Excel Rows/Columns, Excel interface Excel workbook
11:15 AM – Basic Data Enter text/numbers, Edit cells, Enter employee or
12:15 PM Entry AutoFill product data
2:00 PM – Saving & File
Save As, .xlsx vs .csv Save a sample file
3:00 PM Formats
Day 10:00 AM – Text alignment, Font size, Format a staff list or
Formatting Cells
2 11:00 AM Borders, Colors table
11:15 AM – Number Currency, Date, Percent, Comma Format salary or
12:15 PM Formatting style sales data
2:00 PM – Total and average
Basic Formulas SUM, AVERAGE, MAX, MIN
3:00 PM sheet
Day 10:00 AM – Sorting & Sort and filter
A-Z, Z-A, Filter by values
3 11:00 AM Filtering product list
11:15 AM – Copy-Paste Copy data between
Paste Special, Transpose
12:15 PM Tools sheets
2:00 PM – Page Setup & Print Area, Margins, Print a formatted
3:00 PM Printing Header/Footer sheet
Day 10:00 AM – Create simple visual
Charts (Intro) Bar, Column, Pie
4 11:00 AM charts
11:15 AM – Create entry form
Data Validation Drop-down list, Input rules
12:15 PM with drop-downs
2:00 PM – Freeze & Hide Freeze Panes, Hide Practice with large
3:00 PM Data rows/columns tables
Day 10:00 AM – Shortcuts & Keyboard shortcuts, AutoSum,
Speed entry practice
5 11:00 AM Tips Flash Fill
11:15 AM – Final Practice Complete sample
Revise key concepts
12:15 PM Test worksheet
2:00 PM – Q&A + Discussion &
Solve doubts, Improve skills
3:00 PM Feedback feedback session
✅ What You’ll Need:
Microsoft Excel (2016 or later preferred)
Sample datasets (e.g. Employee List, Sales Data)
Notebook for shortcuts & formula notes
🗓✅ Advanced MS Excel Concepts – 15-Day Learning
Time Table
Day Topic Concepts Covered Practice/Outcome
Week 1: Advanced
Functions &
Formulas
Advanced Logical IF with AND/OR/NESTED Dynamic decision
Day 1
Functions IF, IFS, SWITCH logic
Traditional arrays, Dynamic
Advanced data
Day 2 Array Formulas arrays (SEQUENCE, SORT,
extraction
FILTER)
XLOOKUP (modern), INDEX Multi-criteria
Day 3 Lookup Mastery
+ MATCH, XMATCH lookups
IFERROR, ISERROR, ISNA, Clean and
Day 4 Error Handling
ERROR.TYPE troubleshoot data
Named Ranges & Dynamic ranges, INDIRECT Create flexible
Day 5
INDIRECT use with formulas models
Week 2: Data
Tools &
Automation
Pivot Tables Deep Slicers, Timelines, Calculated
Day 6 Advanced reporting
Dive Fields/Items
Power Query (Get
Load, clean, and transform Connect/import
Day 7 & Transform) –
data external data
Basics
Power Query – Merge, Append, Parameters, Automate data
Day 8
Advanced Custom Columns cleaning
Create relationships, DAX
Data Modeling
Day 9 basics (CALCULATE, Multi-table analysis
with Power Pivot
SUMX)
KPIs, Form controls, Build executive
Day 10 Dashboard Design
Interactive charts dashboards
Week 3: Analysis,
VBA & Final
Project
Goal Seek, Scenario Manager,
Day 11 What-If Analysis Forecasts & planning
Data Tables
Constraint-based problem Resource allocation
Day 12 Solver Add-In
solving problems
Excel Macros Record macro, Assign to
Day 13 Automate tasks
(VBA) – Basics button, Basic code
VBA – Loops, Conditions, User Custom task
Day 14
Intermediate Forms automation
Day Topic Concepts Covered Practice/Outcome
Create a dynamic dashboard
Final Project & Demonstrate all
Day 15 with Power Query, Pivot,
Assessment skills
Macros
🗓 Excel Training Time Table: Basic to Advanced (For
Data Entry Operator)
Day Topic Concepts Covered Practice Focus
Week 1: Basics &
Fundamentals
Interface, Workbook vs
Introduction to Opening/Saving
Day 1 Worksheet,
Excel files, Navigation
Rows/Columns/Cells
Data Entry Typing in cells, AutoFill,
Day 2 Entering simple data
Basics Copy/Paste, Undo/Redo
Format
Formatting Text alignment, Number
Day 3 sales/inventory
Cells formats, Borders, Cell color
sheet
SUM, AVERAGE, MAX, Practice
Day 4 Basic Formulas
MIN sales/marksheets
COUNT, COUNTA, Simple calculations,
Day 5 Basic Functions
ROUND totals
Week 2: Intermediate
Skills
Cell
Day 6 Relative, Absolute, Mixed Using $ in formulas
Referencing
Sorting & Sort A-Z/Z-A, Custom Sort, Filter data by
Day 7
Filtering Filters criteria
Create visuals for
Day 8 Charts Bar, Column, Pie, Line
data
Conditional Highlight duplicates, color
Day 9 Dynamic formatting
Formatting scales
Drop-down lists, input Create clean data
Day 10 Data Validation
messages forms
Week 3: Productivity
Tools & Advanced
Functions
CONCATENATE, LEFT,
Day 11 Text Functions Clean up messy data
RIGHT, MID, LEN, TRIM
Date & Time TODAY, NOW, DATEDIF, Track durations,
Day 12
Functions TEXT format dates
Logical Decision-making
Day 13 IF, AND, OR
Functions logic
Day Topic Concepts Covered Practice Focus
Lookup Retrieve data from
Day 14 VLOOKUP, HLOOKUP
Functions tables
Advanced Better than
Day 15 INDEX + MATCH
Lookup VLOOKUP
Week 4: Advanced
Tools & Practice
Pivot Tables Create PivotTable,
Day 16 Basic pivot reports
(Part 1) summarize data
Pivot Tables Grouping, Filtering, Pivot
Day 17 Drill-down insights
(Part 2) Charts
Remove duplicates, Text to Prepare large
Day 18 Data Cleaning
Columns datasets
Shortcuts & Keyboard shortcuts, Flash
Day 19 Boost efficiency
Speed Tricks Fill
Final
Day 20 Assessment & Solve mock project, Q&A Complete test sheet
Practice
