Management Training
Intermediate Excel
Description
Following on from the Beginner’s Excel course, this intermediate course will continue to develop and expand your skills in using Microsoft Excel. This course will teach more powerful features like creating forms and creating and formatting charts.
Progression routes are available and all individuals who wish to increase their Microsoft Excel knowledge may wish to take the Advanced Excel course.
Course Duration
1 day.
Location
Neath College.
Who Should Attend?
There are no entry requirements yet it is recommended you have taken the beginners course or have basic knowledge and experience of using Microsoft Excel.
Method of Assessment
Internally assessed via controlled tasks.
Certification
College certificate and Agored Cymru accreditation.
Entry Requirements
There are no entry requirements yet it is recommended you have taken the beginners and intermediate course or have a good understanding of using Microsoft Excel.
Course Content
This course covers the following topics:
- Learn how to use formulas and functions
- Explore the various user interface elements
- Use the Microsoft Excel galleries
- Customise the interface
- Creating forms with Microsoft Excel
- Replicate forumulas and functions
- Create an absolute reference
- Range names and how they are applied
- Using freeze panes
- Recording the current date and time on the printed spreadsheet
- Turning your figures into charts
- Formatting charts
Course Cost
This course is £100 per person. Funding is available subject to eligibility
