Microsoft Excel Courses

Microsoft Excel course

Excel is one of the most in-demand work tools for organizing and processing data. Behind its seemingly simple interface lie powerful capabilities: hundreds of built-in functions, analysis tools, pivot tables, macros, and a built-in programming language.

The program is useful not only for office staff but also for managers, analysts, economists, and logistics specialists — anyone who regularly works with calculations, reports, and large spreadsheets.

Excel features covered in the course

1. Working with numeric data.
2. Working with text.
3. Graphs and charts.
4. Diagrams and images.
5. Lists and databases.
6. Importing and exporting data.
7. Automating repetitive tasks.
8. Dashboards.
9. The built-in programming language.

Course goals

To give participants Excel knowledge and skills they can apply at work right away:

• core concepts and tools of the program;
• professional work with formulas and tables;
• confident spreadsheet skills;
• competent and efficient use of the program for work tasks.

Individual and corporate training

The program is tailored to the participant's starting level, so you don't spend time on what you already know. The course suits users of all levels, and the assignments mirror real work processes:

1. creating and editing spreadsheets;
2. mathematical calculations of varying complexity;
3. sorting and selecting data;
4. preparing spreadsheet documents of any complexity;
5. fast data processing in documents and calculations;
6. working with lists and pivot tables;
7. generating reports;
8. building charts and graphs.

Excel for economists and finance professionals

A separate block covers financial analysis with Excel: financial functions (including depreciation calculations), evaluating investment returns, and forecasting indicators such as exchange rates.

By the end of the course, participants will be able to

• create, edit, and save Excel workbooks, lists, and tables, and configure settings;
• enter and edit data, format cells, and sort, filter, group, consolidate, copy, and move data;
• build formulas and perform calculations of varying complexity, work with functions and relative and absolute references, and automate large numbers of repetitive calculations;
• design spreadsheet documents (schedules, statements, catalogs, price lists) and use Excel as a database;
• build and customize charts (column, pie, line, scatter), choosing source data, axes, and formatting;
• create pivot tables and analytical reports from large data sets;
• record macros and automate routine operations.

Training terms

• Format: individual, corporate, online.
• Duration: 5–7 sessions.
• Group size: 4–6 people.
• Fee: depends on the training format; see the Contacts section for details.
• Schedule: days and times by arrangement.
• Certificate: HSE IPAA certificate of completion.