Microsoft Excel - Power Query COURSE DESCRIPTION So you’ve impressed your coworkers with your encyclopedic memory of formulae, become a Pivot pro, and started working IF statements into regular conversation. Now what? We say, Power Query. In a world where
A question came up in the Excelguru forums today about how to use Excel tables to filter a Power Query. While Power Query can't read a filter from an Excel table natively, there is a cool little trick that you
We've been kind of quiet here, but we're excited to announce that we've just published an update to Monkey Tools QuerySleuth feature. It now contains an "tabbed" experience so that you can easily flip back and forth between queries, "pinning"
We’re super excited to announce that we have given the Monkey Tools calendar creator feature an upgrade. In fact, it is so much of a power up, that this feature has graduated into its own full grown monkey! We call
ON-DEMAND: Dimensional Modeling for the Excel and Power BI Pro COURSE DESCRIPTION What is Dimensional Modeling and why should you care? The classic Excel PivotTable did a great job of letting us quickly pivot and slice data for years. There
Have you ever loaded a Power Query to a worksheet and then changed the name to match the query? It's a shame that there is no option to name worksheets after queries, as this would be handy. Well, after seeing
Have you ever built multiple queries in one Power Query session? You get to choose one load destination, then have to change each of the incorrect ones... one by one. Have you ever wished you could change multiple load destinations
We’re pleased to announce the first Monkey Tools update is now available for download! This one contains a new feature, some new logic and an update to one of our data connectors. Read on for more information! I can’t believe
Will Thompson from the Power BI team threw out a question on Twitter today related to Appending Columns with Different Names: Let's say I have some CSVs coming in where the column names differ from file to file, but always
We are super excited to announce that we’ve (at last) released the first version of our Monkey Tools software! Ken has been working on this software on and off for the better part of 8 years now. But after showing
Copyright © 2022 Excelguru Consulting Inc. All rights reserved.
