Course Detail(IT032Cv : Exploring Microsoft Excel (2016) New Features (Live Webinar))

SDF Funding, SkillsFuture Credit

IT032Cv : Exploring Microsoft Excel (2016) New Features (Live Webinar)

14.00 CPE Hours (Others)
Live Webinar

 

Notice
Our Computer Lab is equipped with Microsoft Excel 2016 & 2010. Due to compatibility issue, Excel 2013 will not be provided.
You may opt to bring along your laptop if you wish to use Excel 2013.

Programme Objective
 
Microsoft Excel 2016 is designed to help you get professional-looking results quickly. The new features let you get away from massive walls of numbers, allow you to draw a clearer pictures of your data, provide you with tools to create reports faster and enable you to make more effective decisions.
 
The course will focus on new features such as Flash Fill, Quick Analysis, Recommended Charts, Recommended PivotTables, Slicer, Timelines, Power Map, Power View and so on. Power View provides users with an easy-to-use reporting tool to create interactive visual reports, whereas Timelines provides an easy way to filter Pivot Tables and Pivot Charts graphically by date or time-oriented options. Quick Analysis tools and Flash Fill provide a quick way to analyze data and to separate text from a column.
 
This 2-days workshop will equip the participants with knowledge and skills to improve their experience in using Microsoft Excel 2016 data analysis and reporting tools.

Programme Outline

  • Introducing Excel 2016 New Features
    • Excel New Templates
    • Quick Analysis
    • Recommended Charts
    • New Chart Formatting Icons
    • Enhanced Chart Labels
    • Statistic and Hierarchy Chart Types
    • Flash fill
    • Recommended PivotTables
    • Timeline filter for PivotTable
    • Create Relationships Between Tables
    • Slicer filter for table
    • Power View and Power Map
  • Customizing Excel 2016 Program Window
    • Microsoft Excel 2016 Screen
    • Customizing Quick Access Toolbar
    • Customizing the Ribbon
    • Resetting Customizations
    • Changing User Interface
    • Displaying Underlying Formulas
  • Using Flash Fill to Manage Data
    • Turn Flash Fill On
    • Start Flash Fill Manually
    • Format Numbers
    • Format Dates
    • Split Names
    • Change Text Cases
    • Combine text from Two or More Cells into One Cell
    • Split Addresses
  • Using the Quick Analysis Tools
  • The Formatting Tab è Highlighting data with Conditional Formatting
  • Managing Conditional Formatting Rules
  • The Charts Tab è Visualizing data with Recommended Charts
  • The Totals Tab è Calculating Totals automatically
  • The Tables Tab è Summarizing data with Tables
  • Using the Table Tools
  • The Sparklines Tab è Creating in-cell mini charts with Sparklines
  • Customizing Sparklines
  • Using Recommended Charts and New Chart Types
    • Let Excel Recommend a Good Chart
    • Creating Combo Chart
    • Creating Waterfall Chart
    • Creating Histogram Chart
    • Creating Treemap Chart
    • Creating Sunburst Chart
  • Using New Charting Features
    • Customizing Chart using the Design Tab
    • Formatting Chart using the Format Tab
    • Using the New Chart Icons
    • Using Enhance Chart Labels
    • Using the New Format Task Pane
    • Formatting Chart Values Axis
    • Formatting Chart Category Axis
    • Formatting Legend
    • Formatting Data Labels
    • Formatting Data Series
    • Formatting Chart Area
  • Using Recommended PivotTables Tool
    • Let Excel Recommend a PivotTable
    • Creating PivotTable from Excel Data
    • Changing Report Layout
    • Creating PivotChart
    • Creating a Combo PivotChart
  • Using Timeline and Slicer Filters
    • Creating Excel Table from Source Data
    • Using Slicer to Filter Excel Table
    • Creating PivotTable from Excel Table
    • Inserting Timeline to PivotTable
    • Using Slicer to Filter PivotTable
    • Formatting Slicer and Timeline
    • Connecting Multiple PivotTables to a Slicer
    • Connecting Multiple PivotTables to a Timeline
  • Creating Relationship Between Two Tables
    • Introducing Table Relationships
    • Creating Excel Tables
    • Creating Relationships Between Two Tables
    • Using Related Tables to Create a PivotTable
    • Creating PivotChart from PivotTable
    • Adding Slicer and Timeline
  • Creating Power View Reports
    • Introducing Power View
    • Inserting a Power View Report
    • Creating Table in Power View
    • Formatting a Power View Report
    • Refreshing the Power View Report
    • Using Matrix Visualization
    • Using Card Visualization
    • Using Chart Visualization
    • Introducing Map in Power View
    • Adding a Map to Power View
    • Adding the Map Legend
    • Adding Data Labels to Map
    • Changing the Map Layout
    • Changing the Map Background
  • Using the Power Map
    • Introducing Power Map
    • Download and Install the Power Map
    • Creating Power Map
    • Customizing Power Map
    • Closing the Power Map
    • Launching the Power Map
    • Creating Video with Power Map


