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

Redesigning a Better Life

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

1 year 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…

2 years ago

MS Sharepoint – Users

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

4 months ago

Document Design in Word

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

2 years ago

MS SharePoint – Owners

SharePoint features are robust and complex. Site owners can determine which features and options to…

4 months ago