SEO Training in Singapore – 2 Full Days

SEO training at Intellisoft, Singapore
2 Days SEO Training in Singapore
2 Days SEO Training in Singapore

When it comes to website design, most people take an active interest in the aesthetics, look and feel, font sizes, and content.  And once the website is completed, they just wait for traffic to show up automatically. They do not realise that websites are ranked by Google, and it is not difficult or impossible to get a higher rank in the Search Engines.

Getting a higher rank in the Search Engines is not only left to the Experts, the SEO Gurus, the Black Hat SEOs.

Now, you can learn to optimize your own website, and get a higher rank in the Search Engines too.

Intellisoft is organizing a 2 day, practical, hands on training on learning the tips, tricks, and trade secrets of optimizing websites – Doing SEO – on your own.

Join us for this 2 days workshop in singapore. Bring your own Website, and we will teach you the step by step procedure to optimize it for higher rankings in search engines.

In fact, Intellisoft Systems conducts Corporate and Public Training in Singapore for Internet Marketing. There are a whole series of course for Internet Marketers

1. Pay per Click Advertising Workshop (PPC Training)

2. Email Marketing Training – Best & Cheapest Way to Market your products and Services.

3. Facebook Marketing for Businesses – A great way to network with clients, prospects, friends and generate a healthy return with minimal efforts.

Join today! and Learn to do the SEO of your own website, easily, without any hassles.

See you soon in class –
Intellisoft Systems – Providing Practical Training Tips, Tricks and Advice

Advantages of JavaScript

Speed: Being client-side, JavaScript is very fast because any code functions can be run immediately instead of having to contact the server and wait for an answer.

Simplicity: JavaScript is relatively simple to learn and implement.

Versatility: JavaScript plays nicely with other languages and can be used in a huge variety of applications. Unlike PHP or SSI scripts, JavaScript can be inserted into any web page regardless of the file extension. JavaScript can also be used inside scripts written in other languages such as Perl and PHP.

Server Load: Being client-side reduces the demand on the website server.

Libraries: Many code libraries for JavaScript functions are freely available. These allow developers to provide extensive levels of functionality without having to implement the details themselves.

Content Management: JavaScript allows developers a level of flexibility in terms of the information that is displayed within a page.

Styling: JavaScript can alter the style of website elements as users interact with them. Common uses of this technique include altering the appearance of an interactive item such as a menu option when the user moves her mouse on and off it, changing the colors and images displayed within it. JavaScript can also create animations within Web pages, making the appearance and disappearance of page elements smoother and more engaging.

Interactivity: JavaScript functions often enhance interactivity with a Web page. Developers can create JavaScript functions to implement interactivity within user control features.

Related Training: Join our 2 days JavaScript Programming for Web

Using Pivot Table Data in Summary Sheets

Learn Pivot Tables Easily

Pivot tables are a great boon in Excel. Previously, getting IT departments to write custom reports used to take ages. And even if you could get a report written for your needs, by the time you got it, it was too late, or you wanted to look at information from another angle.

With Pivot tables, you can now create your own reports in no time. And you can slice and dice information pretty easily, with just a few clicks.

However, even though Pivot tables are great, they are not the best tool  for presenting information for the senior management. There may be times when you want to pick up certain information from the pivot table, format it nicely, and present it with other summary figures.

To use the summarized data from the pivot table, but make it more presentable,  you can use an extremely useful function of Excel called the GetPivotData.

Enabling GetPivotData Button
It is very easy to get this function to work. This little gem is hidden right within the Pivot Toolbar. Just right click on the Pivot Toolbar, right at the end, and select customize. Pick Add/Remove Buttons.

Select GetPivotData button. This is a toggle button – click it once and it gets enabled, and another click disables it. You can see a slight change in the icon when it is enabled or disabled.

Once the button is highlighted, you can begin writing your formula. Start with a = sign in a black cell where you want a pivot table value. then point to any cell in the Pivot Table. Its value is captured in your formula.

As long as the data is available and visible in the Pivot table, you can move the data around from rows to columns or page fields, but it will still appear correctly in the presentation area.

