top of page
Microsoft Excel 2 Hour Statistical Functions & Excel as a Database
Bitesize Module
Delve into the features of statistical functions to help you work through data more meaningfully. Excel provides an extensive range of Statistical Functions, that perform calculations from basic mean, median & mode to the more complex statistical distribution and probability tests.
​
Format: 2 Hour Virtual Session: Max Capacity 4
Session Topics
​
-
Basic Statistical Functions (Average, Max, Min, Stdev etc)
-
Formatting Information as an excel table
-
Table formulas and references
-
Collating information from multiple sheets
-
Using Power Query (Get and transform) to:
- Transform Data
- Join tables
- Append Tables
- Custom Calculations
- Split/Archive Data
bottom of page