How To Write Excel Formulas

Learn Excel at Intellisoft

Do You Know How to Write Excel Formulas?

Chances are that you can only click on the Autosum button to add a few numbers. If you have never written a single formula in Microsoft Excel, fret not. It is not difficult at all. In fact, with our step by step Excel training, you will be able to write Excel formulas in no time.

Advanced Excel training at Intellisoft in Singapore
Advanced Excel training at Intellisoft in Singapore

The real power of Microsoft Excel is the usage of Formulas. This is what differentiates it from Paper or Typewritten Reports. With the use of Formulas, Excel can calculate and update the totals, and complex calculation or computations on the fly.

How Excel identifies Rows and Columns

Excel uses a simple numbering system to differentiate between cells. Each cell or box that you see in an open Excel file has a unique number – pretty much like the pigeon hole letter box that each house has. Each letterbox number is unique, making the life of postmen easier.

In Excel, Rows are numbered from 1 onwards. These Rows appear on the Left of your screen.

Excel VLookup Sample
Excel VLookup Sample Setup

For Columns, it uses alphabet combination – like A, B, C, and when it comes to Z, it starts with AA, AB, AC and so on.

So the first cell cross-section of column A and row 1 is called A1, column M and row 5 is called M5. Simple huh?

Using Rows & Columns in a Formula

How does these unique references to each cell make a difference? Well, let’s say you want to add the total of A1 and A2  in the cell A10. All you need to do is to go to A10 cell, and then start to write a formula.  A formula begins with the = sign.

So you are at A10. Key in =A1+A2 and hit the enter key.

That’s it. You see the totals of A1 & A2 show there.

Go ahead. Fire up Excel. You can’t learn Excel by looking at tutorials. You have got to try it out, and practice. Practice makes you perfect.


  1. Key in 20 in cell C1, 30 in cell C2, and 40 in cell C3.
  2. Then go to cell C4, and key in the formula to calculate the total.
  3. If it matches 90, you have got it correct!
  4. Congratulations. You are on your way to write Excel Formulas and get better at computing using Microsoft Excel.

Vinai Prakash
founder & principal trainer at Intellisoft Systems Singapore.

Looking for Microsoft Advanced Excel Training? You have come to the right place

Contact us at +65 6250-3575 for any questions, or to join our upcoming classes in various versions of Excel.

What are you using Microsoft Excel for?

Excel Chart
Excel Chart

Most people learn Microsoft Excel by hit and trial. As soon as someone explains, or they figure out how to write a simple formula to add two numbers, they think that they know everything about Microsoft Excel.

Nothing could be far from the truth! There is much more to Microsoft Excel than just adding numbers.

And I have even seen people using a Calculator even when a Microsoft Excel spreadsheet is open.

Right out of the box, Microsoft Excel, whether Excel 2010, Excel 2013 or Excel 2016 can do wonders! Let’s see some examples of what Microsoft Excel can do.

Pivot Tables
Pivot Tables

Basic Things that Microsoft Excel is great to use for are:

  • Creating Tables
  • Finding Duplicates
  • Eliminating Duplicates

Advanced Excel Techniques

  • Using Range Names
  • Formulas and Function like Vlookup, Text Functions, Date Functions
  • Pivot Tables
  • Pivot Charts
  • Macros to automate routine tasks
  • Sharing Worksheets and Workbooks
  • Protecting Worksheet, Workbook, individual Cells

Advanced Analysis Techniques and Data Analysis using Microsoft Excel:

Excel VLookup Sample
Excel VLookup Sample



Are you using Excel to your advantage, or just using it as a basic calculator?

Vinai Prakash
Intellisoft Systems

Choosing A Career in IT Industry

Thinking of starting a career in IT?

Love to play with Computers and  Mobile Phones, and thinking of making IT a career choice?

Like to develop new IT products and services and be the next generation whiz-kid?

You are not alone. Thousands of people are moving to IT for continuous and long term job prospects with great salaries.

According to Forbes, top jobs pay anything from $120,000 to $150,000 for starters.

Business Insider lists over 40 technologies that pay over $120,000 per annum.

