Course NT-Excel (IV) Microsoft Excel, part 4

The Microsoft Excel Course Part 4 covers advanced capabilities for data analysis, automation, and interactive reporting. Part 4 continues the Excel training program (Parts 1, 2, and 3) and is designed for users who already work confidently with formulas, tables, functions, and basic data analytics, and want to move to an advanced level of Excel usage for business tasks, financial analysis, modeling, and process automation.

In this course, participants learn tools that turn Excel into a powerful system for data analysis, building interactive reports, scenario modeling, and basic automation of routine tasks.

What the Excel course (Part 4) includes

The course covers key advanced-level Microsoft Excel tools:

1. Custom number formats in Excel
Participants learn how to create and apply custom number formats for professional data presentation. The structure of formats (positive, negative values, zeros, and text), formatting of numbers, dates, and time, as well as conditional formatting within custom formats are covered. This enables more readable financial and analytical reports without changing the underlying data.

2. What-If Analysis in Excel
Covers scenario analysis tools widely used in financial modeling, planning, and forecasting. These tools allow quick analysis of different scenarios and the impact of changing variables on outcomes.

3. Excel Solver add-in (Optimization / Goal seeking)
A dedicated section focuses on Solver for optimization tasks in Excel: finding the best solution under defined constraints. This tool is widely used in financial analytics, logistics, resource planning, and business modeling.

4. Controls (form elements)
Used to build interactive dashboards, dynamic reports, and user interfaces for data analysis in Excel.

5. Excel Macros and task automation (VBA basics)
Introduces macros as an automation tool in Excel. This section helps automate repetitive tasks and significantly improve productivity.

After completing this course, students will be able to:

• use custom number formats for professional data presentation in Excel
• apply What-If Analysis tools for forecasting and modeling
• work with Solver for optimization problems
• create interactive dashboards and reports using form controls
• record and run macros to automate Excel processes
• understand basic VBA principles and edit simple macros
• improve efficiency when working with large datasets
• build more flexible, dynamic, and automated Excel models

Audience Profile

The Excel Part 4 course is intended for:

• Data Analysts
• finance professionals and accountants
• managers working with Excel reporting
• economists, planners, and business analysts
• users who have completed Excel Parts 1-3
• anyone who wants to move from basic Excel to automation, analytics, and modeling

Before attending this course, students must have:

For effective learning, participants should have:

• confident Microsoft Excel skills
• experience with formulas (IF, SUM, VLOOKUP/XLOOKUP and other basic functions)
• understanding of tables and structured data
• skills in creating basic charts and reports
• preferably completion of previous Excel courses (NT-Excel (I), NT-Excel (II), NT-Excel (III))