Excel for business

Excel training for companies CONTINUE


Excel training - private lessons CONTINUE


Recent manuals

CROSSJOIN – all combinations of two lists (DAX – Power Pivot, Power BI) (28.4.2019)

The CROSSJOIN function creates table, showing all possible combinations of values from two other tables. For example from these two…
Pokračovat ve čtení

CALENDARAUTO – create time dimension automatically (DAX – Power Pivot, Power BI) (18.4.2019)

CALENDARAUTO simply generates the list of dates. These dates automatically cover all dates, that can be found in any table…
Pokračovat ve čtení

How to create Dataflow and how to connect to it (12.4.2019)

Dataflow is a set of tables on powerbi.com. The main benefit is that one person in company can handle the connection…
Pokračovat ve čtení