LEVEL 1: Excel Fundamentals (Weeks 1-2)
Goal: Navigate Excel confidently and perform basic data tasks
Navigation & Interface
- Understanding the ribbon, tabs, and quick access toolbar
- Workbook vs worksheet concepts
- Cell references (A1, B2, etc.)
- Moving between sheets and workbooks
- Freezing panes and splitting windows
- Zoom and view options
Basic Data Entry & Management
- Entering data efficiently
- Copy, paste, cut (and paste special)
- Fill handle and auto-fill
- Find and replace
- Undo/redo shortcuts
- Saving and file formats (.xlsx, .csv, .xlsm)
Basic Formatting
- Cell formatting (fonts, colors, borders, alignment)
- Number formats (currency, percentages, dates, custom)
- Column width and row height