(Čeština) Windows 11 Insider preview instalace na virtuálním systému
(Čeština) Instalace Windows 11 Insider Preview ve virtuálním systému VMware Workstation Player.
(Čeština) Instalace Windows 11 Insider Preview ve virtuálním systému VMware Workstation Player.
(Č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) Videonávod jak správně nastavit novou funkci XLOOKUP v Excelu 365 a vysvětlení rozdílu v porovnání s SVYHLEDAT.
(Čeština) Video návod jak spojit hodnoty z buněk Excelu dohromady s využitím funkcí CONCATENATE, TEXTJOIN a dalších metod.
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 helped you, become a fan on Facebook and recommend this site to your friends, it can […]
The last part of tutorials Deal with Pivot Tables represents tweaks that do not fit into previous episodes and it is worth to know them. Learn eg. how to fill the empty cells with zero value, to generate the detailed in-depth analysis and how to update and expand the source table. If this guide has helped you, become […]
Another episode of tutorials Deal with Pivot Tables continues with the topic how to consolidate multiple source table into one Pivot. It can be achieved using PivotTable and PivotChart wizard, which remained in Excel from older versions. If this guide has helped you, become a fan on Facebook and recommend this site to your friends, it can be useful for […]