Course Description

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.

Course Objectives

At the end of this course, you should be able to:

Create and work with Access Table and Fields. Understand field properties indexing a field and adding a primary key to the table

Build PivotTables from single or multiple data sources

Add calculated fields filter your results

Add calculated fields, filter your results

Create and Use forms to make it easier to view access and input data

Format your layout to make it more readable.

Create and work with Access Table and Fields. Understand field properties indexing a field and adding a primary key to the table

Build PivotTables from single or multiple data sources

Add calculated fields filter your results

Add calculated fields, filter your results

Create and Use forms to make it easier to view access and input data

Format your layout to make it more readable.

Course Outline

You will be learning the following:

  • 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
  • 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)
  • Grouping fields
  • Sorting and filtering PivotTable data
  • Refreshing PivotTable
  • Formatting the PivotTable
  • Summarizing PivotTable Data

Course Fees And Grants

S$302.40 per participant (Incl. 8% GST)

 

Click here for UTAP Fundings

 

SDF Subsidy for Company Sponsored Individuals:

Applicants may use SkillsFuture Credit for this course

 

SKILLSFUTURE CREDIT
> Check your account

Absentees will be charged the full course fee.

Course Schedule

CourseCodeVenueJun-23Jul-23Aug-23Sep-23Oct-23Nov-23Dec-23
Advanced Pivot Table Techniques in Microsoft ExcelTGS-2020503212JTC Summit-13-15-08-
TGS-2020503212Mountbatten Square23-16-18-20

Registration

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

Our Corporate Partners

What Our Students Say

COURSE FEES AND GRANTS

S$302.40 per participant (Incl. 8% GST)

 

Click here for UTAP Fundings

 

SDF Subsidy for Company Sponsored Individuals:

Applicants may use SkillsFuture Credit for this course

 

SKILLSFUTURE CREDIT
> Check your account

Absentees will be charged the full course fee.

REGISTRATION

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

ASK Training