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:

• 2 days, 16 hours

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.

DOWNLOAD FILE