Go ahead. Give it a try and make your data presentation summaries more dynamic and presentable. Any questions or comments, do let me know.

Editor, Microsoft Excel Tips Blog

Intellisoft Launches Oracle SQL Expert Certification Training

Oracle SQL Expert Certification is an excellent way to demonstrate your expertise, build your credibility, and boost your career in the Oracle Relational Database Management by writing fast and efficient SQL.

Whether you are an Oracle application developer, an SQL Query Writer, or creating Web ASP.Net / PHP Programs, it is essential to know the full potential of the Oracle SQL Database engine, and the best way to write simple, complex and powerful SQL Queries that deliver quick results for your end users.

Oracle SQL expert certification requires a thorough knowledge and understanding of SQL. The certification will test your knowledge, and application experience with multiple questions.

Anyone can brag about their expertise and experience, but Certification also gives confidence to the employer, and shows that you are serious about your career.

Certification demonstrates your expertise, knowledge, experience and builds your credibility. It also gives you the confidence, and helps you plan your next career move.

Intellisoft Systems, a premier training and skills development institute, has come up with a detailed, 5 day training and coaching program that gives you the required knowledge, skills, step by step approach to learn to build, manage, execute and manage simple to complex SQL database queries, and build robust SQL that can handle the pressure of small and large businesses with ease.

After this training, you will have the required skills and know how to prepare and give the Oracle SQL Expert Certification Examination with ease. This course is appropriate if you are using Oracle 10g or Oracle 11g database.  This course is well suited for beginners and advanced users of Oracle, who are vying for Formal Oracle Certification in the use of SQL – with passing the Oracle SQL Expert certification exam.  Course Duration: 5 Full Days (9am – 5pm)

This course is well suited for beginners and advanced users of Oracle, who are vying for Formal Oracle Certification in the use of SQL – with passing the Oracle SQL Expert certification exam.
Course Duration: 5 Full Days (9am – 5pm)

The Oracle SQL Expert Certification (1Z0-047) is a 2 hour test with 70 multiple choice questions. You need to score 66% to pass the exam and gain this coveted certification. The exam can be scheduled at any PearsonVue Centre, and there are several centres in each country, with  15+ examination centres in Singapore alone.

The SQL Expert Certification Training and Coaching is provided by Vinai Prakash, founder and CEO of Intellisoft Systems. He has over 25 years of experience working with SQL Databases, and has extensive experience with Oracle, SQL Server, MySQL, Sybase, and many other databases. His expertise in Business Intelligence, Performing Complex Query Optimization and Managing Large and Distributed databases is exceptional. Further, Vinai is passionate about training, and has been conducting Oracle, Microsoft SQL Server, MySQL training and consulting projects over the past 20 years.

Certification is the way to go for adding value to your portfolio, differentiating yourself from your peers, and raising your standard. It is a must for continuous, lifelong learning.

Contact Intellisoft at +65 6296-2995 or email to for more information, training dates, and for training course registration.

Pivot Tables in Microsoft Excel

Learn Pivot Tables Easily

In Microsoft Excel , new features are sparklines and slicers, and improvements to Pivot Tables and other existing features, can help us to discover patterns or trends in the data. In the previous post we had a look at the Sparklines and Slicers features of Excel 2010 so now we will look at the improved pivot table feature of excel.

Improved Pivot Tables

PivotTables are now easier to use and more responsive. Key improvements include:

  • Performance enhancements: In Excel, Multi-threading helps advanced  sorting, data retrieval and filtering in Pivot Tables.
  • Write-back support: In Excel, we can update values in the OLAP PivotTable Values area and then transferred to the Analysis Services cube on the OLAP server. We can use the write-back feature in what-if mode and then roll back the changes when we no longer need them, or we can save the changes. We can use the write-back feature with any OLAP provider that supports the UPDATE CUBE statement.
  • Enhanced filtering: We can use slicers to quickly het the reqiured data in a PivotTable and see which filters are applied without having to open additional menus. In addition, the filter interface includes a handy search box that can help us to find what we need among potentially thousands (or even millions) of items in the PivotTables.
  • Pivot Table labels: We can add labels in a Pivot Table and also replicate them in the Pivot Tables. This will help us to display item captions of nested fields in all rows and columns.
  • PivotChart enhancements: It has made things easy to interact with PivotChart reports. Specifically, it’s easier to get the required data directly in a PivotChart and to reorganize the layout of a PivotChart by adding and deleting fields. Similarly, we can hide all field buttons on the PivotChart report.
  • Show Values As feature: The ‘show values as’ feature includes a number of new, automatic calculations, such as % of Parent Row Total, % of Parent Column Total, % of Parent Total, % Running Total, Rank Smallest to Largest, and Rank Largest to Smallest.

