Course NT-Excel (II) Microsoft Excel, part 2

The course provides knowledge and skills in working with Microsoft Excel tools for data preparation and analysis. The course was created on the basis of many years of experience in conducting trainings for data analysis experts, their most typical tasks and methods of analysis. The course also considers interesting innovations in Excel for analytics, in particular, working with multi-page tables, automating calculations using built-in functions, "deep diving" into pivot tables and their multiple settings, and also provides an understanding of working with the Data Object Model.

After completing this course, students will be able to:

• form reports of different complexity;
• choose the data you need according to one or more criteria;
• perform calculations;
• automatically collect one of several tables;
• build various graphs and charts;
• use built-in capabilities of the Excel program to automate similar operations.

Audience Profile

The course is intended for specialists who have studied one of the previous versions of Microsoft Excel, use the application at work and wish to gain advanced knowledge of Excel.

Before attending this course, students must have:

• knowledge in the scope of the first part of the course "Microsoft Excel"; or equivalent knowledge;
• skills for creating Excel workbooks, working with tables, saving files and performing basic data operations, formatting, copying and moving, cleaning and deleting;
• skills of using absolute and mixed reference formulas;
• skills in using Excel to create simple formulas, also using the "Insert function" window; (Insert Function);
• skills in using functions TODAY, ROUND, IF, SUMIF, COUNTIF, VLOOKUP (VPR), HLOOKUP (HPR), etc.;
• skills for working with the "Table" object, formatting and using the summary line, using the table field when writing formulas;
• skills for creating summary tables based on the data of one sheet;
• skills for constructing linear graphs and diagrams based on Excel table data.