Microsoft Excel:
from Beginner to Advanced
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
from Beginner to Advanced
education
For whom is this course
The course is intended for those who are not particularly keen on monotonous duties, rather seeking to automate and speed up their workflows
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
190 ₽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
- 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
Tutors at the course
Ekaterina Pavlova
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.
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
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.
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
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
We have trained 16,287 specialists
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
English
Русский