• ABOUT THE COLLEGE
  • ERG Refurbishment Tender Information
  • Courses
  • News
  • Events
  • How to find us
  • Vacancies
  • Publications
  • Get in touch
  • Essential Information
  • The Job Shop
  • Treat yourself
  • Corporate Information
  • Equality, Diversity and Inclusion
  • Safeguarding
  • College History
  • Ofsted
  • Active Inside Out
• YOUNG LEARNERS
  • Welcome
  • Courses
  • Applications
  • Past Results
  • Essential Information
  • Transport
  • 16-18 Bursary Fund
  • The Job Shop
  • Full Time Guide
  • College Videos
  • Supported Learning
  • Student Unions
  • 14 - 16 Learners
  • myNCS
  • 999 Academy
  • Enrichment
  • GCSEs
  • FreshFM
  • Active Inside Out
• UNIVERSITY COURSES
  • Welcome
  • Courses
  • Applying and Contacts
  • Modules
  • Life in North Devon
  • Tuition Fees
  • HE Course Guide
  • University of Plymouth Colleges
  • Scholarships
  • Studying at Petroc
  • Access to Higher Education
  • Staff Scholarly Activity
  • Workbased HE
  • Arts: End of Year Show
• EMPLOYERS
  • Welcome
  • A course to suit you
  • Courses
  • Working with You
  • Benefits of Training
  • Why Petroc?
  • Apprenticeships
  • Contact Us
  • Qualifications
  • Work Based Training
  • Security at Petroc
  • Innovation
  • The Job Shop
• ADULT LEARNERS
  • Welcome
  • Part time Courses
  • Categories & Fees
  • Adult Learner Support Fund
  • How can I enrol?
  • Part Time Course Guides
  • Extra Help
  • Essential Info
  • Supported Learning
  • Essential Skills
  • Arts on Prescription
  • Active Inside Out
• APPRENTICESHIPS
  • Welcome
  • Courses
  • Applications
  • Overview by Area
  • Costs and Funding
  • How Does it Work?
  • Earn and Learn
  • Framework
  • What we offer
  • Qualification Guide
  • Apprenticeship Guide

• Find a course
• Publications
• Essential Information
• About Us
• Young Learners
• Higher Education
• Employer Training
• Adult Learners
• Apprenticeships
• Employer Training

Spreadsheets Core Skills - (Microsoft Excel 2010)

The Programme

This one day course includes an introduction to the concept of spreadsheets, entering and editing data, setting data types, formating data so that it is clear and attractively presented, sorting data by various criteria and entering formula's.

The course will cover:
Introduction and Excel Overview
Key Changes and new Features in Excel 2010
Basic Functions and Formula's
Relative and Absolute Cell Referencing
Formatting
Sorting and Filters
Linking Cells Within Worksheets and Workbooks
Graphs and Charts
Printing Options

This course will lead onto Spreadsheets Advanced (Tools for Analysing and Reporting Information using Excel 2010)
link - http://www.petroc.ac.uk/courses/c353279020/spreadsheets-advanced-tools-for-analysing-and-reporting-information-using-excel-2010

Costs

£70

Dates

Please contact us for dates.

Length of Study

One day, 9.30am to 4pm.

Further Information

For further information please telephone 01271 338225, email employers@petroc.ac.uk or fill out our online enquiry form.