Edukey - IT Training Logo
Microsoft 365 (Office)MS Excel

MS Excel - Advanced level

Excel at Master Level! 🚀 Advanced Techniques and Data Analysis 📊⚡

businesswoman-at-desk-modern-office.jpg

Goals

  • Boost your professional skills and work speed.
  • Solve complex problems independently.
  • Enhance your efficiency working with large datasets.

Course content

Poniżej przykładowy program na 2 dni, 14 godzin.
Zawsze dostosowujemy go do potrzeb grupy i celów biznesowych firm

  1. Wstęp i krótkie powtórzenie

    • Tworzenie nazwanych obiektów
    • Zarządzanie nazwami
  3. Walidacja danych

    • Funkcje wyszukiwania i adresu
    • Funkcje statystyczne
    • Funkcje matematyczne
    • Funkcje baz danych
    • Funkcje daty i czasu
    • Funkcje zagnieżdżone
  5. Praca z funkcjami tekstowymi i narzędziami do pracy z tekstem

    • Jednokomórkowych
    • Wielokomórkowych
  7. Zaawansowane metody analizy danych

    • Tworzenie tabeli przestawnej
    • Modyfikacje  tabeli przestawnej
    • Grupowanie danych
    • Zmiana sposobu pokazywania danych
    • Funkcja WEŹ.DANE.Z.TABELI
    • Pola i elementy obliczeniowe

    • Solver

    • Pobieranie z baz danych
    • Pobieranie ze stron WWW
    • Pobieranie z innych skoroszytów
  11. Konsolidowanie danych

    • Tworzenie
    • Posumowanie scenariuszy
  13. Makropolecenia i ich edytowanie (krótkie wprowadzenie do VBA)

Target Audience

For individuals regularly working with data who aim to analyze it better and faster to make more accurate decisions. Professionals encountering complex challenges at work, seeking to solve them effectively with Excel (good proficiency in MS Excel required).

Training Methodology

Practical workshops (minimal theory). We solve tasks together, simulating real workplace challenges. We can discuss your specific problem and/or work on your own data (e.g., anonymized). Before the training, we perform a training needs analysis to develop a tailored curriculum. We use the latest MS Office 365, but older versions can also be covered upon request.

Additional information

Customer Reviews

Our greatest pride is thousands of satisfied customers. Below are their reviews about this course:

1/30/2020

Our employees rated the substantive level of the training highly (...) The training conducted by Edukey fully met our expectations.

Translated from: PL

Złote Wyprzedaże

Dagmara Gadomska, HR & Finance Specialist

9/28/2018

The instructor demonstrated extensive subject knowledge (...) The trainer's extensive knowledge and competencies significantly impacted the effectiveness (...) I recommend Edukey Sp. z o.o. as a reliable, flexible, and professional training partner.

Translated from: PL

UNISYSTEM

Kamil Kozłowski, Vice President of the Board

10/5/2010

EDUKEY employees took due care to ensure the training was conducted professionally, competently, and reliably. With full conviction, we recommend EDUKEY as a solid partner in the field of training and consulting.

Translated from: PL

Agrosak

Marek Zawadzki, President of the Management Board

11/24/2011

Listening to the Client's needs (...) high substantive level (...) The trainer (...) well prepared in terms of content (...) pleasant atmosphere (...) high quality rating (...) solid and reliable partner.

Translated from: PL

KRUS

Stanisław Zawilski, Director

10/28/2019

Reliable and interesting materials, along with the professionalism of the instructor, deserve high praise (...) The trainer conveyed knowledge in a simple and easy manner (...) The training met the expectations of even our most demanding employees (...) Edukey has proven to be fully professional.

Translated from: PL

Knott

Piotr Nowaczyk, Manager of Production Settlements Department

4/13/2016

The trainers demonstrated high engagement... A large number of practical exercises... Mr. Karol Jażczak, who patiently... explained all the unclear issues to the participants...

Translated from: PL

Widex

Agnieszka Kaczor, Junior HR Specialist

11/24/2011

The trainer conducting the training was very well prepared substantively, while also demonstrating the ability to convey knowledge to participants and a high personal culture. Noteworthy is also the pleasant atmosphere during the classes and...the high quality rating of the training as given by the participants.

Translated from: PL

KRUS

Stanisław Zawiłski, DIRECTOR

3/15/2016

The training was conducted at a high substantive level. The company fulfilled the commissioned training correctly and competently. The knowledge and skills gained in the aforementioned training contributed to the raising of our employees’ qualifications.

Translated from: PL

Clariant Polska

Karolina Balcerzak , [NOT PROVIDED]

4/22/2016

Fagioli Polska had the opportunity to utilize the training services of Edukey Sp. z o.o. (...) The training helped us enhance our skills (...) we can recommend Edukey Sp. z o.o. to potential clients, as in our opinion, it is a reliable and professional company.

Translated from: PL

Fagioli Polska

Anna Adamczak, [NOT PROVIDED]

12/1/2016

Its goal was to enhance competencies in the area of (...) The training was conducted in a thorough and professional manner (...) consider Edukey Sp. z o.o. as a recommendable company.

Translated from: PL

Urząd Marszałkowski Województwa Kujawsko-Pomorskiego

Jolanta Rudnicka, Head of the Department of Analysis and Evaluation

Related Courses

Woman, data analyst, working at a desk with dual monitors showing spreadsheets and VBA code in an office in Warsaw, with a view of Pałac Kultury.
Microsoft 365 (Office)MS Excel

MS Excel - Intermediate level

Intro for MS Excel - Intermediate level course