Course Detail(IT032C** : Exploring Microsoft Excel 2013 New Features)

SkillsFuture Credit

IT032C** : Exploring Microsoft Excel 2013 New Features

14.00 CPE Hours (Others)
Classroom

Important

If you wish to disburse your SkillsFuture Credit to ISCA, please login to SkillsFuture Credit (SFC) portal (http://www.skillsfuture.sg/credit) with your Singpass within 60 days before the course start date to submit the SkillsFuture Credit Claim and obtain the necessary approval. For more information on SFC procedure, please click here.
 
Failure to submit claim application via SkillsFuture Portal and obtain necessary approval before the course start date will result in an administrative fee of $42.80 levied to revise the invoice based on the amount of SkillsFuture Credit you have indicated to use.


Notice

With effect from 2018, the course outlines will be revised to include Excel 2016 functionality and features. Please click here to view the 2018 outlines and dates.
 
Our Computer lab and software will be upgraded to support Excel 2016 to ensure a greater learning experience for our participants. Participants may bring along their personal laptop if they prefer to practise the hand-on exercises using Excel 2013.
 
Programme Objective

Microsoft Excel 2013 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 Power View, Flash Fill, Quick Analysis, Timelines 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 the Microsoft Excel 2013 data analysis and reporting tools.

Programme Outline

  • Introducing Excel 2013 New Features
  • Flash fill
  • Quick Analysis
  • Recommended Charts
  • New Chart Formatting Tools
  • Enhanced Chart Labels
  • Slicer filter for table
  • Table Relationships
  • Separate Workbook Windows
  • Recommended PivotTables
  • Timeline filter for PivotTable
  • Excel Apps
  • Power View
  • Power Map2. Customizing Excel 2013 Program Window
  • Customizing Quick Access Toolbar
  • Customizing the Ribbon
  • Resetting Customizations
  • Changing Excel Options
  • Using New Excel Templates
  • Downloading On-line Templates
  • Creating Custom Templates3. Cleaning Data with Flash Fill
  • Splitting text into multiple columns 
  • Combining text from multiple columns
  • Changing text cases
  • Formatting numbers and dates4. Analyzing Data with Quick Analysis
  • Highlighting data with Conditional Formatting
  • Visualizing data with Recommended Charts
  • Calculating Totals automatically
  • Summarizing data with Tables
  • Creating in-cell mini charts with Sparklines 5. Visualizing Data with Charts
  • Using  Recommended Charts
  • Creating Other Charts
  • Using The Chart Tools
  • Creating Combo Chart
  • Using Enhance Chart Labels
  • Creating Dynamic Chart Labels
  • Formatting Chart Axis6. Summarizing Data with Excel Table
  • Converting data range into Excel Table
  • Formatting Excel Table
  • Sorting Table data
  • Filtering Data with Slicer
  • Adding Calculated Columns
  • Applying Conditional Formatting to Table data
  • Sorting Table Data by Color
  • Filtering Table Data by Color
  • Managing Conditional Formatting Rules
  • Creating relationship between two tables7. Analyzing Data with PivotTables
  • Using Recommended PivotTables Tool
  • Creating PivotTable from related tables
  • Changing Functions in PivotTable
  • Using Labels Filter and Values Filter
  • Using Slicer Filter
  • Connecting Multiple PivotTables with Slicers
  • Using Timeline filter
  • Connecting Multiple PivotTables with Timelines8. Visualizing Data with PivotCharts
  • Creating PivotChart from External Data
  • Creating PivotChart from Excel Table
  • Formatting PivotCharts
  • Using the PivotChart Tools9. Creating Power View Reports
  • Creating Table in Power View
  • Applying filters in Power View
  • Using Visualizations in Power View
  • Using Map in Power View
  • Customizing Map in Power View 10. Using Microsoft Power Map
  • Installing Power Map
  • Creating Power Map
  • Customizing Power Map
  • Exploring Data in Power Map Tour
  • Launching and Closing Power Map11. Case Study
To view our full list of Infocomm courses, please click here.

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 2013. 

Competency Mapping

Others = 14.00 Hours

Schedule & Fees

Date & Time

07 Nov 2016 (9:00 AM - 5:00 PM)
08 Nov 2016 (9:00 AM - 5:00 PM)

Registration is closed

Programme Facilitator(s)

Valene Ang

Date & Time

04 Jul 2016 (9:00 AM - 5:00 PM)
05 Jul 2016 (9:00 AM - 5:00 PM)

Registration is closed

Programme Facilitator(s)

Valene Ang
Valene Ang

Date & Time

30 Mar 2016 (9:00 AM - 5:00 PM)
31 Mar 2016 (9:00 AM - 5:00 PM)

Registration is closed

Programme Facilitator(s)

Valene Ang
Valene Ang

Testimonial

Funding

1] SkillsFuture Credit
All Singaporeans aged 25 and above will receive an opening credit of S$500 from January 2016. The SkillsFuture credit will not expire and the government will provide periodic top-ups. You may accumulate your credit and use your credit to pay for or offset skills related course fees by applying for claim(s) starting January 2016. For more details about this scheme and submission on SkillsFuture claim, please visit http://www.skillsfuture.sg/credit.

