(Č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.
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 helped you, become a fan on Facebook and recommend this site to your friends, it can […]
Hidden function DATEDIF
You may know that Excel can subtract from each other not only numbers, but also dates. The fundamental difference between the two dates will be the number of days between them. But if we want to determine the precise number of months, years or just months indiscriminately years, it would be quite difficult. Fortunately, we […]
Table transpose
Do you have wrong direction of a table and you do not want to rewrite the cells from a column in a row? Use a simple trick and Excel will do all that is necessary. Read in this manual, what needs to be done. If this guide has helped you, become a fan on Facebook […]
Functions for rounding
For calculations in Excel can be often assumed difference between the format of the result and the real value rounded. In this tutorial you will learn how solve this problem and learn practical function to correct round. If this guide has helped you, become a fan on Facebook and recommend this site to your friends, it can be useful […]
Useful date functions
Excel users often struggle with functions, which are total more than 350. Many of them will learn on my trainings, but how to remember them after a long time? In this article we will focus on some useful functions for working with dates. For each function you will find not only a general description, but a […]