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 ObjectivePivotTable for Excel 2010 is the most powerful and versatile reporting tool that enables you to extract information easily from large amount of raw data and transform them into meaningful report. PivotTable is extremely user friendly in that you can look at the same data in different ways by moving or pivoting fields of data from one area to another using drag and drop. The new Slicer feature is an easy-to-use filtering component that allows you to quickly filter the data in a PivotTable report with just a mouse click. This 2-days workshop will equip the participants with the essential skills to prepare the raw data for PivotTable, create dynamic PivotTables and PivotCharts reports, layout and format the PivotTable Report, as well as build up an interactive and informative report. Being able to analyze the raw data in your worksheet effectively and build interactive reports from the data can help you make better business decisions and increase your productivity. The participants will have chance to try out a few case studies based on real-world problems.
1. Introducing PivotTables and PivotCharts Overview of the PivotTableExploring PivotTable Features Understanding PivotTable LimitationsOverview of the PivotChartExploring PivotChart FeaturesUnderstanding PivotChart LimitationsFormatting Source Data as Excel Table 2. Creating PivotTables from Local Data Creating PivotTable from a Data RangeCreating PivotTable from an Excel TableEnable Classic PivotTable LayoutCreating PivotTable from Existing PivotTableCopying PivotTable with Paste SpecialRefreshing PivotTable Data ManuallyRefreshing PivotTable When Open FileProtecting PivotTable 3. Manipulating PivotTable Fields Changing Order of FieldsChanging Report layoutRepeating Item LabelsShowing or Hiding SubtotalsShowing or Hiding Grand TotalsDisplaying Details of PivotTable DataDeleting PivotTable 4. Formatting PivotTables Applying PivotTable StylesChanging PivotTable Style OptionsApplying Number FormatApplying Date FormatCreating Custom Formats 5. Filtering PivotTable Data Filtering PivotTable with Report FilterChanging Report Filter LayoutFiltering PivotTable with Label FiltersFiltering PivotTable with Value FiltersFiltering Multiple Items with Search BoxExtracting Records to another Worksheet 6. Sorting and Grouping PivotTable Fields Sorting PivotTable AutomaticallySorting PivotTable ManuallyGrouping Date Items AutomaticallyGrouping Number Items AutomaticallyShowing or Hiding Group DetailsGrouping Text Items ManuallyDisplaying Subtotals for the Groups 7. Using Color Visualizations Applying Conditional FormatsManaging Conditional Formatting RulesSorting Data by ColorFiltering Data by ColorCreating and Customizing Sparklines Removing Sparklines 8. Performing Calculations Summarizing Values with FunctionsRenaming Row and Column LabelsShowing Values as PercentageSpecifying Characters for Empty CellsCalculating Running TotalCalculating DifferenceRanking Values within a Field 9. Creating Custom Calculations Understanding Calculation LimitationsCreating Calculated ItemsCreating Calculated FieldsListing Custom Formulas Removing Custom CalculationsCreating Formulas Outside PivotTable 10. Creating PivotCharts Creating PivotChart from Excel TableCreating PivotChart from Existing PivotTableChanging PivotChart TypesCustomizing PivotChart ElementsFormatting PivotChartDeleting PivotChart 11. Creating Reports from External Data Creating PivotTable from Text FileCreating PivotTable Report from Access Creating PivotTable Report from Other SourcesCreating PivotChart Report from Access Refreshing PivotTable AutomaticallySetting External Data Properties 12. Creating Interactive Report Creating PivotTable and PivotChart ReportMoving PivotChart to another WorksheetRemoving Field Buttons from PivotChartChanging PivotChart Size and AlignmentLinking PivotChart Label to a CellConnecting a Slicer to a PivotTableCustomizing and Formatting Slicer Connecting a Slicer to Multiple PivotTables 13. Case StudyTo view our full list of Infocomm courses, please click here. Training MethodologyLecture style, with hands-on exercises
1. Introducing PivotTables and PivotCharts
2. Creating PivotTables from Local Data
Training MethodologyLecture style, with hands-on exercises
This intermediate level workshop is for all existing Microsoft Excel users who intend to create effective and dynamic business reports using PivotTable and PivotChart. The participants must know how to build a simple PivotTable. This course is NOT for beginners who are not familiar with Excel commands and those who seldom use Excel program.
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)