MS Excel - basic level | COMARCH SA

Remote and stationary training options

What will you gain from the training?

Training objectives and skills

After completing the course, participants will know how to:

perform basic operations on copying and pasting data
protect cells, sheets and workbooks
use data filter and subtotals
use advanced filter
perform operations on dates and hours
use text conversion functions
use logical functions with multiplied conditions
insert data from other applications

Is this training for you?

Audience profile

The training is intended for people who are just starting to work with MS Excel.

Requirements

Basic knowledge of the Windows environment is required from the training participants

Duration

Duration:

2 days, 16 hours

Detailed training program

Detailed training program

Data management

Sheets management (naming, copying, colour change)
Efficient data entering
Efficient selecting
Go To and Go To Special tools
Sorting data
Custom lists
Autofilter and Advanced filter
Advanced operations on copying and pasting data

Adjustment of the working environment

Hotkeys, facilities
Create and modify toolbars
Excel Options (autosave, input, calculations, etc.)

Formatting

Cell styles
Format painter
Number formats

Functions

Subtotals function and subtotal tool
Statistical functions (average, maximum, minimum and quantity)
Text conversion functions
Date and time functions
Sheet inspection

Tables and list management

Using names of cells and ranges
Format as Table

Conditional functions

IF
Logical functions
Informational functions
Avoiding errors
Other conditional functions (countif, sumif and others)
Creation of complex / multiple formulas

Consolidation of data

Getting external data (CSV, TXT, Access)
Data consolidation functions and tools

Review

Collaboration
Tracking changes
Comments

Protection

Protect worksheet and workbook
Secure and encrypt files

Training delivery method

The training is carried out in the form of theoretical part in the form of mini lectures and the practical part in the form of computer exercises.