Microsoft

Excel – Power Query

In this course, you will become comfortable with:

» Using PQ for data loading and cleaning purposes
» Using PQ to reformat reports to tables for easier data analysis
» Combining data from multiple sheets in a workbook
» Combining data from multiple files in a folder
» Tips, tricks, and best-practice techniques

You will benefit most from this course if you:

Consider yourself an intermediate user of Excel and need to work with data that originates outside Excel.

superadmin

Recent Posts

Microsoft Planner

With Planner you and your team can to create plans, assign tasks, chat about tasks,…

4 weeks ago

Redesigning a Better Life

Redesigning a Better Life is about creating your own unique path and living a more…

2 years ago

Adobe Premiere Pro – Quickstart

Creating short videos is becoming an indispensable skill. In this one-day workshop, you will learn…

2 years ago

Project Management Quickstart

In this introductory course, students learn all of the basics of project management. Perfect for…

3 years ago

MS Sharepoint – Users

In this hands-on course, we will demonstrate and practice the essential skills you need to…

9 months ago

Document Design in Word

A well-designed document reflects well on you because a good page layout makes any document…

3 years ago