MS Excel: On the Edge of Magic (MSEV1)

Microsoft Office, Excel

Join a hands-on three-hour online workshop that opens Excel's hidden rooms and reveals clever shortcuts. You will master hidden operators, clean formula design, time-saving techniques and ways to simplify tasks for faster, error-reduced workflows.

This workshop is practical and demo-driven: we show how to replace monstrous nested formulas with clean functional notation, speed up calculations using operators and dynamic arrays, and preview future Excel features to build robust models.

Location, current course term



VirtualPro (online)
5/20/2026 - 5/20/2026 CZECH
Order
Custom Customized Training (date, location, content, duration)

The course:

Hide detail
  • The power of hidden operators
    1. Logic without IF and lightning-fast calculations
    2. Lookups without lookup functions
    3. Dynamic strings and formatting
  • Dynamic arrays and functions of the future
    1. How to master dynamic ranges
    2. Implicit intersection — where and why?
    3. New practical functions used with operators
Assumed knowledge:
Basic user knowledge of MS Excel.
Schedule:
1 day (9:00 AM - 12:00 PM )
Course price:
36.00 € ( 43.56 € incl. 21% VAT)
Language: