How to Use Power BI
Get started with Power BI now by creating your first dashboard. Download the free files, follow along and in 20 minutes you'll have setup your interactive dashboard which you've published to the web!
DAX CALCULATE Function
If you'd like to "see" how the DAX CALCULATE function works, then you need this tutorial. It will show you what's happening behind the scenes: How the CALCULATE function works and delivers results.
3 Hidden Tips for Power Pivot
These 3 hidden Excel Power Pivot tips will help you to: Copy your data model from one file to another, create a dedicated measures table and convert your pivot table data to formulas.
Excel Repeat blocks of Values x times
With this trick you can easily combine and repeat blocks of values together in Excel. You don't need copy pasting or complicated formulas. Just a tiny bit of Power Query. This keeps your solution dynamic too.
Excel – Switch Columns Multiple Values
Pivoting columns in Excel is a common task when cleaning and organizing data. Sometimes you have a complex scenario where you have multiple values when switching columns. You'll have to combine these multiple values into one cell. I'll show you 3 methods to get this done.
Excel Remove Duplicates
These are 3 easy ways to remove duplicates in your data to create a unique or distinct list of values in Microsoft Excel. It's a very common task for data cleaning and also a very common job interview question... BUT one of the methods returns a different result. Make sure you understand why.
Create a Pivot Table from Multiple Sheets
Easily create ONE Pivot Table in Excel from data in multiple sheets. Sometimes you need to "merge" the data and sometimes you have to "append" data from multiple sheets for your Pivot Table. Don't use formulas! Instead use this method.
Import Outlook to Excel with Power Query
Learn how to easily export your Outlook emails into Excel. No VBA or Add-ins are necessary. I'll show you how to create a connection to any Outlook folder (or your full inbox) so you can easily import your Outlook data to Excel.
Excel Pivot Tables from Multiple Sheets
This is a simple but advanced Pivot Table technique in Excel. If you'd like to create a Pivot Table based on multiple sheets or tables, you can easily do that by defining the relationship between the tables from the data tab. It just takes one click.
Import PDF to Excel
Learn to properly convert PDF files to Excel without losing any formatting. With this method you can even refresh your Excel result to grab the latest data from your PDF file.