Tag Archives: Data

1704, 2019

How to use the CHOOSE function

Kornilios Ampatzis/ April 17, 2019/ Tutorials

Probably the easiest to understand lookup function is the CHOOSE function. It returns a value from an array of values, that corresponds to a specific position in that array.

1704, 2019

Hierarchies with PowerPivot in Excel

Kornilios Ampatzis/ April 17, 2019/ Tutorials

Let us take the next step in power pivot tables. We will talk about hierarchies in Power Pivot and will show a bit more of its functions.

1604, 2019

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.

1604, 2019

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.

1604, 2019

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.

1604, 2019

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.