How to use the OFFSET function
One very useful Excel function is OFFSET. It returns a range of cells which corresponds to a specified number of rows and columns starting at a given distance from a reference cell.
1704, 2019
Monthly Archives: April 2019
1704, 2019
How to use the MATCH function
There is no way to create a powerful and versatile lookup formula without using at least once the MATCH function.
1704, 2019
How to use the INDEX function
The INDEX function is one of the most interesting functions in excel. It can be combined with many other functions to help you out of some difficult situations.
1704, 2019
How to use the CHOOSE function
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
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
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
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
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
Using Calculated Fields and Items in Excel’s Pivot Tables
In this lesson we will try to explain and use a very useful feature of pivot tables. The creation of Calculated fields and items.
1604, 2019
Learning about Pivot Tables
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.
