Years-long experience using Excel is not always enough to know the novelties of the program you work in.
Of course, you get a desired result, but you can achieve the desired outcome in less time with the help of new tools.
The course focuses on profound issues and modern Excel functions, providing an insight into many practical and unfamiliar ways of working in Excel.
Multifunctional tables, sorting, filtering and text functions
Relative, absolute and mixed addressing; logical, mathematical and statistical functions at the high level, date and time functions, conditional in-depth visualization of address (source), graphs and data entry restrictions, dynamic charts, observance of working areas; finding one, two and N variables; developer tools;
After completing the course, you will be able:
to solve various tasks and create logical and structured data models within the shortest time possible, which will simplify the data entry and analysis process.
Advantages of our training:
The number of trainees in a group doesn’t exceed 10 persons, which allows the trainees to be maximally involved in practical activity and discussions during the training sessions, as well as to present their problematic issues.
This training is unique in the sense that it is based on the years-long teaching experience, as well as on the review and analysis of the real-life cases that help trainees apply the obtained knowledge in their daily activity.
The course is intended:
for individuals with many years of experience working in Excel, who are willing to improve their program skills, to learn high-order functions of the program with due account for the program details, as well as to master new Excel functions.