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
excel
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
29.Dec.2020
Paid
Members
Public
The Promise Of PowerQuery Custom Data Types
PowerQuery custom data types offer promise of bold and powerful new features in the future; however, their current implementation is currently limited to simple, non-hierarchical 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
13.May.2019
Paid
Members
Public
Advanced Get and Transform, Chapter 4 Complete
The final three lessons for chapter four have been published to the Advanced Get & Transform course, which can be found here. These lessons cover: 1) Tips and Tricks for working with Lists 2) The List.Accumulate Function 3) The Blackjack Challenge Solution With the publishing of these lessons, the
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
10.Apr.2019
Paid
Members
Public
Advanced Get and Transform, Chapter 4 Now Live!
Chapter 4 of the Advanced Get and Transform course is now live on Udemy.
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.
More Posts