MS Excel Today – Modern Tools and New Functions (MSED)

Microsoft Office, Excel

MS Excel is no longer just a spreadsheet — with new intelligent tools and modern functions it can transform daily work. This course introduces practical techniques for handling routine data tasks, from dynamic ranges to smarter automation.

Throughout hands-on sessions you'll practice with real datasets, receive practical tips and proven recommendations to boost productivity. Learn to use AI helpers, improve data analysis and visualization, and apply new features to everyday workflows.

Location, current course term

Praha + online (volitelně)	11/13/2025 - 11/13/2025 CZECH Order 2/10/2026 - 2/10/2026 CZECH Order 4/7/2026 - 4/7/2026 CZECH Order
Custom	Customized Training (date, location, content, duration)

The course:

Hide detail

• New tools and commands in Excel 365
1. Tools for clearer data handling
2. Efficient navigation and optimization for large datasets
3. New visual and interactive cell elements

• Dynamic ranges and new operators
1. Explanation of dynamic range principles
2. Introduction to new operators and practical uses
3. Hands-on examples with real data

• Introduction to new functions in Excel 365
1. New functions for efficient text handling and examples
2. Functions for dynamic data processing and analysis
3. Advanced formatting and custom rules for dynamic ranges

• Analytical tools
1. Quick summaries using the built-in Quick Analysis tool
2. Tips for fast data summaries and clearer visual reports

Assumed knowledge:

Good familiarity with the MS Excel interface and routine experience with functions and pivot tables.

Recommended previous course:

MS Excel – PivotTables Without Fear (MSE3)

Schedule:

1 day (9:00 AM - 5:00 PM )

Course price:

180.00 € ( 217.80 € incl. 21% VAT)

Language: