Microsoft Excel Training - Excel Tables and Pivot Tables - Philippines

Harness the power of Pivot Tables and Excel analysis tools for comprehensive data management

Courses are delivered remotely by our experienced Microsoft Certified Trainers. 

Enhance your Excel proficiency with our Excel Tables and Pivot Tables course. This one-day workshop is meticulously designed for corporate professionals aiming to harness the full potential of Excel’s Pivot Tables and key analysis tools for data modelling and manipulation. Learn to create and filter PivotTable reports and charts, handle large data sets efficiently, summarise complex data, and ensure data accuracy through validation. This course equips you with the critical skills needed to excel in today's data-driven corporate environment.

Microsoft Excel Training - Excel Tables and Pivot Tables - Philippines

Become an Excel Data Wizard in just one day. Learn Pivot Table analysis, data consolidation, and visualisation techniques to master data reporting.

₱ 23,200
10 max
1 day
₱ 23,200
10 max
1 day

Manila

Remote PH

Upcoming Courses:
Manila

We currently have no public courses scheduled. Please contact us to register your interest.

Remote PH

We currently have no public courses scheduled. Please contact us to register your interest.

Scheduled
Taking enrollments.
Confirmed
Taking enrollments.
Few Seats left
Book Now.
Sold Out
Try another date.

Excel Excel Tables and Pivot Tables Philippines Course Details

Price
₱ 23,200
Duration
1 day
Times
9am-4pm
Class Size (max)
8
Class Size (avg)
6
Reference Materials
Provided
CPD Hours
6 hours
Delivery
Instructor-led training
Live Online
Address
Remote Classes
N/A
microsoft_gold
deloite_logo

Excel Excel Tables and Pivot Tables Philippines Course Details

Price
₱ 23,200
Duration
1 day
Times
9am-4pm
Class Size (max)
8
Class Size (avg)
6
Reference Materials
Provided
CPD Hours
6 hours
Delivery
Instructor-led training
Live Online
Address
Lumify Philippines
17F SM Aura Tower
Bonifacio Global City
Taguig
1630
Philippines
microsoft_gold
deloite_logo

Excel Course Outlines

  • Excel Beginner
    ₱ 18,200
  • Excel Intermediate
    ₱ 19,400
  • Excel Advanced
    ₱ 19,600
  • Excel Expert
    ₱ 22,500
  • Excel Tables and Pivot Tables
    ₱ 23,200
  • Excel Macro Mastery
    ₱ 16,700
  • MO-201 Excel Certification

Skills Test

Try our short skills test and find out

which course is right for you.

Nexacu Skills Test

 skills test

 

Contact Us


What do I need to know to attend?

To get the most out of this course, you should have successfully completed the Excel Essentials course and/or the Excel Intermediate course, or have equivalent skills and knowledge. Understanding Named Ranges would be advantageous.

Excel Excel Tables and Pivot Tables Philippines Learning Outcomes

You will learn how to:

  • Create and filter PivotTable reports to analyse data
  • Create and manipulate PivotTable charts for graphical data representation
  • Use sort and filter features to efficiently analyse large data sets
  • Work with Excel tables to summarise and manage data
  • Consolidate data into comprehensive reports using Data Consolidation
  • Use Data Validation to control and ensure accurate data inpu

Excel Excel Tables and Pivot Tables Philippines Course Content

  • Introduction to PivotTables
  • Creating and modifying PivotTable reports
  • Analysing data using PivotTables
  • Grouping field items for better data organisation
  • Building a PivotTable based on an Excel Table
  • Displaying and understanding source data in PivotTables
  • Filtering and sorting labels and data
  • Using Slicers and Timelines for advanced filtering
  • Smart Charting Techniques
  • Creating and modifying PivotCharts for data visualisation
  • Adding a secondary axis and trendlines for enhanced analysis
  • Outlining Data
  • Using the Outline feature to summarise large worksheets
  • Displaying only the necessary totals for clear data presentation
  • Sort and Filter Table Data
  • Sorting data using AutoFilter buttons or the Sort dialog box
  • Creating and applying Custom filters for specific data views
  • Subtotalling filtered lists for better data understanding
  • Working with Excel Tables
  • Understanding formatting and management with Excel Tables
  • Filtering data with Slicers for quick insights
  • Deleting duplicates using Conditional Formatting for data accuracy
  • Data Validation
  • Controlling data entry using Data Validation rules
  • Setting up various data validation settings for consistent data entry
  • Creating input and error messages to guide users
  • Circling and clearing invalid data entries in Excel
  • Locking cells with data validation to protect data integrity

Contact Us

Why Nexacu? 

Valued by Individuals

4.72 / 5
Over 77046 Reviews

Trusted by Business

Awards and Accreditations

Follow us