/

Microsoft Excel 2010 Advanced

(5.0)1 review
Recent reviews of this course provider

Very Good Course

Really good and thorough course. It moved at a good pace and covered many aspect...more

See all reviews
Add to shortlist

https://www.hotcourses.com/courses-by-subject/Microsoft-Excel-2010-Advanced-courses/55411306/

Course description

Microsoft Excel 2010 Advanced:

Who is this course for?

With basic skills and some experience of Microsoft Excel, the topics covered on this course will enable you to further enhance your spreadsheets and to use some of the more advanced features to streamline your work

Content

Advanced Spreadsheets

Working with range names.

Working with and consolidating multiple sheets.

Further use of Excel functions such as conditional IF and Lookup.

Working with Text

Text Functions and Text Import.

Graphs and Charts

Different graph styles, creating, enhancing and editing graph.

Printing independently or as part of the spreadsheet.

Database Functions

Creating Excel databases.

Accessing data by sorting and filtering data.

Producing summary statistics.

Cross tabulation using Pivot tables.

Specific database functions.

Introducing Macros

Recording commands in macros to simplify routines.

Editing macros and assigning to objects.

Object Linking & Embedding

Embedded Objects and Linking Objects.

Security Features

Protecting Files.

Protecting Cells.

Protecting Worksheets.

Protecting Workbooks.

What-If Analysis

Goal Seek and Solver.

Scenarios.

Data tables.

Additional Topics

Other topics of interest will be covered when you are comfortable with the core elements of the course, where time allows.

Additional entry requirements

It is assumed only that you have a skill level equivalent to that gained through attending the Excel Intermediate Course.

Training for employers

This course has been specifically designed for companies training their employees.

Course info

Location:

Altrincham, WA14 1TD, Nottingham, NG13 8PF, Can be taught anywhere in Central England, North West England, Yorkshire And Humberside

Time:

During the day or In the evening

Duration:

By arrangement

Attendance:

Customised to suit your needs

Qualification:

Certificate of Attendance

Level:

BeginnerIntermediate Advanced

From: £360

Summary of all course reviews for Vantage Training Ltd

1 review

(100%)

Average student ranking

Course reviews

This course currently has no reviews.

Write a review

Ask a question

Get course info
Next steps
Add to shortlist