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.
This is a case study-based course. The course will train participants how to create dynamic dashboards using Excel lists or data downloaded from external database, how to create relationship between two tables.
The Basic Excel Skills Hands-on training teaches you how to use Microsoft Excel 2019 / Microsoft Office 365 extremely well for day to day use in the office, and at home.
Our instructors are exclusive to us and we only engage excellent instructors to ensure all learners meet their individual needs and receive quality teaching. Our curriculum is unique and they include exercises to help participants retain knowledge for long-term use.
The Introduction to Microsoft Word certification, as the name suggests, validates an individual's basic understanding and proficiency in using Microsoft Word, a word processing software.
This Microsoft Access Training Course is designed for beginners, assuming little or no knowledge of the software. However, it would be beneficial to have a general understanding of personal computers and the Windows operating system environment.
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.
© 2024 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