fbpx
Logo.
Menu_mob. Mob_closed.

Pogliblenie
Excel course

Main image Excel Advanced Excel course.
145 min
€2000

Excel advanced course will open up new possibilities for working with data, allowing you to maximize the power of Excel.

You will learn how to apply complex formulas, including INDEX & MATCH, create pivot tables for in-depth data analysis, and forecast and analyze "IF" scenarios.

This course will help you become a real expert in using Excel. Buy the course now and take your skills to the next level!

For whom
will be a good course

Financial analysts
and economists

- Those involved in in-depth data analysis, financial planning, and forecasting will find this course useful for improving their skills and learning new tools.

Managers ta
project managers

- people who manage teams and projects will be able to use Excel more effectively to monitor progress, create reports, and analyze results.

Business analysts
and consultants

- professionals who advise companies or are engaged in business analysis will be able to apply the knowledge to create detailed reports and forecasts.

Office workers

- people who already have basic knowledge of Excel and want to deepen their skills to increase productivity and efficiency at work.

Students and teachers

- Students and teachers who use Excel to prepare research papers, projects, and analyze data will be able to significantly improve their analytical skills.

Freelancers and the
self-employed

- Experts who provide services to clients and want to improve their skills to perform more complex tasks and analyze data.

Detailed content
course

XLOOKUP
  • Limitations of VLOOKUP and HLOOKUP functions, XLOOKUP function.
  • Wildcards, search direction.
  • Create a drop-down list from a range.
Formulas part 1
  • Using a combination of IF/IFS and VLOOKUP functions, various application examples.
  • Logical AND and OR in formulas.
  • Features of references to table fields in formulas.
  • Quick analysis formulas.
  • Converting a table to a range.
Formulas part 2
  • Forms for processing of pomilokas IFNA, IFERROR.
  • Various options for IF/IFS and VLOOKUP combinations to simplify formulas.
INDEX & MATCH
  • Data substitution using a combination of the INDEX and MATCH functions, ascending or descending substitution.
  • An additional method of work: special insertion of a constant with a mathematical operation.
SUMPRODUCT
  • SUMPRODUCT function: standard and non-standard application (comparing data with duplicates).
Database functions
  • Database functions: calculations with many conditions.
  • DSUM, DMAX, DCOUNT, and DCOUNTA functions.
  • Additional workflow: replace special characters with the SUBSTITUTE function
Summary tables - part 1
  • Create a pivot table report based on worksheet data.
  • Working with the list of fields in a pivot table.
  • Formatting and modifying pivot tables.
  • Results: intermediate and general.
  • Grouping items in a summary table report (manual and automatic).
  • Change the formulas for calculating fields.
  • Features of getting several pivot tables based on one source.
Summary tables - part 2
  • Your own sorting list.
  • Multiple pivot tables on one sheet.
  • Formatting data in pivot tables.
  • Calculated elements in pivot tables.
Summary tables - part 3
  • Change the format of numbers in pivot tables, use a separator.
  • Layout of pivot tables.
  • Copy pivot table data to another worksheet.
  • Displaying data with calculations: difference from the previous period, percentage increase, percentage of the parent row total.
  • Use of separators, separator parameters, number of columns.
Summary tables - part 4
  • Proper names of pivot table fields.
  • Date scale.
  • Adding calculated fields of a pivot table.
Summary tables - part 5
  • The field format is in thousands.
  • Connect multiple pivot tables to a single separator.
  • Create a pivot chart based on a pivot table.
  • Formatting the chart, color scheme, axis labels.
  • Field buttons.
  • Formatting divisions on the chart axes.
  • The GETPIVOTDATE function
Forecast sheet
  • Forecasting future results based on available data, data frequency.
IF analysis
  • Modeling the results: obtaining a table of results when changing one or two parameters.
  • Scenarios - simulations with three or more variable parameters.
  • Selection of one parameter to obtain a predetermined result.
  • Find a solution to a problem with several variable parameters.
Final testing
  • 20 questions, passing score 70% (14 questions), the number of attempts is infinite, the time is not limited.

Demo video

Metodi training

The course is designed as a simulation of real-life Excel work, including interactive assignments. Participants will complete tasks that are as close as possible to practical situations they may encounter in their work. The main learning methods include:

Interactive tasks

Tips for interactive tasks

Choosing the right answers

Entering values in cells

Recommendations.
to start learning

To enroll in an advanced Excel course, participants must have:

In addition, access to a computer with Microsoft Excel installed is required to complete practical tasks and exercises throughout the course.

Related
Excel online course

Excel Basic Online Course

Data analysis

Visualization in Excel

Common question.

Do I need any prior knowledge of Excel to take this course?

No prior knowledge of Excel is required, but it can be helpful. This course is designed to cover all the basics of Excel, so the user will be able to get started from scratch even if they have never used the program before.

How does the course take place?

This basic online course in Excel combines simulations with interactive exercises and hands-on activities. Participants can study the materials at their own pace, allowing them to better absorb the information.

Will users receive a certificate after completing the course?

We can provide a template for an individual certificate upon request, which the user will receive upon successful completion of the course. The conditions for obtaining the certificate, such as points gained, materials listened to, or results of the final test, can be determined by you.

Is there any access to the materials after the course?

You can independently determine the conditions of access to the course materials after its completion, according to the needs of your company.

Is there a trial version of the course or a free trial?

A demo version of the course is available above on this page. Upon request, we can provide access to individual elements of the course, allowing you to customize it to your needs.