The video series Deal with Pivot Tables continues with episode Design tab. In this tutorial you will learn how to change the design, report layout and subtotals visibility in Pivot Table. 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 […]
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 […]
When creating presentations or other documents sometimes we need to insert an image of another open window or its crop part. In Windows, you can use Snipping Tool, which you already could read in the previous tutorial. In Microsoft Office there’s another way to insert the screenshot. Read in this manual, what needs to be done. If […]
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 […]
We use the Address book in Outlook to organize our contacts. What to do if we want to send the contact information to other people in our Address book, or even a group of contacts to share with colleagues? In this article you will find answers to both questions. You will learn even how to ensure that you […]
