Excel SUMIFS Function
The SUMIFS function, adds all of its arguments that meet multiple criteria. First, let’s compare the SUMIF function. […]
Blog
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 […]
Create a Slideshow in PowerPoint
Microsoft’s PowerPoint is a good choice for creating a slideshow of pictures. You can insert pictures one at […]
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 […]
Relationships and the Data Story
When we describe and present the data we are telling a story or narrative. Quantitative stories are always […]
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 […]
Excel Power Pivot Introduction
What is Power Pivot? It is an add-in, and according to Microsoft: “Power Pivot is a data modeling […]
Excel Power Query Data Type Error
Sometimes when you bring in data into the Power Query Editor, you experience data type errors. Here below […]
Excel Power Query Fill Down
Are you using Power Query to import data into Excel and finding that one of your columns is […]