WSQ ICDL Microsoft Excel
ICDL – Perform Spreadsheet Functions (Excel 2019) – 24 Hours
On completion of this unit, the learner will have the knowledge and application skills in using a spreadsheet application. The skills include understanding fundamental spreadsheet concepts, designing a spreadsheet and using basic functions within a spreadsheet.
- Work with spreadsheets and save them in different file formats
- Choose built-in options such as the Help function within the application to enhance productivity
- Enter data into cells and use good practice in creating lists. Select, sort and copy, move and delete data
- Edit rows and columns in a worksheet. Copy, move, delete and appropriately rename worksheets
- Create mathematical and logical formulas using standard spreadsheet functions. Use good practice in formula creation and recognise error values in formulas
- Format numbers and text content in a spreadsheet
- Choose, create and format charts to communicate information meaningfully
- Adjust spreadsheet page settings and check and correct spreadsheet content before finally printing spreadsheets
Course Reference Number: TGS-2020503519
Duration: 8.30AM-6.00PM (3 days)
ICDL – Perform Spreadsheet Functions (Excel 2016) – 24 hours
On completion of this unit, the learner will have the knowledge and application skills in using a spreadsheet application. The skills include understanding fundamental spreadsheet concepts, designing a spreadsheet and using basic functions within a spreadsheet.
- Work with spreadsheets and save them in different file formats
- Choose built-in options such as the Help function within the application to enhance productivity
- Enter data into cells and use good practice in creating lists. Select, sort and copy, move and delete data
- Edit rows and columns in a worksheet. Copy, move, delete and appropriately rename worksheets
- Create mathematical and logical formulas using standard spreadsheet functions. Use good practice in formula creation and recognise error values in formulas
- Format numbers and text content in a spreadsheet
- Choose, create and format charts to communicate information meaningfully
- Adjust spreadsheet page settings and check and correct spreadsheet content before finally printing spreadsheets
Course Reference Number: TGS-2016500632
Duration: 8.30AM-6.00PM (3 days)
ICDL – Perform Advanced Spreadsheet Functions (Advanced Excel 2019) EC – 24 Hours
ICDL Advanced Spreadsheets is a high level certification programme which presents learners with the opportunity to bring their spreadsheet skills to an expert level. This allows them to use the full potential of the spreadsheet application to produce higher quality management information. Individuals with ICDL Advanced Spreadsheets certified skills can:
- Produce higher quality information
- Pinpoint key information quicker and more easily
- Provide more sharply-defined analysis
- Produce more sophisticated reports
- Use advanced editing, data handling, functions and analysis features
- Use macros within the spreadsheets application
Course Reference Number: TGS-2020504094
Duration: 8.30AM-6.00PM (3 days)
ICDL – Perform Advanced Spreadsheet Functions (Advanced Excel 2016) EC – 24 Hours
ICDL Advanced Spreadsheets is a high level certification programme which presents learners with the opportunity to bring their spreadsheet skills to an expert level. This allows them to use the full potential of the spreadsheet application to produce higher quality management information. Individuals with ICDL Advanced Spreadsheets certified skills can:
- Produce higher quality information
- Pinpoint key information quicker and more easily
- Provide more sharply-defined analysis
- Produce more sophisticated reports
- Use advanced editing, data handling, functions and analysis features
- Use macros within the spreadsheets application
Course Reference Number: TGS-2016500688
Duration: 8.30AM-6.00PM (3 days)