Articles

Articles

Welcome to the Excelguru Article Catalog! We have an extensive collection of articles on Excel, Power Query, Power BI, VBA, PivotTables, Power Pivot, and more. Browse the articles below or use the search function to learn more about a specific topic.

Looking for something specific? Search here for relevant content.

Most Recent Posts

Excel Fundamentals Boot Camp

COACHED TRAINING: Excel Fundamentals Boot Camp Course Description In the Fundamentals Boot Camp, you will begin with a review core skills for the Excel analyst. This section is geared to...

Read More >>

Building a SelectQuery Function

For a while now, I have been wanting to have the capability in Power Query to select a query by name PROGRAMMATICALLY.  Why?  Building a SelectQuery Function would allow me...

Read More >>

Major redesign at Skillwave.Training

This past weekend we published a major redesign at Skillwave.Training.  Months in the making, this has been a total overhaul to focus on delivering the best online learning experience for...

Read More >>

New Monkey Tools Features

We're super excited to let you know that we've just released some new Monkey Tools features!  Let's take a quick look as to what is new... The Table Monkey This...

Read More >>

Excel Power Pivot

Microsoft Excel - Power Pivot COURSE DESCRIPTION Are you ready to turbocharge your PivotTables? Power Pivot is a free Excel add in that allows you to perform powerhouse data analysis...

Read More >>

Excel Power Query

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....

Read More >>

Excel Dashboards

ON-DEMAND: Excel Dashboards COURSE DESCRIPTION Take your Excel skills to a whole new level by learning how to build dynamic Excel dashboards to show off your data. Ken Puls has...

Read More >>

Introducing the Measure Monkey

You know the drill… extract, transform and load your data, relate your tables, then create basic DAX measures.  All work that needs to be done before you can really get...

Read More >>

Most Commented Upon Posts

The IF Function In Power Query

In my last post I talked about useful text functions, and how they differed between Excel and Power Query.  Today we’re going to look at another compare/contrast scenario, but this...

Read More >>

Date Formats in Power Query

Date formats in Power Query are one of those little issues that drives me nuts… you have a query of different information in Power Query, at least one of the...

Read More >>

Clean WhiteSpace in PowerQuery

The other day as I was working through a model, I once again tripped upon the fact that Power Query’s Text.Trim function doesn’t clean whitespace inside the text string, only...

Read More >>