TOP Training in tools for working with data

The course teaches the PL/SQL language version of Oracle 11g R2: software constructs such as procedures, functions, packages and triggers; some of the standard packages; dynamic SQL; Bulk data downloads using collections; ways to influence the compilation of PL/SQL code and the dependency management mechanism. The tool used is Oracle SQL Developer.

A practical online course where you will master the profession of a data analyst from scratch in 6 months at your own pace. You will develop all the necessary analyst skills, learn to work with Python, SQL, Excel, Power BI and become an up-to-date IT specialist.

During the course, you will learn how to build graphs and dashboards, work with large amounts of data and create interactive reports. Everything that will help you quickly solve business problems.

The latest version of Microsoft Office 365/2021 has a built-in programming language called Visual Basic for Applications (VBA) still remains the main most important means of automating the work of users with office applications. The largest number of application tasks that require the use of macros arise when working with Excel spreadsheets. Experienced users can independently cope with Microsoft Excel 365/2021/2019 automation issues if they master the capabilities of macro programming in VBA.

4,3

1 review

The course covers the basic capabilities of LibreOffice Calc: creating files, navigation, creating tables and charts, working with simple formulas.

Learn to use all the Excel tools to process data, automate routine tasks, and improve productivity. Master formulas, charts, pivot tables and advanced features.

Trainings, seminars and certification. The program volume is 32 hours. The goal of the program is to acquire theoretical knowledge in the field of functionality of calculations and analysis information, as well as practical skills in analyzing large volumes of data, statistical data processing, solving optimization problems, generating macros for the purpose of using them for frequently repeated operations and automating work using spreadsheets MS Excel.

Course by Olga Bazaleva and Excellent data visualization school. About the main things you need to work in Excel: formulas, functions, visualization.

Professional retraining. Working with data. Study of databases and SQL language, Python language, its application for data collection, visualization and analysis, statistics and machine learning, as well as approaches for working on real-world problems.