Microsoft Excel 2007 Maximising Pivot Table Oaks Training
Price: SGD 230.05

    Course details

    This 1-day pivot table course is an intensive 7 hour programme design to help you apply and get the most out of your data. It is not just a breeze through which you normally get from an Excel course covering many other topics. This course will show learners various scenarios on how a pivot table can be used to help users go beyond the basic usage. In this course you will also learn how to create formulas in a pivot table as well as creating pivot charts.

    What will i learn?

    • Introduction to Pivot Table
    • Creating a Pivot Table
    • Editing/Updating a Pivot Table
    • Filtering Data by Creating a Page Field
    • Creating a Chart from Pivot Table
    • Customize a Pivot Table
    • Creating a Formula in a Pivot Table Report
    • Printing Pivot Table and Pivot Chart
    • Import Text File
    • Consolidate Multiple Worksheets in a Pivot Table Report
    • Pivot Table Keyboard Shortcuts

    Who is this course for?

    Learners who have attended our Microsoft Excel 2007 Foundation and Microsoft Excel 2007 Functions for Decision Making modules or must be well versed in those topics covered in these modules.

    Updated on 08 November, 2015

    About Oaks Training

    Oaks Training operates as a closely knitted family with a team that is passionate in sharing knowledge and has a love for teaching. Our team's experience in training began as early as 1990. Oaks Training considers everyone (admin staff, trainers, management) who works in the company as a family member. Our philosophy is “Everyone is indispensable. Everyone plays a crucial part in the success of the company and for the benefit of our customers.

    See all Oaks Training courses
    Are you from Oaks Training ? Claim your course!
    Courses you can instantly connect with... Do an online course on Microsoft Office starting now. See all courses

    Is this the right course for you?

    Rate this page

    Didn't find what you were looking for ?

    or