​

Advanced Pivot Table Techniques in Microsoft Excel New

Course Code: ASKEP8

Advanced Pivot Table Techniques in Microsoft Excel

Course Objective – Advanced Pivot Table Techniques in Microsoft Excel

Excel’s most powerful analytical tool is the PivotTable. In this course, you’ll be taught how to leverage PivotTables to summarize, sort, count, and chart your data in Microsoft Excel. You will also learn how to navigate the complexity of PivotTables to take advantage of their power. By the end of the course, you will be able to build PivotTables from single or multiple data sources, add calculated fields, filter your results, and format your layout to make it more readable.

Advanced Pivot Table Techniques in Microsoft Excel

At the end of the 1 day course, you will learn to:-

  • Prepare data source and create a PivotTable
  • Summarize multiple data fields, Manage subtotals and grand totals,
  • Create Grouping of PivotTable fields
  • Perform filter with selections, rules, search filters, slicers, and timeline
  • Apply PivotTable styles and format cells with conditional formatting
  • Show different calculations in PivotTable value fields
  • Create calculated fields using formulas and create calculated items with combine fields
  • Create PivotCharts

  • Course Dates and Venue

    Course Duration: 1 days (8 hours) 9am – 5pm

    CourseVenueAug-20Sep-20Oct-20Nov-20Dec-20
    Advanced Pivot Table Techniques in Microsoft ExcelJTC Summit-16-18-
    Mountbatten Square06-29-30

    September 2015

    SMTWTFS
    30
    31
    1
    2
    3
    4
    5
    6
    7
    8
    9
    10
    11
    12
    13
    14
    15
    16
    17
    18
    19
    20
    21
    22
    23
    24
    25
    26
    27
    28
    29
    30
    1
    2
    3

  • Introduction to PivotTable

    • Preparing data source to be use in PivotTable
    • Creating the PivotTable and Using external data source in PivotTable
    • Understand PivotTable Fields Pane and Structure
    • Building up the PivotTable and Pivoting it
    • Show report filter pages
    • Removing field from the PivotTable

    Managing PivotTable

    • Grouping fields
    • Sorting and filtering PivotTable data
    • Refreshing PivotTable
    • Formatting the PivotTable
    • Summarizing PivotTable Data

    Working with PivotChart

    • Printing PivotTables & PivotChart
    • Grouping problem and solution
    • Create Calculated field and Items in PivotTable
    • Converting a crosstab data into normal data list (optional)
    • Using multiple source data (optional)

  • Who should attend:

    • People who wants to learn how to create Pivot Table in a proper way
    • People who wants to go beyond the basic Pivot Table like using formula to create calculated fields
    • People who wants to summarize their data in different ways
    • People who wants to generate more reports which is hard to achieve in normal spreadsheet
    • People who wants to generate chart that can be change easily using Pivot Table

    Pre-requisite:

    • Must have attended Excel Basic or has been using Excel for the past three years continuously
    • Must know how to use Excel basic functions
    • Basic knowledge on Excel chart
Download Course PDF

Fees and Grants

$299.60 per participant (Inc. GST)

Click here for UTAP Fundings

SDF subsidy: WSQ Courses. For more information on SDF, please refer to www.skillsconnect.gov.sg > Funding Mechanism.

Registration

Click here to download registration form.

For Organisations on HRMS Learning Hub, you are strongly encouraged to use this platform for registration.

Apply Online

Apply Online

Advanced Pivot Table Techniques in Microsoft Excel (ASKEP8)

All registration should be submitted at least 1 week before course commencement. Please call us directly to check on the class status.

A. Company Particulars

Company Name*

Company Address*

Postal Code*

B. Training Coordinator / Contact Person

TC / Contact Person Name*

TC / Contact Person Email*

Contact Number*

Fax Number

C. Billing Information


Billing Contact Person Name*

Billing Contact Person Email*

Billing Contact Number*

Billing Fax Number

Business Unit (BU / SBU)

For Businesses or Government Agencies using the e-invoice system only.

Are you applying for SDF Grant?

Applicable to some select IT and Softskills Courses.

How did you get to hear about us?*

D. Participants

Participant 1*

Course Start Date*

Course End Date*

Participant 2

Course Start Date*

Course End Date*

Participant 3

Course Start Date*

Course End Date*

Have more than 3 participants?

Attach their particulars here (PDF, Word .doc, Excel .xls)

I have Read and Agree to the Terms and Conditions


We do not sell or share your information with anyone else.

Share this course

en English
zh-CN Chinese (Simplified)en Englishms Malay