Lesson 2.1 Excel Interface & Basic Functions
Microsoft Excel is a fundamental tool for data cleaning, summarization, and basic analysis.
Key Components of Excel Interface
- Ribbon: Contains command tabs like Home, Insert, Data
- Formula Bar: Displays formulas or cell content
- Worksheet Area: Grid of rows and columns
- Cell Reference: Unique identifier like A1, B2, C7
Basic Operations
- Sorting (ascending/descending)
- Filtering (show specific conditions)
- Basic formatting (colors, borders, alignment)
- AutoFill for repeating patterns