Why you should take this training?

The training is designed to present tools that will allow effective data management in Microsoft Excel. The session will involve demonstrating the practical possibilities offered by spreadsheets in supporting the work of service and product sellers and analysts, which allow for quick and efficient preparation of calculations, predictions and analyses.

Who is it for?

The training is intended for those who have experience in working with Microsoft Excel. Those who want to consolidate their knowledge through practical examples. It is intended for employees who have access to sales data and whose job requires them to create data sets, analyse them, present them clearly and draw logical conclusions.

Having completed the training, participants will be able to:

1. Make creative calculations using selected logical, text, search as well as date and time functions,
2. Prepare easy-to-read reports using simulation analysis and analytical tools such as Scenario Manager, Goal Seek and Solver,
3. Create data graphics using pivot charts, dashboard elements as well as formatting and conditional formatting (value-based and function-based).

Agenda of the training:

I. Databases:

1. The concept of a database in Excel
2. Checking the correctness of data
3. Filtering data using the Autofilter tool
4. Advanced filter
5. Data sorting
6. Data grouping
7. Subtotals
8. Pivot table
9. Pivot table chart

II. Formulas and functions:

1. Relative and absolute cell addressing
2. Practical examples of functions
   1. Date and time
   2. Logical
   3. Text
   4. Lookup and reference
3. Editing functions
4. Errors
5. Formula inspection

III. Data analysis tools:

1. Scenarios
2. Report manager
3. Use of automated analysis tools
   1. Goal Seek...
   2. Solver
   3. Data analysis...

IV. Advanced formatting:

1. Conditional formatting
2. Custom data formats
3. Formatting and adjusting graphics
4. Dashboard elements