Office scripts
7h 21min
Time
39
Chapters
Office
Category
5.0
Rating
Intermediate
Level
czech
Language
Chapters
1. Teoretická část OS
1. Prostředí Office Scripts
5min
Available only with full access purchase
2. Rozdíly VBA Office Scripts
7min
Available only with full access purchase
3. Console log
6min
Available only with full access purchase
4. Komentáře
7min
Available only with full access purchase
5. Textové řetězce
7min
Available only with full access purchase
6. Operace
14min
Available only with full access purchase
7. Proměnné a dátové typy
10min
Available only with full access purchase
8. Datumy
13min
Available only with full access purchase
9. Pole
11min
Available only with full access purchase
10. Slovníky
7min
Available only with full access purchase
11. Let & Const
5min
Available only with full access purchase
12. Recorder
6min
Available only with full access purchase
13. Práce s Worksheety
9min
Available only with full access purchase
14. Rozdíl Get & Set argumentu
6min
Available only with full access purchase
15. Oblasti
15min
Available only with full access purchase
16. Tabulka
10min
Available only with full access purchase
17. Builtin Scripty
6min
Available only with full access purchase
2. Praktická část OS
18. Kopírování dat
11min
Available only with full access purchase
19. Poslední hodnoty
9min
Available only with full access purchase
20. Vkládání dat na volnou buňku
12min
Available only with full access purchase
21. Filtr
15min
Available only with full access purchase
22. Řazení
8min
Available only with full access purchase
23. Grafy
16min
Available only with full access purchase
24. Pivotky - část 1
14min
Available only with full access purchase
25. Pivotky - část 2
16min
Available only with full access purchase
26. Podmínky
8min
Available only with full access purchase
27. Cykly for & forEach
18min
Available only with full access purchase
28. Cykly While & Dowhile
7min
Available only with full access purchase
29. Excelovské funkce
21min
Available only with full access purchase
30. Validace dat
13min
Available only with full access purchase
31. OfficeScript funkce
13min
Available only with full access purchase
32. Kopírování více listů
17min
Available only with full access purchase
33. Tabulka obsahu
11min
Available only with full access purchase
3. Pokročilý OS
34. ErrorHandling
9min
Available only with full access purchase
35. JSON data
14min
Available only with full access purchase
36. Regulární výrazy (Regex)
9min
Available only with full access purchase
37. API
10min
Available only with full access purchase
BONUS: OS s Power Automate
38. Data na nový workbook s PA
17min
Available only with full access purchase
39. Graf do mailu s PA
9min
Available only with full access purchase
12
Online courses
8
Posts