COMPUTERS - EXCEL - INTERMEDIATE
COMPUTERS - EXCEL - INTERMEDIATE
Provider rating:
Starting dates and places
Description
What is the course about?
Automating Excel – custom number and text formats, using find
and replace
Using Workbooks – Working with multiple worksheets
Charts – Chart formatting features, moving a chart to Word
Chart Views and Protection
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:
Carry totals over to a summary sheet
Enter data into a cell and customise for number/word format/ Use
autofill to complete sequences.
Enter formulas (addition, subtraction, multiplication, subtraction
& calculation) using the correct syntax and operators.
Edit data via the …
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?
Automating Excel – custom number and text formats, using find
and replace
Using Workbooks – Working with multiple worksheets
Charts – Chart formatting features, moving a chart to Word
Chart Views and Protection
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:
Carry totals over to a summary sheet
Enter data into a cell and customise for number/word format/ Use
autofill to complete sequences.
Enter formulas (addition, subtraction, multiplication, subtraction
& calculation) using the correct syntax and operators.
Edit data via the Formula Bar.
Use Freeze Panes to display headings when scrolling through a
sheet.
Use AutoFilter to select the required data.
Change your page orientation from portrait to landscape.
Insert Headers and Footers.
Set heading rows to repeat on each sheet.
Use Page Layout View to select the data displayed on each
sheet.
Who is the course for?
It is therefore essential that students already have completed
the Excel for Beginners course or have a basic 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.
Please bring a packed lunch and any snacks and cold drinks for the
day.
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.