The IT Industry is a huge, and booming industry. In the coming years, more and more automation is happening, and more computer engineers, and support people are needed than ever.

The Internet of Things (IOT) is firming up and taking leaps and bounds. According to several surveys, the number of jobs in providing IT Development (Cloud Computing, Green Computing, Web Design and Development, Mobile Application Development, Graphics Design, Game Design) and in IT Services.

Programming languages like Ruby, ASP.NET, PHP, and databases like SQL, MySQL, Oracle, C, Java, C++ are all in the vogue. You don’t even have to master all of them. Just take one, and master it.

Use it to program trial and real projects. Experiment and learn the nuances of each language. There will be several versions and flavors of each language. Figure out the correct framework and go for it.

Computer programming is not only for computer science graduates. Several top universities, including Stamford, National University of Singapore etc. get their Engineering students studying Mechanical, Civil, or any other specialization to take C or Java programming as electives or one of the core modules in the first or second year itself.

Where Should I Begin For an IT Career?

First of all, you must look at your interest and passion, and browse the world of IT. Find out what kind of things make you feel like you will want to do it? It could be Design, or Development or Support Services.

For Design, you could look at Product Design, Creative Design, Web Design, User Interface Design.

For Development, you could take up Mobile App Development, Web App Development, or Back-end Interface Development, Business Intelligence, ERP, Data Warehousing, Data Mining etc.

For Support & Services, there are Cloud Services, Web Hosting Services, Network Services, Hardware Services, Software Services, Web Services, SEO Services, Email Marketing.

There’s a whole new world of Social Media Services, in Using and Exploiting Facebook for Business, Using LinkedIn, Twitter, Instagram, Snapchat, Pinterest and ever increasing new platforms to explore.

To begin with, you can visit Wikipedia and read a little bit about each one… It will give you a better understanding of the various options available, and then explore your interests.

There are several good books available on the broad topic of IT, Internet, Social Media to explore. A visit to your local library is a must to look at the plethora of choices available. You don’t have to purchase so many books. Just browse, borrow some, and gain as much knowledge about the various options.

You can then begin to talk to your peers, friends, colleagues, and friends of friends to generally discuss and get a better, first hand information about choosing an IT career. Schools, colleges, Polytechnics and Universities also organize several talks and seminars about choosing the right career, and how to pick the right thing for you.

Finally, create a mind map of all your ideas and thoughts. If you are not familiar with it, read about it here and begin using it. If you want to follow the old fashioned way, you can jot down all your notes in a diary or paper, and then sift through them.

Make detailed notes, and review them yourself, as well as others who support your goal in choosing the right IT career for you.

Next Steps in Choosing an IT Career

Strategy in IT Career
Once you have a fair idea about the kind of things you want to within IT, you can join some short term courses to know more about the things, and get direct experience at working on these.

Sure, you will have to spend some time and money, but it is better to spend a little and get a better idea, rather than spending a long time studying a particular topic, and then realizing it is not for you.

I have seen countless people graduating from college with a degree, and not pursuing it as a career, because they did not really like it… they had chosen something because of their parents, or peer pressure.

Don’t waste a college seat doing something that you have no interest in. Imagine someone studying 5 years to be a doctor, and then deciding to not be a doctor and help cure people… What a waste of time, money, resources. As well give that seat to someone else whose passion it is to be a doctor.

Similarly, to gain mastery over any area within IT, you will have to spend a lot of time studying it. Invest your time, money and passion in something that you really care for. Once you have chosen a field of study, put your heart and soul into it.

While I was studying Computer Programming back in the 1980s, after learning Basic, COBOL, ForTran,Pascal, and C, I fell in love with Pascal & DBase III (a database programming language). I then spent countless hours in the lab experimenting it.

I purchased almost every book on these topics and even got my father, my uncle to support me in purchasing very expensive books on these topics. I am proud to say that I mastered both Dbase, Pascal and C to a great extent, and it helped set my foundation in Computer Programming, which helped me all along in my IT career.

Even as I got promoted, and was not writing code, it helped me supervise my team, and work closely with them in implementing several cool features that were unheard of in those times. This gave me great visibility in the company and the senior management got to know of my skills.

