Excel Data Analysis Training Course

Primary tabs

Course Language

This course is delivered in German or English.

Course Code

exceldataanal

Duration Duration

14 hours (usually 2 days including breaks)

Requirements Requirements

Knowledge of Windows and MS Excel basics

Course Outline Course Outline

Knowledge of Windows and MS Excel basics

  • Excel Data Types
  • Look up values ​​in a spreadsheet
  • Naming the range, create a range of labels
  • Modifying named ranges
  • Create custom number formats
  • Use AutoFormat options in a spreadsheet
  • Create a named style
  • Creating a user template
  • Protection sheets

Organizing data in a worksheet

  • Create a list of data
  • Adding to the list of series
  • Creating a custom sort lists
  • Consolidate data
  • Create conspect

Processing of data in a spreadsheet

  • Apply conditional formatting
  • Summarizing data with subtotals
  • Filter the list of data
  • Create a custom filter
  • Create an advanced filter
  • Create scenarios
  • Data Validation

Creating formulas

  • Aggregation of cell contents using the AutoSum
  • Adding in the dialog window
  • Insert Function
  • Editing formulas
  • Evaluate Formula
  • Using Solver tool to obtain specific values ​​of the arguments
  • Create a conditional formula
  • Using the data table to solve the formulas
  • Tracking error performance formulas
  • Look up values ​​in a particular row or column
  • Determine the value location 
  • Returning values ​​from a cell in a specific location in the data list
  • Positioning of the data list
  • Create a table of credit

The processing of information from external data sources

  • Combining data from other Windows programs
  • Importing a delimited text file
  • Dividing a column of data into multiple columns
  • Create a Web Query
  • Importing database table
  • Using queries to selectively retrieve information from external databases
  • Calculate the average of the values ​​stored in the database

Produce data charts

  • Changing the chart type
  • Creating a custom chart types
  • Adding a trendline to a chart
  • Adding new values ​​and change data for the chart
  • Create a combination chart

Using Pivot Table reports

  • Basic information about PivotTables
  • Overview of PivotTable fields.
  • Create a PivotTable report with a list of data
  • Change the layout of a PivotTable
  • Filtering fields
  • Changing the type of calculation data fields
  • Grouping PivotTable data elements
  • Entering additional calculations to the data area
  • Add a calculated field
  • Adding a calculated
  • Get values ​​from a PivotTable report

Creating a PivotChart

  • Performing the pivot of information from external database
  • Change the layout of a PivotChart
  • Changing a PivotChart
  • Filtering fields PivotChart
  • Grouping elements PivotChart field
  • Add a table of data to the PivotChart

Public Classroom Public Classroom
Participants from multiple organisations. Topics usually cannot be customised
From 1473EUR
(26)
Private Classroom Private Classroom
Participants are from one organisation only. No external participants are allowed. Usually customised to a specific group, course topics are agreed between the client and the trainer.
From 1473EUR
Request quote
Private Remote Private Remote
The instructor and the participants are in two different physical locations and communicate via the Internet
From 1430EUR
Request quote

The more delegates, the greater the savings per delegate. Table reflects price per delegate and is used for illustration purposes only, actual prices may differ.

Number of Delegates Public Classroom Private Classroom Private Remote
1 1473EUR 1473EUR 1430EUR
2 1062EUR 1037EUR 1015EUR
3 924EUR 891EUR 877EUR
4 856EUR 818EUR 808EUR
Cannot find a suitable date? Choose Your Course Date >>
Too expensive? Suggest your price

Related Categories


Course Discounts

Upcoming Courses

VenueCourse DateCourse Price [Remote/Classroom]
HannoverThu, 2016-10-27 09:301430EUR / 1930EUR
DresdenWed, 2016-11-09 09:301430EUR / 1930EUR
StuttgartWed, 2016-11-09 09:301430EUR / 1930EUR
BremenMon, 2016-11-14 09:301430EUR / 1930EUR
KölnMon, 2016-11-14 09:301430EUR / 1930EUR

Some of our clients