Course Overview
This two-day Microsoft Excel 2019 course will give you a deep dive into how to quickly and efficiently analyze your data in Excel. You will be surprised at how your current workflows will be streamlined after attending this training. Excel 2019 offers a variety of highly specialized features for analyzing large amounts of data both mathematically and through visualization. In addition to these functions that analyze collected data, you will also learn forecasting and optimization techniques.
Who should attend
Controller, clerk, sales employee, logistics employee
Prerequisites
Good knowledge of Windows and experience with Excel 2019
Course Content
- Evaluate data in pivot tables
- Use recommended pivot tables
- Create pivot tables from Excel data
- Change calculation function in the value range
- Predefined report layouts and formats
- Filtering data in the pivot table
- Use data slices
- Create pivot tables from external data sources
- Consolidate tables into pivot tables
- Arrange, add and delete fields
- Group data individually
- Special display options
- The PIVOT DATA ASSIGNMENT function
- Graphing Pivot Tables - PivotChart
- Trend analysis, data tables and target value search
- Use of the solver
- Constraints
- Minimum or maximum target value
- Solver models
- Solver reports
- Inserting Office Apps (Solver)
- Scenario Manager
- Primary and secondary axes
- Error indicators
- Draw trend lines
- Regression and compensation curves
This text was automatically translated. Please click here to read the original German version.