Power Pivot Kevin Cookie
Let’s work with Kevin here on the fictitious Kevin Cookie Company’s data. Have a look at the YouTube […]
Blog
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 […]
Get Data From the Web Into Excel
You can get data from a web page and import it into Excel. It’s easy. You might want […]
Excel Pivot Tables Date Grouping
Dates can be a bit tricky. For the best solution to working with dates in our Pivot Table […]
Excel Protect Sheet
Do you have an Excel template for others to fill out and you want to make sure that […]
Excel Table Relationships
Suppose you have two tables of data in Excel that are related. As an example, you might have […]
Create a Pivot Table from Multiple Sheets using Power Query
Do you have an Excel workbook (file) that has multiple worksheets of data that you need to combine […]
Excel’s AGGREGATE Function
The AGGREGATE function allows you to summarize values and gives you the ability to ignore values such as […]
Excel’s New Data Types
If you have Microsoft 365 (formerly Office 365) you can use Excel’s new data types to create Excel […]