Subscribe e-Newsletter
    Member Login
    Course Information
    Email
    Pass
    Forget password? Click here
    Event Profile
    Date Oct 25, 2017
    Time 9:00am to 5:00pm
    Venue Mandarin Orchard Singapore
    333 Orchard Road
    Singapore 238867
    Fee SGD 395.00
    For Member
    SGD 375.25
    NoteBreakfast, two tea breaks and buffet lunch will be served; complimentary car parking coupon will be provided upon request
    Other Date(s)1) Jan 30, 2018
    2) Apr 16, 2018
    3) Jul 30, 2018
    4) Oct 17, 2018
    Trainer
    Activity
    You may reach us via
    T: (65) 9879 6267
    E: info@ccisg.com
    To register via fax, fill in This Form and fax to (65) 6310 5430.
    PivotTable and PivotChart are the most powerful and versatile reporting tool in Excel that enables you to retrieve information easily from large amounts of data in many user-friendly ways and transform them into meaningful reports. A PivotTable report is useful to summarize, analyze, explore, and present summary data whereas a PivotChart report can help you visualize PivotTable report summary data so that you can easily see comparisons, patterns, and trends. Both PivotTable and PivotChart reports enable you to make sound decisions about critical data in your organization

    Participants should bring a laptop with Microsoft Excel 2013 / 2016
    Objective
    This course will equip participants with knowledge and essential skills they need for creating interactive PivotTable and PivotChart reports. Participants will learn how to use Excel PivotTable report features more effectively and wisely to improve their productivity.
    Outline
    Chapter 1: Building PivotTable Reports
    1.1 Introducing PivotTable and PivotChart
    1.2 Creating PivotTable from Excel Table
    1.3 Adding New Record to PivotTable
    1.4 Refreshing PivotTable Data
    1.5 Using Microsoft Query Wizard

    Chapter 2: Customizing PivotTable
    2.1 Adjusting Report Layout
    2.2 Applying PivotTable Styles
    2.3 Formatting Numbers in PivotTable
    2.4 Displaying Zero for Empty Cells

    Chapter 3: Performing Custom Calculations
    3.1 Summarizing Values with Functions
    3.2 Creating Percentage Calculation
    3.3 Creating Difference Summary Calculation
    3.4 Creating Running Total Calculation

    Chapter 4: Sorting and Filtering PivotTable Data
    4.1 Sort PivotTable Data Automatically
    4.2 Sort PivotTable Data Manually
    4.3 Filtering Data with Report Filter
    4.4 Filtering Data with Label Filters
    4.5 Filtering Data with Values Filters
    4.6 Filtering Data with Slicer
    4.7 Connecting Slicer to Multiple PivotTables
    4.8 Filtering Data with Timeline

    Chapter 5: Grouping Fields in PivotTable
    5.1 Grouping Dates Field Automatically
    5.2 Grouping Number Field Automatically
    5.3 Grouping Text Field Manually

    Chapter 6: Creating Custom Formulas
    6.1 Creating Calculated Field
    6.2 Creating Calculated Items
    6.3 Group Items Manually
    6.4 Turn Off Grand Totals
    6.5 Show Subtotal Automatically

    Chapter 7: Building PivotChart Reports
    7.1 Building PivotChart from a PivotTable
    7.2 Building PivotChart from Excel Table
    7.3 Building PivotChart from Ms Access Data
    7.4 Using PivotChart Tools

    Chapter 8: Customizing and Formatting PivotChart
    8.1 Hiding and Showing Field Buttons
    8.2 Adding and Removing Labels
    8.3 Changing PivotChart Styles and Layouts
    8.4 Changing Legend Position
    8.5 Formatting PivotChart Category Axis
    8.6 Formatting PivotChart Values Axis
    8.7 Creating Dynamic Labels

    Chapter 9: Creating Dynamic PivotTable Driven Report
    9.1 Converting Data Source to Excel Table
    9.2 Creating PivotChart from Excel Table
    9.3 Creating PivotTable from another PivotTable
    9.4 Formatting Number in PivotTables
    9.5 Moving PivotChart to another Worksheet
    9.6 Creating Slicer and Timeline for PivotChart
    9.7 Connecting Slicer to Multiple PivotCharts
    9.8 Formatting the Report
    Who should attend
    • This Intermediate to Advanced level course is for frequent Excel users who wish to learn how to increase their productivity in daily work with dynamic PivotTable and PivotChart reports.
    • Participants must have some working experience using Excel PivotTable.
    Testimonials
    "I get to learn some important tips which will definately increase productivity at my work"
    Agency for Integrated Care Pte Ltd

    "trainer is with knowledge of the subject."
    Stahl Asia Pacific Pte Ltd

    "Trainer is interactive with the group."
    Breadtalk Pte Ltd
    Valene Ang's Profile
    Valene Ang is a Microsoft Certified Trainer, ACTA Certified Trainer and Master Instructor of Microsoft Office Specialist (MOS). She has over 17 years’ experience in corporate IT training and course material development. Her corporate clients include NOL, PSA, IRAS, DFS, CPF, PUB, MOM, MOE, NEA, SingTel, Canadian High Commission, British High Commission, Temasek Polytechnic, Republic Polytechnic and etc...
    Valene has a broad experience in customizing Microsoft Office training programs, developing customized course outline and course material, assisting corporate clients in business data analysis and providing dynamic report solutions. She had conducted many Microsoft Office seminars and workshops in Singapore and Malaysia. Her training focuses on providing practical solutions to real life Excel problems.
    Privacy Policy  |  Terms of Use
    Copyright © 2017 CCISG Pte Ltd  |  ACRA Reg No: 201207591D