• 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 Advanced (Tools for Analysing and Reporting Information using Excel 2010)

The Programme

This course looks at the advanced features of Excel to analyse and report information. How to organise and manipulate data, create lookups and pivot tables, conditional formating and using advanced functions to help you get the most out of your data.

This course looks at the advanced features of Excel to analyse and report information. How to organise and manipulate data, create lookups and pivot tables, conditional formating and using advanced functions to help you get the most out of your data.

Spreadsheets Advanced (Tools for Analysing and Reporting Information using Excel 2010) covers:
Naming Cell Ranges
Creating Lists
Customising Lists
Using Data Validation
Conditional Formatting - creating and formatting
Worksheet Protection
Cell Comments
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 and Time
Managing Links
Using Goal Seek
Creating and Editing Scenarios
Using Lookup Functions (HLOOKUP, VLOOKUP)
Creating and Using PivotTables
Editing PivotTables
Formatting in Pivot Tables
Advanced Formatting of Charts and Graphs

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.