Please note that if you wish to disburse your SkillsFuture Credit to ISCA and did not login to SkillsFuture Credit portal (http://www.skillsfuture.sg/credit) via Singpass, one day before the start of your course, to submit an application and obtain the approval, an administrative fee of $42.80 will be levied to revise your invoice based on the amount of SkillsFuture Credit you wish to use.

2] SDF Funding
This course is approved for SDF funding - For Company-sponsored participants only (eligibility criteria apply). SDF Funding amount is $2 per training hour.

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.

Important

If you wish to disburse your SkillsFuture Credit to ISCA, please login to SkillsFuture Credit (SFC) portal (http://www.skillsfuture.sg/credit) with your Singpass within 60 days before the course start date to submit the SkillsFuture Credit Claim and obtain the necessary approval. For more information on SFC procedure, please click here.
 
Failure to submit claim application via SkillsFuture Portal and obtain necessary approval before the course start date will result in an administrative fee of $42.80 levied to revise the invoice based on the amount of SkillsFuture Credit you have indicated to use.


Notice

With effect from 2018, the course outlines will be revised to include Excel 2016 functionality and features. Please click here to view the 2018 outlines and dates.
 
Our Computer lab and software will be upgraded to support Excel 2016 to ensure a greater learning experience for our participants. Participants may bring along their personal laptop if they prefer to practise the hand-on exercises using Excel 2013.
 
Programme Objective

Microsoft Excel 2013 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 Power View, Flash Fill, Quick Analysis, Timelines 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 the Microsoft Excel 2013 data analysis and reporting tools.

Programme Outline

  • Introducing Excel 2013 New Features
  • Flash fill
  • Quick Analysis
  • Recommended Charts
  • New Chart Formatting Tools
  • Enhanced Chart Labels
  • Slicer filter for table
  • Table Relationships
  • Separate Workbook Windows
  • Recommended PivotTables
  • Timeline filter for PivotTable
  • Excel Apps
  • Power View
  • Power Map2. Customizing Excel 2013 Program Window
  • Customizing Quick Access Toolbar
  • Customizing the Ribbon
  • Resetting Customizations
  • Changing Excel Options
  • Using New Excel Templates
  • Downloading On-line Templates
  • Creating Custom Templates3. Cleaning Data with Flash Fill
  • Splitting text into multiple columns 
  • Combining text from multiple columns
  • Changing text cases
  • Formatting numbers and dates4. Analyzing Data with Quick Analysis
  • Highlighting data with Conditional Formatting
  • Visualizing data with Recommended Charts
  • Calculating Totals automatically
  • Summarizing data with Tables
  • Creating in-cell mini charts with Sparklines 5. Visualizing Data with Charts
  • Using  Recommended Charts
  • Creating Other Charts
  • Using The Chart Tools
  • Creating Combo Chart
  • Using Enhance Chart Labels
  • Creating Dynamic Chart Labels
  • Formatting Chart Axis6. Summarizing Data with Excel Table
  • Converting data range into Excel Table
  • Formatting Excel Table
  • Sorting Table data
  • Filtering Data with Slicer
  • Adding Calculated Columns
  • Applying Conditional Formatting to Table data
  • Sorting Table Data by Color
  • Filtering Table Data by Color
  • Managing Conditional Formatting Rules
  • Creating relationship between two tables7. Analyzing Data with PivotTables
  • Using Recommended PivotTables Tool
  • Creating PivotTable from related tables
  • Changing Functions in PivotTable
  • Using Labels Filter and Values Filter
  • Using Slicer Filter
  • Connecting Multiple PivotTables with Slicers
  • Using Timeline filter
  • Connecting Multiple PivotTables with Timelines8. Visualizing Data with PivotCharts
  • Creating PivotChart from External Data
  • Creating PivotChart from Excel Table
  • Formatting PivotCharts
  • Using the PivotChart Tools9. Creating Power View Reports
  • Creating Table in Power View
  • Applying filters in Power View
  • Using Visualizations in Power View
  • Using Map in Power View
  • Customizing Map in Power View 10. Using Microsoft Power Map
  • Installing Power Map
  • Creating Power Map
  • Customizing Power Map
  • Exploring Data in Power Map Tour
  • Launching and Closing Power Map11. Case Study
To view our full list of Infocomm courses, please click here.

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 2013. 

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

07 Nov 2016 (9:00 AM - 5:00 PM)
08 Nov 2016 (9:00 AM - 5:00 PM)

Fee (inclusive of GST)

For Members: $ 647.35
For Non-Members: $ 770.40

Programme Facilitator(s)

Valene Ang

Venue

60 Cecil Street
ISCA House
Singapore 049709