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

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 900PLN
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.
Private Remote Private Remote
The instructor and the participants are in two different physical locations and communicate via the Internet
From 1500PLN
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 Remote
1 900PLN 1500PLN
2 750PLN 1050PLN
3 700PLN 900PLN
4 675PLN 825PLN
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]
Building Web Apps using the MEAN stack Kraków, ul. Rzemieślnicza 1 Mon, 2016-10-24 09:00 14652PLN / 6440PLN
ITIL® Foundation Certificate in IT Service Management Zielona Góra, ul. Reja 6 Mon, 2016-10-24 09:00 4554PLN / 2320PLN
Apache Tomcat and Java EE Administration Warszawa, ul. Złota 3/11 Mon, 2016-10-24 09:00 5178PLN / 1894PLN
Market Forecasting Kraków, ul. Rzemieślnicza 1 Tue, 2016-10-25 09:00 5742PLN / 2714PLN
A Practical Guide to Successful Pricing Strategies Poznan, Garbary 100/63 Wed, 2016-10-26 09:00 3366PLN / 1883PLN
Design Patterns in C# Bielsko-Biała, Al. Armii Krajowej 220 Wed, 2016-10-26 09:00 3861PLN / 2130PLN
Creating and delivering presentations in Power Point (social skills workshop) Poznan, Garbary 100/63 Thu, 2016-10-27 09:00 3346PLN / 1414PLN
Agile Project Management with Scrum Kraków, ul. Rzemieślnicza 1 Wed, 2016-11-02 09:00 3386PLN / 1929PLN
Understanding Windows Communication Foundation (WCF) Szczecin, ul. Małopolska 23 Wed, 2016-11-02 09:00 10266PLN / 3611PLN
Python Programming Szczecin, ul. Małopolska 23 Mon, 2016-11-07 09:00 N/A / 5434PLN
Agile Project Management with Scrum Poznan, Garbary 100/63 Mon, 2016-11-07 09:00 3386PLN / 1529PLN
Business Analysis, BABOK V3.0 and IIBA Certification Preparation Katowice ul. Opolska 22 Mon, 2016-11-07 09:00 9405PLN / 5753PLN
Adobe InDesign Lublin, ul. Spadochroniarzy 9 Mon, 2016-11-07 09:00 1881PLN / 1327PLN
Administration of Linux System Olsztyn, ul. Kajki 3/1 Tue, 2016-11-08 09:00 3861PLN / 1920PLN
SQL Fundamentals Warszawa, ul. Złota 3/11 Wed, 2016-11-09 09:00 3663PLN / 1510PLN
Adobe Illustrator Katowice ul. Opolska 22 Wed, 2016-11-09 09:00 2871PLN / 1848PLN
Excel For Statistical Data Analysis Warszawa, ul. Złota 3/11 Mon, 2016-11-14 09:00 2673PLN / 1291PLN
Visual Basic for Applications (VBA) in Excel - Advanced Białystok, ul. Malmeda 1 Mon, 2016-11-14 09:00 3455PLN / 2202PLN
Social Media - facebook, twitter, blog, youtube, google+ Gdynia, ul. Ejsmonda 2 Mon, 2016-11-14 09:00 1881PLN / 1102PLN
Apache Web Server Administration Kraków, ul. Rzemieślnicza 1 Tue, 2016-11-15 09:00 4732PLN / 3177PLN
SQL in MySQL Gdynia, ul. Ejsmonda 2 Thu, 2016-11-17 09:00 2851PLN / 1413PLN
OCUP2 UML 2.5 Certification - Intermediate Exam Preparation Wroclaw, ul.Ludwika Rydygiera 2a/22 Thu, 2016-11-17 09:00 5148PLN / 2175PLN
Creating and managing Web sites Kraków, ul. Rzemieślnicza 1 Mon, 2016-11-21 09:00 5841PLN / 3298PLN
Angular JavaScript Katowice ul. Opolska 22 Mon, 2016-11-21 09:00 5940PLN / 3380PLN
Agile w projektach zdalnych Katowice ul. Opolska 22 Tue, 2016-11-22 09:00 5049PLN / 1962PLN
Effective working with spreadsheet in Excel Rzeszów, Plac Wolności 13 Thu, 2016-11-24 09:00 PLN / 767PLN
Test Automation with Selenium Gdańsk, ul. Powstańców Warszawskich 45 Tue, 2016-12-06 09:00 7722PLN / 3624PLN
Graphic techniques (Adobe Photoshop, Adobe Illustrator) Wroclaw, ul.Ludwika Rydygiera 2a/22 Tue, 2016-12-06 09:00 4851PLN / 2740PLN
Docker and Kubernetes Gdańsk, ul. Powstańców Warszawskich 45 Wed, 2016-12-07 09:00 N/A / 4989PLN

Upcoming Courses

VenueCourse DateCourse Price [Remote/Classroom]
Warszawa, ul. Złota 3/11Mon, 2016-11-07 09:001500PLN / 900PLN
Szczecin, ul. Małopolska 23Tue, 2016-11-08 09:001500PLN / 1000PLN
Poznan, Garbary 100/63Tue, 2016-11-08 09:001500PLN / 900PLN
Częstochowa, ul. Wały Dwernickiego 117/121Tue, 2016-11-08 09:001500PLN / 1200PLN
Rzeszów, Plac Wolności 13Wed, 2016-11-09 09:001500PLN / 1200PLN

Some of our clients