Course description
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. Excel skills are highly useful IT & computer skills, especially in a business context.
Learners will develop their understanding, knowledge and skills using spreadsheet software. Improve your digital skills with this course!
Upcoming start dates
Suitability - Who should attend?
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.
There are no formal qualifications required to undertake this course. To secure your place please return the completed application form (found on the course webpage on the Step Into Learning website). After this, we will be in touch to arrange next steps.
This course is for you if you want to start, build or enhance your spreadsheet skills
Outcome / Qualification etc.
These courses are completed in one day and there is no assessment – tasks will be given and completed throughout the session.
Training Course Content
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
Course delivery details
This course can be delivered either:
- Online in a virtual classroom
- Face to face
Why choose Step Into Learning
100% of learners on our Access to HE courses achieved merit or distinction in 2020/21
Expenses
This course costs £120 – potential additional venue and travel charges if face to face
Request info
Step Into Learning
Step Into Learning specialise in training and courses with a vocational focus within the broad remit of health and wellbeing. We are an independent training provider with 20+ years experience based in Cornwall in the South West of England. Depending...