fbpx

Microsoft Excel Courses Online

Checkmark icon.

Choose the Excel courses that best suits your learning objectives to improve your skills and achieve professional success.

Main image of the Microsoft Excel online course.

Basic course

  1. 1. Input in Excel
  2. 2. Working with data and formats
  3. 3. Working with tables
  4. 4. Understanding the structure of Excel
  5. 5. Combining data
  6. 6. Basic formulas, part 1
  7. 7. Basic formulas, part 2
  8. 8. Additional techniques for working with Excel

Advanced course

  1. 1. Using the XLOOKUP function
  2. 2. In-depth study of formulas, part 1
  3. 3. In-depth study of formulas, part 2
  4. 4. Using the INDEX & MATCH functions
  5. 5. Working with the SUMPRODUCT function
  6. 6. Using database functions
  7. 7. Summary tables, part 1
  8. 8. Summary tables, part 2
  9. 9. Summary tables, part 3
  10. 10. Summary tables, part 4
  11. 11. Summary tables, part 5
  12. 12. Working with the forecast sheet
  13. 13. Using the IF Analysis function

Data analysis

  1. 1. Collecting data in Excel
  2. 2. Data conversion
  3. 3. Connect and add data
  4. 4. Data merging, part 1
  5. 5. Data merging, part 2
  6. 6. Techniques for working with Power Query
  7. 7. Relational data model in PowerPivot
  8. 8. Calculated columns and measures
  9. 9. Hierarchy
  10. 10. Building KPIs
  11. 11. The CALCULATE() function
  12. 12. Functions of working with the date
  13. 13. Building dashboards
  14. 14. Processing in PowerPivot with Power Query

Visualization

  1. 1. Pie charts
  2. 2. Line and bar charts,
    histograms
  3. 3. Dot, bubble, and
    combination charts
  4. 4. Additional methods for selecting elements
  5. 5. Additional types of charts
  6. 6. Pivot charts
  7. 7. Conditional formatting, part 1
  8. 8. Conditional formatting, part 2
  9. 9. Mini-charts
Decorative image.

Similar courses

Decor for the curriculum of online courses excel.

Learning plan of
the online Excel courses

Our Microsoft Excel online courses offer a wide range of learning opportunities for all levels of users, from fundamentals to advanced data analysis and visualization strategies.

1. In the basic course, participants will learn the basics of the program, learning how to work with data, tables, and important formulas.

2. The advanced course offers an extended study of data processing functions and techniques, including database work and complex formulas. databases and complex formulas.

3. The Data Analytics course offers the study of specialized methods of data collection, processing and analysis of data, allowing participants to become experts in working with large amounts of information.

4. In the final visualization Microsoft Excel training, participants learn how to effectively visualize their data, enabling them to draw qualitative conclusions.

With our online Excel courses, each participant gains not only in-depth knowledge, but also practical skills that can be applied in any field of activity.

A decorative element for whom the Excel course is suitable.

What is Excel Training
Courses Suitable for?

Financiers
and accountants

- for financial accounting, financial reporting, budget analysis and forecasting

Marketers,
PR managers, analytics
specialists

- for financial accounting, financial reporting, budget analysis and forecasting

Training managers,
researchers, students

- creation of educational materials, data processing in scientific research and statistical analysis

Managers
of sales

- tracking sales, analyzing results, reporting and forecasting sales

Entrepreneurs

- business plan calculations, market and competitor analysis, cost and
profit monitoring

HR specialists

- processing employee data, creating working time schedules, analyzing data on employee performance and skills assessment

Decorative part of the certification unit.

Certification of
employees

Employee certification is an important step in recognizing their professional development and competence in Excel classes online.

Main certificate
  • Certificates are issued in the name of the participant and contain information about the course or package of courses that has been successfully completed.

  • We are ready to provide a customized certificate at the request of the customer, which will be deleted after successful completion of the course under the conditions that he or she determines.

  • These certificates can be used by employees to upgrade their skills, include them in their resumes or profiles on professional networks, and for further professional development.

  • These conditions may include such parameters as points scored, material listened to, final test result and others.

Decor for Course Integration.

Integration of an Excel course online
to the learning management system (LMS)

Main image of the Excel Online Course Integration in the Learning Management System.
Excel icon about our courses.

Our courses on Microsoft Excel Online

can be easily integrated into your learning management system (LMS) with the package SCORM.

This format allows the customer to receive a set of ready-made Excel simulation training materials, that can be directly integrated into the the LMS platform of their choice.

Files in SCORM format:

  • provide a standardized way to present interactive courses that allows you to store data on progress, test results, and other information about users.

  • provide the ability to customize Excel online courses or other to the specific needs and requirements of the customer.

Decor for companies that use an Excel course.

Companies that use
Excel course from PG-Group

The logo of Ukrnafta.
The logo of Kernel.
The logo of the Pumb company.
Company logo Novapay.
Viyar's logo.
Borjomi's logo.
The logo of MHP.
The logo of EUROPEAN UNION.

Ordering a course and prices
for employee training

Icon for ordering a course and prices for employee training.

You can order an Excel course either as a single course or as a package that includes all four courses.

An arrow icon for ordering a course and prices for employee training.

To order any course or course package, please fill out the contact form below. Our representative will get back to you shortly to finalize the details and provide additional information.

Image of an airplane when ordering a course and prices for employee training.

Basic course:

€ 1600

Advanced course:

€ 2000

Data analysis:

€ 2150

Visualization:

€ 1450

A package of all courses:

-15%

€ 7200

€ 6120

Frequently asked questions

How can my company benefit from enrolling in these Excel courses?

Is there a trial period or demo version before registration?

How long is the typical duration of each Excel course?

Is it possible to customize the courses according to the specific needs of the company?

What are the technical requirements for accessing online courses?

Is support provided to students throughout the course?

What payment options are available for corporate clients?

How do we track the progress of employees in the courses?