ICDL EXCEL ADVANCED
(WSQ COURSE)

Programme Content

If you are looking at improving your Word skills after knowing the basics, this ICDL Word Advanced Course will help you to create professional document. This course further helps learners with the basic and intermediate level of Microsoft Word knowledge to further enhance the complexity of creating a variety of professional documents. User: Higher working personnel who are required to do report writing, meeting minutes and etc. Typically, they are people like Admin Executives, Personal Assistants or Journalists.. A brief of items covered below: Use advanced text formatting features to enhance formatting and output of a document Apply referencing features to documents Use advanced functions to enhance productivity Manage collaborative editing to a document

Course Deliveries

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

Durations

24 hrs

Prerequistes

Note:

 

Self-Sponsored

  1. Singaporean & PR aged 21 and above = 70% funding.

  2. Singaporeans only (not PR) aged 40 and above = 90% funding.

  3. Singaporeans aged 35-39 with WSS letter = 70% funding.

Company-Sponsored (till end of 2020)

  1. Singaporeans & PRs aged 21 years and above are allowed 90% funding.

  2. Absentee Payroll applies for company sponsored up to $10/training hour. Please use Absentee Payroll calculator provided by SSG to calculate the absentee payroll for your employee.

 

All information is correct at time of publish (18 August 2020). The company reserves the rights to make any changes at any time without notice at its discretion.

Notes to Application:

  1. Please check the available date before you apply for your course.

  2. Your application does not qualify for a seat for the course. You will receive a phone call from our friendly consultant who will assist you in the application.

  3. The Training Provider (ATO) reserves the rights to postpone or cancel the course if the course does not meet the minimum learners required.

Application Procedures:

  1. Applications can enquire online or through email or WhatsApp. We will be in touch with you for the documents required to complete your registration

  2. Upon your seat confirmation, you will receive a confirmation email from the training provider.

  3. Payment must be made prior to the commencement of the course.

 

For Enquiries:

Should you required any further assistance, please contact us at our hotline at

8155 6920 or email to support@ifuture.sg

© 2020 Proudly created by  iFuture.sg