Microsoft Excel 2019 - Data Analysis (E19DAS)

 

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.

This text was automatically translated. Please click here to read the original German version.

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

Prices & Delivery methods

Online Training

Duration
2 days

Price
  • 890.— €

Courseware language: German

Classroom Training

Duration
2 days

Price
  • Germany: 890.— €
  • Switzerland: CHF 1,130.—

Courseware language: German

Currently there are no training dates scheduled for this course.