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.
DurationUnderstand 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
Welcome to James Cook Institute, formerly known as Eagle Infotech Consultants. With over 35 years of experience, we are an established training organization dedicated to empowering the Singapore workforce.
Our mission is to deliver exceptional training that maximizes learners’ potential and open up vast possibilities for their personal and professional growth.
At James Cook Institute, we pride ourselves on our expertise and the ability to provide cutting-edge short courses in IT and Soft Skills.
These areas are not only relevant to the current workplace but also crucial for the future of work. Our courses are meticulously crafted in collaboration with industry experts, ensuring real-world applicability.
Whilst our WSQ courses strictly adhere to the WSQ Skills Framework, we also offer customized training options tailored to the specific needs of our clients. To date, we have successfully empowered over 175,000 learners from diverse industries.
Excitingly, James Cook Academy, a wholly-owned subsidiary of James Cook University (JCU) in Singapore, acquired Eagle Infotech on 30 November 2021.
We are thrilled to announce the rebranding of Eagle Infotech Consultants to James Cook Institute to further leverage JCU’s network to reach new clients.
The ownership of James Cook Institute will also be transferred from James Cook Academy to JCU in Singapore to enable the consolidation of all training activities under James Cook Institute.
Driven by our passion for learning and growth, James Cook Institute is committed to diversifying and enhancing our short course offerings for individuals, as well as delivering customized programs for corporate clients.
Our primary goal is to provide more people with the opportunity to upgrade their skills and stay relevant and employable in today’s ever-changing world. Together, let us embark on a journey of endless possibilities, where opportunities abound, passions ignite, and optimism prevails.
Vision:
To be the preferred training provider to enable a future-ready workforce in Singapore and beyond
Mission:
rs for success through exceptional and tailored training, creating a supportive and innovative learning environment.
Microsoft Excel Intermediate course will equip you with hands-on knowledge to leverage the power of data analysis and presentation in order to make informed, intelligent organizational decisions.
This course will equip learners with the techniques to create a new workbook using template, add data to the worksheet, format data, build formulas, insert functions, copy formulas, print worksheet and workbook, sort and filter data list, find and replace text or formatting.
Microsoft Excel Course in Singapore trains learners in the basic concept of spreadsheets and demonstrates the ability to use a spreadsheet application.
The Intermediate Microsoft Excel Certification is an accreditation that underlines proficiency in utilizing Microsoft Excel at an intermediate level.
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.
About Coursetakers.com
Coursetakers.com is more than a decade old course aggregator and Online course platform that helps students find courses and compare course prices from Training providers in the UAE, UK, USA, India and South Africa, by just submitting their inquiry through the website. Coursetakers also helps Institutes, Universities and Online Instructors market their courses, gain leads and get more students to enroll into their courses.
© 2025 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy
Online
USA
UK
India
UAE
South Africa
Canada
New Zealand
Australia
Malaysia
Singapore
Saudi Arabia
Egypt
Jordan