Excel for business

Excel training for companies CONTINUE


Excel training - private lessons CONTINUE


Recent manuals

Fuzzy matching in Power BI queries (23.1.2019)

This article describes, how to merge queries in Power Query in Power BI, when the keys in both tables are…
Pokračovat ve čtení

Synoptic Panel – create working visual from your custom scheme (20.1.2019)

This article describes an interesting Power BI visual - Synoptic Panel. Synoptic Panel works differently from other visuals, that are…
Pokračovat ve čtení

PATH, PATHLENGTH, PATHITEM, PATHITEMREVERSE, PATHCONTAINS – playing whith hierarchies (DAX – Power Pivot, Power BI) (19.1.2019)

This article describes functions that can be used for managing of hierarchical tables. I mean tables having some items in…
Pokračovat ve čtení