Module :3 Spreadsheet Course Content
1. Basics of Spreadsheet & Data Entry
Day 1: Basics of Spreadsheet & Data Entry
Day 2 – Entering and Organizing Data in Rows and Columns
Day 3 – Fill Series & Auto Fill
Day 4 – Managing Rows, Columns & Sheets
Day 5 –Mini Project
2. Spreadsheet Formatting & Styling
Day 6 – Basic Formatting & Alignment
Day 7 – Advanced Formatting & Styling
3. Data Management & Organization
• Day 8: Creating Tables and Applying Table Styles
• Day 9: Editing & Structuring Tables
• Day 10: ISorting & Filtering Data
• Day 11: Using Merge and Split Cells for Reports
• Day 12: Sorting Student Data by Marks and Names
• Day 13: Highlighting Key Data with Conditional Formatting
• Day 14: Weekly Project: Managing Class A vs Class B Data
4. Formulas & Functions
Day 15 – Introduction to Formulas & Mathematical Operations Formulas
Day 16 – Math & Statistical Functions Formulas
Day 17 – Logical & Error Handling Functions formulas
Day 18 – Text & Date-Time Functions Formulas
Day 19 – Lookup & Advanced Formulas
5. Tools & Features, Inserting Objects & Graphics
Day 20: Tools & Feathers
Day 21: Inserting Objects & Graphics
5. Data Analysis & Decision Making
Day 1 – Pivot Tables & Pivot Charts
Day 21 – What-If Analysis & Goal seek Decision Tools
Day 3 – Advanced Filtering & Descriptive Statistics
6. Charts & Visualization
Day 25: Converting Tables into Informative Graphs
Day 26: Using PivotTables for Data Summarization
Day 27: Using PivotCharts for Visual Analysis
Day 31. Tools & Feathers
Day 32: Inserting Objects & Graphics
6. Reporting & Printing
Day 30: Page Layout & Print Setup Exporting Worksheets as PDF & Print Preview Options
7. AI use in Excel
Day 33: AI Use in Spreadsheet 2nd class
Day 34: AI Use in Spreadsheet 3rd class
Day 35: AI Use in Spreadsheet 4th class
📘 30 Days Excel Course – Detailed Syllabus
1. Basics of Spreadsheet & Data Entry
Chapter 1: Getting Started with Excel: Introduction & Workbook Creation
Chapter 2: Entering and Organizing Data in Rows and Columns
Chapter 3: Understanding Cell Addressing and Range Selection
Chapter 4: Using AutoFill and Creating Data Series
Chapter 5: Managing Sheets, Rows and Columns Effectively
Chapter 6: Working with Text, Numbers and Date Entries
Chapter 7: 📝 Weekly Practice: Building a Complete Class Record Sheet
2. Data Management & Organization
Chapter 8: Creating Tables and Applying Table Styles
Chapter 9: Improving Readability with Borders, Shading and Alignment
Chapter 10: Inserting and Deleting Rows/Columns Inside Tables
Chapter 11: Using Merge and Split Cells for Reports
Chapter 12: Sorting Student Data by Marks and Names
Chapter 13: Highlighting Key Data with Conditional Formatting
Chapter 14: 📝 Weekly Project: Managing Class A vs Class B Data
3. Formulas & Functions
Chapter 15: Performing Basic Calculations with Excel Formulas
Chapter 16: Creating and Copying Formulas Across Rows
Chapter 17: Applying Essential Functions for Analysis (SUM, AVERAGE, MIN, MAX)
Chapter 18: Mastering Relative, Absolute and Mixed Cell References
Chapter 19: Using 3D Formulas Across Multiple Sheets
4. Data Analysis & Decision Making
Chapter 20: Searching Data with VLOOKUP and HLOOKUP
Chapter 21: Using Goal Seek & What-If Analysis
Chapter 22: 📝 Weekly Project: Creating an Automated Student Report Card
5. Charts & Visualization
Chapter 23: Creating Charts for Student Performance Visualization
Chapter 24: Formatting and Customizing Excel Charts
Chapter 25: Converting Tables into Informative Graphs
Chapter 26: Using PivotTables for Data Summarization
Chapter 27: Using PivotCharts for Visual Analysis
6. Advanced Excel Tools
Chapter 28: Data Consolidation & Advanced Filters
Chapter 29: Recording Macros, Data Validation & Worksheet Protection
7. Reporting & Printing ✅
Chapter 30: Page Layout & Print Setup (Margins, Orientation, Setting Print Area, Print Titles, and Repeating Row Scaling, Page Breaks)
Chapter 31: Adding Headers, Footers, and Page Number, Exporting Worksheets as PDF & Print Preview Options