MS Excel

by James Cook Institute Claim Listing

Understand the concept of spreadsheets and demonstrate the ability to use a spreadsheet application. Our core commitment lies in providing excellent training to unlock our learners’ vast potential, ensuring personal and professional growth.

$300

Contact the Institutes

Fill this form

Advertisement

James Cook Institute Logo

img Duration

17 Hours

Course Details

Understand the concept of spreadsheets and demonstrate the ability to use a spreadsheet application. Our core commitment lies in providing excellent training to unlock our learners’ vast potential, ensuring personal and professional growth.

We collaborate with industry experts to design courses with practical, real-world applicability. Our WSQ courses strictly adhere to the WSQ Skills Framework.

 

 

Course Outline

  • Managing the Underlying Data

  • Creating and Modifying a Pivot Table

  • Summarizing data by using summary functions other than SUM, such as COUNT or MAX

  • Showing data as a percentage of the total by using a custom calculation

  • Creating your own formula inside a pivot table report by using a calculated field

  • Modifying the data source and refreshing the Pivot Table

  • Filtering and sorting data in a Pivot Table

  • Automatically group data to view a quarterly summary instead of a daily summary in a Pivot Table

  • Manually group data and rename groups

  • Comparing values in a pivot table to show Year-Over-Year Percentage Change

  • Creating a pivot table using MS Query

  • Creating Pivot Chart

  • Improving the Pivot Chart presentation

  • Creating multiple Pivot Chart quickly

  • Printing Pivot Table and Pivot Chart

  • Central Branch

    150 Orchard Rd, #06-14, Central

© 2025 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy