Today, MS Excel is the most widely used tool in organizations for performing various quantitative analyses. One of the ways to quickly summarize large volumes of data and interpret them easily is by using charts and pivot tables and automating tasks with the Macro Recorder—skills that are required in most companies seeking professionals. With these options, you can view different summaries of the source data and filter them to display different pages or details of specific areas of interest. Likewise, by running macros, these summaries can be automated, making daily work easier.
The course is taught in real time using the ZOOM videoconferencing tool and is supported by the INFOPUC educational platform.

Overall Objective

Upon completion of the workshop, students will be able to:

• Use Pivot Tables in MS Excel to analyze databases.
• Create dynamic charts in MS Excel that reflect changes in input data.
• Create custom charts, tailoring them to different types of presentations.

Thematic Block

1. Pivot Tables
2. Pivot Charts
3. Special Charts
4. Using Macros in Charts and Pivot Tables

Intended for

Students, professionals, and the general public who want to make the most of charts and pivot tables.

Certifications

Certificate: INFOPUCP will issue a digital certificate to participants who earn a passing grade of 11 or higher.
Certificate of Participation: INFOPUCP will issue a certificate of participation to students who earn a grade of 10 or lower and who have participated in all graded course activities.

Economic Investment

General rate: S/ 289.00

Special Discounts

• PUCP community—undergraduate and graduate students, alumni, and staff: S/ 229.00.
• Undergraduate students from other universities: S/ 246.00

Teachers

More information

Similar courses

eXential 2022 Short Courses | CENTRUM PUCP

Start Date: February 21

Course in Warehouse and Inventory Management

Start Date: November 16

Workshop on Charts and Pivot Tables in Excel

Start Date: December 4