Course objectives

Skills in data processing, filtering, and analysis. Understanding of effective methods of working with MS Excel.

Benefits

Workshop participants will learn:

• Basic concepts of working in MS Excel
• Tools to support reporting
• Advanced data filtering

Students will gain detailed knowledge to:

• Pivot tables
• Subtotals
• Content management

Training scope

• Repetition of the basics of Excel
• Formula
• Conditional Formatting
• Forms
• Tracking dependencies
• Sorting data and filters
• Subtotals
• Basic data validation (selection from drop-down lists)
• Work with charts
• Printing and its options
• Management Workbooks
• Pivot Tables and Pivot Charts
• Data Management

Audience

People using the primary means of MS Excel. People who start to work on the preparation of reports and analysis based on MS Excel.