Microsoft Excel and Power Query - Video 1 Import Excel files into Power Query

Описание

Before you can analyse and create pivot table reports, you must first extract data from the various data sources. Interacting with SQL Server is different from Excel, so you should learn the nuances of both systems. After you’ve learned the particulars of each system, you can use Power Query (the query engine used by Excel) to help you clean the data, such as renaming columns, replacing values, removing errors, and combining query results. After the data has been cleaned and organised, you are ready to build reports in Excel.

@softwaresolutions.

Please like or subscribe!

This is one of a collection of videos that goes with our Excel Level 4 Course called Get and Transform Data with Power Query. If you would like the exercise files and notes and other resources that accompany the videos, please visit www.softwaresolutions.co.nz and enrol in either the MS Excel Level 4 Face to Face, Remote or Online versions of the course.

https://www.softwaresolutions.co.nz/excel

Kind Regards Cathi Barker