It paved the way for frequent promotions and helped me accelerate my career within the company. Pretty soon I was commanding a high 6 figure salary, all because of my passion and interest in the chosen field within IT.


Don’t spend your entire lifetime finding your purpose, your passion, your dreams. Find it, and spend the time in achieving it. Choose something not because of the money, but because of your passion.

Once you have chosen a field, go deep in it. Make a trench that you know every bit of. It will give you immense advantage in the field, and help you accelerate your career, and help you achieve you dreams.

Remember, success is not achieved by luck alone. Success is 99% perspiration, and 1% inspiration. If you stick to the thing that you love, you will attract luck and success automatically, and make the world better for you, for others and leave a legacy that will make an impact in this world.

Written By Vinai Prakash

This article is written by Vinai Prakash, the founder and managing director of Intellisoft group of companies in Singapore. He has helped, coached and guided thousands of participants in achieving their goals, their dreams and finding their passion.

Vinai lives in Singapore. He loves to teach Project management, IT Courses, Photoshop, Web Design, Management Dashboards with Excel, Facebook for BusinessCommunication Skills, Time Management techniques and Killer Presentation skills among other topics.

Recommended IT Courses: CC Programming FundamentalsC-AdvancedC++Java, JavaScript, PHPSQLPythonCreate DB Apps PHP & SQL

Why You Should Train Your Staff

 Employee TrainingMost businesses are always in a state of crisis, fighting some fire or the other each day. By the time one fire is put off, they find themselves involved in putting off another fire.

This is the nature of all operational work.

Similarly, if you  are working on a project, things keep changing, you keep moving from one crisis to another – nothing stays the same…

Only “change is constant”.

Thus, we hardly have time to think, to plan ahead, and to be proactive. Most of our actions each day are pretty “reactive”. This is the worst position to be in. There is a total lack of control, and many a time you will feel totally “overwhelmed”… not sure what to do, where to begin, and what to do to get out of this mess or chaos.

Steven Covey, in his famous book  The Seven Habits of Highly Effective People talks about Being Proactive (the First Habit), and Sharpen The Saw (The Seventh Habit).

What is Being Proactive?

This simply means that you do not wait for things to happen. Rather, prevent them, avoid them, and circumvent them. Have a long term view, plan, so you can see the pitfalls immediately, and you can then plan for any foreseen eventuality, and be prepared. If you are prepared, you know what to do when the event happens, if it happens. This is being proactive. It is totally in your hands.

You can take aside some time each day – ideally in the morning, or the last thing in the day, to plan your day, and actions for the next day or week in advance. Our mind, our brain is a goal seeking device. If you give it a goal, it will find ways to achieve it!

Sharpen The Saw

Continuous Training Opportunities to Stay Ahead - Sharpen the SawCovey talks about a wood cutter so busy with the work, that he has no time to sharpen the saw. Thus, he toils to cut the tree, but this task takes ever longer, due to the fact that the saw is in a pretty bad shape. The wood cutter knows that the instrument is blunt, but does not want to spend the time to sharpen the saw.

It is a pretty simple story, and makes perfect sense.

But aren’t you doing the same? You have no time to plan ahead, no time to do the right things, no time to think and then act. You believe in ‘shoot first, and think later’.

An Emerging Economy

We are living in a world of unprecedented change. Things change very fast. Each morning you pick up the newspaper, and find out some new rules imposed by the government. You can not even anticipate what their next step is going to be. You have to react in this situation. Even if our country’s economy is stable, it is impacted by the US economy, China, India and the smaller third world countries. Interest rates, inflation, GDP, economic growth rate, ERP, COE, Housing prices, petrol price, US economy, exports, exchange rates, all are changing all the time.

With so many variables, what are you supposed to do?

You Are The Commander of Your Ship

There are hundreds of things that you can control. Your thoughts, your actions, your plans can be managed and controlled. They are not cast in stone, but you can control, change, and achieve them. All you need is a little persistence, determination, and focus.

Plan for a better future. Take some time to plan, and define your actions. Just be flexible, and be ready to adapt, in case someone throws a spanner in your plans.

