Microsoft Excel XP Level 3 |
|
| |
|
Overview
This course introduces
you to more advanced data analysis tools and database management
features. Requirements
You should be using Excel
as a spreadsheet and database. You should understand the differences
between relative and absolute referencing.
If you are unfamiliar with these topics, you may be interested
in our Excel Level 2 course.
Prerequisites
You should be confident, and have a reasonable understanding and knowledge of all the topics covered in our Excel level 1 and level 2 courses.
Objective
To understand how Pivot tables work. To understand how to analyse data in different
ways. To be able to create and modify a Pivot Table. To be able to create different formula for
analysing data.By the end of the course, you will have created
a Pivot table and will be able to audit and analyse data using
a variety of methods.
Platform PC Only | Duration 1 day
Price Per Course £195.00 ex VAT
Full payment must be received prior to the course commencing.
Course Outline
Database recap
• Validation in Excel
Advanced functionality
• Creating Pivot tables
• Modifying Pivot tables
Financial functions
• Data tables
• Goal seek
• Scenarios Importing data from the web (XML data)
• Using data from the web
• Using the VLOOKUP function |
To book this course, please use the online booking
form or telephone Business Development Team on 020 7241 7499
or email sales@theinnovatory.com |
|
|
|
