In this Microsoft Excel Data Analysis with Tables and PivotTables Half Day session, attendees will learn how to best model data lists and how to create the extremely powerful Excel Table. You will learn how to apply basic sort orders and complex sort orders and how to filter a Data Table in Excel using various criteria. In order to summarise large data sets, attendees will learn how to use a PivotTable, one of the most powerful analysis tools available in Excel.

We can organize this training at your preferred date and location. Contact Us!

Prerequisites

Create, edit and format spreadsheets
Navigate within worksheets and books
Use Insert Function to create built-in functions

What You Will Learn

Work with data in Excel data tables
Create and manage PivotTables and PivotCharts

Training Outline

Creating Excel Tables

Create and edit Excel Tables
Sort, filter and calculate data

Creating PivotTables and PivotCharts

Create and modify PivotTables
Grouping and Calculated Fields
Applying Filters and Slicers
Creating a PivotChart

Why Choose Bilginç IT Academy

At Bilginç IT Academy, we combine our strong presence in both the UK and Türkiye to deliver high-quality, practical training solutions for organizations worldwide.

International Presence with Local Expertise
With operations in the United Kingdom and Türkiye, we bring together global standards and local market understanding to deliver effective training experiences across regions.

Expert Instructors with Real-World Experience
Our courses are delivered by certified trainers with extensive industry experience, ensuring you gain practical knowledge that can be applied immediately.

Corporate-Focused Training Approach
We specialize in training corporate teams, tailoring our programs to meet your organization’s goals, technologies, and project requirements.

Flexible Training Delivery Worldwide
We offer classroom, virtual classroom, and onsite training options globally, tailored to your organization’s needs.

Hands-On, Practical Learning
Our training sessions include real-world scenarios, case studies, and interactive exercises to ensure lasting understanding and skill development.

Proven Track Record
With over 10 years of experience, we have successfully trained professionals from leading organizations across different industries and regions.

Training Reviews

N. A. - Üretim planlama mühendisi
Havelsan Teknoloji Radar

Rated the training 5 stars.

B. A. - Planlama ve Lojistik Uzmanı
Havelsan Teknoloji Radar

Rated the training 5 stars.

Why have you chosen us?

I have attended a training from Bilginc IT Academy before and I was satisfied.

I have attended a training from a different provider and it was not helpful.

Other

How many employees do you have in your IT department?

0 – 50

50 – 250

250 – 1000

1000+

Avaible Training Dates

Join our public courses in our Saudi Arabia facilities. Private class trainings will be organized at the location of your preference, according to your schedule.

We can organize this training at your preferred date and location.

04 Dhuʻl-Qiʻdah 1447 (3 Hours)
Riyadh, Jeddah, Dammam, Neom

€370 +VAT

16 Dhuʻl-Qiʻdah 1447 (3 Hours)
Riyadh, Jeddah, Dammam, Neom

€370 +VAT

24 Dhuʻl-Qiʻdah 1447 (3 Hours)
Riyadh, Jeddah, Dammam, Neom

€370 +VAT

04 Dhuʻl-Hijjah 1447 (3 Hours)
Riyadh, Jeddah, Dammam, Neom

€370 +VAT

07 Dhuʻl-Hijjah 1447 (3 Hours)
Riyadh, Jeddah, Dammam, Neom

€370 +VAT

17 Dhuʻl-Hijjah 1447 (3 Hours)
Riyadh, Jeddah, Dammam, Neom

€370 +VAT

18 Dhuʻl-Hijjah 1447 (3 Hours)
Riyadh, Jeddah, Dammam, Neom

€370 +VAT

06 Muharram 1448 (3 Hours)
Riyadh, Jeddah, Dammam, Neom

€370 +VAT

Saudi Arabia is currently undergoing one of the most significant digital transformations in modern history under the umbrella of Vision 2030. Riyadh, Jeddah, and the revolutionary smart-city project NEOM are at the forefront of this technological leap, focusing on non-oil economic growth through digital innovation. The Kingdom is investing billions into cloud infrastructure, AI research, and cybersecurity to protect its national interests and support a burgeoning private tech sector. Our educational frameworks in Saudi Arabia are aligned with this national transformation, providing the workforce with essential skills to manage mega-scale digital projects. We empower Saudi professionals to take the lead in building a tech-driven future that honors the Kingdom's heritage while embracing the possibilities of the Fourth Industrial Revolution.

Microsoft Excel Data Analysis with Tables and PivotTables Training in Saudi Arabia

Prerequisites

What You Will Learn

Training Outline

Creating Excel Tables

Creating PivotTables and PivotCharts

Why Choose Bilginç IT Academy

Avaible Training Dates

Other trainings and courses related to the Microsoft Excel Data Analysis with Tables and PivotTables