Invest in your Future. Now. How?

Make sure you have the right skills to do the job, and a little more. And also make sure that your team, your staff is also equipped  the same way. When we have thought of every event that can derail the project, plan what we could do, what we would do if it happens, we are much more in control.

Training is the Key

Training is like sharpening the saw. A trained worker is a happy worker. He or she takes pride in the work, and has a heightened sense of self satisfaction.

Employee Training Skills

Some of the known, proven benefits of training the workers are

  1. Increased Productivity – you get more things done, with a better quality, and improve the productivity of the employees, as well as your products and services. The government is also giving generous grants to improve the productivity of the workforce. Make use of these grants.
  2. Lower Cost – less rework, less repair, and a higher quality reduces cost overall, and improve the product. This produces cost savings for your organization.
  3. Higher Satisfaction – with a better quality product or service, the team is happier, and take pride in the company and its products or services. It raises their self esteem, morale, and generates a feeling of self satisfaction.
  4. Lower Turnover – with a higher self-worth, a higher self satisfaction, the employees want to stay in your organization, and this will reduce the turnover. Thus, you do not need to train the staff frequently, and they add value by giving suggestions to improve the product, processes, services, and directly

Thus, you can see how training sets a chain reaction of improved productivity, lower costs, satisfied employees and customers, and a higher brand recognition.

With so many benefits of training, you must look for every opportunity to “sharpen the saw“, and generate the maximum benefit, maximum productivity, and maximum satisfaction for your company, your employees, and your customers.

To learn more about how you can use training to improve your business, give the Intellisoft Training team a call at +65 6250-3575. I am sure you will benefit from it.

Vinai Prakash

Director, Training Services

Vinai Prakash holds a Masters Degree in E-Commerce and is a certified PMI Project Management Professional. He is currently the Director &  Principal Trainer at Intellisoft, providing training to commercial and government organizations in Project Management Methodology, and in various other programs to analyze data, manage IT projects, learn soft skills.

Armed with 27 years of solid management experience, he is the most sought after Trainer and  Consultant at Intellisoft. He has taught Project Management, IT Outsourcing, Business Intelligence, Data Interpretation & Analysis courses in Asia, Middle East, Africa & Australia for Intellisoft clients.

Let us know if you would like to speak to him about your organization’s unique training requirements.

Self Study for PMP Certification


The PMP certification is the highest certification for Project Managers. It is issued by the Project Management Institute in USA.

Eligibility Criteria for PMP Certification
To be eligible to sit for the PMP exam, and get PMP certification, you need to have 3 things.

  1. Degree or Diploma
  2. 4500 hours (3 years) of project management experience for Degree holders; 7500 hours (5 years) of experience for Diploma Holders. If you are not sure about how to compile your experience and check if it meets the 4500 hour requirements, you can contact the PMP Trainer in the class.
  3. 35 Hours of Formal education in Project Management ( 35 PDU Certificate).

Self Study for the PMP Examination

Yes, you can do self study for the PMP examination. In fact, once you have attained the 3 minimum requirements for the PMP Exam, almost all people will do self study for at least 6-8 weeks (about 2 months), before they will be ready for the PMP examination.

Usually, at Intellisoft, in our 4 Day PMP Examination Preparation Training Workshop in Singapore, or Malaysia, we help each student to come up with an individualized study plan, based on the amount of time available. This is a must, because of the sheer amount of study material.

There are 10 knowledge areas, and 5 process groups. In between them, there are 47 unique processes, each with its own Inputs, Tools & Techniques & Outputs.

Most PMP Books in the market are quite voluminous, huge and scary to look at. If you do not have a study plan, you will soon begin to wander, and begin to procrastinate.

In the PMP Boot camp at Intellisoft, we will help you to come up with a study plan, that is easy to follow, requires only 1-1.5 hours per day, and has a extremely high success ratio. Over a thousand students have followed it, and passed the PMP exam after studying and following the study plan created with Intellisoft.

How to Do Self Study for PMP Certification?

One of the first things you should do is to set a deadline – by when do you want to achieve the PMP certification? Set a date.

