Microsoft Excel
Microsoft Excel offers the creation and management of tables with hundreds of functions carried out by sophisticated calculations and analysis. Using conditional formatting,charts visualizing the data obtained. For larger amount of data enables using pivot tables and PowerPivot tools to compare the data in context and summary results displayed to the user. Let ITLektor show you the mysteries of this powerful application.
Many tips and tricks, which I met in practice, giving to readers free of charge in my useful videos. See with your own eyes how to deal with situations that are perhaps your daily basis. To view a list of all video tutorials just go to the video category.
Nemáte čas chodit na drahá školení? Stejnou osnovu jako běžná školení mají i online kurzy (E-learning) v podobě video lekcí s podrobným návodem, cvičnými soubory ke stažení, certifikátem a doživotním přístupem. Podívejte se na Online kurzy Excelu.
If you find that you are missing some knowledge, there is no easier way than to be trained. If you choose the path of “self-learning”, some procedures you will learn can take more time or perhaps not quite correct. You can always use the articles on this site for inspiration or consult the ITLektor.
Mostly searched
Excel posts
- (Čeština) Počet jednoznačných položek v kontingenční tabulce
(Čeština) Co znamená a jak zjistit počet jednoznačných položek v kontingenční tabulce? Funguje v Excelu od verze 2013. - (Čeština) XLOOKUP v Excelu
(Čeština) Videonávod jak správně nastavit novou funkci XLOOKUP v Excelu 365 a vysvětlení rozdílu v porovnání s SVYHLEDAT. - (Čeština) Spojení buněk v Excelu
(Čeština) Video návod jak spojit hodnoty z buněk Excelu dohromady s využitím funkcí CONCATENATE, TEXTJOIN a dalších metod. - (Čeština) Online kurz Excel makra VBA – základy programování
Sorry, this entry is only available in Czech. - Training Excel VBA basics
Training description
At this training you will learn about concepts such as procedure, method, variable or function, and you will gradually learn the principles for automating Excel activities. In the examples we will show how the conditions and cycles work, what ... - (Čeština) Online kurz Excel – grafy
Sorry, this entry is only available in Czech. - Convert text to formula using EVALUATE
If you need to convert a text expression to a formula in Excel, there is a way even without programming, using the hidden EVALUATE function. In this manual we will look at how to use it. If this guide has ... - (Čeština) Online kurz Excel – Pro experty
Sorry, this entry is only available in Czech. - (Čeština) Online kurz Excel – Microsoft Query
Sorry, this entry is only available in Czech. - (Čeština) E-learning Excel – Pro pokročilé
Sorry, this entry is only available in Czech.