Course

Course 1: Microsoft Excel Basics

Introduction to Excel: Introduction to the program interface, basic functions and capabilities.
Working with cells: Entering and formatting data, using formulas and functions.
Creating tables: Building and formatting tables, working with data tables.
Charts and Graphs: Create and edit charts and graphs to visualize data.
Functions and Formulas: Basic Excel math, logic, and text functions.

Course 2: Advanced Excel

Complex formulas and functions: Advanced functions such as VLOOKUP, HLOOKUP, INDEX and MATCH.
Conditional Formatting: Rules and techniques for conditionally formatting data.
Working with big data: Using filters, sorting and grouping data.
Building Pivot Tables: Create and configure pivot tables for data analysis.
Introduction to Macros: Basics of using macros to automate tasks.

Course 3: Excel for Data Analysis

Data Import and Export: Methods for importing data from various sources and exporting data from Excel.
Data Analysis Functions: Use SUMIFS, COUNTIFS, AVERAGEIFS and other functions to analyze data.
Scripts and Data Tables: Create scripts and use data tables for what-if analysis.
Regression Analysis: Conducting regression analysis using Excel tools.
Data visualization: Creation of interactive dashboards and reports.

Course 4: Excel for Financial Analysis

Organizing Data: Techniques for structuring and managing data in Excel.
KPI Analysis: Analyzing key performance indicators using Excel.
Management Reports: Create and present reports to senior management.
Business Data Visualization: Using visualization tools to present data.
Decision Making: Supporting decision making using data analysis in Excel.

Course 5: Excel for Project Management

Project Planning: Create project schedules and plans using Excel.
Resource Management: Managing resources and costs in projects.
Progress Tracking: Techniques for keeping track of project tasks and deadlines.
Project Reports: Generate project status reports and variance analysis.
Using Gantt charts: Creating and using Gantt charts for project management.

Course 6: Excel for Managers

“The Excel courses helped me systematize and deepen my knowledge, especially in the field of data analysis. I really liked the professional approach and the presence of real cases. Now I feel more confident and can solve complex problems much faster.”
Andrey M., data analyst

“These Excel courses have completely changed my approach to work! Previously, I spent a lot of time creating reports, but now I do it much faster and more efficiently. The teachers explain the material very clearly, and many practical examples helped me immediately apply the knowledge in practice.”

Olga P., marketing specialist

“I took the Excel course for analysts, and I can say that it was one of the best investments in my career. I learned new tools and methods of data analysis, which I immediately began to use in my work. Thank you for the quality materials and excellent presentation of information!”

Victor S., financial analyst

“I’ve been looking for courses to help me improve my data skills for a long time and finally found them here. The management courses were exactly what I needed. Now I can easily create reports and analyze data, which allows me to make more informed decisions. Very I’m happy with the result!”

Anna M., head of sales department