The Explainly Blog

News, Tips, and Solutions

Power BI, Diving In

As anyone who visits already knows, I'm really fond of Get and Transform in Excel. As you'll also know, if you've taken my courses, is that the Get and Transform "M" language powers the Query Editor inside Power BI. Up until now, I've only worked with some of the data aspects of Power BI. Below,...

READ MORE

Excel Javascript - Adding Unit Tests

This is part two in my Excel Javascript series. Part one is here. So my last blog post rambled on about the history of Excel customization from VBA to VSTO to Javascript and how they are different with some suggestions as to why you might want to use the newer Javascript approach. Today, I'm...

READ MORE

The Excel Javascript API

Welcome to my first blog entry on the Explainly blog. We launched the blog almost specifically for this series of posts discussing my head-first dive into the Office Javascript API. This is part one, where I will discuss what the Office Javascript library is and why it matters from the context...

READ MORE

The Explainly Blog

Welcome to the new Explainly blog. Our authors have requested this for awhile for sharing discussion and information surrounding updates, solutions not deserving of a full course, and other various topics. We hope you'll follow us and participate in our blogs via comments and...

READ MORE