18% off for Latvia’s Independence Day
Contacts

Excel Courses for Experienced Users

This course is designed for people who already know how to use basic Excel functions and want to master its advanced features. You will learn how to analyze data, create reports, visualize information, use pivot tables, and automate repetitive tasks. The course is suitable for office employees, financial and project managers, entrepreneurs, and anyone who works with data in everyday life.

About the courses

Course Duration:
30 academic hours (10 sessions)

Format:
Online classes with an instructor (via Zoom)

Group Size:
Up to 12 participants

Certificate:
Upon course completion and successful exam

Class Schedule:
Monday/Wednesday, 18:00–20:15

Course Price:
330 EUR (incl. VAT)

Start Date:
January 28, 2026

Who is this course for?

This course is designed for those who already know how to use basic Excel functions and want to master its advanced capabilities.

 

You will learn how to analyze data, create reports, visualize information, use pivot tables, and automate repetitive tasks.

The course is suitable for office workers, financial and project managers, entrepreneurs, and anyone who works with data in their daily life.

Course Benefits

Experienced instructor who adapts to the group’s level

01

Practical real-life examples

02

Online format – learn from anywhere!

03

Certificate upon course completion

04

Course Plan

Lesson 1
Popular formulas and references

  • SUM, AVERAGE, MIN, MAX
  • Relative and absolute references
  • Copying formulas and efficient structure

 

Lesson 2
IF and logical functions

  • IF, AND, OR and combinations
  • TEXT, DATEDIF, TODAY, YEARFRAC
  • Common practical examples

 

Lesson 3
VLOOKUP, XLOOKUP and MATCH

  • Searching data across tables
  • Advantages of XLOOKUP over VLOOKUP
  • INDEX + MATCH combinations

 

Lesson 4
SUMIFS, COUNTIFS, AVERAGEIFS

  • Conditional calculations
  • Multi-level analysis scenarios
  • Real examples with filtered data

 

Lesson 5
Data filtering and validation

  • Advanced filters, unique records
  • Data validation
  • Removing duplicates and data protection

Lesson 6
Visualization and conditional formatting

  • Conditional formatting by criteria
  • Sparklines and visual cell analysis
  • Professional report styling

 

Lesson 7
Pivot tables and Pivot charts

  • Creating and structuring pivot tables
  • Grouping, calculations, slicers
  • Pivot charts and customization

 

Lesson 8
Data analysis tools: What-If, Goal Seek, Solver

  • Creating and comparing scenarios
  • Optimization with Solver
  • Calculating costs, forecasts, resources

 

Lesson 9
Automation and Power Query

  • Recording simple macros (no coding)
  • Action automation
  • Power Query: import, filter, transform data
  • File merging, column cleanup, applying conditions

 

Lesson 10
Test and summary

  • Knowledge check
  • Q&A session
  • Recommendations for further learning

Want to enroll in the course?

Fill out the form and our managers will contact you shortly

Trusted by leading companies

Other computer courses

excel kursi

Excel courses for beginners

€
per course

Order a subscription

Submit the form and our manager will contact you shortly!

Join the team

Fill out and submit the form and we will contact you shortly.