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

Wireless Computer Accessories
microsoft-excel-seeklogo.com.png

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