Excel Data Analysis Training Course

Primary tabs

Course Language

This course is delivered in Polish or English.

Course Code

Duration Duration

14 hours (usually 2 days including breaks)

Requirements Requirements

Knowledge of Windows and MS Excel basics

Overview Overview

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

Guaranteed to run even with a single delegate!
Public Classroom Public Classroom
Participants from multiple organisations. Topics usually cannot be customised
From 1094PLN
(82)
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 1094PLN
Request quote
Private Remote Private Remote
The instructor and the participants are in two different physical locations and communicate via the Internet
From 2290PLN
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 1094PLN 1094PLN 2290PLN
2 847PLN 747PLN 1345PLN
3 765PLN 631PLN 1030PLN
4 724PLN 574PLN 873PLN
Cannot find a suitable date? Choose Your Course Date >>
Too expensive? Suggest your price

Related Categories


Course Discounts

Course Venue Course Date Course Price [Remote/Classroom]
Debian Administration Olsztyn, ul. Kajki 3/1 Mon, 2016-07-25 09:00 3157PLN / 2167PLN
Angular JavaScript Gdańsk, ul. Powstańców Warszawskich 45 Tue, 2016-07-26 09:00 2235PLN / 1585PLN
Python Programming Warszawa, ul. Złota 3/11 Mon, 2016-08-01 09:00 5790PLN / 3753PLN
Data Analysis with Oracle 11g - workshop Warszawa, ul. Złota 3/11 Mon, 2016-08-01 09:00 4350PLN / 3012PLN
Data Science w biznesie Gdynia, ul. Ejsmonda 2 Mon, 2016-08-01 09:00 3731PLN / 3292PLN
Basics of C # language based on object model Wroclaw, ul.Ludwika Rydygiera 2a/22 Mon, 2016-08-01 09:00 6158PLN / 4543PLN
Web Application Development in PHP Warszawa, ul. Złota 3/11 Wed, 2016-08-03 09:00 2688PLN / 2022PLN
Oracle 11g - Programming with PL / SQL II Kraków, ul. Rzemieślnicza 1 Mon, 2016-08-08 09:00 2363PLN / 1968PLN
Zapewnienie jakości oprogramowania – przegląd metodyk Warszawa, ul. Złota 3/11 Tue, 2016-08-09 09:00 2735PLN / 1863PLN
Python Programming Gdańsk, ul. Powstańców Warszawskich 45 Tue, 2016-08-09 09:00 5790PLN / 3908PLN
Programowanie w języku C# Poznan, Garbary 100/63 Tue, 2016-08-09 09:00 2188PLN / 1475PLN
Programming in WPF 4.5 Gdynia, ul. Ejsmonda 2 Wed, 2016-08-10 09:00 2409PLN / 1815PLN
Oracle 11g - Programming with PL / SQL II Wroclaw, ul.Ludwika Rydygiera 2a/22 Wed, 2016-08-10 09:00 2363PLN / 1785PLN
Team Building and Management Rzeszów, Plac Wolności 13 Tue, 2016-08-16 09:00 2124PLN / 1287PLN
Stress management Warszawa, ul. Złota 3/11 Thu, 2016-08-18 09:00 2112PLN / 1212PLN
PowerShell Master Class Gdańsk, ul. Powstańców Warszawskich 45 Mon, 2016-08-22 09:00 2547PLN / 1701PLN
Effective working with spreadsheet in Excel Gdańsk, ul. Powstańców Warszawskich 45 Mon, 2016-08-22 09:00 768PLN / 652PLN
Java Performance Gdynia, ul. Ejsmonda 2 Mon, 2016-08-22 09:00 4400PLN / 2917PLN
Java Spring Kraków, ul. Rzemieślnicza 1 Mon, 2016-08-29 09:00 7039PLN / 5245PLN
Java Spring Szczecin, ul. Małopolska 23 Mon, 2016-09-05 09:00 7039PLN / 5044PLN
Programming in WPF 4.5 Warszawa, ul. Złota 3/11 Mon, 2016-09-05 09:00 2809PLN / 1805PLN
Building Web Apps using the MEAN stack Szczecin, ul. Małopolska 23 Mon, 2016-09-12 09:00 4788PLN / 3124PLN
Java Spring Gdańsk, ul. Powstańców Warszawskich 45 Mon, 2016-09-12 09:00 7039PLN / 5153PLN
Java Spring Poznan, Garbary 100/63 Mon, 2016-09-12 09:00 7039PLN / 4961PLN
Java Spring Wroclaw, ul.Ludwika Rydygiera 2a/22 Mon, 2016-09-19 09:00 7039PLN / 4961PLN
Java Performance Gdynia, ul. Ejsmonda 2 Mon, 2016-09-19 09:00 4150PLN / 2866PLN
Java Spring Warszawa, ul. Złota 3/11 Mon, 2016-09-19 09:00 7039PLN / 4961PLN
BPMN 2.0 for Business Analysts Wroclaw, ul.Ludwika Rydygiera 2a/22 Tue, 2016-09-27 09:00 3110PLN / 2337PLN
Visual Basic for Applications (VBA) in Excel - Advanced Wroclaw, ul.Ludwika Rydygiera 2a/22 Mon, 2016-10-10 09:00 1689PLN / 1296PLN
ITIL® Foundation Certificate in IT Service Management Warszawa, ul. Złota 3/11 Mon, 2016-10-10 09:00 2639PLN / 2076PLN
Visual Basic for Applications (VBA) in Excel - Advanced Białystok, ul. Malmeda 1 Mon, 2016-11-14 09:00 1689PLN / 1413PLN

Upcoming Courses

VenueCourse DateCourse Price [Remote/Classroom]
Opole, Wladyslawa Reymonta 29Mon, 2016-08-08 09:00873PLN / 767PLN
Tarnów ul. Kościuszki 10 Tue, 2016-08-09 09:00873PLN / 710PLN
Kielce, ul. Warszawska 19Thu, 2016-08-11 09:00873PLN / 710PLN
Bydgoszcz, ul. Dworcowa 94Thu, 2016-08-11 09:00873PLN / 644PLN
Lublin, ul. Spadochroniarzy 9Wed, 2016-08-17 09:00873PLN / 710PLN

Some of our clients