Courses / Excel - Intermediate
Excel - Intermediate
- Provider
- Desktop Training & Development Ltd
- Summary
- This course builds upon the basic knowledge of Excel skills by familiarising the user with some of the most commonly used features within the program.
About the Course
- Target
- Delegates with some experience of Microsoft Excel who can easily produce simple worksheets with basic calculations
- Entry requirements
- Delegates should have attended the Introductory course or gained similar knowledge in the workplace
- Outcome
- To demonstrate Excel's more powerful functions including charting data, working with multiple worksheets and sorting data
- Content
- Hints and Tips
- techniques for selecting cells
- using named ranges of cells
- copying and pasting techniques
- adding cell comments
- exploring the Fill handle
- applying conditional formatting.
Multiple Worksheets- moving between worksheets
- customising worksheet names
- inserting and deleting worksheets
- moving and copying worksheets
- group mode
- linking worksheets
- printing multi worksheet workbooks.
Charts- creating a chart
- changing the chart type
- adding data
- improving the appearance of a chart
- using AutoFormat
- creating custom formats
- 3D charts
- inserting graphics
- saving charts
- printing charts.
Working with Lists of Data- creating and editing a database list
- using Excel’s data form to enter data into a list
- searching and finding data using the data form
- sorting data in a list
- using the AutoFilter to find data in a list.
Automatic Subtotalling- adding subtotals to a list of data
- using different subtotal functions
- removing subtotals.
Working with Worksheets- freezing areas of the worksheet
- splitting the screen
- hiding cells and worksheets
- protecting worksheets and workbooks
- validating entered data
- adding a password to a workbook.
A comprehensive course manual provides support throughout the course and upon your return to the office. - Cost
- £150
- Enrolment
- Telephone, fax or write to Desktop.
- Website
- www.desktoptraining.co.uk
Availability
- Starts
- 04 Oct, 14 Dec, Please contact Desktop training to enquire about further dates
- Duration
- One day
- Timetable
- 9.30 am - 16.30 pm
- Provider
- Desktop Training & Development Ltd
Venues/Contact
Main (View map)
11 Beta Terrace
Masterlord Office Village
Ransomes Europark
Ipswich, Suffolk
IP3 9FE
UNITED KINGDOM
Telephone 0845 1188150
Email info@desktoptraining.co.uk
Website http://www.desktopcourses.co.uk
Courses
Syndicate
