24hrs – ICDL Perform Advanced Spreadsheet Functions (Excel Advanced) 

Course Code: CRS-Q-0026883-ES

Course Objective – 24hrs – ICDL Perform Advanced Spreadsheet Functions (Excel Advanced)

During the midst of the course, 24hrs – ICDL Perform Advanced Spreadsheet Functions (Excel Advanced) , you will be able to:

  1. Use advanced formatting, formulae and charts features to enhance a spreadsheet
  2. Analyse, validate and audit data in a spreadsheet
  3. Use advanced spreadsheet functions to enhance productivity
  4. Manage collaborative editing to a spreadsheet

In completion of this course, participants may think of doing a recap either via Microsoft Excel 2013 – Basic , Microsoft Excel 2013 – Intermediate and Microsoft Excel 2013 – Advanced

 

  • Course Dates and Venue

    CourseVenueOct-17Nov-17Dec-17Jan-18Feb-18Mar-18
    24hrs - ICDL Perform Advanced Spreadsheet Functions (Excel Advanced)JTC Summit-15-17-29-31--
    JTC Summit (Weekend)--02, 09 & 16--17, 24 & 31
    Mountbatten Square09-11-11-13-26-28-
    Mountbatten Square (Weekend)------

    September 2015

    SMTWTFS
    30
    31
    1
    2
    3
    4
    5
    6
    7
    8
    9
    10
    11
    12
    13
    14
    15
    16
    17
    18
    19
    20
    21
    22
    23
    24
    25
    26
    27
    28
    29
    30
    1
    2
    3
  • Advanced Formatting

    • Considerations in Designing a Spreadsheet
    • Working with Cell Styles & Document Themes
    • Apply, Create & Manage Conditional Formatting
    • Creating a Custom Number Format

    Working with Tables

    • Create a Table & working with the Total Row
    • Sorting & Filtering a Table
    • Formatting the Table
    • Converting to a Range

     Advanced Functions and Formulas

    • Formulas with Multiple Operators
    • Using and Managing Defined Names
    • Using Mixed Cell Referencing
    • Date and Time Functions
    • Using Logical Functions (IF, AND and OR)
    • Using Lookup Functions
    • Mathematical and Statistical Functions
    • Using Financial, Text & Database Functions
    • Using 3D Reference within SUM Function

    Validating Data and Auditing Worksheets

    • Using Data Validation
    • Auditing Tools
    • Displaying and Tracing Formulas
    • Understanding Formula Errors

    Managing Charts

    • Editing, Adding, and Removing Chart Data
    • Changing Chart Data
    • Change Scales and Display Unit of the Axis
    • Add Secondary Axis & Change Series Chart Type
    • Changing and Aligning Data Labels and Chart Legend

    Working with Data Ranges

    • Sorting by a Custom List
    • Creating a Custom AutoFilter
    • Using Advanced Filter

    Working with PivotTables

    • Creating a PivotTable
    • Specifying PivotTable Data
    • Changing a PivotTable’s Calculation
    • Filtering and Sorting a PivotTable
    • Working with PivotTable Layout
    • Grouping PivotTable Items
    • Updating & Formatting a PivotTable
    • Creating a PivotChart
    • Using Slicers between PivotTables

    Analyzing Data

    • Creating Scenarios
    • Working with Data Tables
    • Using Goal Seek
    • Using Text to Columns
    • Grouping and Outlining Data
    • Using Subtotals
    • Consolidating Data by Position or Category

    Managing Templates

    Linking and Importing Data

    • Inserting a Hyperlink
    • Linking Data & Managing External Links
    • Importing Data
    • Working with Existing Data Connections

    Working with Macros

    • Recording a Macro
    • Playing and Deleting a Macro
    • Adding a Macro to the Quick Access Toolbar

    Managing Collaborative Editing

    • Working with Comments to Cells
    • Tracking Changes
    • Protecting Worksheets and Worksheet Elements
    • Protecting a Workbook
  • For people who have good basic to intermediate level of understanding on Microsoft Excel.

  • “Bee Hoon is a skillful trainer and has expertise in sharing her thoughts. She is indeed a competent trainer to inject a soft skills to new learners. Teaching environment was so good.” – Ayyadurai Sundarapandian (12, 19 & 26 Nov 2016)

    “The knowledge and skills that were taught are useful to my job.” – Rasida Bte Abdul Rashid (12, 19 & 26 Nov 2016)

Fees and Grants

$556.40 per participant (Inc. GST)

SMEs Company Sponsored Singaporean/PR only: $88.40 (Inc. GST).
Click here for more details on Grant.

SDF subsidy: WSQ Courses. For more information on SDF, please refer to www.skillsconnect.gov.sg > Funding Mechanism.

Applicants may use SkillsFuture Credit for this course

Registration

Click here to download registration form for company-sponsored trainees.

Click here to download registration form for self-sponsored trainees.

Apply Online - ICDL

24hrs – ICDL Perform Advanced Spreadsheet Functions (Excel Advanced)  (CRS-Q-0026883-ES)


All registration should be submitted at least 1 week before course commencement. Please call us directly to check on the class status.

A. Company Particulars

Company Name

Company Address

Postal Code

B. Training Coordinator / Contact Person

TC / Contact Person Name*

TC / Contact Person Email*

Contact Number*

C. Billing Information


Billing Contact Person Name*

Billing Contact Person Email*

Billing Contact Number*

Billing Fax Number

Business Unit (BU / SBU)

For Businesses or Government Agencies using the e-invoice system only.

Are you applying for SDF Grant?

D. Participants


Participant 1

NRIC Type

Gender

Nationality

Race

Education Level

Salary Range

Course Start Date*

Course End Date*

Participant 2

NRIC Type

Gender

Nationality

Race

Education Level

Salary Range

Course Start Date

Course End Date

Participant 3

NRIC Type

Gender

Nationality

Race

Education Level

Salary Range

Course Start Date

Course End Date

Have more than 3 participants?

Attach their particulars here (PDF, Word .doc, Excel .xls)

I have Read and Agree to the Terms and Conditions


We do not sell or share your information with anyone else.