ICDL - Perform Advanced Spreadsheet Functions (Advanced Excel 2019) - SkillsPortal.sg

ICDL - Perform Advanced Spreadsheet Functions (Advanced Excel 2019)

Eagle Infotech Consultants Pte Ltd

  • $642.00
    Unit price per 


COURSE SYNOPSIS
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 

TARGET AUDIENCE
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.

COURSE CONTENT
 
Overview of Module


  1.  Considerations in designing spreadsheets
  2.  Formatting 

Table AutoFormat

Conditional formatting

Apply data formats

 Using multiple worksheets

 Insert, move and remove split

Hide and show rows, columns, worksheet

  1.  Functions and formula

Using cell references in formula

Function syntax and categories

Logical functions

Nested functions

Nested functions

Mathematical functions

Statistical functions

Date and Time functions

Financial functions

Text functions

Lookup and Reference functions

Database functions

Creating Three-D worksheets

Paste Special options

  1.  Charts

Using Custom Charts

Formatting charts
 

  1.  Analysis

Managing data in a spreadsheet

PivotTables

Data Tables

Scenario Manager

Sorting a database

Auto and Advanced Filters

Subtotals

  1.  Validating and Auditing

Data validation

Auditing

  1.  Enhancing Productivity

Range Names

Using Templates

Linking data

Inserting hyperlinks and bookmarks

Import data to Excel

Macros

  1.  Collaborative Editing

Working with comments

File protection

Accessing and sharing data

Funding


Additional Info

Course Funding Period : 02 Jun 2020 To 04 Aug 2022

Course Code : TGS-2020504094

Customer Reviews

No reviews yet
0%
(0)
0%
(0)
0%
(0)
0%
(0)
0%
(0)