Spreadsheet Software: Pre-exam Checklist
Use a spreadsheet to enter, edit and organise numerical and other data
Identify what numerical and other information is needed in the spreadsheet and how it should be structured
Enter and edit numerical and other data accurately
Combine and link data from different sources
Store and retrieve spreadsheet files effectively, in line with local guidelines and conventions where available
Select and use appropriate formulas and data analysis tools and techniques to meet requirements
Explain what methods can be used to summarise, analyse and interpret spreadsheet data and when to use them
Select and use a range of tools and techniques to analyse and interpret data to meet requirements
Select and use forecasting tools and techniques
Use tools and techniques to present, and format and publish spreadsheet information
Explain how to present and format spreadsheet information effectively to meet needs
Select and use appropriate tools and techniques to format spreadsheet cells, rows, columns and worksheets effectively
Select and use appropriate tools and techniques to generate, develop and format charts and graphs
Select and use appropriate page layout to present, print and publish spreadsheet information
Explain how to find and sort out any errors in formulas
Check spreadsheet information meets needs, using IT tools and making corrections as necessary
Use auditing tools to identify and respond appropriately to any problems with spreadsheets
Copyright © |
Premier Training
- Specialists in accountancy training
