Using Excel Spreadsheet Software
These courses will allow you to develop your skills using spreadsheet software. The courses are offered at three different levels so you can choose the one that suits your current level – basic, intermediate or advanced. Build your knowledge, confidence and skillset.
Course Summary
| Level: Basic, Intermediate or Advanced | Duration: 1 day (6 hours including breaks) |
| Start Date: Please enquire | Type: Online in ‘live’ classroom or face to face |
| Location: Online or Suitable Venue Agreed by Learner & Step Into Learning | |
| Price: £120 – payment required upfront. Potential additional venue and travel charges if face to face | Age Range: 19+ |
| Funding: Free places available via SPF Digital Futures project | Awarding Organisation: N/A |
Information about free places through SPF Digital Futures project
Who is this course for?
These courses are for everyone, whether you’re looking to start building your spreadsheet skills, need a refresher or are looking to move on to a more advanced level – we have an option for you! The course is available at three levels – basic, intermediate and advanced.
Entry Requirements
There are no formal qualifications required to undertake this course. To secure your place please return the completed application form and send to info@stepintolearning.org.uk. After this, we will be in touch to arrange next steps.
Why should I do this qualification?
This course is for you if you want to start, build or enhance your spreadsheet skills
What will I learn?
Learners will develop their understanding, knowledge and skills using spreadsheet software:
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
How will I be assessed?
These courses are completed in one day and there is no assessment – tasks will be given and completed throughout the session.
Need some answers?
We're here to help.
Call us on: 01566 770729
Or email us at: info@stepintolearning.org.uk
Excited to get Started
If you’re happy with what you’ve seen, why delay, apply today.
Related Courses
Using Word (Word Processing Software) – Basic, Intermediate & Advanced
Using Word Processing Software These courses will allow you to develop your skills using word processing software. The courses are offered at three different levels so you can choose the one that suits your current level - basic, intermediate or advanced. Build your...
Level 3 Project Management
Level 3 Project Management Project management is important because it helps every part of the business run more efficiently and effectively. When done correctly, it enables leadership to plan and manage projects so that every objective and deliverable is completed on...
Level 1 / 2 Data Analysis
Level 1 / 2 Data Analysis Data analysis translates numbers and data into information that can be used to solve problems or track business performance. Data analysis produces graphs, charts, tables and reports. Data analysis is in high demand across all sectors, such...
