Excel 1 - Curriculum

Introduction to Microsoft Excel
Getting Started: Excel Interface
Exercise 1: Employee Data Management
Enter and Edit Data in Cells
Use Cut, Copy and Paste Commands
Apply Autofill to complete data patterns
Select cells, rows, and columns
Save and Manage Workbook Files
Exercise 2: Sales Calculations & Formatting
Use AutoSum function for quick calculations
Apply absolute cell references in formulas
Copy formulas using AutoFill
Format numbers
Apply font formatting, alignment and cell styles
Use merge & center for Titles (center across selection)
Exercise 3: Product Inventory Management
Insert and delete rows and columns
Adjust column widths and row heights
Use Wrap Text for long content
Merge cells for section headers
Apply borders and shading
Freeze panes for easier navigation
Exercise 4: Customer Order Analysis
Manage multiple worksheets in a workbook
Rename and color-code sheet tabs
Sort data by multiple columns
Filter data by various criteria
Quick Reference Guide