Intermediate ExcelIntermediate Excel
Introduction
Welcome to Intersect’s Intermediate Excel course for researchers.
Text Text Text Text Text Text Text Text Text Text Text Text Text Text Text Text Text Text Text Text Text Text Text Text Text Text Text Text Text Text Text Text Text Text Text Text Text Text Text Text Text Text Text Text Text Text Text Text Text Text Text Text Text Text Text Text Text Text Text Text Text Text Text
Prerequisites
This course assumes Text Text Text Text Text Text Text Text Text Text Text Text Text Text Text Text Text Text Text Text Text Text Text Text Text Text Text Text Text Text Text Text Text Text Text Text Text Text Text Text Text Text Text Text Text
Text Text Text Text Text Text Text Text Text Text Text Text Text Text Text Text Text Text
Outline
TODO: Move objectives to YML and auto-populate the table below..
| Module number | Name | Learning Objectives |
|---|---|---|
| 0 | Setup | How to setup Excel |
| 1 | Pivot Tables | How to use advanced features of Pivot tables, columns and rows, filters, count, average, custom functions |
| 2 | Advanced Functions | Including Countif/countifs, sumif, sumproduct, reference to ranges, iferror, query?, vlookup, regexmatch, unique, split, importrange, dcount, filter |
| 3 | Interactive plots | Text text text |
| 4 | Conditional Formatting | Text text text |
| 5 | Data Validation and Named ranges | Text text text |
| 6 | [Mod 6] | Text text text |
| 7 | [Mod 7] | Text text text |