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. 

Programme Facilitator(s)