Author: John

The Complete Guide to Power Query

What is power query? Power Query is a business intelligence tool available in Excel that allows you to import data from many different sources and then clean, transform and reshape your data as needed. It allows you to set up a query once and then reuse it with a simple refresh. It’s also pretty powerful. Power query can import and clean millions of rows into the data model for analysis after. The user interface is intuitive and well laid out so it’s really easy to pick up. It’s an incredibly short learning curve when compared to other Excel tools...

Read More

How to Create Delete and Rename Folders from a List

I started making videos to go along with my post on pivot tables called 101 Advanced Pivot Table Tips And Tricks You Need To Know. I wanted to be a bit organized and have all the related files for each video tip in its own folder. This meant creating 101 new folders and then naming them based on each tip in my post. Doing this manually would be a very tedious task. Copy tip title into clipboard. Open the file explorer and right click to create a new folder. Paste the tip title name into the folder name Prefix...

Read More

2017 Year in Review for How To Excel

I thought it might be a good idea to review the last year and what’s happened with this site since I started it. I know the year end review is a little late, but I’ve never been one to be on time. Why I Started This Site I started this site for a couple different reasons. I wanted a place to archive solutions I had discovered so I could reuse them later. Recycling is a good skill for any analyst to have. I wanted to share the things I learn with others. I really like Excel, and am always...

Read More

How To Access A JSON API With Power Query

In this post I’ll show you how to hack into tons of top secret government data using Excel. Ok, by “top secret“, I actually mean a database API made publicly available. And by “hack into“, I actually mean use Excel’s From Web Power Query functionality to access the API. Governments have a lot of data covering agriculture to renewable energy, and the cool thing is anyone can access it and they provide it all for free with an API. Data is always a valuable resource to have at hand when you’re trying to learn Excel too, so learning how...

Read More

Advertisement

Microsoft MVP

Categories

Advertisement

Pin It on Pinterest