Customize Consent Preferences

We use cookies to help you navigate efficiently and perform certain functions. You will find detailed information about all cookies under each consent category below.

The cookies that are categorized as "Necessary" are stored on your browser as they are essential for enabling the basic functionalities of the site. ... 

Always Active

Necessary cookies are required to enable the basic features of this site, such as providing secure log-in or adjusting your consent preferences. These cookies do not store any personally identifiable data.

No cookies to display.

Functional cookies help perform certain functionalities like sharing the content of the website on social media platforms, collecting feedback, and other third-party features.

No cookies to display.

Analytical cookies are used to understand how visitors interact with the website. These cookies help provide information on metrics such as the number of visitors, bounce rate, traffic source, etc.

No cookies to display.

Performance cookies are used to understand and analyze the key performance indexes of the website which helps in delivering a better user experience for the visitors.

No cookies to display.

Advertisement cookies are used to provide visitors with customized advertisements based on the pages you visited previously and to analyze the effectiveness of the ad campaigns.

No cookies to display.

Program of new courses in Microsoft Excel


Course 1: Introduction to Microsoft Excel

Basics of working in Excel: Introduction to the interface, basic functions and capabilities.
Data entry and formatting: Basic operations with cells, rows, columns.
Working with formulas and functions: Basic mathematical, logical and text functions.
Creating simple tables and graphs: Constructing and formatting tables and charts.
Basics of data sorting and filtering: Methods for organizing and filtering information.

Course 2: Advanced Excel

Complex functions and formulas: Working with functions VLOOKUP, HLOOKUP, INDEX, MATCH.
Conditional Formatting: Apply conditional formatting rules.
Pivot tables: Create and customize pivot tables for data analysis.
Working with big data: Optimizing work with large volumes of data.
Data protection: Methods for protecting and encrypting data in Excel.

Course 3: Data Analysis in Excel

Data Import and Export: Methods for importing data from various sources and exporting data from Excel.
Data analysis functions: Using the functions SUMIFS, COUNTIFS, AVERAGEIFS.
Scripts and Data Tables: Create scripts and use data tables for what-if analysis.
Regression analysis: Conducting regression analysis.
Data visualization: Creation of interactive dashboards and reports.

Course 4: Financial Analysis in Excel

Financial functions: Using the functions PV, FV, NPV, IRR.
Budgeting: Creation and analysis of budget tables.
Sensitivity Analysis: Sensitivity Analysis Methods.
Evaluation of investment projects: Project evaluation methods such as DCF and NPV analysis.
Financial Modeling: Creating financial models for forecasting and analysis.

Course 5: Project Management with Excel

Project Planning: Create project schedules and plans.
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: Advanced Excel Tools

Power Query: Import and transform data using Power Query.
Power Pivot: Analyze big data using Power Pivot.
Power BI integration: Integrate Excel with Power BI to create powerful dashboards.
Data Modeling: Creating complex data models and analyzing them.
Report Automation: Create automated reports using macros and VBA.

Sign up for a course