Petr Kohoutek

1. Videotutorial – PivotTable Slicerprurez

1. Videotutorial – PivotTable Slicer

Check out the first videotutorial, this time focusing on Slicer feature in PivotTables Excel 2010 and newer. In six minutes you’ll see how to create a Slicer, and how to set it up so that you can filter the data more interactive and more fun than ever before and also learn how to connect it with a […]

Format as “smart” table in Excelchytra tabulka

Format as “smart” table in Excel

On my trainings I usually show the “smart table” as a bonus topic, the students are amazed by the options of this tool and collectively agree that they do not want to work with another table anymore. Indeed it makes easier both formatting and filtering, subtotals, and more. Let’s see at least some of the tweaks, others I will […]

Sparklines in Excel 2010

Sparklines in Excel 2010

Excel 2010, among other innovations, comes with a tool called Sparklines. It is a tool that can create a small chart in a worksheet cell showing the trend of selected numbers, eg. the income gains over time. How this instrument is inserted into the worksheet and what can be set inside, you will learn in this article. If this […]

Presentation templates in PowerPointspp2

Presentation templates in PowerPoints

Presentations are designed for showing of information, data visualization, promote corporate policies … It is not easy to create eye-catching presentation that complies with generally accepted visual standards such as:   uniform presentation cleanliness typology of fonts use of color amount of information Therefore, leave this job to a specialist. Offered services presentation formatting merging presentations […]

Training Visiovisio

Training Visio

Training description On this training, students will learn techniques for practical use Microsoft Visio. A list of topics is provided below. Topics are presented by the trainer, then he answers any questions from the audience about the topic and then students do exercises on their computer to use their new knowledge. Throughout the trainer assists […]

Training Accessaccess

Training Access

Training description On this training, students will learn techniques for practical use of Microsoft Access and control of database objects, including theoretical introduction to the world of databases. A list of topics is provided below. Topics are presented by the trainer, then he answers any questions from the audience about the topic and then students […]

Training Excel for experts

Training Excel for experts

Training description Are you only interested in a specific part of Excel? We offer the opportunity for consultation of specialized methods and tools in Excel in any combination. A list of possible topics is given below. Choose topics that you want to learn during the training. Topics are presented by the trainer, then he answers […]

Scroll to Top