What is SPF Digital Futures Cornwall?
Digital Futures Cornwall is a part funded training programme to support people in Cornwall and the Isles of Scilly to get the specialist skills they need to thrive in an increasingly digital world.
Digital Futures Cornwall, which is led by Truro and Penwith College and part funded by the Shared Prosperity Fund*, brings together ten skills providers (Step Into Learning are one of these providers) and a further 3 strategic partner organisations, including Cornwall Council and the Council of the Isles of Scilly.
The programme is providing a shared space for all things digital and focus on providing opportunities for local people who are currently underrepresented in the tech sector, whilst tackling the challenges of a growing industry.
What courses are we offering through SPF Digital Futures Cornwall?
We are offering Excel basic, intermediate and advanced courses at the low-cost of £25 per session. Sessions run 9.30am to 3.30pm face to face and online.
Excel Courses will cover the following:
Basic Level:
- Navigation
- Text – alignment
- Cell formatting
- Introduction to mathematical formulae
- Tables and helpful tools
- Charts
- Pivot tables
- Copying between workbooks
Intermediate Level:
- More complex formulae
- Splitting cell content
- Linking cells
- Functions (IF, AND, OR)
- Nesting functions
- Conditional formatting
- Combo charts
- Managing large spreadsheets – including multi select
- Freezing views
- Printing
Advanced Formula:
- Understand and construct formulae with absolute cell references
- Understand and construct some logical functions
- Understand and construct a combination of some logical functions
- Understand and construct VLookup and HLookup functions
- Effectively use the built in auditing tools available
- Understand and construct data validation to restrict types of data entry
- Consolidate data using pivot table and charts
- Understand and construct some common functions
- Use different methods to convert text into columns
- Use advanced formatting techniques
- Use advanced conditional formatting
- Be able to apply and remove protection to workbooks and individual worksheets
- Printing large spreadsheets
Advanced Desktop App:
- Macros
- Protecting workbooks/worksheets
- More topics can be added if required
Current Dates:
- Tuesday 13th January – Excel Intermediate, online (Teams)
- Tuesday 20th January – Excel Advanced, online (Teams)
- Thursday 22nd January – Excel Basic, face to face @ The Orchard Centre, Launceston
Sessions for Care Sector Staff:
- Tuesday 28th October – Excel for Care Administration, face to face @ Truro New County Hall, 12.30pm – 4.30pm
To book any of these sessions:
Telephone: 01566 770729
*This project is part-funded by the UK Government through the UK Shared Prosperity Fund. Cornwall Council is responsible for managing projects funded by the UK Shared Prosperity Fund through the Cornwall and the Isles of Scilly Good Growth Programme.
The UK Shared Prosperity Fund proactively supports delivery of the UK Government’s five national missions: pushing power out to communities everywhere, with a specific focus to help kickstart economic growth and promoting opportunities in all parts of the UK. For more information, visit https://www.gov.uk/government/publications/uk-shared-prosperity-fund-prospectus
Want help?
To book an Excel or Word course, or to chat to us further about the SPF Digital Futures Cornwall project, please call or email us:
Call us on: 01566 770729
Or email us at:
info@stepintolearning.org.uk