Pre-requisites

Please take note of the following admission requirements:

  • Trainings will be conducted on Zoom platform, thus video camera and microphone are compulsory
  • Mandatory for video camera to be turned on throughout the course
  • Display your official name (as per NRIC) in Zoom, to facilitate attendance taking


Training Methodology
 Lecture style, with hands-on exercises
 
Closing Date for Registration
1 week before programme or until full enrolment.

Intended For

This workshop is for all existing Microsoft Excel users who intend to learn the powerful new features in Microsoft Excel 2016.

Competency Mapping

Others = 14.00 Hours

Schedule & Fees

Date & Time

26 Oct 2020 (9:00 AM - 5:00 PM)
27 Oct 2020 (9:00 AM - 5:00 PM)

Registration is closed

Programme Facilitator(s)

Valene Ang

Testimonial

Funding

1] SkillsFuture Credit (SFC)
Funding Period: Until 13 Sep 2023
Course Reference Number: TGS-2020500778

All Singaporeans aged 25 and above will receive an opening credit of S$500 from the government. You may wish to use your SFC to pay for partial/full ISCA course fees. 

On 1 Oct 2020, the Government provided a one-off SkillsFuture Credit Top-up of $500 for all eligible Singaporeans aged 25 or above by 31 Dec 2020. Singaporeans aged 40 to 60 by 31 Dec 2020 will also receive an Additional SkillsFuture Credit (Mid-Career Support) of $500 which can be used for courses under: (i) SGUnited Skills Programme, (ii) SGUnited Mid-Career Pathways Programme – Company Training, and (iii) Career Transition Programmes. This additional SFC (Mid-Career Support) is NOT applicable for use on ISCA courses. (For more information on the SFC scheme, please visit http://www.skillsfuture.sg/credit)

If you wish to enrol for the course with SFC Funding, please proceed with the following steps:

Failure to submit claim application and obtain necessary approval before the course start date will result in topping up of the SFC indicated for use. Please note that there will be an administrative fee of $42.80 for any revision of invoice.


2] WDA Training Grant - SDF Funding
This course is approved for SDF funding ($2 per training hour) for Company-sponsored participants only (Eligibility criteria apply). 

Funding Period: Until 13 Sep 2023
Funded Hours: 14 hours
Course Reference Number: TGS-2020500778

If you wish to enrol participants with SDF Funding, please proceed with the following steps (For Corporate enrolments only) :

  • Step 1: Register for the course online via ISCA Portal. Upon adding to cart, the system will prompt a question “Do you wish to apply for WDA Funding?”, click Yes and input all required information. At the Cart page, please ensure that SDF funding is applied before clicking “Checkout”.
     

 

For course run start date before 1 Nov 2020, submit training grant application in SCN until 30 Nov 2020.

