Tag: tutorial

Windows God Mode

Windows God Mode

With the arrival of new version Windows 10 you may have lost track of possible settings, anything – from the appearance, through localization, to the devices, and sounds. There is older Control Panel, although still available, but finding options even before was not that simple. The new Settings may not suit everyone, as just find […]

43. Videotutorial – Deal with Pivot Tables 3 – Design tab

43. Videotutorial – Deal with Pivot Tables 3 – Design tab

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 […]

42. Videotutorial – Deal with Pivot Tables 2 – Calculation options

42. Videotutorial – Deal with Pivot Tables 2 – Calculation options

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 […]

Insert Screenshot

Insert Screenshot

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 […]

41. Videotutorial – Deal with Pivot Tables 1 – Basic model

41. Videotutorial – Deal with Pivot Tables 1 – Basic model

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 […]

Table transpose

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 […]

Scroll to Top