excel trainingIf you would like to learn more about these new features of Microsoft Excel 2010 or 2013, or would like to attend the Microsoft Excel Training, do contact us at Intellisoft Systems.

If you have any further questions then contact us through email Systems or call at +65 62962995!!!

Trainer: Vinai teaches Advanced Excel Techniques, Dashboard Techniques using Excel, Data Interpretation and Analysis Training courses at Intellisoft. He has trained over 5000 students in over 18 countries, and regularly conducts Excel Workshops in Singapore, Malaysia, Indonesia, Australia, India, Dubai, Egypt, Zimbabwe, South Africa etc.

Effective Presentation Techniques for the Board Room

Creating Killer Presentations @ Intellisoft

After years of slogging, you are finally getting a chance to do a presentation in the board room. Do not take this lightly. And do not blow this chance to impress senior management about your skills.

Many a career have been contained when engineers, who are domain experts, completely knowledgeable, are called to the board room, and because of fear, or in-experience, are tongue tied, mutter, splutter, and mumble something incomprehensible.board-presentations

It is true, Fear of Public Speaking is the worst fear in the world. It is the highest fear, even ranking higher than the fear of death.

Do you want to stifle your career too soon, all because you are un-prepared for the big boardroom presentation?

Practice now. Get ready. Be prepared for your big chance. And play it safe, play it well, and present to win, present to wow, present to amaze your audience!

Effective presentation techniques for the boardroom can be easily acquired.

1. Prepare a Solid Presentation
This should not be a problem as you have the content, and you have the domain expertise. But it is an art to prepare a presentation. Do not present a 100 slide presentation full of bullet points. This leads to Death by PowerPoint.

The Secrets of a Great Presentation are:

A.  Tell ’em what you are going to tell ’em.
B.  Tell ’em.
C.  Tell ’em what you have just told them.

What this means is that a. Have a clear and thought about Agenda. State it in the beginning, so there is no mystery. Stick to the agenda.


Secondly, have only 3-5 points to cover in the presentation. Keep slides simple. And stay away from amateurish PowerPoint Animation effects. Fly in objects, slow animation, corny graphics or too much use of clip art is sadly lost on the boardroom. Do a slick presentation with corporate like graphics, simple round or square bullets. Keep to only 2-3 bullets on a slide.

Show less information, and talk more from these bullet points. So that people are not reading your PowerPoint, but rather they are listening to you.

Thirdly, summarize the information. Tell them the key points, your own justification/stand, and the final outcome.

2. Rehearse it well.

You must rehearse your presentation a few time in front of the mirror, or in an empty room. Time it, so that you know you will not overshoot the allocated time. And practice how to open the speech. How to close the speech. Some speakers start with a joke. But this must be done with care. What if no one laughs on the joke? It can back fire on you. So choose your opening carefully. You can go to YouTube to watch some good presentations at

Another good way is to record your presentation using a Video recorder, or a audio recorder on your phone. Listening to your own voice can seem odd, but you will catch many mis-pronunciations, and many pauses which you were not aware of.

3. Maintain Eye Contact & Good Body Posture

Many people are so afraid of the audience that they try to hide behind the podium, or they look at some remote corner of the room while speaking. In one of my earlier presentations, someone from the audience congratulated me on observing their new curtains. When I told them I didn’t find anything new about their curtains, she told me that I was staring at the curtains all entire time I was speaking. What a polite way to tell me that I lacked eye contact. I was so naive… but then I realized the mistake and thanked her for being so thoughtful. I then worked upon improving my eye contact, and learnt how to work a room.

