Introduction to PowerQuery Updates
Introductory course receiving light updates for Excel 2019 plus all new audio tracks.
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.
Quick Tip: Automating Tasks With Microsoft Flow
Learn how to create your first Microsoft Flow automation process following this YouTube -> Twitter automation example.
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.
The New(er) Explainly Blog
We're updating our site to fit with our new mission as we expand our course offerings, our informational tips, and extend into direct training and consulting.
Welcome to Explainly!
Our new marketing and branding page is under development. You'll be seeing some changes around here pretty soon!
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.
Power BI, Diving In
I attended a Dashboard In A Day seminar to learn a few tips and tricks for using Power BI. The best part? Learning how to publish and share these reports via the web, like directly in this post!
Excel Javascript - Adding Unit Tests
The second part of my Excel Javascript series covering my trials and tribulations adding Jest Unit Tests to my project.
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?