Autoplay
Autocomplete
Urmatoarea Sesiune
Completeaza si continua
Ninja in Excel
Introducere
Introducere in curs (3:58)
Ce inseamna Excel avansat (4:19)
Functii si formule
Introducere in functii formule (0:58)
VLOOKUP la Stanga (14:18)
Cautare cu mai multe conditii (11:25)
Cauta a 2-a valoare (11:24)
Lambda (13:16)
Power Query
Introducere in Power Query (16:40)
Web query (9:12)
Import din folder (18:11)
VLOOKUP in Power Query (9:29)
Pivotare - depivotare (7:03)
Proiect
Power Pivot
Introducere in Power Pivot (10:11)
Data model (18:37)
Coloane calculate (12:31)
Masuri (14:45)
Power Query, Power Pivot si Power BI (6:10)
Proiect
Macro / VBA
Introducere - Macro Recorder (12:13)
Visual Basic Editor (6:08)
Obiecte, proprietati, metode (8:40)
Scriere in celule (9:47)
Variabile (11:27)
Decizii - IF (9:25)
Bucle FOR (10:04)
Bucle DO (7:47)
UDF (User Defined Functions) (10:29)
Proiect
Closing
Lasa-ne un review
Introducere - Macro Recorder
Descarca
Tabel angajati.xlsx
Completeaza si continua
Discutie
2
comentarii
Incarca mai multe
2 comentarii