Functii de cautare: VLOOKUP, XLOOKUP | onLearn

Autoplay
Autocomplete

Previous Lesson Complete and Continue

MS Excel Extended

Introducere

MS Excel Extended: Introducere (9:39)

Excel Essentials

Formatare in Excel (8:52)
Freeze panes (5:03)
Filtrare in Excel (15:42)
Sortare (3:26)
Imprimare (12:48)
Introducere in functii si formule (16:26)

Procesarea datelor

Tabele in Excel (9:04)
Formatare conditionata (10:57)
Text to columns (8:35)
Autofill si Flash Fill in Excel (6:18)
Validarea datelor in Excel (6:24)
Protejarea datelor in Excel (10:46)
Remove duplicates (3:28)
Introducere in Power Query (17:13)
Introducere in Macro / VBA (12:30)
Quizz

Analiza datelor

Subtotal (7:30)
Pivot Table 1 (20:36)
Pivot Table 2 (23:28)
Introducere in Power Pivot (10:56)
Consolidate in Excel (5:19)
Quizz

Grafice in Excel

Introducere in Grafice (13:09)
Grafice cu mai multe serii de date (7:19)
Grafice pe 2 axe (4:27)
Sparklines in Excel (3:55)
Pivot Chart in Excel (4:11)
Quizz

Functii si formule

Functii aritmetice simple (12:14)
Functii care gestioneaza textul (10:41)
Functii care gestioneaza date (8:03)
Functii de cautare: VLOOKUP, XLOOKUP (19:16)
Functii de cautare: INDEX + MATCH (7:38)
Array formulas (11:07)
Functii de cautare: FILTER (6:31)
Functii logice: IF, AND, OR (11:42)
Functii aritmetice conditionate: SUMIF, SUMIFS (8:29)
LAMBDA - creaza functii custom (13:15)
Quizz

Diverse

Colaborare in Excel (10:51)
Lasa-ne un review
Recomanda acest curs

Functii de cautare: VLOOKUP, XLOOKUP

Download

5.4. Functii de cautare.xlsx

Complete and Continue

Discussion

24 comments