Power Query training in MS Excel

Catalogue index: PCO/37

  • In stock
  • Delivery: free
  • Dedicated training:
  • Producer:
  • Training level:
    • -
  • Type of training:
    • stacjonarne
PLN280.00 net / particip. PLN4,200.00  net for 1 workshop PLN344.40 gross incl. 23% VAT / particip.

product- line 1

Features

Features
Additional materials:
  • skrypt szkoleniowy, pliki do zadań i ćwiczeń
Certification:
  • TAK
Dedicated training:
Number of training hours:
  • 8
Producer:
Training language:
  • polski
Training level:
  • -
Type of training:
  • stacjonarne

Description

Company Description

Since 2012, we have been operating in the training industry, and our team consists of people who have been involved in teaching and creating modern solutions in the field of IT for many years. We spend over 600 hours a month in training rooms. This time is dedicated to training our clients but also to enriching our experiences, listening skills, and responding to your needs. We specialize in training and consulting in the field of IT. We create ready-made solutions that facilitate everyday work. Our offer includes a wide range of training for both beginners and advanced users and IT specialists. The client is the most important to us! Our work makes sense when the client returns to us again and recommends us to others.

Training Description

The training "Power Query in MS Excel" is a practical course that allows participants to learn and master one of the most powerful tools for automating data work in Excel. Power Query enables quick and intuitive importing, transforming, and combining data from various sources – without the need to write code. The training is conducted in a workshop format, allowing participants to immediately apply the acquired knowledge in practice, using real examples.

Who is the Training For

The training is aimed at individuals working with data in Excel – analysts, accountants, HR specialists, logistics, sales, as well as anyone who wants to automate repetitive tasks and increase their work efficiency.

Goals

The goal of the training is to teach participants to independently create Power Query queries that will allow for quick data preparation for analysis.

Benefits
  • Data processing automation without using macros
  • Time savings by eliminating manual operations
  • Ability to combine data from multiple sources
  • Better data preparation for analysis and reporting
  • Increased work efficiency in Excel
  • Integration possibilities with Power BI and other tools
Training Program
  • Introduction to Power Query – what it is and what it is used for
  • Power Query interface – discussion of the work environment
  • Importing data from various sources (Excel, CSV, Web, databases)
  • Transforming data – filtering, sorting, changing types
  • Creating calculated and conditional columns
  • Grouping and aggregating data
  • Merging and appending tables
  • Creating parameterized queries
  • Automating data updates
  • Practical exercises and case studies using Power Query
Duration

8 hours

Price Includes
  • Practical classes with a trainer
  • Training script
  • Files with tasks and exercises
  • Certificate
  • Email consultations

Zamów szkolenie