Introducere in Power Query | onLearn

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 Query

Download

Tabel angajati.xlsx

Complete and Continue

Discussion

22 comments