IMDB and the Excel Data Model
What if we wanted to import this database into Microsoft Excel and work with it? We want to […]
Blog
Choosing a Chart Type
There are lots of graphs you could use. Not all are great choices. Many times choosing simple and […]
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 […]
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 […]