Subscribe e-Newsletter
    Member Login
    Course Information
    Forget password? Click here
    Event Profile
    Date Jul 26, 2018
    Time 9:00am to 5:00pm
    Venue Mandarin Orchard Singapore
    333 Orchard Road
    Singapore 238867
    7% GST will apply
    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) Jun 19, 2019
    2) Sep 30, 2019
    3) Dec 18, 2019
    You may reach us via
    T: (65) 9879 6267
    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
    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.
    Chapter 1: Building PivotTable Reports
    1.1 Introducing PivotTable and PivotChart
    1.2 Creating PivotTable from Excel Table
    1.3 Using Microsoft Query Wizard
    1.4 Refreshing PivotTable Data
    1.5 Adjusting Report Layout
    1.6 Formatting PivotTable
    1.7 Formatting Numbers in PivotTable

    Chapter 2: Performing Custom Calculations
    2.1 Summarizing Values with Functions
    2.2 Creating Difference Summary Calculation
    2.3 Creating Percentage Calculation
    2.4 Creating Running Total Calculation
    2.5 Creating Calculated Field
    2.6 Creating Calculated Items

    Chapter 3: Sorting and Filtering PivotTable Data
    3.1 Sort PivotTable Data Automatically
    3.2 Sort PivotTable Data Manually
    3.3 Filtering Data with Report Filter
    3.4 Filtering Data with Label Filters
    3.5 Filtering Data with Values Filters
    3.6 Filtering Data with Slicer
    3.7 Connecting Slicer to Multiple PivotTables
    3.8 Filtering Data with Timeline

    Chapter 4: Grouping Fields in PivotTable
    4.1 Grouping Dates Field Automatically
    4.2 Grouping Number Field Automatically
    4.3 Grouping Text Field Manually

    Chapter 5: Building PivotChart Reports
    5.1 Building PivotChart from a PivotTable
    5.2 Building PivotChart from Excel Table
    5.3 Changing Legend Position
    5.4 Hiding and Showing Field Buttons
    5.5 Adding and Removing Data Labels
    5.6 Changing PivotChart Styles
    5.7 Formatting PivotChart Axis
    5.8 Creating Dynamic Labels

    Chapter 6: Creating Dynamic PivotTable Driven Report
    6.1 Building Dashboard with PivotCharts
    6.2 Converting Data Source to Excel Table
    6.3 Creating PivotChart
    6.4 Filtering Data in PivotTable
    6.5 Sorting Values in PivotTable
    6.6 Customizing the PivotChart
    6.7 Creating a PivotTable from another PivotTable
    6.8 Creating and Formatting Slicer
    6.9 Connecting PivotTable Report
    6.10 Creating and Formatting Timeline
    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.
    "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 (MCT) with a degree in Business Computing. Her Professional qualifications including Advanced Certificate in Training and Assessment (ACTA) and Master Instructor for Microsoft Office Specialist (MOS). She has more than 19 years of experience in corporate IT training and course materials development.

    Valene has a broad experience in customizing Microsoft Office training programs, developing customized course outlines and course materials, assisting corporate clients in business data analysis and providing dynamic report solutions. Her training focuses on providing practical solutions to real life Excel problems.

    Valene conducted many Microsoft Office training in Singapore, Malaysia and China. Her corporate clients include NOL, PSA, IRAS, DFS, CPF, PUB, MOM, MOE, NEA, DHL, SingTel, Singapore Expo, Changi Airport Group, SPRING Singapore, Nanyang Polytechnic, Singapore Polytechnic, Republic Polytechnic, Denza (ShenZhen) and etc...
    Privacy Policy  |  Terms of Use
    Copyright © 2019 CCISG Pte Ltd  |  ACRA Reg No: 201207591D  |  GST Reg No: 201207591D