Excel: tipy a triky
2h 2min
Time
51
Chapters
Office
Category
4.8
Rating
Intermediate
Level
slovak
Language
Chapters
Excel tipy z Praxe
Filozofia excel práce vo firmách
1min
Available only with full access purchase
Čo robí Excel skvelým
2min
Available only with full access purchase
Limity a obmedzenia Excelu
3min
Available only with full access purchase
Rýchle tipy
Materiály ku kurzu
-
Available only with full access purchase
Slovenský vs. Anglický jazyk Excelu
2min
Available only with full access purchase
Excel skratky
2min
Available only with full access purchase
Prilepenie ako hodnoty a formát
1min
Available only with full access purchase
Rozšírenie viacerých stĺpcov naraz
2min
Available only with full access purchase
Rýchly filter a filtrovanie
1min
Available only with full access purchase
Smart tabuľky
1min
Available only with full access purchase
Ako z tabuľky vyexportovať unikátne hodnoty
1min
Available only with full access purchase
Ako sa dostať na konkretnú adresu bunky
1min
Available only with full access purchase
Čo je to CSV súbor
5min
Available only with full access purchase
Ako otvoriť rôzne CSV súbory
3min
Available only with full access purchase
Formát XLS vs. XLSX
1min
Available only with full access purchase
Unzip XLSX
1min
Available only with full access purchase
Zabezpečenie v Exceli
1min
Available only with full access purchase
Automatické prepojenia v Exceli
3min
Available only with full access purchase
DropDown Box - Výberové pole s možnosťami
2min
Available only with full access purchase
Pomenovanie polí a rozsahov Excelu
Relatívne a absolutné odkazy
4min
Available only with full access purchase
Názvy tabuliek, buniek a rozsahov
3min
Available only with full access purchase
Pomenovanie a zmena farby hárkov
1min
Available only with full access purchase
Základné Excel vzorce
Vzorec SUM
44s
Available only with full access purchase
Vzorec VLOOKUP
3min
Available only with full access purchase
Vzorec IF
2min
Available only with full access purchase
SUMIF, COUNTIF, AVERAGEIF
2min
Available only with full access purchase
MIN, MAX
3min
Available only with full access purchase
Dátumové vzorce
-
Available only with full access purchase
CONCATENATE - Spájanie textov
-
Available only with full access purchase
Pivotné (kontingenčné) tabuľky v praxi
Základné pivotky
5min
Available only with full access purchase
Pokročilejšie pivotky
2min
Available only with full access purchase
Ako zmeniť pivotné tabuľky na tabuľkový formát
2min
Available only with full access purchase
Odkazy vzorcami na pivotku
2min
Available only with full access purchase
Vytváranie interaktívnych kópii pivotiek
-
Available only with full access purchase
Najčastejšie chyby v pivotkách
2min
Available only with full access purchase
Excel vs. iné riešenia
Microsoft Excel vs. Google Sheets
3min
Available only with full access purchase
Microsoft Excel vs. Libre Office
1min
Available only with full access purchase
Microsoft Excel vs. Power BI
3min
Available only with full access purchase
Automatizácia práce v Exceli
Automatizované práce v exceli - VBA makrá
1min
Available only with full access purchase
Automatizované práce v exceli - Power Query
1min
Available only with full access purchase
Automatizované práce v exceli - Excel vzorce
1min
Available only with full access purchase
Automatizované práce v exceli - VBA makrá vs. Power Query vs. Excel vzorce
4min
Available only with full access purchase
Export z Excelu
4min
Available only with full access purchase
Najčastejšie Excel chyby
Najčastejšie chyby - Refresh Pivotky
2min
Available only with full access purchase
Najčastejšie chyby - Refresh Power Query a Pivotky je oddelený
3min
Available only with full access purchase
Najčastejšie chyby - Excel svet vs. Automatizovaný svet
1min
Available only with full access purchase
Najčastejšie chyby - Zmeny pomenovania stĺpcov v exceli
4min
Available only with full access purchase
Najčastejšie chyby - Číselné, textové a chybové hodnoty
4min
Available only with full access purchase
Najčastejšie chyby - Premiestenie súboru Excel
29s
Available only with full access purchase
Najčastejšie chyby - Skryté hárky
1min
Available only with full access purchase
Najčastejšie chyby - Zoraďovanie a filtrovanie
3min
Available only with full access purchase
3
Online courses
1
Posts