Course Materials
All materials required to follow the online course are provided in electronic format.
In an era where data is growing faster than ever, the difference between an average professional and a top-tier expert comes down to one essential tool: Microsoft Excel. But not the Excel used for simple table entry—the one that acts as the brain of your business.
This training is designed for those who have moved beyond the basics and refuse to spend hours on manual processes. If your work involves complex cost calculations and extensive databases, it is time to stop struggling with the software and start directing it.
From data processing to strategic decision-making: Master Excel 2026
It is no longer enough to simply “know Excel.” In 2026, you are expected to be an information architect. Our advanced course takes you where most people stop, into the zone where data tells the story on its own.
Unlock the full power of digital intelligence
It is no longer enough to simply “know Excel.” In 2026, you are expected to be an information architect. Our advanced course takes you where most people stop, into the zone where data tells the story on its own.
-
Take full control: Turn hours of tedious work into seconds of automated processes. Experience the freedom that comes from working in a system that makes no mistakes.
-
See what others miss: Learn how to turn a sea of numbers into clear trends and forecasts. Be the person who brings management not tables, but solutions.
-
Analytical edge in practice: Instead of manual processes, adopt methodologies that enable automation and flawless accuracy. The training is designed to give you technical confidence when working with the most demanding models and calculations.
What will I learn?
Tools for more efficient work and document protection
- Freeze and split panes
- Using keyboard shortcuts
- AutoFill option
- Selecting data
- Merging data from different columns
- Locking cells in a worksheet
- Locking the workbook
Advanced data formatting and use of references
- Custom data formatting
- Types and use of references in formulas
- Named cells
- Data parsing
Functions
- Tools for working with formulas
- Statistical functions (Sum, SumIF, Sum Ifs, Count, Countifs…)
- Mathematical functions (Round, Ceiling, Floor, Mod….)
- Date functions (Eomonth, Edate, Workday, Weekday, Datedif…)
- Logical functions (If, Iferror, Or, And, Not…)
- Text functions (Left, Len, Find, Mid, Replace, Trim, Search…)
Tools for data display and validation
- Sorting data
- Filtering data
- Filtering data with the Advanced filter option
- Conditional formatting
- Writing custom functions for more complex data formatting
- Built-in data validation options
- Writing custom functions for data validation
Data analysis tools
- Creating subtotals
- What-if analysis
- Pivot tables
- Working with charts
- Data model basics
Macros
- Recorded macros
- Relative and absolute positioning
Special discount for participants!
IT Centar wants to provide participants with comprehensive knowledge that will make them more competitive in the job market, and that is why we want to reward your effort and dedication.
All participants who complete the Advanced Excel course receive a voucher with a 25% discount that can be used for further education at IT Centar.
This is your space to grow, not just a starting point.
That is why we choose to invest together with you in your knowledge and your future.
