Search Results

Here's what we found

54 results for: power query
All Tutorials in One File at XelPlus

Free Excel Tutorials (Power Query Hack Included)

Find the links to helpful and free Excel tutorials all in one place. These include videos, articles and downloadable Excel files. Whenever you get stuck, refer to this list.

Import Power BI Data into Excel

Learn how to export data from Power BI and use it in Excel. The data can be enhanced by Excel and receive updates from Power BI when new data is added to the Power BI Data Model.

Financial Modelling in Power BI (eBook)

You’d like to create financial models in Power BI? This eBook will teach you how. Download the templates and get started today!

Power Excel Bundle course cover

Power Excel Bundle

10x your productivity in Excel 💪. This bundle includes Master Excel Power Query course & Master Power Pivot and DAX course. It’s Excel’s Ultimate Power Tools in ONE convenient (cost savings) bundle. Learnings apply to Power BI as well.

Power Pivot, Data Modelling, DAX Course Cover

Master Excel Power Pivot & DAX (Beginner to Pro)

Transforming data into meaningful reports can feel like being in an Olympic event. It is hard!
Join the course and learn how to use Excel’s Power Pivot and Data Modelling tools to make reporting easy and fast.

Power BI course image

Fast Track to Power BI

Stay ahead of the game in 2023.
Get access to our best-selling Power BI course now and become a highly sought-after Power BI professional.
This course gets you started in Power BI – Fast!

How to Use Power BI – Beginner’s Guide

Get started with Power BI now by creating your first dashboard. Download the free files, follow along and in 20 minutes you’ll have setup your interactive dashboard which you’ve published to the web!

3 Hidden Tips for Excel Power Pivot

These 3 hidden Excel Power Pivot tips will help you to: Copy your data model from one file to another, create a dedicated measures table and convert your pivot table data to formulas.

Google Sheets QUERY Function Explained

The Query function in Google sheets is one of the most powerful Google Sheets functions. It’s easy to learn if you follow the rules laid out in this tutorial. You’ll be ready to solve any data analysis problem in Google Sheets.

How to Transpose Mutliple Header Rows to Columns in Excel – Advanced Unpivot Techniques

You can easily use Excel Power Query to transpose a data-set with multiple row headers from multiple columns to rows. Find out how in this quick tutorial.

5 Hidden Excel Features for Busy People

Learn five amazing time-saving features in Excel that you likely have never tried or even knew existed. Turn hours of work into seconds.

Excel Dashboard to Track Budget and Actuals with Variances

Learn to build a budget vs actual dashboard in Excel. Master key formulas and chart customization for effective year-over-year variance analysis.

Free Guide!

The ONE Critical Excel Skill You Need in 2023

This free QuickStart guide will help you to:

  • Pinpoint the skill you should work on now
  • Understand how this skill can help you
  • Find the optimal learning path to master this skill