COMPUTERS - EXCEL - ADVANCED

COMPUTERS - EXCEL - ADVANCED

Aspire Sussex
Logo Aspire Sussex
Provider rating: star_halfstar_borderstar_borderstar_borderstar_border 1 Aspire Sussex has an average rating of 1 (out of 1 reviews)

Need more information? Get more details on the site of the provider.

Starting dates and places

There are no known starting dates for this product.

Description

What is the course about?

Working with Advanced Formulas
Lookups and Data Tables
Advanced List Management
Working with Pivot Tables and Pivot Charts
Exporting and Importing Text Files
Using Analytical Options
Working with Macros

The content and outcomes of the course will be discussed with you and may be adapted to meet your needs and those of the group. As a guide, by the end of the course you should be able to:
Work with Advanced Formulas Using names and decision-making functions
Create nested functions and use financial functions
Work with lookup functions
Create data tables
Create subtotals and validate cell entries
Work with, formatting and rearranging PivotTables
Export and Import Piv…

Read the complete description

Frequently asked questions

There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.

What is the course about?

Working with Advanced Formulas
Lookups and Data Tables
Advanced List Management
Working with Pivot Tables and Pivot Charts
Exporting and Importing Text Files
Using Analytical Options
Working with Macros

The content and outcomes of the course will be discussed with you and may be adapted to meet your needs and those of the group. As a guide, by the end of the course you should be able to:
Work with Advanced Formulas Using names and decision-making functions
Create nested functions and use financial functions
Work with lookup functions
Create data tables
Create subtotals and validate cell entries
Work with, formatting and rearranging PivotTables
Export and Import Pivot Charts and text files
Use Analytical Options working with Goal Seek and Solver and with Scenarios and Views
Run and record macros, view VBA code and use function procedures

Who is the course for?

This is designed as an intensive course and it is therefore essential that students have completed the Excel Intermediate course or have a good working knowledge of Microsoft Excel.

What is your approach?

There will be a combination of lectures, demonstrations, discussions and practical exercises on all topics covered on the course.

You will have an opportunity to maintain an Individual Learning Record and your tutor will discuss your progress and achievement with you throughout the course.

What can I do next?

If you would like more information about progression opportunities, please speak to your tutor or other member of staff.
Further information about career opportunities can be found by visiting https://nationalcareersservice.direct.gov.uk
All Aspire Sussex dedicated Adult Education centres have Windows 7 and Microsoft Office 2010 installed on all computers.
If it is important for you to be using a particular version of software on your computer you must check with the centre at the time of booking your course, that the version you wish to learn is used on the course you are joining.
Use of removable Computer media
A number of Adult Education courses make use of computers and they allow for the use of removable media either provided as part of the course or brought in by students or tutors. This media may include CDs, DVDs, USB memory sticks or digital camera memory cards. Although virus checkers are used on all course PCs there is always the possibility of virus infection owing to

What will I need?

Students do not need to bring anything specific as handouts are provided but it is advisable to have a notebook and pencil.
If it is a Saturday school you will need to bring a packed lunch and a drink.
Are there any other costs?
None

There are no reviews yet.

Share your review

Do you have experience with this course? Submit your review and help other people make the right choice. As a thank you for your effort we will donate £1.- to Stichting Edukans.

There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.