Course details
Course description
Microsoft Excel is enormously powerful and flexible and has a reputation as the most widely used spreadsheet application. Very few users venture beyond the basics and therefore do not exploit the benefits of this formidable application. Microsoft Excel can be delivered to introductory, intermediate, and advanced level. Each level is scheduled into a one-day course which is trainer led. This course will cover the following topics: Introductory level •Understand the principles of a Worksheet and Workbook •Create, edit, save, and retrieve spreadsheets •Copy and move data •Construct formulae and use functions •Format text and numbers Intermediate level •Link formulae and use more functions •Work with multiple worksheets and workbooks •Consolidate data •Create and customise charts •Create hyperlinks Advanced level •Use the Group feature •Protect workbooks, worksheets, cell ranges, add/remove a password •Understand, apply, modify, create styles •Use linking formulas •Understand and use data consolidation •Use advanced functions •Understand, manage, and create a scenario manager As well as being open to any individual, this course can be delivered: •to meet individual company requirements •to company house styles and templates •within company premises •specifically to a group or team of staff This one day short course is delivered at Carnegie Conference Centre
Entry requirements
As a working knowledge of the full range of ICT packages is becoming a core competence within any workforce, this course would be suitable for anyone who works with or manipulates data at any level within an organisation.
Course options
Course details
Part time
22nd Feb 2024 to 22nd Feb 2024
Cost: £195.00 (ex. VAT)
Venue details
Fife College
Pittsburgh Road
Halbeath
Dunfermline
KY11 8DY
Who to contact
Tracy Wilson/Linzi Nelson
External Contracts Coordinator
03442480115
Course details
Part time
25th Apr 2024 to 25th Apr 2024
Cost: £195.00 (ex. VAT)
Venue details
Fife College
Pittsburgh Road
Halbeath
Dunfermline
KY11 8DY
Who to contact
Tracy Wilson/Linzi Nelson
External Contracts Coordinator
03442480115
Course details
Part time
13th Jun 2024 to 13th Jun 2024
Cost: £195.00 (ex. VAT)
Venue details
Fife College
Pittsburgh Road
Halbeath
Dunfermline
KY11 8DY
Who to contact
Tracy Wilson/Linzi Nelson
External Contracts Coordinator
03442480115