Advanced Excel 2016 features. Level 2. — rate 5900 rub. from Softline, training 16 hours, Date: December 15, 2023.
Miscellaneous / / December 05, 2023
Softline Training Center is a reliable business partner for corporate training with state accreditation, capable of ensuring the development of employee competencies and preparing professionals in the field business and IT.
The training center is part of Softline Group of Companies, a leading global supplier of IT solutions and services operating in the markets of Eastern Europe, America and Asia. At the end of 2019, Softline’s turnover exceeded $1.54 billion, growth in Russia was 65% in rubles, in the EECA region - 8%, in other countries - 27%.
Having in our arsenal the official statuses of the training center of all key vendors, we are pleased to offer students classes with highly qualified teachers in any convenient form of training, passing certification exams, flexible individual approach to training, discounts, promotions. The training center also has a number of unique authorizations for such vendors as: CommuniGate, Bentley, InfoWatch, Veritas, Acronis.
Long-term partnership with companies such as Microsoft, Cisco, Autodesk, Kaspersky, Vmware, Oracle, Red Hat, Citrix says that training programs in these areas fully comply with vendor requirements. But cooperation is not limited to this list; there are more than 30 vendors in the CA portfolio.
Over more than 18 years of existence, we have trained more than 300 thousand first-class specialists in the field of modern information technologies. Upon completion of training at our Training Center, you can receive the following completion documents: certificate Softline Training Center, vendor certificate, advanced training certificate, professional diploma retraining After passing the exams at testing centers, an international IT specialist certificate is issued.
Come to us for knowledge and we will make your IT dream come true!
A practical online course where you will master all the functions of Excel and Google spreadsheets: from working with tables to data visualization.
The course covers the features of managing workbooks, sharing them, filling cells with data, conditional formatting, and data checking, applying advanced formulas and data analysis, creating macros, creating and modifying advanced charts, pivot tables in MS Excel.
The purpose of the course is to study the standard and additional capabilities of pivot tables and charts, PowerPivot add-ins and then create a pivot table and data transformations using queries Power Query. The course program is designed with an emphasis on the practical application of pivot tables for data analysis. The capabilities of the PowerPivot and Power Query add-ins are considered as a tool for preparing and transforming data for subsequent analysis.