ICDL - Perform Advanced Spreadsheet Functions (Advanced Excel 2016)
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
Prospective learners should ideally have the ICDL certification and/or previous experience using computers and common software applications. Typically, these would be individuals who use a wide range of advanced functionalities within a spreadsheet application in a personal or professional context. Spreadsheet applications enable learners to manipulate and produce precise information and conduct crucial data analysis. The ICDL Advanced Spreadsheets certification has been specifically designed to provide learners with the skills to exploit the full potential of the spreadsheet application.
Considerations In Designing Spreadsheets
The purpose and structure of the spreadsheet
The intended audience or users
Apply data formats
Using multiple worksheets
Insert, move, remove spilt
Hide and show rows, columns, worksheet
- Functions And Formulas
Using cell references in formula
Function syntax and categories
IF, AND, OR
IF + AND, IF + OR
SUMIF, ROUND, ROUNDDOWN, ROUNDUP
COUNTA, COUNTBLANK, CUNTIF, RANK/RANK.EQ
Date and Time functions
TODAY, NOW, DAY, MONTH, YEAR
PV, FV, PMT
CONCATENATE, LEFT, MID, RIGHT, TRIM
Lookup and Reference functions
DSUM, DAVERAGE, DCOUNT, DMA, DMIN
Creating Three Dimensional worksheets
Past Special options
Use paste special options
Create a combined column and line chart.
Add a secondary axis to a chart.
Change the chart type for a defined data series.
Add, delete a data series in a chart.
Re-position chart title, legend, data labels.
Change scale of value axis.
Change display units on value axis without changing data source.
Format columns, bars, plot area, chart area to display an image.
Managing data in a spreadsheet
Create, modify a pivot table
Modify the data source and refresh the pivot table
Filter, sort data in a pivot table
Automatically, manually group data in a pivot table and rename groups
Use one-input, two-input data tables/multiple operations tables
Create named scenarios
Show, edit, delete scenarios
Create a scenario summary report
Sorting a database
Sort data by multiple columns at the same time
Create a customized list and perform a custom sort
Using Auto and Advanced Filters
Automatically filter a list in place
Apply advanced filter options to a list
Subtotals and Outlining
Use automatic sub-totalling features
Expand, collapse outline detail levels
Validating And Auditing
Set, edit validation criteria for data entry in a cell range.
Enter input message and error alert.
Trace precedent, dependent cells. Identify cells with missing dependents.
Show all formulas in a worksheet, rather than the resulting values.
- Enhancing Productivity
Name cell ranges, delete names for cell ranges.
Use named cell ranges in a function.
Create a spreadsheet based on an existing template.
Modify a template.
Link data within a spreadsheet, between spreadsheets, between applications.
Update, break a link.
Inserting Hyperlinks And Bookmarks
Insert, edit, remove a hyperlink
Import Data To Excel
Import delimited data from a text file
Record a simple macro.
Run a macro.
Assign a macro to a custom button on a toolbar.
- Collaborative Editing
Working With Comments
Insert, edit, delete, show, hide comments
Add, remove passowrd protection for a spreadsheet
Protect, unprotect cells, worksheet with a password.
Hide, unhide formulas.
Accessing And Sharing Data
Turn on, off track changes. Track changes in a worksheet using a specified display view.
Accept, reject changes in a worksheet.
Compare and merge spreadsheets.
Course Funding Period : 15 Apr 2020 To 01 Aug 2022
Course Code : TGS-2016500688
I would like to know more about the schedule and details of Advance Excel 2016 .