Excel Data Analysis Training Course

Primary tabs

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 £2150
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 £1850
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 £2150 £1850
2 £1285 £1120
3 £997 £877
4 £853 £755
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]
RabbitMQ London, Barbican Mon, 2016-11-07 09:30 £1832 / £2432
MariaDB Database Administration Bristol, Temple Gate Wed, 2016-11-09 09:30 £1733 / £2333
MongoDB for Administrators London, Barbican Mon, 2016-11-14 09:30 N/A / £2432
MongoDB for Advanced Users Birmingham Wed, 2016-11-16 09:30 £1733 / £2358
Big Data Architect London, Barbican Mon, 2016-11-21 09:30 £4406 / £5756

Upcoming Courses

VenueCourse DateCourse Price [Remote/Classroom]
London, BarbicanWed, 2016-11-09 09:30£1850 / £2450
Belfast City CentreThu, 2016-11-10 09:30£1850 / £2350
Plymouth Drake CircusMon, 2016-11-14 09:30£1850 / £2150
OxfordMon, 2016-12-05 09:30£1850 / £2500
Exeter - The SenateTue, 2016-12-06 09:30£1850 / £2450

Some of our clients