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.

S$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

Check out more MS Excel courses in Singapore

Koenig-Solutions Logo

Intermediate Microsoft Excel

The Intermediate Microsoft Excel Certification is an accreditation that underlines proficiency in utilizing Microsoft Excel at an intermediate level.

by Koenig-Solutions [Claim Listing ]
Advanced Learning Singapore Logo

Excel 365 Dynamic Arrays Series 1 - Power Functions

This Excel 365 Series 1 – Dynamic Arrays and Power Functions course will take you through the basic of Excel LAMBDA, which enables you to create your own Microsoft Excel custom function without writing any code,

by Advanced Learning Singapore [Claim Listing ]
Intellisoft Logo

Microsoft PowerPoint 2019 (Basic)

The PowerPoint Training at Intellisoft is very practical, hands-on, and to the point. The PowerPoint trainer will show you how to use the most important features of Microsoft PowerPoint 2019 / 365, and how to apply them to make an impressive presentation.

by Intellisoft
Inspigenius Logo

Excel Course For Kids

In this course your child clear the fundamentals of Excel, like, excel interface, creating spreadsheets, entering/editing data, working with formulas, formatting data, excel print options, common excel shortcuts, and visualize data with charts.

by Inspigenius [Claim Listing ]
ITEL Learning Systems Logo

Microsoft Word Training

Microsoft Word is the standard document and word processing for both the business world and personal use, and ITEL Learning Systems courses for Word will teach you basic to advanced features.

by ITEL Learning Systems [Claim Listing ]

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