Excel topics

How to Import Data from a Website to Excel

Append tables using M code

Append with different culture formats

Append tables using a function

Rolling average / total using power query

Custom function: NetWorkingDays

LAG and LEAD using power query

Statistics

Binomial Distribution

Poisson Distribution

Normal DIstribution

Hypothesis testing, z-score

Hypothesis testing, T-Distribution

Hypothesis testing, F-Ratio

One-way ANOVA. Post hoc test.

Two-Way ANOVA

Simple linear regression

Multiple linear regression