Microsoft Excel:
from Beginner to Advanced

Course start — April 22

Online course from basic utilities to Macros to Vlookup and Hlookup, to PivotTables and Data tables. Master the functions of Microsoft Excel and Google sheets

Microsoft Excel:
from Beginner to Advanced
Course start — April 22

Online course from basic utilities to Macros to Vlookup and Hlookup, to PivotTables and Data tables. Master the functions of Microsoft Excel and Google sheets

Maximally efficient
education

Up-to-date knowledge

The courses are crafted with a focus on the most current industry demands. We include only essential skills necessary for the field, avoiding any unnecessary content

Study with
tutor

Learning new things proves by far easier when guided by a personal tutor who will dive deep into your project, help you build on your strengths and won’t leave you to face issues on your own

Real-world projects

Implementation of projects primes the student for real-life job conditions. Projects help to learn the course material and also allow for an immediate immersion into the intricacies of the profession

Easy, fast and convenient

A clearcut structure. The course is broken down into modules. Modules consist of lessons. Each lesson offers some theoretics with the tutor's practical experiences

For whom is this course

People active in their careers

The course is intended for those who are not particularly keen on monotonous duties, rather seeking to automate and speed up their workflows

Job seekers

Knowledge of Microsoft Excel is one of the most sought-for skills according to job ads reviews. Some vacancies don't even presume an applicant to have work experience or any skills other than competence in Excel

Course description

40
experiential classes
2
options, with or without tutor
20 $
at payment without tutor
40% discount
when paid by April 22
Date
Location: any place
Location
Date: anytime
How We learn

You can take the course at your own pace. It includes clear theory in text and short videos, detailed feedback on each practical assignment from a personal tutor. All of this is available on our educational platform

You can take the course at your own pace. It includes clear theory in text and short videos, detailed feedback on each practical assignment from a personal tutor. All of this is available on our educational platform

Relevant knowledge
in the course

Relevant knowledge
in the course

Technologies to study up
  • Statistical and logical functions
  • VLOOKUP/HLOOKUP: Search functions
  • Text functions: Simplification of workflows
  • Functions for working with dates and times
  • Large data sets: Operations and analytics
  • PivotTables: A tool for calculating, analyzing, and aggregating arrays of data
  • Data tables: A powerful utility for data formatting
  • Data analysis: From scratch
  • Macros: Customize and handle
  • Google Sheets
These are the skills you are going to acquire during the course at Brunoyam
Your access to the entire course, inclusive of all updates, persists indefinitely. Your tutor stays in touch even after the end of the training
Your access to the entire course, inclusive of all updates, persists indefinitely. Your tutor stays in touch even after the end of the training

Tutors at the course

Working professionals from different countries
Tutotor Ekaterina Pavlova
Ekaterina Pavlova

Ekaterina Pavlova

Work Experience

I received my education in management with a focus on data analysis for business purposes. I am also currently pursuing a PhD and enjoy teaching my students about the importance of using a data-driven approach in business.

About

Nobody has ever taught me how to work in MS Excel – for me this program is enough intuitive, however based on empirics only my journey of polishing Excel skills was rather long. I am happy to have now an opportunity to share my knowledge and help others improve their Excel skills. I believe that with practice and dedication, anyone can become proficient in using this powerful tool

I wanted to refresh my Excel skills after a long break. During the course, I didn't just refresh them; I also learned many new nuances. A big thanks to Kate for sharing her professional and structured knowledge with us

Sonya, Group WM253-1433
Work Experience

I received my education in management with a focus on data analysis for business purposes. I am also currently pursuing a PhD and enjoy teaching my students about the importance of using a data-driven approach in business.

About

Nobody has ever taught me how to work in MS Excel – for me this program is enough intuitive, however based on empirics only my journey of polishing Excel skills was rather long. I am happy to have now an opportunity to share my knowledge and help others improve their Excel skills. I believe that with practice and dedication, anyone can become proficient in using this powerful tool

I wanted to refresh my Excel skills after a long break. During the course, I didn't just refresh them; I also learned many new nuances. A big thanks to Kate for sharing her professional and structured knowledge with us

