• 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 (Microsoft Excel 2003) - Expert Skills

The Programme

This course looks at the advanced features and functions within Excel, including organising and manipulating data, understanding functions, data analysis tools, pivot tables and macros. Prior knowledge of using Excel is required.

Organising and Manipulating Data in Excel covers:
Naming Cell Ranges
Creating Lists
Custom Lists
Using Data Validation
Conditional Formatting
Worksheet Protection
Cell Comments

Understanding Functions covers:
Function Structure
Creating Logical Statements (IF, AND OR)
TEXT Functions (TEXT, LEFT, RIGHT, CONCATENATE)
DATE Functions (WEEKDAY, MONTH)
FINANCIAL Functions (PMT)
Customised Cell Formatting
Dates
Time

Importing & Linking with Excel covers:
Importing Data
Managing Links

Data Analysis Tools covers:
Using Goal Seek
Creating and Editing Scenarios

Working with Lookup Tables covers:
Using Lookup Functions (HLOOKUP, VLOOKUP)

Working with PivotTables covers:
Creating and Using PivotTables
Editing PivotTables
Formatting in Pivot Tables

Working with Graphics and Charts covers:
Advanced Formatting of Charts and Graphs

Costs

The course costs £95 (including refreshments and lunch).

Dates

Tuesday 5 April 2011 at the School of Management, Barnstaple; Tuesday 19 April 2011 at Tiverton Campus.

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.