Advanced Microsoft Excel 2019

What Skillset do you wish to acquire?

Advanced Microsoft Excel 2019

Course Overview

Advanced Microsoft Excel Course

Advanced Microsoft Excel Course is a high level certification programme which presents learners with the opportunity to bring their spreadsheet skills to an expert level. This allows them to use the full potential of the spreadsheet application to produce higher quality management information. Students will be able to:

  • Produce higher quality information
  • Pinpoint key information quicker and more easily
  • Provide more sharply-defined analysis
  • Produce more sophisticated reports
  • Use advanced editing, data handling, functions and analysis features
  • Use macros within the spreadsheets application

Course Title

Level Up Your Excel Skills

Course Objectives

By the end of this course, learners will be able to:

1) Import and organise data sources
2) Prepare worksheets for data entry and calculations
3) Manage data and navigate cells effectively
4) Perform efficient analyse of data
5) Perform advanced calculations with Excel functions
6) Collaborate and review workbooks

Advanced Microsoft Excel 2019

Target Audience (OPERATIONAL, SUPERVISORY & MANAGERIAL)

The job role(s)/occupations that this unit would be relevant for learners who are required to prepare data and analyze data using Microsoft Excel at an advanced level. The competencies covered in this course would be relevant to all industries and to organizations of all sizes.

Assumed Skills:

  • Workforce Skills Qualifications (“ES WSQ”) Workplace Literacy (“WPL”) level 5.
  • Be able to read and write English at a proficiency level equivalent to ES WSQ WPL level 5.
  • Be able to manipulate numbers at a proficiency level equivalent to ES WSQ Workplace Numeracy (“WPN”) level 5.
  • Learners to have minimum GCE ‘O’ level or ITE certificate education
  • Learner should have at least 1 year’s working experience in any industry.
  • Learners must be able to operate a personal computer, use a keyboard and mouse
  • Learners are expected to have basic knowledge of Microsoft Excel

Course Content

Learning Unit 1 – Gather Data

  • Import data
  • Data consolidation
  • Linking to cells, range, between applications, break links

Learning Unit 2 – Format & Manage Worksheets

  • Custom number formats
  • Data validation
  • Worksheet grouping
  • Paste Special options

Learning Unit 3 – Advanced Data Handling

  • Range name
  • Go To Special

Learning Unit 4 – Data Analysis

  • Using Quick Analysis
  • Conditional formatting
  • Advanced sorting
  • Advanced filters

Learning Unit 5 – Advanced Excel Functions

  • Cell referencing
  • Logical functions
  • Nested functions
  • Mathematical functions
  • Date functions
  • Text functions
  • Lookup & reference functions
  • Database functions
  • Formula auditing

Learning Unit 6 – Collaborative Editing

  • Track changes
  • Share workbook
  • Compare & merge

Optional Topic

  • PivotTable and PivotChart

Who Should Attend This Course

Prospective learners should ideally have previous experience using computers and common software applications. Typically, these would be individuals who use a wide range of advanced functionalities within a spreadsheet application in a personal or professional context. Spreadsheet applications enable learners to manipulate and produce precise information and conduct crucial data analysis. This course has been specifically designed to provide learners with the skills to exploit the full potential of the spreadsheet application.

For learners with little or no knowledge of using a spreadsheet application, please visit the basic Microsoft Excel course

Visit this page for more Microsoft Office courses in Singapore.

Course Feature

Course Feature

Course Provider: James Cook Institute Pte Ltd
UEN: 198802365N
Course Reference Number: TGS-2022017320
Mode Of Training: Classroom
Funding Validity Period: 02 Dec 2022 – 01 Dec 2024

Advanced Microsoft Excel 2019

FULL COURSE FEE$518.4
Singaporean 40 yrs and above$182.4
Singaporean 21-39 yrs / PR$278.4
Duration2 days
(17h of training)

Available in: English

Book Class Now!

Contact Us On Whatsapp

Contact Us Now On Whatsapp
+65 6255 5584

Coursemology
4.9
Based on 87 reviews
powered by Google
Tee AhwenwenTee Ahwenwen
08:50 26 Feb 23
Ms Ashley Shirley wong is a nice and cheerful teacher thanks for today 26feb23 thank you I am wenyi is teachable teacher and i understand everything and enjoying your lesson so much 😊 really appreciate that.
Ben HanBen Han
18:30 03 Jan 23
Coursemology provides a wide range of massage courses with flexible training schedules..Sales manager , Rachel Lip, assisted me quickly and positively with both my course enquiries as well as the registration of my chosen massage course in a fuss free manner..So for my friends out there...If you are looking to enrol for serious massage courses..Coursemology is your recommended choice...RegardsBen Han
Devaghi ATDevaghi AT
00:35 15 Aug 22
The trainers were very Knowledgeable n conducted the session to participants understanding. Friendly n approachable. Motivational approach during practicals. I benefited from Course. Tq, trainers.
Mohd IqbalMohd Iqbal
09:58 24 May 22
My Food and Hygiene course here was superb! Instructor is very helpful to ensure you understand the importance of Cleanliness and Safety in the kitchen. I highly recommend Coursemology.
MattMatt
02:58 12 May 22
Attended the Food Hygiene course at vision exchange. The course sign up and payment process was fast and simple. The instructor was fun and engaging and helpful. Highly recommend this place if you want to get your food hygiene cert.
Joey GanJoey Gan
09:29 24 Apr 22
My sister and I had many questions about the different courses. The staff present including the boss Mr Wee were very patient and friendly to help us. The centre at Toa Payoh was also easy to get to and centre facilities were kept clean and tidy. We have a very good experience.
ting siongting siong
06:05 19 Apr 22
The trainer is patient and able to explain food hygiene and safety concept clearly. She demonstrated the hand cleaning techniques, share industry practices and safety standards with participants.A good training indeed.
js_loader

Coursemology is an online course directory, listing short courses in Singapore to provide information on WSQ courses and SkillsFuture Subsidy to corporates and individuals. We do course listing for training providers in Singapore to improve your employability via skills upgrading and job skills upskilling through skills development courses.

About Us

Training Locations

Toa Payoh Central
Blk 190 Toa Payoh Lorong 6, #02-514 Singapore 310190 (Above KFC)

9142 8897

Jurong East Central
2 Venture Drive, Vision Exchange, #07-23 Singapore 608526

8669 1718

Tampines Central
300 Tampines Avenue 5, NTUC Income Tampines Junction #07-05, Singapore 529653 (Opposite Our Tampines Hub)

8028 6619

Mon to Sun:
8:30am to 6:00pm
Closed on Public Holidays