Data Analysis in Excel
Data Analysis in Excel
This set of screencasts is geared toward learning aspects of Excel that are useful for statistical data analysis.
| Screencast | Description |
|---|---|
| CLS-Stats Lambda Functions | Named Lambda functions in CLS-Stats and how to manage them |
| Keyboard Shortcuts 1 | Some essential keyboard shortcuts in Excel |
| Keyboard Shortcuts 2 | Customizing keyboard shortcuts with VBA (advanced) |
| Cell Formulas 1 | Creating, copying, editing formulas. Cell addresses. |
| Cell Formulas 2 | Relative, absolute, mixed addresses. Named ranges. |
| Data Visualization | Methods for visualizing univariate data in Excel |
| Excel Tables | Creating and using Excel tables. Advantages of Excel tables. |
| Arrays in Excel 1 | Array functions, array operations, subsetting arrays. |
| Arrays in Excel 2 | Using array formulas and the LET function to avoid helper cells |
| Filtering Data | Conditional display of data, either in-place or separately |
| Conditional Statistics 1 | Single-criterion conditional statistics |
| Conditional Statistics 2 | Conditional statistics with multiple criteria |
| Callback Functions in Excel | Eta and lambda functions as callback functions |
| Lambda Function Programming | Creating named lambda functions (and why you’d want to) |