Module :3 Spreadsheet Course Content
2. Spreadsheet Formatting & Styling
4. Formulas & Functions
5. Tools & Features, Inserting Objects & Graphics
5. Data Analysis & Decision Making
6. Charts & Visualization
6. Reporting & Printing
📘 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
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