ICDL Perform Advanced Spreadsheet Functions (Excel Advanced)

exelICDL Perform Advanced Spreadsheet Functions (Excel Advanced) is a highly funded WSQ SkillsFuture approved course. It is highly recommended for those who want to leverage on the Advanced functions and features to improve productivity in your daily work activities.

During the course, you will get to how to use advanced functions such as complex formula writing, inserting and editing functions, defining names, tracing formulas, and diagnosing errors. The course is delivered using 2019 excel version.

Course  Objectives

  • Use advanced formatting, formulae and charts features to enhance a spreadsheet
  • Analyse, validate and audit data in a spreadsheet
  • Use advanced spreadsheet functions to enhance productivity
  • Manage collaborative editing to a spreadsheet

You will be awarded with an e-cert of SOA (Statement of Attainment) by SSG and a hard copy certificate by ICDL Asia (International Computer Driving License) which is recognised world-wide upon the completion of this course and passing the assessment.

Course  Outline

excelAdvanced 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

Target Audience

This course is meant for users who have good basic to intermediate level of knowledge on Microsoft Excel and would like to further extend the knowledge on more advanced functions of Excel to become more productive in their work. Learners who are not familiar with Microsoft Excel may consider taking up the ICDL Perform Spreadsheet Functions (Excel Fundamentals) first. This course is most suitable for Account Executive, Admin Executive, and HR Personnel who deals with number reporting. It allows them to create managed worksheets, create charts, do calculations to manage reports such as inventory listing, payrolls, invoices, payment and product pricing even more professionally.

Course Fees

Full course fees: $556.40 (inclusive of GST)

Company Sponsored

Self-Sponsored

SME

Non-SME

Singaporean & PR aged from  21-39 

Singaporean

Singaporean Aged >= 40

Singaporean & PR 

Singaporean & PR

 

Singaporean aged >=40

$88.40

$148.40

$88.40

$148.40

$88.40

 

Note:

  • Company sponsored – – Enhanced Absentee Payroll applicable. (Valid till 31 Dec 2020) ▪ SME & Non-SME – $10 x 24 hours = $240
  • Skillsfuture Credit eligible for Singapore Citizens aged 25 and above.

Course Schedule

Duration: 3 day, 24 hours

Face to Face, classroom mode

5, 6 & 7 Oct (Mon. Tue & Wed), 9am to 6pm @ JTC Summit

26, 27 & 28 Oct (Mon, Tue & Wed), 9am to 6pm @ Mountbatten Square

Live Virtual Learning via Zoom

12, 13 &14 Oct (Mon, Tue and Wed), 9am to 6pm

28, 29 & 30 Oct (Wed, Thurs & Fri), 9am to 6pm

Delivery Mode

This is a 3-day practical oriented course that can be delivered face-to-face classroom mode OR live virtual learning via Zoom. Learners who choose live virtual learning via zoom is required to have their laptop/computer equipped with EXCEL 2019 version. A computer is provided for learners who choose face to face, classroom mode.

For more information/ registration or Group / In-House Training, please contact Jaslyn @ 6278 9785 or email jaslyn@cbsgroup.com.sg

RSS
Follow by Email