‘DIY BI’ e-Book Launches Tomorrow!
Last week I announced that we are working on a series of free 'DIY BI' e-Books. We've been hard at work on polishing it up, and I'm pleased to announce that the first DIY BI e-Book launches tomorrow! It will
Last week I announced that we are working on a series of free 'DIY BI' e-Books. We've been hard at work on polishing it up, and I'm pleased to announce that the first DIY BI e-Book launches tomorrow! It will
Today I wanted to just make a quick announcement that we are currently working on a series of free 'DIY BI' e-Books. Free 'DIY BI' e-Books? Tell me more! Over the past few years of working with Excel an Power
I got an email from a reader this morning who asked how to calculate start and end dates for a given employee when they have had multiple terms of employment. Since it's been a while since we've had a technical
This week's blog post on solving business problems with Power Query is a guest post by Alex Jankowski Does your business or work group have manual tasks that are repeated regularly, such as data re-entry, copy/paste functions, sending the same old email,
In this post we will explore how to make the Sample Binary file path dynamic when combining files using the new Combine Binaries experience in Excel and Power BI Desktop. Sample Files If you'd like some sample data files to
If you've wanted to use Power Query to combine Excel files with a single click - like you could for TXT and CSV files - the feature is finally here*. The Combine Binaries feature has been re-written (as I discussed
One of the updates in the latest Excel 2016 Insider preview build is a new Combine Binaries experience for Power Query. This is both good and bad, and in this post we'll take a detailed look at both sides before
The November 2016 update is now out and it finally brings a way to view the Power Query dependencies viewer. While it’s been out in Power BI Desktop for a while, (as Matt posted about a while ago,) this is
More and more I’m seeing examples where people are trying to extract data from a mixed column. In other words, they have two data types in a single column, but need to find a way to extract one from the
In this post I’m going to show one of my favourite financial modeling tricks: how to use Aggregate to Count Visible Rows. Background Often, when I’m building models in Excel, I like to group key assumptions at the top of
Copyright © 2022-present Excelguru Consulting Inc. All rights reserved.
