Online course Advanced Excel
Comprehensive Excel: from basic utilities to Macros to Vlookup and Hlookup, to PivotTables and Data tables
Maximally efficient
education
About course
- Classes in Petersburg
The course is purely practical. For every topic the knowledge gained is immediately taken into practice by means of a large number of applied tasks
Our tutors every day run into some new problems to solve with Excel, thereby contributing to automatization of outines and expediting daily operations, for themselves and their co-workers. Such versatile experiences make them able to find just the right approach to any student`s issue
New solutions constantly added up, things no more relevant left out — all you have to do is make yourself familiar with the solutions available and apply them to your task, in this manner mastering crucial skills. The entire course has been geared to#nbsp;render the contents clear and descriptive and easy to#nbsp;comprehend
The course is purely practical. For every topic the knowledge gained is immediately taken into practice by means of a large number of applied tasks
Our tutors every day run into some new problems to solve with Excel, thereby contributing to automatization of outines and expediting daily operations, for themselves and their co-workers. Such versatile experiences make them able to find just the right approach to any student`s issue
New solutions constantly added up, things no more relevant left out — all you have to do is make yourself familiar with the solutions available and apply them to your task, in this manner mastering crucial skills. The entire course has been geared to#nbsp;render the contents clear and descriptive and easy to#nbsp;comprehend
You can take the course at your own pace. Clear theory in text and short 10-15 minute practice videos. Detailed feedback on each practical assignment from a personal mentor. All of this is available on our educational platform.
You can take the course at your own pace. Clear theory in text and short 10-15 minute practice videos. Detailed feedback on each practical assignment from a personal mentor. All of this is available on our educational platform.
For whom is this course
The course is intended for those who are not particularly keen on#nbsp;monotonous duties, rather seeking to automate and speed up heir workflows
EnrollKnowledge 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
How the
training goes
Learn at a convenient schedule from anywhere in the world on our platform
Practice with homework assignments. They consist of three levels of difficulty
Work on projects. They will go into your portfolio
Submit practical assignments to your mentor. They will provide detailed feedback within 24 hours
- Learn at a convenient schedule from anywhere in the world on our platform
- Practice with homework assignments. They consist of three levels of difficulty
- Work on projects. They will go into your portfolio
- Submit practical assignments to your mentor. They will provide detailed feedback within 24 hours
Relevant knowledge
in the course
Relevant knowledge
in the course
- Statistical and logical functions
- Vlookup/Hlookup — search functions
- Text functions — simplification of workflows
- Functions to work with dates and times
- Large data sets — operations and analytics
- PivotTables — a tool to calculate, analyze and aggregate arraysof data
- Data tables — a powerful utility for data formatting
- Data analysis — from scratch
- Macros — customize and handle
Thanks to the Brunoyam team and your practice, of course
Thanks to the Brunoyam team and your practice, of course
Tutors at the course
Alice Pushina
I graduated from the sociology faculty and worked as a marketing analyst. I have a total of 10 years of experience in data analytics
I don't enjoy 'hands-on' work. Monotonous tasks make my eyes glaze over. That's why I strive to automate my activities as much as possible, so I can focus on interesting tasks rather than collecting field data. If you relate to these statements, let's move forward together in the direction of growth! Excel is not just a tool; it's fascinating
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. There was a wonderful, warm, and friendly atmosphere in the group. A big thank you to Alice for sharing her professional and structured knowledge with us.
I graduated from the sociology faculty and worked as a marketing analyst. I have a total of 10 years of experience in data analytics
I don't enjoy 'hands-on' work. Monotonous tasks make my eyes glaze over. That's why I strive to automate my activities as much as possible, so I can focus on interesting tasks rather than collecting field data. If you relate to these statements, let's move forward together in the direction of growth! Excel is not just a tool; it's fascinating
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. There was a wonderful, warm, and friendly atmosphere in the group. A big thank you to Alice for sharing her professional and structured knowledge with us.
Course Program
- Application parameters
- Hot keys and shortcuts
- Auto Fill
- Flash Fill
- Types of reference
- Cell Format
- Relative Hyperlinks
- Separating and combining of data
- Applying various types of integrated functions
- COUNT and COUNTIF functions
- UPPER and LOWER functions
- COUNTIFS function
- LEFT and RIGHT functions
- MIN, MAX and AVERAGE functions
- SEARCH and MID functions
- LARGE and SMALL functions
- How to remove spaces
- other useful features
- SUM function
- SUMIF function
- SUMIFS function
- IF function
- Usage of named ranges
- IF+AND function
- Applying data validation rules
- IFERROR function
- Creating drop-down lists
- IF+OR function
- Cell and Worksheet protection
- IF+IF function
- Workbooks. Protection of Workbooks
- VLOOKUP complex function
- HLOOKUP complex function
- INDEX+MATCH function
- Using the regular Excel Filter
- Excel Advanced Filter, the range of conditions
- Remove Duplicates
- Generic and Multi-level Data Sorting
- Defining the Conditional Formatting rules
- Rapid Analysis
- Interim Summaries
- Building 2-axis charts
- Creating PivotTables
- Modifying PivotTables
- PivotCharts
- Specifying PivotTable fields
- Adding calculated fields into a PivotTable
- Additional calculations on PivotTables
- Data Tables
- Macro recorder
- Saving macros with the Macro recorder
- Editing macros
- Creating buttons to run macros
- Building custom functionalities
- Tweaking custom functionalities
- Usage of absolute references for macro recording
- Usage of relative references for macro recording
- 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
Fast training with no compromise of quality
Effective solution of your business problems lies just within a few months of the course beginning
Effective solution of your business problems lies just within a few months of the course beginning
Effective solution of your business problems lies just within a few months of the course beginning
Effective solution of your business problems lies just within a few months of the course beginning
English
Русский