Nothing works better than a deadline. Remember your old college days? Most of the time, you used to complete that college assignment the night before it was due to be turned in… Remember those days!

Well, the PMP Exam is not something that you can take lightly and study the night before only. You need to study consistently for a longer period, usually 6-8 weeks.

So persistence. Consistent Persistence is required.

If you really desire the goal of being a certified PMP, you must exercise persistence, consistently. Study each and every day…. even if you study for only 1 hour each day.

You will be amazed at the progress you can make in a week of consistent effort.

Find a Buddy or a Partner with whom you can practice, and quiz each other for the PMP exam preparation.

This helps tremendously, and checking each other brings in some accountability. Now you have promised your buddy that you will study, so you end up studying.

In the PMP Training workshop in Singapore, our certified PMP trainers will give you hundreds of tips, techniques, tricks and mock exam questions to prepare, and get ready for the PMP certification examination.

Follow it, act on it, consistently. And you will be ready for the certification exam in no time.

We can help you!

If  you have any questions, simply post a comment below, or send an inquiry to the PMP Course Coordinator at Intellisoft, and they will assist you.

To your success in the PMP Examination. All The Best!

Vinai Prakash, PMP, ITIL, Six Sigma, MBA, GAP
Master Trainer at Intellisoft Systems, Singapore

PS: If you would like to know more about the PMP examination, attend a Free PMP Exam Preview Session at Intellisoft. Registration is Free. There is no obligation. See you soon…

Recommended Training: Blended PMP Exam Preparation Training SingaporePMP Exam Preparation Training Singapore

Creating Management Dashboards in Microsoft Excel

Excel dashboard training Singapore

Today, Microsoft Excel has become extremely power tool for any data warrior. Whether you work in Sales, Marketing, Customer Service, Logistics, Accounts, Manufacturing, Finance or Administration, everyone must become an expert at using Microsoft Excel.

It is not sufficient to know Tables & Formulas in Excel. You must also know how to make sense of the data that you have.

Successful analysis of data, and presentation of data are vital skills for any office worker. Simple techniques to analyze data are to use Pivot Tables, Normal Data Ranges, and Tables.

Further, there are Advanced Data Analysis tools within Excel – like the Scenario Manager, Goal Seek, Solver, Conditional Formatting, Slicers etc. that make the job of data analysis much easier.

However, it is not sufficient to merely analyze the data. It is important for you to also present the data using the latest and best in-built techniques within Excel. Most of the people who come for Excel Dashboard Training, or the Data Analysis Training With Excel are not aware of these features.

Microsoft Excel Dashboard Training

Microsoft Excel Dashboard Training

When you create an Excel Report, which allows for the Report to become interactive, allows the management to play with the data, change the parameters, and see the data change, the graphs update dynamically, then such a report is called a Dashboard.


The key different between a Report and a Dashboard is that a Report can be static, long, and without any interactivity.

In contrast, a Dashboard is a dynamic report, Short, Fits a page usually, and allows the users to change several parameters on the fly to compare the data from the past year, quarter, and play what if dynamically.

Dynamic Checkbox Dashboard With Microsoft Excel

Dynamic Dashboard With Microsoft Excel – Learn to Do It Yourself!

Intellisoft Systems in Singapore conducts Public and Customized Classes for Creating Dashboards With Microsoft Excel. Many companies have opted for Corporate Training, where the content can be customized to suit your audience and participants, plus their level of expertise with Microsoft Excel.

For the dashboard training, the Excel version is not that important. You can use Microsoft Excel 2010, 2013 or Microsoft Excel 2016 for the Excel Dashboard Training.

Plus, the Dashboard training can be conducted in your country. Simply contact Intellisoft at +65-6250-3575 for the training details.

Intellisoft Systems Team, Fortune Centre, #10-08,
Singapore 188979

Recommended Training: Advanced Excel 2013Excel Dashboards MasterClassData Interpretation & AnalysisCustomized Corporate Training

Free Tips, Tutorials & Training Grants Info

Learn from expert tips, tricks and resources for Excel, PowerPoint, Photoshop, Python, Power BI, 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!