EXCEL · DATA SKILLS
Excel references and next steps
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
Use Microsoft’s documentation for your platform. Select the relevant version tab where available, since desktop, Mac, and web features differ.
- Fill guidance from Microsoft
- Formulas guidance from Microsoft
- Std guidance from Microsoft
- Rows guidance from Microsoft
- Validation guidance from Microsoft
- Save guidance from Microsoft
- Object guidance from Microsoft
- Data guidance from Microsoft
- Date guidance from Microsoft
- Stats guidance from Microsoft
- Excel guidance from Microsoft
Next steps: practice a tidy table with one header row, filters, and a clear data dictionary. Check ranges and results before applying these techniques to real research data.
Reference: Microsoft Support. Menu names may vary by platform and update.