For course run start date on or after 1 Nov 2020, Enterprises/employers are NOT required to log into TPGateway/SCN to submit training grant.

Remarks

Step 2: After receiving email that the programme status is confirmed, please proceed to submit the Training Grant application via SkillsConnect Portal (https://www.skillsconnect.gov.sg/).

Employers of company-sponsored participants must submit training grant via SkillsConnect to obtain training grant for course fees. You may submit the Training Grant application within the period from 30 days before the course start date to 30 days after course start date.

The employee’s enrolment, attendance and assessment recordswill be submitted by ISCA onto TPGateway.


Please note that there will be an administrative fee of $42.80 for any revision of invoice.

Eligibility Criteria:

  • Company must be registered or incorporated in Singapore and;
  • Applicant is taking the course for the first time.
  • Applicant must be employed, and is either Singapore Citizen or Permanent Resident of Singapore and;
  • Applicant must achieve at least 75% attendance, and pass all examinations /assessments and;
  • Applicant must be fully sponsored by the Company for all costs associated with the training and;
  • Payment has to be made via corporate means (e.g. corporate cheque, corporate GIRO, corporate credit card).

Programme Facilitator(s)


Valene Ang

Valene Ang is a Microsoft Certified Trainer (MCT) and ACTA Certified trainer. She has 20 years training experience in Information Technology field. She had conducted many Microsoft Office seminars and workshops in Singapore and Malaysia. Her spreadsheet training focuses on providing practical solutions to problems in data analysis and reporting.

 
Valene has a broad experience in customizing Microsoft Office training programs, developing customized course outline and courseware, assisting corporate client in business data analysis and providing dynamic report solutions.

 

Notice
Our Computer Lab is equipped with Microsoft Excel 2016 & 2010. Due to compatibility issue, Excel 2013 will not be provided.
You may opt to bring along your laptop if you wish to use Excel 2013.

Programme Objective
 
Microsoft Excel 2016 is designed to help you get professional-looking results quickly. The new features let you get away from massive walls of numbers, allow you to draw a clearer pictures of your data, provide you with tools to create reports faster and enable you to make more effective decisions.
 
The course will focus on new features such as Flash Fill, Quick Analysis, Recommended Charts, Recommended PivotTables, Slicer, Timelines, Power Map, Power View and so on. Power View provides users with an easy-to-use reporting tool to create interactive visual reports, whereas Timelines provides an easy way to filter Pivot Tables and Pivot Charts graphically by date or time-oriented options. Quick Analysis tools and Flash Fill provide a quick way to analyze data and to separate text from a column.
 
This 2-days workshop will equip the participants with knowledge and skills to improve their experience in using Microsoft Excel 2016 data analysis and reporting tools.

Programme Outline

  • Introducing Excel 2016 New Features
    • Excel New Templates
    • Quick Analysis
    • Recommended Charts
    • New Chart Formatting Icons
    • Enhanced Chart Labels
    • Statistic and Hierarchy Chart Types
    • Flash fill
    • Recommended PivotTables
    • Timeline filter for PivotTable
    • Create Relationships Between Tables
    • Slicer filter for table
    • Power View and Power Map
  • Customizing Excel 2016 Program Window
    • Microsoft Excel 2016 Screen
    • Customizing Quick Access Toolbar
    • Customizing the Ribbon
    • Resetting Customizations
    • Changing User Interface
    • Displaying Underlying Formulas
  • Using Flash Fill to Manage Data
    • Turn Flash Fill On
    • Start Flash Fill Manually
    • Format Numbers
    • Format Dates
    • Split Names
    • Change Text Cases
    • Combine text from Two or More Cells into One Cell
    • Split Addresses
  • Using the Quick Analysis Tools
  • The Formatting Tab è Highlighting data with Conditional Formatting
  • Managing Conditional Formatting Rules
  • The Charts Tab è Visualizing data with Recommended Charts
  • The Totals Tab è Calculating Totals automatically
  • The Tables Tab è Summarizing data with Tables
  • Using the Table Tools
  • The Sparklines Tab è Creating in-cell mini charts with Sparklines
  • Customizing Sparklines
  • Using Recommended Charts and New Chart Types
    • Let Excel Recommend a Good Chart
    • Creating Combo Chart
    • Creating Waterfall Chart
    • Creating Histogram Chart
    • Creating Treemap Chart
    • Creating Sunburst Chart
  • Using New Charting Features
    • Customizing Chart using the Design Tab
    • Formatting Chart using the Format Tab
    • Using the New Chart Icons
    • Using Enhance Chart Labels
    • Using the New Format Task Pane
    • Formatting Chart Values Axis
    • Formatting Chart Category Axis
    • Formatting Legend
    • Formatting Data Labels
    • Formatting Data Series
    • Formatting Chart Area
  • Using Recommended PivotTables Tool
    • Let Excel Recommend a PivotTable
    • Creating PivotTable from Excel Data
    • Changing Report Layout
    • Creating PivotChart
    • Creating a Combo PivotChart
  • Using Timeline and Slicer Filters
    • Creating Excel Table from Source Data
    • Using Slicer to Filter Excel Table
    • Creating PivotTable from Excel Table
    • Inserting Timeline to PivotTable
    • Using Slicer to Filter PivotTable
    • Formatting Slicer and Timeline
    • Connecting Multiple PivotTables to a Slicer
    • Connecting Multiple PivotTables to a Timeline
  • Creating Relationship Between Two Tables
    • Introducing Table Relationships
    • Creating Excel Tables
    • Creating Relationships Between Two Tables
    • Using Related Tables to Create a PivotTable
    • Creating PivotChart from PivotTable
    • Adding Slicer and Timeline
  • Creating Power View Reports
    • Introducing Power View
    • Inserting a Power View Report
    • Creating Table in Power View
    • Formatting a Power View Report
    • Refreshing the Power View Report
    • Using Matrix Visualization
    • Using Card Visualization
    • Using Chart Visualization
    • Introducing Map in Power View
    • Adding a Map to Power View
    • Adding the Map Legend
    • Adding Data Labels to Map
    • Changing the Map Layout
    • Changing the Map Background
  • Using the Power Map
    • Introducing Power Map
    • Download and Install the Power Map
    • Creating Power Map
    • Customizing Power Map
    • Closing the Power Map
    • Launching the Power Map
    • Creating Video with Power Map


Pre-requisites

Please take note of the following admission requirements:

  • Trainings will be conducted on Zoom platform, thus video camera and microphone are compulsory
  • Mandatory for video camera to be turned on throughout the course
  • Display your official name (as per NRIC) in Zoom, to facilitate attendance taking


Training Methodology
 Lecture style, with hands-on exercises
 
Closing Date for Registration
1 week before programme or until full enrolment.

Intended For

This workshop is for all existing Microsoft Excel users who intend to learn the powerful new features in Microsoft Excel 2016.

Competency Mapping

Others = 14.00 Hours

Programme Facilitator(s)

Valene Ang

Valene Ang is a Microsoft Certified Trainer (MCT) and ACTA Certified trainer. She has 20 years training experience in Information Technology field. She had conducted many Microsoft Office seminars and workshops in Singapore and Malaysia. Her spreadsheet training focuses on providing practical solutions to problems in data analysis and reporting.

 
Valene has a broad experience in customizing Microsoft Office training programs, developing customized course outline and courseware, assisting corporate client in business data analysis and providing dynamic report solutions.


Upcoming Schedule

Registration is closed

Date & Time

26 Oct 2020 (9:00 AM - 5:00 PM)
27 Oct 2020 (9:00 AM - 5:00 PM)

Fee (inclusive of GST)

For Members: $ 679.45
For Non-Members: $ 815.34

Programme Facilitator(s)

Valene Ang

Venue

Online Classroom in or outside of
Singapore