Course NT-Excel (III) Microsoft Excel, part 3
The NT-Excel (III) Microsoft Excel, Part 3 course is a continuation of the training track and is intended for learners who have already mastered Excel at the basic and intermediate levels (Parts 1 and 2).
At this stage, the focus is on advanced data analysis tools, calculation automation, and modern Excel capabilities. The course builds a systematic understanding of working with data and prepares learners to use Excel as a full-fledged analytical tool.
After completing this course, students will be able to:
- better navigate advanced Excel capabilities and use more complex chart types (Pareto, Waterfall, Treemap, Sunburst, etc.)
- work with array formulas and dynamic arrays for data processing
- perform data analysis using Power Pivot
- create relationships between tables and understand data model structure logic
- retrieve and process data from various sources using Power Query
Audience Profile
The course is intended for:
- Excel users who already have a confident level
- analysts, finance professionals, marketers
- specialists working with large datasets
- anyone who wants to use Excel as a tool for building analytical solutions rather than only for basic calculations
Before attending this course, students must have:
- Excel knowledge at the level of NT-Excel (I) and NT-Excel (II) courses or equivalent
- confident use of:
- formulas and functions
- tables and charts
- data analysis tools
Preferred:
- experience working with large datasets
- basic understanding of analytical logic
1. Expert-level diagrams
- Creating charts from data that does not form a continuous rectangular data area
- Some chart types: bubble, stock, surface, radar, treemap, sunburst, waterfall, Pareto
- Trendlines
2. Smart Computing: Next-Generation Features
- Functions: SWITCH, CONCAT, TEXTJOIN, XMATCH, XLOOKUP, LET, LAMBDA
3. Array formulas
- Understanding array formulas. How array formulas work. Array formulas that return a single value and formulas that return an array of values.
- Entering and editing array formulas
- Limitations and features of classic array formulas
4. Dynamic arrays
- Understanding Dynamic Arrays
- Spill Ranges
- Automatic Formula Expansion
- Returning Arrays with Excel Classic Functions
- Functions for Working with Dynamic Arrays: FILTER, SORT, SORTBY, UNIQUE, SEQUENCE, RANDARRAY
5. Multi-table data analysis in Excel - Basics of using Power Pivot
- The Power Pivot add-in, its purpose and "environment"
- The concept of a data model, its structure, and construction principles
- Obtaining data from various external sources (Access databases, text files, Excel tables, etc.)
- Relationships between tables. Relationship types. Data model schemas. Reference tables (dimensions) and fact tables
- Establishing and configuring relationships between tables
- Visualizing a data model using pivot tables and charts
6. Basics of obtaining data from external sources and preparing them for further use (Power Query)
- Introduction: Understanding ETL (Extract, Transform, Load). What is Power Query and its application. Understanding queries and working in the query editor.
- Obtaining data from various sources (text files, Excel tables, internet data, etc.).
- The principle of sequential data transformation in the query editor. Step-by-step actions (editing, deleting, adding a new step).
- Step-by-step data transformation.
- Using query results. Updating queries.
Sign up for the closest date
Copyright © 2026 Networking Technologies