Technologies / Office Applications and Tools

Microsoft Excel - Advanced Tools

Learn advanced Excel tools. Master addressing, advanced formulas, data analysis, and chart creation. Ideal for advanced users.

Why choose this training?

Growing market demands mean that, technical competencies have become a critical asset. Learn advanced Excel tools. Master addressing, advanced formulas, data analysis, and chart creation. Ideal for advanced users.

This training delivers comprehensive knowledge in technology, enabling participants to immediately apply acquired skills in their professional work.

What makes our approach unique?

EITT combines theoretical knowledge with intensive practical workshops. Over 3 days of intensive training, participants work on real-world examples and scenarios, ensuring not only theoretical understanding but practical application skills.

With over 2,500 trainings in our portfolio, EITT is a trusted partner in IT competency development for organizations of all sizes. Our trainers are experienced practitioners who share up-to-date knowledge and proven solutions.

Looking for training tailored to your team’s needs? Contact us — we’ll prepare a program customized to your requirements.

Training program

Setting application options
File save formats

Relative, absolute and mixed references
Assigning names to cell ranges
Reference styles
3-D references (between worksheets)

Principles of using built-in functions
Nesting functions
Overview of the most useful functions (VLOOKUP, INDEX, MATCH, IFERROR)
Array functions

Data validation
Custom and conditional formatting
Auto outline and data grouping
Sort options and advanced filter
The Text to Columns tool
The Table object

Subtotals and consolidation
Goal Seek and Scenario Manager

Creating a PivotTable — data sources
Modifying the layout, grouping and sorting
Table and field options, calculated fields
PivotCharts

Importing text files
Database and web queries

Formatting chart elements
Custom charts and templates
Trendlines and forecasting
In-cell charts (sparklines)

Protecting the file, workbook and cells

Choosing where to store a macro
Changing recording options, running macros
Macro security levels

Delivery Methods

Online

Convenience of participating from anywhere
Interactive live sessions with trainer
Materials available for 30 days
No travel costs

On-site

Direct contact with trainer and group
Intensive hands-on workshops
Networking with other participants
Full focus on learning

Frequently asked questions

What are the prerequisites for this training?

The Microsoft Excel - Advanced Tools (Remote Training) training does not require specialized prior knowledge. Basic IT knowledge is sufficient.

What is the format and duration of this training?

The training lasts 3 days and is available in online and on-site format. Sessions run from 9:00 AM to 4:00 PM. We can also customize the schedule to fit your team's needs.