Are Prereqs Recommended?

Yes, they are recommended only, and nothing is required for this course. We will say that for some it will enhance the experience to explore some of the recommendations before your session. The benefit to you is that it will confirm you have the general understanding to get the most of this course. Recommendations You need to know at least generally about Power Query and what it is about. You don't need to know a lot about it, but you should know what it is and how to access it.

What exactly do you cover in this course?

This course really breaks down into the three major categories. Understanding the more advanced data transformation features in Power Query Understanding how to work with the Advanced Editor Understanding how to automate routine data cleaning and modeling tasks

Who is this course designed for?

This course is designed for the rising Excel user who is comfortable with the basics and looking for more. It's also good for experienced users who have heard about what Power Query can do and want to know how to make use of it in their own work.

What technologies are you using in the course?

We focus on Microsoft Excel in this course, specifically Microsoft Excel 2016 or later (earlier versions do not include Power Query). If you have more questions on this, please contact us.

Data Analyst Archives - ThinkDataSol

An intermediate badge showcasing Power Query data skills.

Intermediate Power Query

July 2, 2023

Intermediate Power Query Are you tired of spending valuable time hopping from one spreadsheet to...

Mastering Power Query for data analysis.

Getting Started with Power Query

July 2, 2023

Getting Started with Power Query Power Query is a game-changer in Excel. Whether you're currently...

Understanding and Building SQL Queries

July 2, 2023

Understanding and Building SQL Queries In this course, you don't need to grasp the entire...

Getting started with Power BI - data and viz.

Getting Started with Microsoft Power BI

July 2, 2023

Getting Started with Power BI Dashboards, Smashboards - if you're only surviving with basic pivots...

Removing Duplicates, Build a SumIF, and Creating a Chart in Excel

October 17, 2018

Removing Duplicates, Build a SumIF, and Creating a Chart in Excel October 17, 2018 -...

Data Analyst

Intermediate Power Query

Getting Started with Power Query

Understanding and Building SQL Queries

Getting Started with Microsoft Power BI

Removing Duplicates, Build a SumIF, and Creating a Chart in Excel

Recent Posts

Categories

Archives

Subscribe for news and training updates.