excel

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

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
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

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 [https://www.udemy.com/advanced-get-transform-m-language/]. These lessons cover: 1) Tips and Tricks for working with Lists 2) The List.Accumulate Function 3) The Blackjack Challenge Solution With the

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

Advanced Get and Transform, Chapter 4 Now Live!

Chapter 4 of the Advanced Get and Transform course is now live on Udemy.

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.

Philip Trick
Members Public

The Excel Javascript API

Part one of my Excel Javascript series. Excel has a variety of automation tools, why use Javascript over VBA or VSTO? What are VBA and VSTO anyways?