fbpx
Logo.
Menu_mob. Mob_closed.

Basic
Excel online course

The main image of the visualization in Excel.
75 min
€1600

Basic MS Excel course — is your first step to mastering the most popular data program.

You will learn how to automate tasks, analyze data, and create reports by mastering cell formatting, working with ranges and tables, and using formulas and functions.

Purchase the Excel for Beginners course today and discover new opportunities!

For whom
will be a good course

Office workers

- for those involved in administrative tasks, data management, reporting, and analytics. Knowledge of Excel will help you optimize your workflows and improve the accuracy and efficiency of your tasks.

Students and teachers

- students and teachers who use Excel to analyze data, prepare projects, presentations, and reports. Skills in working with tables and formulas will be useful in the educational process and research.

Businessmen and entrepreneurs:

- for business owners and managers who want to better understand financial performance, create business plans, budgets, and analyze sales. Excel will become an indispensable tool for making informed decisions.

Freelancers and the self-employed

- independent professionals who perform a variety of projects for clients can use Excel to manage their tasks, finances, and reporting

Analysts and financiers

- for those involved in data analysis, financial planning, and forecasting. Skills in working with formulas and tables will help you build complex models and conduct detailed analysis.

Anyone who wants to increase
your qualifications

- people seeking to improve their professional skills and expand their career opportunities. Learning the basics of Excel will help you become more competitive in the labor market.

What will be taught
on the Excel course for beginners

What will be taught in the Excel course for beginners.
  • Data and formats
  • Tables.
  • Data structure
  • Formulas (2 parts)
  • Combining data
  • Additional methods of work
  • Final testing

Demo video

Metodi training

The Excel for Beginners course is a simulation of real-life Excel work with interactive assignments. Participants will complete tasks that are as close as possible to real-life Excel scenarios. The main training methods include:

Interactive tasks

Tips for interactive tasks

Choosing the right answers

Entering values in cells

Detailed content
course

Data and formats
  • Cell contents: what can be in a cell?
  • Features of using different date display formats for further analysis.
  • Autocomplete.
  • Formatting with styles.
  • Copy formats to other cells.
  • Special insert with dynamic viewing.
  • Work with sheets: rename, move, delete, group.
Tables.
  • The difference between a range and a table.
  • Table styles.
  • Features of using filters for fields of different data types.
  • The sum of the rows.
  • The interim results are simple and nested.
  • The SUBTOTAL.
  • Convert a table to a range.
  • Keyboard shortcuts to speed up your work.
Data structure
  • Multi-level sorting.
  • Grouping: automatic and custom.
  • Interim results.
  • Copy special data: select ranges with a condition.
Formulas, part 1
  • Work with formulas: enter, edit, copy to other cells.
  • The concepts of relative, absolute, and mixed references to cells and ranges.
  • Date and time functions (TODAY, DAYS, NETWORKDAYS).
  • Mathematical functions (ROUND).
  • Conditional functions (SUMIF, SUMIFS, COUNTIF, COUNTIFS, IF, IFS).
Formulas, part 2
  • References in formulas to other sheets.
  • Function wizard.
  • VLOOKUP and HLOOKUP functions.
  • Nested functions.
Combining data
  • Combine data on different sheets.
  • Three-dimensional connections.
  • Consolidation tool.
  • Consolidation of unlinked and linked data.
Additional methods of work
  • Separate text by columns: by delimiter and fixed width.
  • Instant filling.
  • Delete duplicate values.
  • Remove unnecessary formatting.
  • Export book to pdf.
  • Data protection in the book.
  • Version log - tracking changes in a file.
Final testing
  • 20 questions, passing score 70% (14 questions), the number of attempts is infinite, the time is not limited.

Recommendations
to start learning

To enroll in the Excel for Beginners course, participants must have:

In addition, access to a computer with Microsoft Excel installed is required to repeat practical tasks and exercises throughout the course.

Related
Excel online course

Excel course

Data analysis

Visualization in Excel

Frequent question.

Do I need any prior knowledge of Excel to take this course?

No prior knowledge of Excel is required, but it can be helpful. This course is designed to cover all the basics of Excel, so the user will be able to get started from scratch even if they have never used the program before.

How does the course take place?

This basic online Excel course is delivered through a combination of program simulations, interactive exercises, and hands-on activities. Your employees will be able to study the materials at their own pace.

Will users receive a certificate after completing the course?

We are ready to provide a customized certificate at the request of the customer, which will be issued upon successful completion of the course under the conditions that the customer determines. These conditions may include such parameters as points scored, material listened to, final test result, and others.

Is there any access to the materials after the course?

You determine all the access conditions that you consider necessary for your company.

Is there a trial version of the course or a free trial?

You can watch the demo version of the course above on this page. Upon request, we can also provide access to individual elements of the course, which will allow you to tailor it specifically to your needs.