Microsoft Excel - Beginner Level

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.