Skip to content
  1. IT

Microsoft Excel 2010 - Advanced
Aspyra Training

This course needs to be fully funded by either you or your employer.

Summary

Price
£240 VAT exempt
Finance options

Pay in full or by instalments.
Study method
Classroom
Duration
1 day · Part-time
Qualification
No formal qualification
Certificates
  • Certificate of completion - Free
Additional info
  • Tutor is available to students
19 students enquired about this course

Add to basket or enquire

Location & dates

Location

Address
46-48 Alfreton Road
NOTTINGHAM
Nottinghamshire
NG73NN
United Kingdom
View on Map

Overview

This course provides delegates with a comprehensive review of Microsoft Excel 2010 at advanced level. The course is therefore designed for those who want to become proficient in performing advanced tasks such as creating nested functions, working with data tables, exporting and importing data, performing what-if analyses, recording and running macros.

Certificates

Description

Course Code APR0190

This Microsoft Excel 2010 Advanced (Level 3) course is the last of a 3 level programme and is designed for Microsoft Excel 2010 spreadsheets users who want to maximise the full use of the software. Delegates will therefore extend the knowledge and skills they acquired from the Intermediate (Level 2) course and will Learn how to use the Advanced Features of Microsoft Excel. We will engage delegates in a range of activities associated with creating lookup functions, setting Excel Working Options, enhancing Charts, protecting Worksheet Data, performing Advanced Data Operations, Pivot Tables, consolidating data, Goal Seeking and Solver, and creating and using Macros. Upon completion of this course delegates will develop sufficient skills and knowledge in the following:

  • Using a variety of Lookup and reference functions
  • Modifying options in Microsoft Excel 2010
  • Customising and formatting charts
  • Creating and using labels and names in workbooks
  • Protecting data in workbooks and worksheets
  • Creating summaries and subtotals in worksheets
  • Using data linking techniques for creating efficient workbooks
  • Consolidating Data in Microsoft Excel 2010
  • Constructing and Operating Pivot Tables using Microsoft Excel advanced techniques
  • Understanding and Creating PivotTable Reports
  • Creating and Editing Pivot Charts
  • Understanding and Using Goal Seeking for determining values in order to achieve results
  • Solving complex and intricate problems in Microsoft Excel 2010
  • Creating Recorded Macros in Microsoft Excel 2010
  • Creating a variety of Macros

Direct Delivery

Direct delivery via tutor-led training session, offering you interactive training in a small classroom setting. Packed with exercises and hands-on experiences, this course enables you to apply what you have learnt back in the workplace and professionally.

Who is this course for?

This course is for you if you have some knowledge and experience of using the Microsoft Excel 2010 software or have completed the Microsoft Excel 2010 course up to Intermediate Level and want to progress further by extending your knowledge and skills and maximise the full benefit of the Microsoft 2010 Excel software.

Requirements

This course assumes that you have some knowledge and experience of using the Microsoft Excel 2010 software or have completed the Microsoft Excel 2010 - Beginner and Intermediate courses. A general understanding of personal computers and the Windows operating system environment would also be beneficial.

Career path

The natural progression is ECDL Excel Advanced; Microsoft Excel 2010 VBA Programming.

Questions and answers

Reviews

Currently there are no reviews for this course. Be the first to leave a review.

Leave a review

Legal information

This course is advertised on Reed.co.uk by the Course Provider, whose terms and conditions apply. Purchases are made directly from the Course Provider, and as such, content and materials are supplied by the Course Provider directly. Reed is acting as agent and not reseller in relation to this course. Reed's only responsibility is to facilitate your payment for the course. It is your responsibility to review and agree to the Course Provider's terms and conditions and satisfy yourself as to the suitability of the course you intend to purchase. Reed will not have any responsibility for the content of the course and/or associated materials.

FAQs

Study method describes the format in which the course will be delivered. At Reed Courses, courses are delivered in a number of ways, including online courses, where the course content can be accessed online remotely, and classroom courses, where courses are delivered in person at a classroom venue.

CPD stands for Continuing Professional Development. If you work in certain professions or for certain companies, your employer may require you to complete a number of CPD hours or points, per year. You can find a range of CPD courses on Reed Courses, many of which can be completed online.

A regulated qualification is delivered by a learning institution which is regulated by a government body. In England, the government body which regulates courses is Ofqual. Ofqual regulated qualifications sit on the Regulated Qualifications Framework (RQF), which can help students understand how different qualifications in different fields compare to each other. The framework also helps students to understand what qualifications they need to progress towards a higher learning goal, such as a university degree or equivalent higher education award.

An endorsed course is a skills based course which has been checked over and approved by an independent awarding body. Endorsed courses are not regulated so do not result in a qualification - however, the student can usually purchase a certificate showing the awarding body's logo if they wish. Certain awarding bodies - such as Quality Licence Scheme and TQUK - have developed endorsement schemes as a way to help students select the best skills based courses for them.
View all
Similar subjects: IT, Microsoft Excel, Microsoft, Office skills