Excel Filter Function
The new Excel FILTER function is one of the new dynamic arrays that are available in Microsoft 365. […]
Excel
Excel Date and Time
All dates in Excel has an associated date value, which is how Excel calculates the passage of time […]
Excel SUMPRODUCT Function
Below is an example of the SUMPRODUCT function. SUMPRODUCT multiplies corresponding cells from multiple arrays and returns the […]
Power Pivot Filtering
As an example, let’s look at the FoodMart database in Excel’s Power Pivot. The first thing to do […]
Excel Pivot and Unpivot
Many of the transformations in Power Query are fairly easy to grasp but other ones, such as Pivotting […]
Excel SUMIFS Function
The SUMIFS function, adds all of its arguments that meet multiple criteria. First, let’s compare the SUMIF function. […]
Excel Data Entry Forms
Using Excel’s forms you can make your life easier. How? Forms can help you reduce the number of […]
Excel Slicers
What is a slicer? A slicer is a visual representation of a filter. They are available in Excel […]
Itzik Ben Gan’s Database
As a more complex and realistic example, let’s look at the database that Itzik Ben-Gan used in his […]
Pivot Table Sales Data Example
Let’s look at some Sales data in a simple example and use Pivot Table to summarize the data. […]
Power Pivot Kevin Cookie
Let’s work with Kevin here on the fictitious Kevin Cookie Company’s data. Have a look at the YouTube […]
Unpivot in Power Query
What is unpivot and when would you use it? The unpivot operation converts columns to rows. It creates […]