excel
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.
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.
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.
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
Quick Tip: Web Scraping with Excel
This Explainly Quick Tip guides you through a quick way to scrape data off of certain websites.
Advanced Get and Transform, Chapter 4 Now Live!
Chapter 4 of the Advanced Get and Transform course is now live on Udemy.
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.
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.
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?