Technologies

Microsoft Excel - Effective calculations and data presentations

Learn effective calculations and data presentation in Excel. Learn advanced formulas, data analysis, charting and formatting. Ideal for intermediate level Excel users.

Why choose this training?

Effective use of modern tools and methodologies, technical competencies have become a critical asset. Learn effective calculations and data presentation in Excel. Learn advanced formulas, data analysis, charting and formatting. Ideal for intermediate level Excel users.

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

What makes our approach unique?

The EITT approach is based on hands-on experience and practical exercises. Over 2 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 and a 4.8/5 participant rating, 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

elements of the program window
saving the file - saving formats
view settings

Correctly enter and edit text, numeric and date data
copying and transferring data
filling cells with series of data

marking the elements of the sheet and notebook
adding and deleting sheets
copying sheets
hiding and revealing sheets
viewing the contents of the sheets - division into sub-windows, blocking of rows and columns

change font and cell color
text alignment options
cell borders and shading
formatting of date numbers and text
use of table styles
use of the Format Painter
adding and editing comments

syntax of formulas and functions
autofilling and copying formulas
use of basic MS Excel functions
inserting functions using the wizard
addressing modes

basic principles of working with data lists
sorting
Data filtering - Autofilter tool.

creation of charts of various types
modifying charts

previewing and printing the contents of the sheet
setting the print area
creating a header and footer
formatting and dividing pages for printing
page settings and preparing the document for printing

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 - Effective calculations and data presentations training does not require specialized prior knowledge. Basic IT knowledge is sufficient.

What is the format and duration of this training?

The training lasts 2 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.