Microsoft Excel - Basic Level

Day 1: Introduction to Excel and Basic Navigation

• Overview of the Excel interface: Ribbon, toolbar, and worksheet

• Creating, saving, and opening workbooks

• Understanding cells, rows, columns, and ranges

• Entering and editing data (text, numbers, dates)

• Basic file management and navigation techniques

• Hands-on exercise: Creating a simple worksheet

Day 2: Formatting Worksheets and Data

• Formatting cells: Text, numbers, dates, and currency

• Adjusting row height, column width, and cell alignment

• Applying cell borders and shading for readability

• Using conditional formatting for automatic visual highlights

• Formatting worksheets for printing: Page layout, headers/footers

• Hands-on exercise: Enhancing a worksheet's appearance

Day 3: Basic Formulas and Functions

• Introduction to formulas: Basic arithmetic operations (+, -, *, /)

• Understanding cell references: Relative, absolute, and mixed references

• Using basic Excel functions: SUM, AVERAGE, MIN, MAX, COUNT

• Introduction to AutoSum and AutoFill features

• Hands-on exercise: Building simple calculations and functions

Day 4: Data Management Tools

• Sorting data in ascending/descending order

• Filtering data to view specific information

• Introduction to Excel tables for better data management

• Copying, moving, and deleting data in Excel

• Hands-on exercise: Managing and organizing data in a worksheet

Day 5: Basic Data Analysis and Presentation

• Creating simple charts and graphs (bar, line, pie charts)

• Modifying and formatting charts for better presentation

• Using basic data validation techniques

• Protecting worksheets and workbooks

• Hands-on exercise: Creating a simple report with charts and graphs