Master Your Data with Excel and Power BI

If you are struggling to clean up your data in Excel or Power BI, or spending time performing repetitive data cleanup on a regular basis, you owe it to yourself to ...

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 and modeling to make intelligent business decisions.

This Power Pivot online training, which Ken Puls has developed with a company called GoSkills, will help you step up your game and take your skills to new heights.

If you aren't familiar with this amazing tool, here are four reasons you will want to learn Power Pivot:

1. Power Pivot makes analysis easy. You can output data visually to

...

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 data is king, you should know how to work with and understand it – and this tool helps you do just that.

In this Power Query online course Ken Puls has designed and built with a company GoSkills, you will learn the BI (Business Intelligence) process of importing data, appending and merging tables, conditional logic, data transformation, and organization. The course starts with the basics of Power Query, and works its way up. This means that you’ll be a pro in no time, even if you’re a beginner with the tool. ...

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 worked with a company called GoSkills to help design and build and online course that will teach you the data visualization skills ...

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 was a ton of logic built into the tool in order to make it easy for end users, but that ease of use had a cost: it didn’t scale to multiple data source tables. And worse, it actually kept you from learning the terms to scale your own knowledge. ...

Monkey Tools Add-in


Monkey Tools is an Excel add-in containing a set of tools to help you build better data models more quickly and using data modelling best ...

COACHED: Self Service BI Boot Camp

Course Description

Prepare to change your company’s reporting game forever! We know that data is not usually stored in nicely curated databases and often – even when it is – the data analyst doesn’t have access to it. Instead, we must piece together data provided in text files, Excel files, ...

Sign up to receive the monthly(ish) Excelguru newsletter, featuring the latest updates for Excel and Power BI, upcoming training sessions, new products, and other information.

As a "thank you" for subscribing, we are excited to share our FREE eBook series, 'DIY BI' Tips, Tricks & Techniques. Don't miss out - sign up today!