Autoplay
Autocomplete
Urmatoarea Sesiune
Completeaza si continua
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)
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
Autofill si Flash Fill in Excel
Descarca
Flash fill.xlsx
Completeaza si continua
Discutie
4
comentarii
Incarca mai multe
4 comentarii