Cube formulas have been around in Excel for a long time. Not like VLOOKUP (which has been around since the beginning)… but they have existed since 2007. These formulas were initially designed to extract values from SSAS cubes. However; with …
Tag: pivot table
Using Shapes for Better Dashboards
In most cases when working with data in Excel, you will be adding data directly into cells, or deriving data through pivot tables or formulas. But when working with dashboards, it is important to consider visual elements for end users. …
3 different ways to get unique values in Excel
It is very common to require a list of unique values from a list that contains duplicates. While it may be easiest to take a single approach to get these values, there are cases where a different approach may be …
What is Advanced Excel?
Advanced Excel is a skill that is in high demand. A quick query on LinkedIn showed over 68,000 jobs worldwide requesting advanced Excel, as of January 2020. The jobs that were showing on LinkedIn are generally for financial jobs, such …
Quarterly Report – Pivot Table
In this post, along with the next few posts, I will be discussing a hypothetical case where data has been provided and your job (as the analyst) will be to create a quarterly report detailing sales of 2018 new vehicles …