from newcomer to expert

A practical online course where you will master all the functions of Excel and Google Tables. Classes are held on interactive simulators - a full copy of the Microsoft Excel interface.

Interactive exercises

In the Excel and Google Tables interface

Official diploma

About the end of the course

2 weeks

On average
For passage

Personal curator

will answer any question

Excel and Google Tables:

Sign up for the course

There are places left: 8

A practical online course where you will master all the functions of Excel and Google Tables.Classes are held on interactive simulators - a full copy of the Microsoft Excel interface.

Excel
And Google Tables:

Elementary

Master

Learn More

Подготовка данных
Вычисления с формулами
Сводные таблицы
Диаграммы и графики

Hurry up to choose the right tariff and use the discount!

The most necessary for beginners

PRO

If an exel is needed in work

Big data and pro-analytics

Access is forever

The most popular

21 Lesson

10 hours

44 lessons

21 times

All from the initial

+

Advanced functions

Google tables

Squeezing tables

3 months of support

Access is forever

Graduation diploma

73 lesson

42 hours

All of Pro Tariff

+

Professional tools

Macros

Dashboard and automation

Power Pivot and Power Query

12 months of support

Access is forever

Graduation diploma

Advanced

What do you learn

Turn chaotic data into a table with which it is convenient to work

1

Quickly make complex calculations using consolidated tables, formulas and hotклавиш

2

Build forecasts and analyze various scenarios

4

Create dashboards for visualization of data and quick analysis of indicators

5

Work with superstructures Power Query and Power Pivot

6

Build informative graphs and diagrams for presentation to management and clients

3

Create your own macros to solve non -standard problems

7

How is training

See interactive lessons at a convenient pace

Perform practical tasks

If questions arise, send them to the curator

Get an official course of the course

Interactive exercises

On the course, you immediately start practice by working in a copy of the Microsoft Excel interface. The simulator gives tips and step -by -step instructions. As a result, you will quickly learn knowledge and will confidently own Excel.

Learning program

1. How to turn chaotic data into a table with which it is convenient to work

Splitting and Merging Text
Finding Duplicates in a List
Error Checking
Text Formatting
Pivot Tables
Conditional Formatting

2. How to make quick calculations using functions and formulas

Sum and Product
Average and Growth
Conditional Sum
VLOOKUP Function

Data Transposition
Hiding and Showing Rows and Columns
Data Grouping
Consolidating Data into One Table

Maximum and Minimum
Frequency Analysis
Logical Functions

10 lessons

8 lessons

/ SUM and SUMPRODUCT

/ Power Query Add-in

3. How to build financial models and predict the results

What-If Analysis
Parameter Search and Scenario Manager
Solver Add-in

4. How to automate tasks and speed up work

Inserting a Character on the Keyboard
Automatic Highlighting of the Active Row
Flash Fill Function
Transliteration
Basics of Working with Macros
Updates in the Latest Version of Excel

3 lessons

6 lessons

/ SUMIF

5. How to make convenient plans, graphs and calendars in Excel

Vacation calendar
Automatic dates and deadlines

6. How to build visual diagrams

Control lines
Histogram with an overlap
Hormized centered histogram
Point diagram
Rounded data

Lolling diagram
Ossy histogram
Sparclayans

2 lessons

8 lessons

/ SUM and SUMPRODUCT

/ SUMIF

Final Project and Diploma

After completing all the lessons, you will carry out a final project in which you apply all the skills learned in Excel. You will receive an official diploma that you can include in your resume.

7. How to Move from Excel to Google Sheets

8. Macros in Excel and Google Sheets

9. Creating Interactive Dashboards in Google Sheets and Excel

When and for what purposes macros are used, how they help
and automate work
Basics and fundamental principles
of writing macros for beginners

When and for what purposes
dashboards are used
How a dashboard helps simplify
or automate work
with analytics and charts
Algorithm for building a dashboard

Introduction to Google Sheets
Basic functions of Google Sheets: VLOOKUP, UNIQUE, SUMPRODUCT, Filter, and others
Advanced functions of Google Sheets: inserting images and text

7 lessons

10 lessons

3 lessons

Pivot Tables and Conditional Formatting
Creating Charts
Data Protection
Keyboard Shortcuts

Syntax and Logic of the VBA Language, Control Structures, Operators, and Loops
Common Errors When Writing Macros

How to add new data to the table and refresh the dashboard
How to work with such a dashboard and utilize all its capabilities

10. Power Query and Power Pivot Add-ins

When and for what purposes Power Query and Power Pivot are used
How Power Query and Power Pivot differ
How the Power Query add-in works
with data, what is included in the concept
of "external data"
The Power Query editor interface
and how to work with it

10 lessons

Power Query M Language, its basic
functions and syntax
How to import and load
external data and transform
it into a readable table
How the PowerPivot add-in is related to Power BI
Key principles of working
with Power Pivot: data models,
data relationships, and calculations

PRO

Master

PRO

Access to materials and updates to the course forever

40 important templates
and "cheat sheets" – as a gift

You will receive useful "cheat sheets" – handouts that will help you in your daily work. We recommend printing them out and keeping them handy.

