​

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. This course shows you how to navigate the complexity of PivotTables while taking advantage of their power. You will learn how 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

Course Objective:

  • Preparing data source to use in Pivot Table
  • Creating a PivotTable
  • Get data from external source
  • Summarizing multiple data fields
  • Managing subtotals and grand totals
  • Grouping PivotTable fields
  • Filtering with selections, rules, search filters, slicers, and timeline
  • Applying PivotTable styles
  • Formatting cells with conditional formatting
  • Show different calculations in PivotTable value fields
  • Create calculated fields using formulas
  • Create calculated items with combine fields
  • Creating PivotCharts

  • Course Dates and Venue

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

    CourseVenueJul-20Aug-20Sep-20Oct-20Nov-20Dec-20
    Advanced Pivot Table Techniques in Microsoft ExcelJTC Summit15-16-18-
    Mountbatten Square-06-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
    • Using external data source in PivotTable
    • About PivotTable Fields Pane
    • About PivotTable structure
    • Building up the PivotTable
    • Pivoting the PivotTable
    • 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
    • Calculation in PivotTable
      • Calculated field
      • Calculated Item
      • Calculations in Show Value As
    • 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.

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