Show e-learning-courses.co.uk as: Mobile

Microsoft Excel 2007 Advanced Training Course

1Training
Course summary
49 GBP
English
Distance
Next available date: This course is available anytime in anywhere. - Distance
Last application: This course is available to register anytime of the year.
e-learning / Online / Distance

Course description

Microsoft Excel 2007 Advanced Training Course

The Microsoft Excel 2007 Advanced course combines the basic and intermediate aspects and gives learners insight on how to analyse and manage data. This course will teach learners how to explore data analysis tools which include goal seek, formula auditing and Scenario Manager. Getting certified in Microsoft Excel 2007 Advanced course will help individuals display their Microsoft skills in an office environment and showcase their competency in Excel.

The Microsoft Excel 2007 Advanced course will teach individuals how to use pivot charts and tables, record basic macros and, format, filter and manage data lists.

The Microsoft Excel 2007 Advanced course will give learners a basic understanding of data collection and functions and can expand their skills. You will be issued an internationally recognised qualification following full completion of Microsoft Excel 2007 Advanced course.

Suitability - Who should attend?

Who is this Course aimed at?

  • The course is aimed at individuals who have intermediate experience of Excel 2007.
  • Students wishing to expand their skills in Microsoft Office Excel 2007.
  • The course is ideal for individuals working in an office environment.
  • Anyone interested in developing their skills in Microsoft Office Excel 2007.

Entry Requirements

  • You must be 16 or over
  • You should have a basic understanding of English and basic IT knowledge
  • You will need a computer or tablet with internet connection (or access to one)

Outcome / Qualification etc.

Those who successfully complete the exam will be awarded the certificate in Microsoft Excel 2007 Advanced.

Training Course Content

Learning Outcomes

  • Learn how to audit formulas for errors
  • Learn how to use key advanced functions for financial, logical, text and maths
  • Learn how to analyse data using subtotals
  • Import and export data from workbook
  • Learn how to use custom and conditional formatting

Access Duration

The course will be directly delivered to you, and you have 12 months access to the online learning platform from the date you joined the course.  The course is self-paced and you can complete it in stages, revisiting the lectures at anytime.

Method of Assessment

At the end of the Microsoft Excel 2007 Advanced course you will be required to take a multiple choice question assessment test. The multiple choice question assessment will be automatically marked with learners receiving an instant grade.

Awarding Body

The certificate will be awarded by CPD and iAP. This internationally recognised qualification will make your CV standout and encourage employers to see your motivation at expanding your skills and knowledge in the IT enterprise.

Course Curriculum

➤ Module 1 - Advanced Functions

1.0 Topic A: Logical Functions

2.0 Topic B: Math and Statistical Functions

3.0 Topic C: Financial Functions

4.0 Topic D: Displaying/Printing Formulas

➤ Module 2 - Lookups and Data Tables

1.0 Topic A: Using Lookup Functions

2.0 Topic B: Using MATCH and INDEX

3.0 Topic C: Creating Data Tables

➤ Module 03 - Advanced List Management

1.0 Topic A: Validating Cell Entries

2.0 Topic B: Exploring Database Functions

➤ Module 4 - PivotTables and PivotCharts

1.0 Topic A: Working with PivotTables

2.0 Topic B: Rearranging PivotTables

3.0 Topic C: Formatting PivotTables

4.0 Topic D: PivotCharts

➤ Module 5 - Exporting and Importing

1.0 Topic A: Exporting and Importing Text Files

2.0 Topic B: Exporting and Importing XML Data

3.0 Topic C: Querying External Databases

➤ Module 6 - Analytical Options

1.0 Topic A: Goal Seek and Solver

2.0 Topic B: The Analysis ToolPak

3.0 Topic C: Scenarios

4.0 Topic D: Views

➤ Module 7 - Macros and Custom Functions

1.0 Topic A: Running and Recording a Macro

2.0 Topic B: Working with VBA Code

3.0 Topic C: Creating Functions

➤ Module 8 - Conditional Formatting, SmartArt

1.0 Topic A: Conditional Formatting with Graphics

2.0 Topic B: SmartArt Graphics

Expenses

Now £49

Was £299

About provider

1Training

1 Training - Together, shaping your future

1 Training has established an excellent reputation in the UK for providing professional and vocational training, aiming to train people (young people in particular) for the world of work. 1 Training aims to fill gaps in employment skills, whilst placing...


Read more and show all courses with this provider

Request info

Fill out your details to find out more about Microsoft Excel 2007 Advanced Training Course.

  Contact the provider

  Get more information

  Register your interest

Request Information

Find out more about this Microsoft Excel 2007 Advanced Training Course course - simply fill out your details: