The video series Deal with Pivot Tables continues with episode Calculation options. In this tutorial you will learn how to change the aggregate function in calculations, how to set up percentage totals and how to display more summaries at once. If this guide has helped you, become a fan on Facebook and recommend this site to your friends, it can […]
The video series Deal with Pivot Tables starts with a tutorial Basic model. You will learn how to create a simple Pivot table in Excel. If this guide has helped you, become a fan on Facebook and recommend this site to your friends, it can be useful for them too. Please note that this tutorial is presented in czech […]
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 […]
How many tasks in Excel can be performed with double click? You may be surprised to learn that there are 15! Check out this guide and use tricks in practice. If this guide has helped you, become a fan on Facebook and recommend this site to your friends, it can be useful for them too. Opening a […]
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 […]
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 […]
Users commonly use predefined series of numbers, dates, days of the week or month. Besides these, you can create your own custom list (eg. the foreign names of the days, months, list of counties and cities, etc..), which will accelerate the formation of stereotypes, frequently used, consecutive values. Custom lists Creating custom lists is a litlle hidden setting in Excel, […]
