Category Archives: Tutorials

Using the PowerPivot add-in with Excel

Kornilios Ampatzis/ April 16, 2019/ Tutorials

Although Pivot tables are very powerful, in the professional editions of excel there is one optional add-in more powerful and versatile than any other.

Using Slicers with your Pivot Tables

Kornilios Ampatzis/ April 16, 2019/ Tutorials

Since Excel 2010, a new and very interesting feature was added. Slicers. At first glance, they might seem like a beautified way to filter a pivot table, but they can be a lot more than that.

Creating Pivot Charts in Excel

Kornilios Ampatzis/ April 16, 2019/ Tutorials

Pivot charts in Excel are the visual representation of pivot tables. They are connected to each other and every change on the table affects the chart and vice versa.

Learning about Pivot Tables

Kornilios Ampatzis/ April 16, 2019/ Tutorials

Pivot tables might as well be Excel’s most powerful feature. A pivot table helps you to summarize and analyze your data, thus extracting the significant information from a large and detailed data set.

How to Transpose cells in Excel

Kornilios Ampatzis/ April 5, 2019/ Tutorials

It is certain that at some point everybody needs to alter the form and layout of their data, in order for them to be more readable, or answer to some specific visual requirements.
The ability to transpose our data is such a need.

Using the Solver add-in

Kornilios Ampatzis/ April 4, 2019/ Tutorials

In another tutorial we saw how we can find ourselves a better loan for a new car, using Goal Seek . Although Excel’s Goal Seek is a powerful tool, it has one basic limitation. It allows only one variable to be changed to help us achieve our goal.
Excel provides an even more powerful tool that bypasses this limitation. The Solver. The Solver is in the form of an add-in which must be enabled before you can use it.