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

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 ]
Coursemology Logo

Microsoft Excel Course

Microsoft Excel Course in Singapore trains learners in the basic concept of spreadsheets and demonstrates the ability to use a spreadsheet application.

by Coursemology [Claim Listing ]
New Horizons Singapore Logo

Excel Training Singapore

Demonstrate that you have the skills needed to get the most out of Office by earning a Microsoft Office Specialist (MOS) certification in Excel 2019.

by New Horizons Singapore [Claim Listing ]
St.Hua Private School Logo

Microsoft Excel Essentials

Microsoft Excel is a powerful yet user-friendly spreadsheet software. In this course, you will learn how to input and organize data, use functions to perform calculations, format the appearance of your data and cells, and build stunning charts and PivotTables.

by St.Hua Private School [Claim Listing ]
Global Training Partners Logo

MS Access 2013 Course

Outlook 2013 training is offered by Global Training Partners. University professors and national experts create our course curriculum.

by Global Training Partners [Claim Listing ]

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