Another episode of tutorials Deal with Pivot Tables continues with the topic Page field. It serves not only for filtering, this can produce several detailed Pivot tables according to the selected criteria. 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 […]
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 […]
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 […]
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 […]
Training description Are you interested in advanced tools of Excel? We offer the possibility of learning advanced methods and tools in Excel with the following suggested outline. 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 […]
