EXCEL · DATA SKILLS
Excel for basic data analysis
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
Build a small dataset, use formulas, and check your results.
These lessons use Microsoft 365 and Excel 2024. Most basics also work in Excel for the web and on Mac; ribbon labels and available features vary. Desktop-only object embedding is identified separately.
Download the practice workbook
Use Sheet1. The five practice cases, scores, and cell positions are preserved so the lessons match the workbook. These are fictional practice values, not a validated instrument or clinical dataset. The historical variable names are retained as labels only.
Start with Cells and ranges, then follow the lessons in order. Work in a saved copy so you can compare your results with the supplied example.
Reference: Microsoft Support. Menu names may vary by platform and update.