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: N/a | Awarding Organisation: N/A |
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 find out about available dates and secure your place, please complete the application form below. 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. We will provide a certificate of attendance.
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.
Course Application Form - Apply Now!
Related Courses
No Results Found
The page you requested could not be found. Try refining your search, or use the navigation above to locate the post.
