Feedback

Feedback to trainingforit.co.uk


Site comment Site ratings
Email (optional)

Content

Design

Ease of use

Overall

Advanced Microsoft Excel

Summary
Length:
2 days
Price:
450 GBP excl. VAT
Training Provider:
Aspect TrainingAspect Training
Location:
Training Method:

Description of Advanced Microsoft Excel

This course was designed for students desiring to gain the skills necessary to create macros, collaborate with others, audit and analyze worksheet data, incorporate multiple data sources, and import and export data.

After Aspect’s Advanced Excel training you're likely to walk away with countless ideas for streamlining your daily activities and enhancing the usefulness of your data. On this course , you'll scratch the surface of one of Excel's most ingenious capabilities that has the potential to revolutionize the way you conduct your tasks - the Excel web query.

In addition, the course is also for students desiring to prepare for the Microsoft Certified Application Specialist exam in Microsoft® Office Excel® 2007, and who already have knowledge of the basics of Excel, including how to create, edit, format, and print worksheets that include charts and sorted and filtered data.

Aspect Training’s Excel Advance course will have you creating your own data powerhouses with just a few clicks. Most people are surprised at how much power Excel has to offer after taking Aspect Training’s Excel Advance course. Book a place for yourself and see how Aspect Training’s Excel Advance course can completely change the way you do business.

Application and qualification

Delegates should have attended both of the following courses (or similar) prior to this course:

» Aspect’s Excel Introduction

» Aspect’s Excel Intermediate

Course Overview

Streamlining Workflow
Create a Macro
Edit a Macro
Apply Conditional Formatting
Add Data Validation Criteria
Update a Workbook's Properties
Modify Excel's Default Settings

Collaborating with Others
Protect Files
Share a Workbook
Set Revision Tracking
Review Tracked Revisions
Merge Workbooks
Administer Digital Signatures
Restrict Document Access

Auditing Worksheets
Trace Cells
Troubleshoot Errors in Formulas
Troubleshoot Invalid Data and Formulas
Watch and Evaluate Formulas
Create a Data List Outline

Analyzing Data
Create a Trendline
Create Scenarios
Perform What-If Analysis
Perform Statistical Analysis with the Analysis ToolPak

Working with Multiple Workbooks
Create a Workspace
Consolidate Data
Link Cells in Different Workbooks
Edit Links

Importing and Exporting Data
Export Excel Data
Import a Delimited Text File

Using Excel with the Web
Publish a Worksheet to the Web
Import Data from the Web
Create a Web Query

Structuring Workbooks with XML
Develop XML Maps
Import and Export XML Data

Expenses

Onsite prices from £300 (+VAT) per day

Description of Aspect Training

Our company, Aspect Training is based in New Malden Surrey and offers a wide range of open IT Training, Management and Personal Skills training. Aspect Training's courses are delivered by experienced trainers at very competitive rates at our premises, or we can present any course on your site all for a straight forward daily rate.

The company was formed by professional trainers all having a large number of years experience presenting and using the very software or business skills they train in.

It is Aspect Training's policy never to train more than eight participants on a course, so each participant can be sure of ample opportunity to ask questions during the course.

Our public course prices include training for up to 8 participants presented by one of our own trainers.

Whether scheduled or on your site, each participant will receive high quality course material to keep and help them build on the skills learnt on the training course.

Find out more about Aspect Training and how their courses can help you here.


Show all courses with Aspect Training

Request information - obligation free

When filling out this form on trainingforit.co.uk, your contact information will be sent to the school you are interested in. The school will then contact you and provide you with further information through email, telephone or regular mail.
To order information from Aspect Training, please fill out the following information:
* =  Required field
Email Address*
First Name*
Last Name*
Company
Position
Town/City*
Telephone*
Message

Contact information for Aspect Training

Aspect Training

20 Coombe Road, New Malden
KT3 4QE Surrey

Phone no: 0208 942 5724
www.aspecttraining.co.uk

Keywords

microsoft excel, advanced excel, excel spreadsheets, spreadsheet training

More Information
Request Information
To order information from Advanced Microsoft Excel, please fill out the following information:

What happens now?
Question of the month
Are you working in the right industry?
Yes, definitely!
Maybe, Maybe not!
No, not really

Answer to see result
Your right to request 'Time to Train'

time to train, training, courses, employment law

Looking for training, or a course to improve your skills?

The new law 'Time to Train', gives employees the legal right to request time off work for training, and to take courses.

Good news for everybody! Learn more.

If you require help finding the right course for you - we can assist you - contact us.

Write a review
Have you studied » Advanced Microsoft Excel at » Aspect Training? What did you think? By sharing your experiences you could help others to pick the right education. Set grades (1-5) where 1 is very poor and 5 is excellent.
Very poor | Poor | Ok | Good | Very good
Teacher / Teaching
Location / Facilities
Literature
Exchange with other students

Do you recommend the school:


Tell a friend

Tell a friend about the education Advanced Microsoft Excel at Aspect Training.

To:  
From: