Excel Data Analysis Training Course

Primary tabs

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

Guaranteed to run even with a single delegate!
Public Classroom Public Classroom
Participants from multiple organisations. Topics usually cannot be customised
From £2150
(51)
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


Upcoming Courses

VenueCourse DateCourse Price [Remote / Classroom]
London, BarbicanWed, 2016-12-28 09:30£1850 / £2450
Coventry - The QuadrantWed, 2016-12-28 09:30£1850 / £2350
Plymouth Drake CircusTue, 2017-01-03 09:30£1850 / £2150
OxfordThu, 2017-01-12 09:30£1850 / £2500
Exeter - The SenateMon, 2017-01-16 09:30£1850 / £2450

Course Discounts

Course Venue Course Date Course Price [Remote / Classroom]
Applied Machine Learning London, Barbican Thu, 2017-03-30 09:30 £1782 / £2382

Course Discounts Newsletter

We respect the privacy of your email address. We will not pass on or sell your address to others.
You can always change your preferences or unsubscribe completely.

Some of our clients