Data Management and Analysis with Pivot Table (Excel 2007/2010) ITBM
Price: SGD 642

    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

    • Module 1 : PivotTables - An Overview
    • Module 2 : Creating PivotTables
    • Module 3 : Working with Pivot Table components
    • Module 4 : 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.

    PRE-REQUISITE

    • The participants are assumed to have fundamental knowledge of Excel and already have foundational knowledge in financial, statistical and data management.
    Updated on 31 August, 2016

    About ITBM

    Instructional & Courseware Design

    • Customized CD Learning, e-Learning and Courseware for companies. Find out more now.

    Office Workflow Automation

    • When running your day-to-day business, you realise that things can be made easier for you if the system is computerised. But how do you get started? More information here.
    See all ITBM courses
    Are you from ITBM ? Claim your course!
    Courses you can instantly connect with... Do an online course on Microsoft Excel starting now. See all courses

    Is this the right course for you?

    Rate this page

    Didn't find what you were looking for ?

    or