Sonya, Group WM253-1433
Read more

Course Program

  • Starting Excel
  • Understanding the Display Screen
  • Working with the Ribbon
  • Working with the Quick Access Toolbar
  • Working with the Status Bar
  • Switching Between Opened Workbooks
  • Using Excel Help
  • Working with cells and ranges
  • Types of data
  • Basic calculations
  • Fill data automatically
  • Worksheets OperationsCopy, Paste and Remove Data. Paste SpecialFind and Replace Text and Numbers
  • Save and Close a Workbook
  • Font formatting
  • Cell Formatting
  • Number formats
  • Custom Format Cells
  • Copy and Save User Defined Cell Forma
  • Frequently used shortcuts
  • Keyboard shortcuts for navigating in cells
  • Keyboard shortcuts for formatting cells
  • Keyboard shortcuts for working with data, functions, and the formula bar
  • Function keys
  • Ribbon keyboard shortcuts (’Mnemonics’)
  • Split Options
  • Combine Options
  • Simple Sorting Data
  • Custom Sort
  • Simple Filtering Data
  • Advanced Filtering
  • Custom Views
  • SORT and FILTER functions
  • Highlight Duplicates and Unique values
  • Advanced Filter
  • Remove Duplicates
  • UNIQUE function
  • Conditional Formatting
  • DDL
  • Types of cell referencing
  • Named Ranges
  • Referencing cells from different worksheets and workbooks
  • Formula Auditing for correct referencing
  • Simple Hyperlink
  • Insert Hyperlink Tool
  • HYPERLINK function
  • Charts
  • Practice
  • Functions
  • Text functions for different tasks
  • Number as a text issue
  • Basic Math and Stat functions
  • LARGE and SMALL functions
  • Adding conditions to math and stat calculations
  • Rounding numeric values
  • Функция промежуточные итоги
  • Date and Time in Excel
  • Date functions
  • Time functions
  • Financial Functions
  • TRUE and FALSE concept. IF-statements
  • IF function. IFS, SWITCH functions
  • AND, OR, NOT statements
  • IFERROR function
  • VLOOKUP and HLOOKUP
  • INDEX and MATCH
  • Data validation, DDL
  • Protect
  • Big case
  • Smart tables
  • Pivot tables
  • Calculated fields

  • Creating a macro
  • Editing a macro
  • VBA
  • Select Case
  • Particular issues of working with Google Sheets: pros and cons
  • Handling queries, QUERY function
  • Learning the interface tools
  • Limit; Where; Group by; Select
  • Collecting data from different tabs
  • Scalar functions in SQL
  • Google Sheets Pivot Tables
  • Importing data into Google Sheets
  • Integrated functions: MAXIFS, SUMIFS, FILTER, VLOOKUP, UNIQUE
  • Analyzing data by filtering columns
  • Conditional data formatting
Any questions? We will gladly answer them
Any questions? We will gladly answer them

We have trained 16,287 specialists

From the course I would initially like to receive information about the built-in functions, pivot tables necessary for work. As a result, all this was studied and worked out with examples, I additionally updated my entry-level knowledge, and received a lot of useful information. Delighted with the resul
Ann
The student course "Microsoft Excel: from Beginner to Advanced"
I wanted to restore some forgotten ones, as well as learn new functions to simplify working with databases, building diagrams. The application of knowledge began already during the training. Completely satisfied with the course. Thank you very much teacher. It was easy to do the exercises. Very useful stuff. Answered all questions. Discovered even more secrets than was in the program.
Kate
The student course "Microsoft Excel: from Beginner to Advanced"

Get answers to your questions

The goal of this course is to provide participants with specific skills and knowledge in Excel, enabling them to simplify your working process by Microsoft Excel.

This course is suitable for all levels, who want to enhance their Excel skills and proficiency.

No specific prerequisites are necessary. This course is designed for individuals starting from scratch.

The training includes text theory, video lessons, hands-on exercises and typically takes 4 weeks, but participants can progress at their own pace.

Support is available through our platform. Additional materials, such as downloadable templates are accessible to enrich the learning experience

Any questions? We will gladly answer them