quicktip

Philip Trick
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
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
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
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
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
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
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
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.