COMPUTERS - EXCEL - ADVANCED
Starting dates and places
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…
Frequently asked questions
There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.
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
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.