Power Query v Exceli

3h 40min
Time
17
Chapters
Business & Finance
Category
5.0
Rating
Intermediate
Level
czech
Language

Chapters

Power Query v Excelu
1. Prostředí Power Query
Available only with full access purchase
2. Základní operace & datové typy
Available only with full access purchase
3. Import dat z webu
Available only with full access purchase
4. Import dat z .csv, .txt, .xlsx
Available only with full access purchase
5. Import kombinace souborů
Available only with full access purchase
6. Rozdělení sloupců
Available only with full access purchase
7. Sloučení a vlastní sloupce
Available only with full access purchase
8. Podmíněné sloupce
Available only with full access purchase
9. Filtr & řazení
Available only with full access purchase
10. PowerPivot & PivotCharts
Available only with full access purchase
11. Seskupení dat
Available only with full access purchase
12. Odseskupení dat
Available only with full access purchase
13. Sloučit - Append
Available only with full access purchase
14. Sloučit vzorcem
Available only with full access purchase
15. Sloučit sloučení
Available only with full access purchase
16. Rozšířený editor
Available only with full access purchase
17. Funkce
Available only with full access purchase
Robin Hrabina Robin Hrabina
Datový Analytik
12 Online courses
8 Posts