Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Convierte lo que sabes en una oportunidad y llega a millones de personas de todo el mundo.
Más información
Tu cesta está vacía.
Seguir comprando
Office Fundamentals - PivotTables in Microsoft Excel
Calificación: 4,5 de 5(267 valoraciones)
1138 estudiantes
Última actualización: 3/2022
Inglés

Lo que aprenderás

  • Properly structure raw data for analysis with Pivot
  • Insert and create PivotTables
  • Editing PivotTable fields
  • Analysis and organization of data
  • Sort, filter, and group pivot data
  • Working with values in PivotTables
  • Calculations with calculated fields
  • Create visual representations with PivotCharts & Dashboards

Contenido del curso

7 secciones58 clases5 h 44 m de duración total
  • Welcome to the course!0:58
  • Why PivotTables? What are they good for?2:42

Requisitos

  • A PC
  • Microsoft Excel

Descripción

Pivot tables are a quick and easy way to organize, summarize, and analyze raw data.


In this course, you'll learn everything you need to know about pivot tables to work with them confidently in everyday life.


We start with the absolute basics and then build on that to learn more advanced and complex topics.


We'll talk about formatting, sorting, filtering, grouping, working with values, calculated fields, and pivot charts, and even build our own dashboard to visualize our data and manipulate and customize these charts live.


The course is designed to be hands-on. We will work with an extensive and practical example that will help you follow and understand the subject matter well. 


Our goal with this course is to make your daily work with Excel easier, and pivot tables are ideal for this.


Since pivot tables are a special sub-topic of Microsoft Excel, it is, of course, helpful if you are already familiar with the program. Ideally, you should already know the basics of Excel if you want to work with pivot tables.


We have already helped thousands of people to become office professionals in our courses, and I would be more than happy to welcome you to the course!


¿Para quién es este curso?

  • Excel beginners
  • Advanced Excel users