SkillsFuture Credit
ImportantIf 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.NoticeWith 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 ObjectiveMicrosoft 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.
Introducing Excel 2013 New FeaturesFlash fillQuick AnalysisRecommended ChartsNew Chart Formatting ToolsEnhanced Chart LabelsSlicer filter for tableTable RelationshipsSeparate Workbook WindowsRecommended PivotTablesTimeline filter for PivotTableExcel AppsPower ViewPower Map2. Customizing Excel 2013 Program WindowCustomizing Quick Access ToolbarCustomizing the RibbonResetting CustomizationsChanging Excel OptionsUsing New Excel TemplatesDownloading On-line TemplatesCreating Custom Templates3. Cleaning Data with Flash FillSplitting text into multiple columns Combining text from multiple columnsChanging text casesFormatting numbers and dates4. Analyzing Data with Quick AnalysisHighlighting data with Conditional FormattingVisualizing data with Recommended ChartsCalculating Totals automaticallySummarizing data with TablesCreating in-cell mini charts with Sparklines 5. Visualizing Data with ChartsUsing Recommended ChartsCreating Other ChartsUsing The Chart ToolsCreating Combo ChartUsing Enhance Chart LabelsCreating Dynamic Chart LabelsFormatting Chart Axis6. Summarizing Data with Excel TableConverting data range into Excel TableFormatting Excel TableSorting Table dataFiltering Data with SlicerAdding Calculated ColumnsApplying Conditional Formatting to Table dataSorting Table Data by ColorFiltering Table Data by ColorManaging Conditional Formatting RulesCreating relationship between two tables7. Analyzing Data with PivotTablesUsing Recommended PivotTables ToolCreating PivotTable from related tablesChanging Functions in PivotTableUsing Labels Filter and Values FilterUsing Slicer FilterConnecting Multiple PivotTables with SlicersUsing Timeline filterConnecting Multiple PivotTables with Timelines8. Visualizing Data with PivotChartsCreating PivotChart from External DataCreating PivotChart from Excel TableFormatting PivotChartsUsing the PivotChart Tools9. Creating Power View ReportsCreating Table in Power ViewApplying filters in Power ViewUsing Visualizations in Power ViewUsing Map in Power ViewCustomizing Map in Power View 10. Using Microsoft Power MapInstalling Power MapCreating Power MapCustomizing Power MapExploring Data in Power Map TourLaunching and Closing Power Map11. Case Study To view our full list of Infocomm courses, please click here.Training MethodologyLecture style, with hands-on exercises Closing Date for Registration1 week before programme or until full enrolment.
This workshop is for all existing Microsoft Excel users who intend to learn the powerful new features in Microsoft Excel 2013.
You are about to leave ISCA eServices Portal and the registration link will be opened in a new tab. Do you wish to continue?
This course has been added successfully
Declaration to be provided by CPE
This Course is Intended for CA Singapore Users..
If you have an account with us, please sign-in first. If you do not have an account with us, create one now for free.
Do you wish to apply for SFC funding? (Singapore Citizenship Only)