Autoplay
Autocomplete
Previous Lesson
Complete and Continue
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 in Power Pivot
Download
Export ERP.xlsx
Complete and Continue
Discussion
12
comments
Load more
Lesson Content Locked
Your session expired. Please sign in again to continue.
Login
12 comments