Excel for Data Management and In-Depth PivotTable

Excel for Data Management and In-Depth PivotTable

Sunday October 23, 2022

8:00 AM – 5:00 PM

Unit 3C Marsk Bldg., Aurora Boulevard corner Balete Drive, Barangay Kaunlaran, Quezon City 1111 (near UnionBank and Robinsons Magnolia)

No. slots: 13

​

​

Requirements:

• Bring your Windows laptop

• Must have MS Excel installed.  Version 2016 / 2019 / 2021 / Microsoft 365

• Must have basic or intermediate skill in MS Excel or any spreadsheet

Inclusions:

• Light snacks and meal

• Softcopies of Handouts and Excel templates

• Certificate

Objective:

• To transform raw data to prepare for summarizing

• Referring raw data from different sheets

• Identify item and field calculations in PivotTable

• Convert PivotTable to formulas

• Create reliable data structure and combine multiple different database

• Create dashboards visualize data

• Data Cleaning and Preparation

• Excel Reference Functions

• Calculations and Summarizing values in Pivot Table

• Organizing data in Pivot Table

• Referring Values in Pivot Table

  • CUBE / OLAP

• Data Structure and Relational Database

• Consolidating Relational Database

• Combine data based on dates or period

• Interactive Excel Dashboard

• He received certification from Asian College for training in Microsoft Excel.
• He is a Certified Microsoft Office Specialist - Excel Expert
• He develops programs using VBA, and Python and manages business data SQL and Access and other ETL and data modeling and visualization in Power BI
• He already trained hundreds of professionals, entrepreneurs, and employees from various companies such DITO Telecommunity, Frontier Towers, Froneri Philippines, ZARA Philippines, DSLU Dasmarinas, PetWarehouse etc.
• JTR Training Consultancy Services owned by him is awarded as Best Reliable Microsoft Training Service Provider at the 15th Golden Globe Award for Business Excellence