Excel: Pivot Tables and Pivot Charts (Custom edition)
Excel: Pivot Tables and Pivot Charts (Custom edition)
This course on Excel Pivot Tables and Charts will provide you with the skills to create and manage pivot tables efficiently. You will start with an introduction to pivot tables, including their definition and creation. You will learn to group data by text, date, and numeric fields, and to use data slicers. You will also explore pivot table styles and calculations in value fields. Finally, you will discover how to create pivot charts and use Power Pivot.
Specific goals | Temary
NOTE: This is a customized edition for a specific organization. Please check the website for other editions of the same activity open to the general public.
OBJECTIVES
- Master basic and advanced formulas
- Apply effective conditional formatting
- Solve practical problems using Excel
COURSE CONTENT
- Introduction to Pivot Tables
- Definition
- Creating a pivot table
- Parts of a pivot table
- Groupings and Slicers
- Groupings by text, date, and numeric fields
- Data slicers
- Timelines
- Styles, Calculations, and Charts
- Pivot table styles
- Calculations in value fields
- Pivot charts
- Power Pivot
Excel Training Pathway: Pivot Tables and Pivot Charts
- Level 1: Excel Pivot Tables - Online
- Level 2: Excel: Pivot Tables and Charts
Editions
General information
>> In case the format is virtual via streaming, it will be carried out through the free platform Microsoft Teams. Registered individuals will receive the invitation link and access instructions by email before the session starts.
>> Entry to the classroom will not be allowed after 15 minutes once the activity has started.
>> The language in which each session is conducted is informed in the description of each activity.
>> Any of the training actions of Cibernàrium may be recorded through an image capture system that aims to subsequently disseminate them through a medium or support within the scope of the mission of Barcelona Activa to contribute to economic promotion and employment. In the recording process, images of attendees may eventually be recorded. Registration for Cibernàrium activities implies authorization for Barcelona Activa to use these images for the aforementioned purpose.
Trainer's person
FERRER MARTÍNEZ
Personal Data Protection Law
There is a new version of Personal Information Protection law.
Please, accept it before continuing the registration.
