Great opportunity for companies:  

Improve work efficiency by upgrading the skills of your employees!  

*Sign up under a Company and get 60% off:  

*Terms and conditions apply. For more information on grant,

Please contact us at 67337810 or email us at contactus@jslearning.com.sg

WWW.JSLEARNING.COM.SG

Want to simplify your work 

in creating tables, charts and presenting data?
 

Course Description:

For just $290, this course enhances your use of MS Excel to facilitate your work. Essential skills like the effective use of formulas in MS Excel to help you combine and split data, make calculations across all data, look up data from large lists and extract a targeted list of data from large databases.

For all full-day IT Courses, JS Learning provides certification which is one of its kinds. We will ascertain the students’ proficiency and skills in solving real-world problems and efficient usage of the software to achieve goals and desired outcomes.

The full-day MS Excel Course covers the following...

 Manipulating Data

•Sorting data

•Filtering data (by text, colour, conditions, etc.)

•Highlighting data (by conditions)

•Removing duplicates

•Text to columns (and reversing it)

 Charts and graphs

•Creating charts and graphs from data

•Manipulating options like axis labels, data source, substitution, ticks, grid lines, etc.

Mastering the use of formulars:

•Count, Math and statistical fomulars  

  (Count/Countif/Countifs; Sum/Sumif/Sumifs; Ceiling; Floor; Rand; Round; Average; Max;Min; 

  Mode; Median; etc.)

•Lookup and text formulars (Vlookup; Concatenate;Left; Mid; Right; Clean; Trim; Proper; Search; etc.)

•Condition formulars (If; Or; And; Not; Iferror; etc.)

•Applying formulars across sheets

Manipulating Page Layout:

•Fit to page

•Margins

•Page numbers/Sheet numbers and names/Worksheet names

Highlights:

Learn Practical MS Excel Skills that are applicable to your job/studies/research project

Step-by-step Guidance from Dedicated and Experienced instructor

Hands-on learning with practical applications

Instant feedback

Very small class size, maximum attention!!

Central Location

~~~

About JS Learning
Transforming Experience....

JS Learning has supported and coached many youth and adult learners in acquiring new skill sets and in overcoming barriers to their learning. We believe that in every person, there exist the ability to overcome challenges, to excel and to soar. That is why we have different approaches to learning IT, research software handling, academic subjects, or lifestyle interests and hobbies. We not only show you the ropes; our final goal is for you to learn to develop and progress on your own.

Our courses are all designed from a Problem-Based instead of a textbook based one. We aim to train you using authentic situations and real-life tasks which you will most probably encounter during your work or your learning and daily needs.

Our coaches are experienced teachers, lecturers and researchers, who have well rounded experience not only in teaching, but academic training and research experience. Most of the training materials and curriculum are constantly reviewed and customized for students so as to allow learning to benefit the most from it. Experienced in numerous pedagogies like Didactic Teaching, Collaborative Learning, Cooperative learning, Problem Based Learning, etc. we aim to help students learn and grow through a different experience.

We conduct IT training for students and professionals, in the following areas, all of which includes the option of certification.

·         Microsoft Office Excel 2010 (Functions and Formulas)

·         Microsoft Office Word 2010 (Advance Features)

·         Microsoft Office PowerPoint 2010 (Design and Presentation)

·         Photoshop and Webpage Design

·         NVivo 10 (Qualitative Analysis Tool)

·         IBM SPSS (Statistical Tool)

·         EndNote (Academic Referencing)

We also offer Math and Science tuition for students from all Streams in Secondary Schools, Junior Collages, International Schools, ITEs and Polytechnics. Leveraging on our belief that students develop understanding through engagement with the subject matter, keeping our our class sizes small is a unique feature of our learning centre. We believe this way, students get maximum attention, while at the same time, having time to develop and practice what they need. 

In addition, we are also using the fees that you have contributed to bless those who are less fortunate...

At JS Learning, we strive to provide you with a transforming experience.

Terms and Conditions

To book your preferred schedule, please call 67337810 or email: contactus@jslearning.com.sg with Name, Contact no, Preferred class dates & time 

Fees inclusive of Course materials  ( No Hidden Cost!!  )

Choose from the Following Schedule :

Every Mon, Wed, Fri: 9am-5pm (Subject to availability)

Or

Call to arrange a timing that is at your convenience (subject to availability)