Issued 28 July 2026
- Advanced functions for data analysis and interpretation - Working with dates: calculations, formatting, and analysis - Absolute referencing techniques for robust spreadsheet design - IF function applications for conditional logic and automation - Nesting functions to create complex, multi-layered calculations - Basic charting techniques for professional data visualisation - Advanced data manipulation and analysis techniques - Automation strategies to reduce manual work and errors
- Use advanced functions to examine and interpret information, uncovering insights that drive better business decisions - Work confidently with dates, performing calculations and analysis that support project planning and reporting - Use absolute referencing techniques to create reliable spreadsheets that maintain accuracy when copied or moved - Implement IF functions to automate decision-making within spreadsheets, reducing manual work and errors - Nest functions together to create sophisticated calculations that handle multiple conditions and scenarios - Create clear, impactful charts that communicate data insights effectively to colleagues and stakeholders - Answer burning questions and advanced challenges
This is your permanent, verifiable record of achievement.
Tag Sterling Training Ltd and share the love.
A skills badge appears directly on your LinkedIn profile under Licences & Certifications. It's different from sharing a post — it stays on your profile permanently.
Add my skills badgeAre you a training provider? Join Open CPD and get 5 free credits to get started.
Find out more