You can look at their foreheads and continue for a few seconds, then move to another forehead and so on… It will seem to the people that you are talking to them, and not staring at some remote corner.

Similarly, it is important to maintain a good body posture. Stand straight. Do not slump. Keep your hands in the front. Not in the pockets, not dangling like a pendulum. And do not keep jingling the key chain or loose change in your pockets to avoid any nervousness. Nothing is more distracting than jingling change or key noise in a presentation. Do not pace the room from left to right. Stand firm in one place. You can move to different areas to illustrate the points, but do not dangle like a pendulum. It should look natural movement, not deliberate, for the sake of moving.

4. Have Enough Time for Questions & Answers

Anticipate some questions. In fact, you can have a Frequently Asked Questions section, and show standard, canned responses to some standard questions.

Keep some time for audience questions. Once the question is asked, repeat the question, so that everyone can hear it, and thank the Enquirer about the thoughtful question. Do not ridicule the question if it is a simple or silly question. Then answer the question completely. And get a confirmation from the enquirer about whether you have answered their question completely or not.


Finally, once everything is said and done, thank the audience for giving you a chance to listen to you, and for their time and patience.

These are simple tips. Easy to master if you at least take notice, and practice on improving them. And once you apply them, you will be amazed at how powerful your presentations will begin to be.

If you would like to learn more practical tips, you can always attend a training program at Intellisoft, and learn from the gurus on how to improve your soft skills.

This article is written by Vinai Prakash, Founder, CEO and Principal Trainer of Intellisoft Systems. Vinai is a sought after trainer in the area of soft skills, project management skills, data analysis, business intelligence and IT courses. Vinai’s articles are published in the Straits Times, and many other books and magazines all over the world. Contact us to book Vinai for your next training or seminar.

Related Training: Presentation Skills: Speaking to Impress in our 1 day workshop. Full of exercises and practical examples, it is a totally immersive workshop that will work wonders to your Presentation Skills. Do check it out here: Presentation Skills: Speaking to Impress

Programming in C – Hands On Training in Singapore

Intellisoft Systems is proud to bring you new and exciting IT Training Courses. We have added yet another popular course for you – Programming in C Language.

This training is divided into 2 classes – a Beginners 2 Day C Programming Course, where you will learn the Fundamentals of C Programming – Data Types in C, Operators, Arrays, Conditional Statements etc. This will assist you to build a solid foundation in C Programming Language.

Advanced C Programming Workshop

Once you have mastered these foundational concepts of C Programming, you will be ready to move on to the More advanced concepts in C languagePointers, Memory, Manipulating Strings, Arrays, Files, Inputs and outputs

Some of the Advanced C Language Concepts we cover in our 2 day public classes in Singapore:

     * Working with bits: number system, OR, XOR , NOT ,Setting bit flags, Bitwise shift operators, Extracting bit values

     * Pointing to data: Getting values via pointers, Passing pointers to function, Arrays of pointers, Pointing to functions

     * Manipulating strings: String function, Working with strings

     * Building structures: Nested structures, Array & pointers in structures, Array of structures

     * Union: Array of union

     * Standard input & output file streams: Working with files

     * Header Function and Linking File: Function in custom headers, Multiple source files linking  files, Static functions.

It is best to take the Basic and Advanced course together – back to back. You can finish it in the same week, and be ready to start coding in C language.

Why not take this opportunity to check out the course outlines, and enroll in the C Language Training Programs. Check out our Training Calendar and Register online for C Programming Courses. You can also call us at +65 6296-2995, or email to us.

Intellisoft Systems Team

Recommended Training: C Programming FundamentalsC Programming – Advanced

Free Tips, Tutorials & Training Grants Info

Learn from expert tips, tricks and resources for Excel, PowerPoint, Photoshop, Project Management, IT, Soft Skills & more with our Email Newsletter.
Plus get the latest news on Grants. Join Today!

Found What You Were
Looking For?

Just Tell us...

We're Here To Help You!