MS Excel basics

Course objectives

Understanding the basic functionality of MS Excel. Learning effective working in basic cases, effective use of program tools.

Benefits

Workshop participants will learn:

Basic organizations working in the program
The necessary functions needed for daily work
Practical shortcuts to accelerate the work

Students will gain detailed knowledge to:

Graphical presentation of data in the program
Creating tables and filtration of data
To identify areas of work

Training scope

The interface of Excel. Entering content
Basic operations on cells and formatting
Working with worksheets
Formula
Conditional formatting (color scale)
Naming cells and ranges
Data sorting and filters
Subtotals – summing up data by categories
Basic data validation (selection from drop-down lists)
Tracking dependencies
Working with charts
Printing and its options
Managing workbooks

Audience

The training is addressed to people who will use MS Excel to accelerate and streamline daily work, or want to know which tool is needed for the majority of jobs office.

Course objectives

Understanding the basic functionality of MS Excel. Learning effective working in basic cases, effective use of program tools.

Benefits

Workshop participants will learn:

Basic organizations working in the program
The necessary functions needed for daily work
Practical shortcuts to accelerate the work

Students will gain detailed knowledge to:

Graphical presentation of data in the program
Creating tables and filtration of data
To identify areas of work

Training scope

The interface of Excel. Entering content
Basic operations on cells and formatting
Working with worksheets
Formula
Conditional formatting (color scale)
Naming cells and ranges
Data sorting and filters
Subtotals – summing up data by categories
Basic data validation (selection from drop-down lists)
Tracking dependencies
Working with charts
Printing and its options
Managing workbooks

Audience

The training is addressed to people who will use MS Excel to accelerate and streamline daily work, or want to know which tool is needed for the majority of jobs office.

Course form

Mix of presentation, hands-on exercises.

Download materials

Download

First name*

Surname*

E-mail*

I consent to the processing of my personal data by Sii sp. z o.o. and its subsidiaries for the purpose of sending marketing information to the provided e-mail address.

At any time, you may withdraw your consent to the processing of personal data, but such withdrawal shall not affect the legal compliance of any processing of such data, which had occurred before you withdrew your consent. Detailed information on the processing of your personal data is specified in the Privacy Policy.

Thank You!

Sorry, something went wrong.

Please refresh the page and try again.

File upload error

No file was uploaded

Incorrect file size (max 5MB)

Invalid file format

Empty file

Processing...

Download materials

Download

Contact our experts with questions about any of our trainings

Natalia & Agata

Training Practice Team

Contact our experts

Natalia & Agata

First name*

Surname*

E-mail*

Phone number

Company name

Job position

Your message*

Your file

Uploaded file:

danieltroc.pdf

Allowed extensions: DOC, DOCX, PDF (max 5MB)

I consent to the processing of my personal data by Sii sp. z o.o. and its subsidiaries for the purpose of sending marketing information to the provided e-mail address. I consent to the processing of my personal data by Sii sp. z o.o. and its subsidiaries for recruitment purposes.