EXCEL · DATA SKILLS
Columns and readable headings
Browse Excel lessons
- Excel for basic data analysis
- Cells and ranges
- Columns and readable headings
- Enter and edit cells
- Share files and embed objects
- Fill a series
- Save a practice copy
- Prepare data for analysis
- Dates and number formats
- Variables and score definitions
- Enter and check practice data
- Insert and delete rows
- AutoSum and totals
- Copy formulas with relative references
- Calculate the mean
- Calculate standard deviation
- Excel references and next steps
Each column should represent one variable and each row one observation. In this historical practice layout, B3:D3 contain variable names and A5:A9 contain case numbers.
- Select column B by clicking its letter.
- Drag the boundary between B and C to adjust its width, or double-click it to fit the contents.
- Use Home → Wrap Text when a heading needs two lines.
For a new analysis dataset, use one complete header row with no blank rows inside the data. Insert → Table can add filters and structured references. Keep this workbook’s layout unchanged while following the cell-based lessons.
Reference: Microsoft Support. Menu names may vary by platform and update.