You've successfully subscribed to Explainly
Great! Next, complete checkout for full access to Explainly
Welcome back! You've successfully signed in.
Success! Your account is fully activated, you now have access to all content.
Home
Authors
Categories
Contact Us
PowerQuery Intro
PowerPivot Intro
M Language: Advanced PowerQuery
Log In
Sign Up
quicktip
Philip Trick
10.Mar.2021
Paid
Members
Public
Quick Tip: Building Measure Tests in Power BI
Incorporate a unit testing framework into your Power BI reports with some simple measures combined with a matrix visualization.
Philip Trick
21.Feb.2021
Paid
Members
Public
QuickTip: Consolidate Excel Data
Consolidate data from multiple tables within Excel into one table using PowerQuery, a basic function, and a parameters table in under 7 minutes.
Philip Trick
13.Sep.2019
Paid
Members
Public
Quick Tip: Build a Project Management Report
Explainly builds a share-able basic project management data capture and reporting system in 7 minutes. Learn how to build the report yourself and then interact with and add your own project data.
Philip Trick
01.Aug.2019
Paid
Members
Public
Quick Tip: Find The Missing (Data) Links
This QuickTip offers a quick use-case for PowerQuery's Merge command to connect data together in order to locate potential missing pieces.
Philip Trick
22.Apr.2019
Paid
Members
Public
Quick Tip: Web Scraping with Excel
This Explainly Quick Tip guides you through a quick way to scrape data off of certain websites.
Philip Trick
11.Apr.2019
Paid
Members
Public
Quick Tip: Automating Tasks With Microsoft Flow
Learn how to create your first Microsoft Flow automation process following this YouTube -> Twitter automation example.
Philip Trick
03.Apr.2019
Paid
Members
Public
Quick Tip: Use Bing Maps for Simple Geographical Data
This three minute video will show you how to use Bing Maps in Excel to build simple, interactive map visuals.
Philip Trick
27.Mar.2019
Paid
Members
Public
Quick Tip: Build Microsoft Forms that Directly Populate Excel
This three minute video will walk you through creating a shareable online form that will push all submissions directly into an Excel file.