Target Audience: Beginners in Microsoft Excel Daily Session Duration: 2 hours Total Duration: 10 hours
Day 1: Introduction to Excel and Navigating the Interface
Objectives:
•
- Understand what Excel is and its uses - Familiarize with the main interface of Excel
Content:
- What is Excel and why use it? - Opening and saving files - Exploring the Excel interface (Ribbon, Columns, Rows, Cells, Worksheet) - Navigating between cells - Entering and editing data - Basic cell formatting (font color, size, type, alignment)
Practical Exercise: Create a simple student or sales table and apply formatting.
Day 2: Formatting and Sorting Data
Objectives:
•
- Improve the presentation and organization of data
Content:
- Number formatting (Currency, Percentage, Dates) - Borders and cell shading - Using Conditional Formatting - Sorting data (Ascending and Descending)
- Filtering data (AutoFilter)
Practical Exercise: Create a sales table with conditional formatting to highlight sales over 1000.
Day 3: Basic Formulas and Functions
Objectives:
•
- Enter basic mathematical formulas - Use simple functions
Content:
- Difference between formulas and functions - Basic arithmetic operations (+ - * /) - SUM function - AVERAGE function - MIN and MAX functions - COUNT function
Practical Exercise: Calculate the total and average grades or product prices.
Day 4: Managing Tables and Merging Data
Objectives:
•
- Organize data effectively within tables
Content:
- Creating tables (Insert Table) - Table formatting - Sorting data within tables - Merging cells - Freezing panes (Freeze Panes) - Auto Fill using the fill handle
Practical Exercise: Create an employee salary table with sorting and freeze the top row.
Day 5: Charts and Printing Preparation
Objectives:
•
- Visually present data - Prepare the file for printing
Content:
- Types of charts (Column, Pie, Line) - Creating and formatting charts - Print settings (Margins, Orientation, Preview) - Inserting Header/Footer - Saving as PDF
Practical Exercise: Create a chart from a sales table and prepare it for printing.
Final Notes:
- Reserve the last 15 minutes of each session for Q&A or quick review. - Consider a simple test or mini-project on Day 5.