Training topics

Basics, Deep dive, DAX, M, R, Visuals, Data modelling, Power Excel...

Where

Anywhere in Europe -  trainers will come right into your conference room. The training language is English.

Trainers

Data analysts with long training history - authors of these tutorials.

Prices

Roughly 1000 - 2000 EUR per day, ask info@exceltown.com for proposal.

References

In recent years we provided trainings for companies from pharma (Fresenius, Gilead, GlaxoSmithKline, Johnson & Johnson, Merck, Roche, SpofaDental), automotive (Aisin, Ford Credit, Good Year, Nokian, Pirelli, Skoda Auto), finance (Allianz, Direct, Generali), infrastructure and telco (E-on, Innogy, Strabag, T-mobile) and others (Avast, Decathlon, Jan Becher, Nestlé, Notino, Sportisimo…).

Recent manuals

Multiple columns as a key for merging in Power Query (23.8.2020)

When merging queries in Power Query, you can simply use multiple columns as a key (this can not be used…
Read more

Running totals in Power Query, using the List.Range function (26.6.2020)

The List.Range M language function can create running totals - when each row is a summary of it an all…
Read more

The List.Range function, extracting values from specified rows in a column (26.6.2020)

Using the List.Range function, you can get specified values from some column.  For example in this table, you may need…
Read more