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

MS Teams – Essentials

Communication is one of the biggest keys to success in the workplace. Microsoft Teams offers…

2 months ago

MS Teams – Quickstart

No question, the speed of work has increased exponentially. Whether you work remotely or in…

2 months ago

Microsoft Power Automate

If you are looking to streamline repetitive tasks and processes, you can use Microsoft Power…

2 months ago

Microsoft Planner

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

4 months 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