Course details
Pivot table is one of the most powerful features of Excel, yet few users use them in their day-to-day activities. PivotTable reports are especially well-suited for taking large amounts of data and summarizing it into useful reports. For some, pivot tables have always been too intimidating and for others, pivot tables are still unknown. With a little instruction and guidance, you will be able to use pivot tables to accomplish routine analysis and reporting that you have never ever thought of.
This course will begin with basic pivot tables and progresses to advanced pivot table topics. Topics covered in this session will include drag and drop pivoting, grouping and ungrouping, calculated items and fields, pivot tables consolidated from multiple ranges, and pivot tables dynamically linked to external databases.
COURSE OUTLINE
- PivotTables – An Overview
- Creating PivotTables
- Working with Pivot Table components
- Analyzing multidimensional data with pivot table
LEARNING OBJECTIVE
- Understand how and when to use pivot tables.
- Automate pivot tables by connecting them to external databases.
- Create basic and advanced Excel pivot tables.
- Create cross tabulations and other associated advanced features.
- Customize fields in a pivot table.
- Format and print your pivot table report.
- Group and perform calculations and its associated advanced options.
- Perform calculations within pivot tables.
- Building and automating business performance dashboards
- Structure and format your tables of raw data to easily allow for data analysis using pivot tables and pivot charts.
Course Location
About COMAT Training Services Pte Ltd
To be or not to be; this is the question which resides in us. All man of clay, our innate differences are subtle and few. The void spanning greatness hinges on existence of mean and will. COMAT holds an intrinsic belief that every inpidual has a potential to be realised. Betterment of society through advancement of its basic unit, empowerment through continuous learning – Upon these axioms were we founded, and today proudly uphold.
Love for the people around us, a desire for a better world, our passion is our profession. COMAT believes learning is a lifelong process and key to a meaningful existence. Spearheaded by a renowned team of highly experienced and motivated trainers, COMAT offers an extensive array of IT, safety and leadership & professional development courses, providing inpiduals with the means to excel.
While adhering to globally accepted quality standards, our intention goes beyond training and certification - COMAT provides a holistic experience, focusing on generation of inductive environments for stimulating philosophical thoughts. True learning lies in instillation of a sense of self-realisation, a will to become who they can be.
We pride ourselves on our innovations, our desire for continuous improvement, and the ability to perceive the needs and wants of each inpidual. Customized approaches for varying needs, we conjure solutions tailored to fit.
See all COMAT Training Services Pte Ltd courses- Data Analysis, Business Intelligence (20 in1) NextGen LearningSGD 162Duration: Upto 30 Hours
- Strategic Business Planning Lead AcademySGD 34
SGD 529Duration: Upto 1 Hour
