Best teachers and best score price/quality & Service Management!
Read more
+31 (0) 20 - 2050324
info@dictsolutions.com

Microsoft Excel Power Query training 1 Day

Map
GENERAL
Target audience
Foreknowledge and level
Duration
Exam details
Extra information
Questions?
The Microsoft Excel Power Query training 1 day helps you enormously during your working day. Retrieving data externally in Microsoft Excel has improved and changed radically since the advent of Power Query. If you do the following activities on a daily basis, such as importing and retrieving data & cleaning the data, merging this data into a consolidated file, VLOOKUP() to combine this data with other tables and/or create Macros to streamline previous ones then this Microsoft Excel Power Query course is definitely suitable!

Microsoft Excel Power Query training 1 day content

Introduction

  • Brief Introduction, What is Microsoft Excel Power Query?
  • Where can you find Microsoft Excel Power Query?

Import from different data sources

  • Microsoft Access
  • Microsoft Excel
  • CSV files
  • Website
  • Files

Change data type with Microsoft Excel Power Query

  • Do it yourself or accept defaults

Combining Similar Data in Microsoft Excel Power Query

  • Combine files into one table and process into pivot table
  • Append: Add Queries
  • Combine tables with data in an Excel file into one table

Grouping grouped data

  • Group multiple tabs
  • Grouping Multiple Columns
  • Unpivoting the data
  • Group multiple files

Import .TXT without separator

  • As defined

Load query

  • Connection only
  • Loading from Query to Table
  • Loading from Query to Data Model

Summarize and group

  • Grouping the data
  • Get the details of the grouped data

Grouping and transporting complex data

  • Data that is supplied differently as in tabular form
  • Data with different headers

 Power Query Formulas

  • Using the best known Excel Formulas with Power Query such as: IF.ERROR(), LENGTH(), SEARCH(), AND(), OR()IF(), LEFT(), RIGHT()

 The advanced editor

  • Introduction: language M
  • Syntax: language M

Using Worksheet Variables Microsoft Excel Power Query

  • Using cells within Microsoft Excel worksheet as variables for queries

Convert query to function

  • Query multiple files

If you do not yet master the basic knowledge, it is better to first Microsoft Excel Basic training 1 day Follow.

For more related training, please visit the Microsoft look at overview page, examples are the Microsoft Access Basic training 2 days Level 1Microsoft Office Powerpoint Basic training 1 day Level 1Microsoft Word Basic training 1 day level 1Microsoft Excel Power Pivot Basic training (1 day) Level 1Basic VBA Excel training (2 days) & Microsoft Excel Power Pivot Advanced – DAX (1 day) Level 21.

Microsoft Excel Power Query training 1 day dtarget group

This Microsoft Excel Power Query course is intended for students who want to analyze data that is not immediately suitable because it still needs to be adapted. Cleaning up with Microsoft Excel Power Query saves a lot of time. Anyone who wants to process data in Excel will benefit greatly from the Microsoft Excel Power Query Training.

Microsoft Excel Power Query training 1 day prior knowledge

To be able to follow this Microsoft Excel Power Query training you must have knowledge of Microsoft Excel. You must at least be able to master the Microsoft Excel Formulas & Functions at a reasonable level and preferably also be able to handle Macros and external data within Microsoft Excel.

You can gain this knowledge by using the Microsoft Excel Basic training 1 day to follow.

Level Microsoft Excel Power Query training 1 day

The level of this Excel Power Query training is MBO+.

Microsoft Excel Power Query training course duration

As the name of the training suggests, this Power Query training lasts 1 day and the course time is from 09:30 to 16:30.

Exam Microsoft Excel Power Query

With Microsoft you can find more information about possible exams. At D-ICT Solutions we can also offer an exam to test your knowledge and possibly earn a certificate.

Microsoft Excel Power Query training 1 Day

If you register your company for a Microsoft Excel Power Query in-company 1 day via D-ICT Solutions, you can always have one of our trainers/consultants visit you (or virtually) for an implementation session Microsoft Excel power query. During this afternoon or morning you will receive advice with regard to optimizing or setting up Power Query within your organization by a certified expert.

Do you have a question about: Microsoft Excel Power Query training 1 Day

Please feel free to contact us if you cannot find a suitable date.

Microsoft Excel Power Query training 1 Day video lesson
Microsoft Excel Power Query training 1 Day Appendix
Download file

FAQ

Lowest price guarantee for the best courses (also for in-company), by working with our own teachers!
We can always provide courses in multiple languages: including German, French, English, Dutch and Italian!
1st place for: best trainers, Price/Quality and Service Management in 2022 and 2023!
Accredited trainers with a lot of work experience, so many examples from practice!
Always more options available because we have our own teachers... Ask about the options!
Look below for a number of examples of option dates, fill in the number of participants and make a reservation!
15,00
350,00
Your shopping cart is currently empty.

Back to shop

Depaus Holding BV / D-ICT Solutions
Verrijn Stuartweg 1A,
1112 AW Diemen
KvK 34143398
VAT NL810633474B01
Bank 45.50.16.429
+31 (0) 20 - 2050324
info@dictsolutions.com
license linkedin Facebook Pinterest youtube rss Twitter Instagram facebook-Blank rss blank LinkedIn-blank Pinterest youtube Twitter Instagram