How to create pivot tables
How to calculate averages and growth
How to use what-if analysis
How to apply the VLOOKUP function
How to perform frequency analysis
How to use logical functions
How to visualize data

–
–
–
–
–
–
–

With them, you will easily find the perfect job for you, where you will feel confident and communicate with colleagues in the same language.

We provide the necessary knowledge and skills

HR specialists from Eduson Academy will help you create a professional resume that will make you stand out from other candidates.

We help you draft your resume

You will gain access to the
employment course and learn
how to prepare for interviews, answer difficult questions
and much more.

We explain everything about job searching

Sending resumes
to partner companies

Since 2013, we have been training employees of major companies. Your resume will go directly to our partners, allowing you to quickly find a job at one of the leading companies.

Help to find a dream work

1

2

3

4

Course methodologists

Nicholas Walker

Content Director. Developed more than 700 courses.

Jeffrey Jackson

Analyst of Trade and Treasury Services, former analyst in the Project Financing Department of Eurasian Development Bank, former consultant on transfer pricing.

Students' reviews

Excel course

Theresa Woods

I have been working with Excel for a long time and wanted to enhance my knowledge. But I didn’t expect to learn so much new... The material in the course is presented briefly, clearly, and without "water." There is an opportunity to review and reinforce skills. I can study at any time that is convenient for me. In case of difficulties, there is prompt and clear feedback from the Academy staff. I learned what Power Query is and figured out macros! This is a significant achievement for me! I have never regretted my training. I look forward to continuing my interaction with the Academy!

Head of the Global HR team, student of the Excel course

Patrick Stewart

The course helped me improve my Excel skills and advance my position to the head of the global human resources team. Now I can work with large volumes of data, optimize processes, save time for other non-routine tasks, and have a greater impact on the business.

Excel course

Viola Cobb

I want to say a big thank you to everyone who worked on creating the Excel course. I learned many new features, useful tricks, and keyboard shortcuts. Eduson Academy truly proved to be a professional in their field; I really enjoyed working and learning in the Excel course. I am confident that in the future, I will definitely try other training programs as well.

Elementary

Everything you need to receive income from your social networks

Полный курс по SMM для продвижения вашего бизнеса в социальных сетях и формирования потока клиентов

Master

Полный курс по продвижению вашего проекта в социальных сетях с аудитом и индивидуальной поддержкой

Buy

PRO

Buy

10

$

15

$

20

$

Data Preparation
Calculations with Formulas
Pivot Tables
Charts and Graphs

Lifetime Access

Все базовые и продвинутые функции Excel

Модуль по функциям Google-таблиц

44 урока и 7 модулей

Поддержка на 12 месяцев

Доступ к материалам курса навсегда

Диплом об окончании курса

Hurry up to choose the right tariff and use the discount!

All basic and advanced Excel functions

Module on Google Sheets functions

73 lessons and 10 modules

Modules on Macros, Dashboards, and Power Pivot and Power Query Add-ins

12 months of support

Lifetime access to course materials

Certificate of completion

The essentials for beginners

The most popular

Basic Excel Functions

3 Months of Support

21 Lessons and 6 Modules

Lifetime Access to Course Materials

If an exel is needed in work

21 lessons

10 hours

Big data and pro-analytics

44 lessons

21 hours

All from the initial

+

Advanced functions

Google tables

Squeezing tables

3 months of support

Access is forever

Graduation diploma

+

73 lessons

42 hours

All of Pro Tariff

+

Professional tools

Macros

Dashboard and automation

Power Pivot and Power Query

12 months of support

Access is forever

Graduation diploma

Frequently asked questions

Is this course right for me?

To understand if the course is right for you and to choose the suitable plan, leave a request for a consultation with our manager in the form above. The manager will provide detailed information about the training, answer all your questions, and provide a demo version of the course.

How long will it take to complete the course?

It depends solely on you. You can complete the course in 2 weeks of intensive training or take a bit longer to master the program. We won’t leave you without support – a curator will be with you for three months or a whole year, depending on the plan.

What are the requirements to start learning?

How and when will I study?

You will study at your own pace at any time of day and can independently structure your learning path.

To start learning, you will need the Excel program and basic knowledge of the interface (you should know how to create an Excel file; know what a cell and a sheet are; be able to change font and text size; and be able to use simple mathematical formulas).

How long will I have access to the course?

Access to the course and all updates is provided forever. We regularly update the courses and supplement them with the most in-demand topics.

Will I receive a diploma?

A diploma is available in the "Optimal" and "Advanced" plans. After completing all the lessons, you can contact the curator to receive an official course completion diploma with a unique number, the Academy's seal, and the founder's signature.

Will I have support?

How can I pay for the training?

You can pay for the training in one payment using a bank card or make monthly payments instead of a one-time payment. No interest will be charged for this. Training can also be paid for with an invoice from a legal entity.

Of course! You will have a personal curator. You can communicate with them through a convenient communication channel: email or popular messaging apps.

Can I purchase this course as a gift?

Yes, of course. Learn more about gift certificates in the special section.

Contact Info
KATERYNA CHUMAK
[email protected]
Street Viry Biloi, building 32, Kryvyi Rih 50079 Ukraine
+380 955970028

Privacy Policy
Terms of Cooperation
Partnership Agreement