How Good Are Your Soft Skills?

valuable_employee_cartoon

Most people learn the hard skills in college, and be a good engineer, architect, doctor, or a specialist based on the skills learnt in the academia. This is fine, and it helps in the initial years. However, as time goes by, you use less and less of these specialist, hard skills, and you need more of other soft skills. This is because as time goes by, you rise in your career, and have bigger and larger responsibilities. You will also have bigger teams to manage, and bigger amounts will be at stake.

This is the time you realize that the hard skills you learnt are not always of great use. What you really need is expertise, mastery and experience in using the soft skills – which is what really matters. Most of all, you have to realize that as you rise higher, you do less and less work, and you need to get other people to do more and more of the work. How do you push others to do the work? What skills are needed to do this?

What are soft skills really?

Wells, soft skills are communication skills, negotiation skills, presentation skills, general management skills, motivational skills, and leadership. These are really people management skills. To do any project, you need people, and to manage the project well, to get it done on time, cost, scope, quality, you need to work with your team, your people effectively.

These skills are generally not taught in school, as we focus to learn the hard skills. However, if you want to accelerate your career, move far, higher, faster, then you need to master these at a great speed. The thing with soft skills is that it improves with experience. But you must practice them. You can’t learn communication by reading a book on communication… just like you can’t be an expert swimmer just by reading the Advanced Manual of Swimming. You need to get into the water, learn to navigate your way, try, make mistakes, and learn from them. It is OK to make mistakes. The important thing is to learn from them, so that you don’t repeat them, and use this experience to get better and better.

Learning soft skills is like learning an art. It takes time, patience, determination, and perseverance. You can do it. Only thing is to become aware about it, take note of your current skills, and the areas where you need to improve. Then work out a plan, and practice to improve your skills in each area.

Today, there are several courses available to improve your soft skills – there are numerous Communication Skills courses, there are several Time Management courses, Stress Management Courses. Most of these courses are short, 1-2 days, and they are good because they tend to teach you a few techniques, a few ways to improve your communication. You will not become an expert in a day or two, but it will be a great start.

Any improvement can only be seen when you first become aware of the short coming, and measure where you are, and where you want to go. Once you know where you are, and what your plan is, then from then onwards, it is easier to take some steps, measure your progress, and see how small steps are shaping up your future, helping you grow, nurture your nature, and improve your skills, improve your life.

It is worthwhile to live a meaningful life, and life rich of experiences, of abundance, of contribution. Do not waste your time. Make the most of this opportunity. Do good, learn, help others grow by applying the principles of self mastery, and self growth. Once you improve, you improve the people around you.

Improve your soft skills. Invest in your future. You do not have to spend a fortune. There are several courses available for free on YouTube, Articles abound on the Internet, and there is a plethora of applications on the mobile phones that can be used to learn new things, grow your knowledge, and grow yourself.

Written by Vinai Prakash,
Master Trainer at Intellisoft

Related Training: Effective Communication Skills, Body Language, Interview Skills – Prepare for An Interview.

How To Use Custom Sort in Microsoft Excel

Excel training in Singapore at Intellisoft

Do you know how to use custom sort in Excel?

I bet you know how to sort data in Excel. It is pretty easy. Most of the time an ascending sorting is what we need – letters and numbers listed in the ascending order a to z, 1 to 100 etc. And just in case you need to sort in the reverse order, you have the Z to A sort, also called the Sort in Descending order. Between the two, most people are quite happy, thanks to Microsoft‘s intuitive sorting options.

However, there arises a time when you don’t want either the sort in Ascending order or the Descending order in Excel.

Examples where a Standard Sorting won’t work:

For example, if the departments in your organization are Finance, Marketing, Sales & Engineering. And you want the Sales department to be listed first, followed by Marketing, Engineering, and Finance being the last.

Now how would you sort the departments in this order? Ascending or descending sort is not going to work.

Do not despair however. Here is where the power of Microsoft Excel Custom sort shines.

Another scenario is the Sorting of Months – say you want to sort April, May & June, in this order. Or maybe you want to sort regions by East, West, North & South. This EWNS order also needs a custom sorting in Excel.

Or if you have a completely random order – which defies any kind of sorting. Say you want to list Oranges, then Apples, then Grapes, and finally Bananas. You can go nuts without custom sorting criteria in Excel.

Using Custom Sort in Excel 

First, let’s create the custom list in Excel.

Go to Tools, Options, Custom Lists.

You can key in your list and click Add. Or you can import your list from another area of the spreadsheet, where you list the options in the sorted order.

Custom sort option screen in Excel

 

 

 

 

 

 

 

Once you have imported the list in the correct order, you can go to Data, Sort, and then click on Options at the bottom of this popup window.

Choose your custom sorted list from the list of First Key Sort Order.

Voila! Your list is now sorted in your very own custom order.

Multi level sort in Excel with Custom Sorting options

 

 

 

 

 

 

 

 

Alternatives to Custom Sort in Excel

Of course, if you don’t want to use Custom Sort, there are other alternatives. I have often used a Lookup Table

Fruit                Sorting
Oranges             1
Apples               2
Grapes               3
Bananas            4

I then use the inbuilt Lookup function of Excel called VLOOKUP function and pick the correct value, and then do an Ascending sort. This is a quick cheat trick.

But it would be tough if you did not know how to use the Lookup functions of Excel in the first place. More on this lookup function in another post.

Let me know if this neat trick help you. And if you want to learn more, join me in a Excel Training workshop in Singapore.

Till then…

Cheers,
Vinai Prakash
Founder & Master Trainer at Intellisoft Systems, in Singapore

Text to Columns in Microsoft Excel

Excel training in Singapore at Intellisoft

It is now very easy to split a name into first name and last name, using Excel, even if the name is in a single column.

Text to Column Function in Microsoft Excel 2010 or older versions

1. Select the data in Excel.

2. Go to the Data Menu, and select Text to Columns
3. Choose Delimited, and click the Space checkbox, and click Finish.
4.  The data would have been split into separate columns.

Text to Column Function in Microsoft Excel 2013, 2016, 2019

You can also customize how you want your data to be separated by specifying a fixed column break location in the cell, using Excel 2016 or Excel 2019.

  1. Select the  cells, and then click Text to Columns on the Data menu.
  2. In Step 1 of the Convert Text to Columns Wizard, click Fixed Width, and then click Next.
  3. In the Data preview window, drag a line to indicate where you want the content to be divided.
  4. The data will now be split according to your specifications, in separate columns.

Simple, isn’t it!

For more such tips on Excel, join Intellisoft Trainings on Excel in Singapore. Visit https://www.intellisoft.com.sg/advanced-excel-2016-training.html.

Cheers,
Vinai
Editor, Excel Tips

How To Create A Dashboard in Excel?

Excel Dashboards To Visualize Information Quickly

How To Create A Dashboard in Excel?

Most people take Excel to be a number crunching tool… boring and unattractive.

Actually, Microsoft Excel has been slowly transforming… adding more and more features that make presentation of number much better with every new edition of Excel.

The Excel 2016, 2019 & Microsoft Office 365 versions are extremely powerful and you can create dynamic dashboards with buttons, check boxes, drop downs, scroll bars, conditional formatting, pivot charts, slicers, and a host of other features, just by using Excel.

What is an Excel Dashboard?

An Excel Dashboard is a simple tool for the management, allowing them to get a glance at the business in just a single screen – without looking at multiple sheets of data or charts.

See the dashboard created in the image here. You may not even realize that it was created in Microsoft Excel.

Plus, it is not just a pretty dashboard. There are things that can change – with  the click of a button, you can change the division, product, year, and the entire set of graphs, numbers, charts will change dynamically. Try that in PowerPoint….

Is Excel Good for Creating Dashboards?

Yes, Excel has all the important features that can make a complete dashboard. In fact, small companies rely on Excel for almost all their work as they can’t afford the more expensive Business Intelligence software. You can create multiple charts, KPIs, to be displayed in a single page, and set them to refresh automatically upon opening.

There are several options to add buttons, dropdowns, check boxes, radio buttons that add interactivity to Excel dashboards. With these control, plus macros, and Power Query running in the background to fetch and clean data, is all you need to make any kind of dashboard in Excel.

How to Create a Dashboard in Excel from Scratch?

It is pretty easy to make a Dashboard in Microsoft Excel. Here are some steps for you to follow:

how to create a dashboard in excel
How To Create a Dashboard in Excel

Step 1: To make a dashboard in Excel, you must begin with the end picture in mind.

If you do not have a clear end picture in mind, it may make sense to do some brainstorming on a piece of paper.

Better still, gather a bunch of colleagues and managers, and do this in a meeting, to understand what are the key things you must measure. KPI, ROI, Net Margin, Market Share, Cost per acquisition etc. are good things to measure. This can be translated into any industry. So you can measure Number of hotel nights booked, Number of patients admitted vs discharged, average hours worked per week etc. Excel Dashboard Course in Singapore

You also have to think about the Dimensions you would like to slice this data on – by Country Department, Quarter, Zone, Area, Cost Center, etc. This will allow you to compare the metrics from the different periods and it becomes much easier to track if the performance is getting better or worse.

Step 2: Collect the Required Data For the Excel Dashboard

Once you know what you want to track and measure, you must make sure that this data is collected, and is available. You might have to extract it from your ERP or internal databases or systems.

Microsoft Excel can load any kind of data – be it text file, CSV file, directly scrape off the data from the Internet, or even read it from a SQL RDBMS database.

Step 3: Clean the Data

Extract & take the required data. You will have to clean it using Excel Formulas and functions, or you can use Power Query. Remove useless columns.

Use of functions like these can be handy

  • FILTER
  • CONCATENATE
  • LEN
  • PROPER
  • DATEDIFF
  • TODAY
  • NOW
  • LEFT
  • RIGHT
  • FIND

Step 4: Build Connections With Master Data

Raw data on its own may not be very useful. Build the right VLookups to link with Master Data for our Dashboard Creation in Excel.

You can link Excel to other external or internal workbooks, and worksheets. You must know how to copy or link data from external worksheets and workbooks.

The good thing is that once the connection is built, you don’t have to open the associated file to use it.

Excel will automatically open the linked files when the management dashboard is being refreshed.

Step 5: Build Measures & Calculations For the Excel Dashboard

A few new formulas may be required to be built, to calculate the key measures. This requires knowledge of advanced excel formulas like the ones here. You may need more or less….

Starting out with these key Advanced Excel Functions is going to be crucial for a good Excel Dashboard.

  • VLOOKUP or XLOOKUP
  • INDEX,
  • MATCH,
  • OFFSET,
  • SUMIF,
  • LARGE
  • SUBTOTAL
  • FILTER

Step 6: Build Charts & Tables With the  KPIs in the Excel Dashboard

The next step is to start building the dashboards with the KPIs, Charts, Pivots to summarize the data at the right granularity.

Excel dashboard training in Singapore by Intellisoft - Vinai Prakash
Excel dashboard training in Singapore by Intellisoft – Vinai Prakash

You can add pivot tables, Excel Tables, Charts, and Summary Calculations. You can also use Conditional Formatting for these values, to be able to pin point them easily. Once the Dashboard looks great, you move to the next step in Excel Dashboard creation, where interactivity is added.

Step 7: Add Interactivity With Excel Controls

Once the KPIs are in place, it is required for your to build the interactivity in, to slice and dice by country, division, zone, periods like quarters, months etc. You can add Slicers, Buttons, Dropdowns, Check boxes to check or uncheck, and based on the selection, the appropriate charts and KPIs can be updated.

Step 8: Begin Using The New Dashboard

That’s it. Your Excel dashboard is ready. Begin using it. Tweak it as needed. Share it with other colleagues, so you can gather more feedback, and improve it. Once a dashboard becomes ready, it becomes easy to measure things throughout the company, based on the same benchmark or metrics.

Learn How To Create Excel Dashboards

Of course, to start building such Excel Dashboards, you must know some Basic & Advanced featured of Excel.

Once you know these, you can begin to learn how to create such dynamic dashboards using Excel.

Attend Excel Dashboard Training in Singapore

Excel Dashboard Training Participants
Excel Dashboard Training Participants at Intellisoft

You can attend our 2 day Most Popular Excel Dashboards Training in Singapore – it starts at the basics, and covers step by step features required to create such dashboards with Excel, on your own.

Plus we provide you with snacks, tea/coffee breaks, so everything required is available… and you can focus on learning and building the Excel dashboards quickly, and easily.

Intellisoft runs Dashboard MasterClass in Singapore, Malaysia, Indonesia, Hong Kong, Dubai, Qatar, India, and many other countries.

If you would like to join our next Excel Dashboard Training Course, simply contact us, and we will advice you of the dates, training schedule in the city of your choice.

Contact us to enroll for this practical, hands on training. We will email you the Course Brochure too, so you can see the topics covered in detail.

Customized Corporate Training is available for this Excel Dashboard Training in Singapore

So far we have conducted a number of such classes for the staff of large MNC companies, teaching them how to create such reports and dashboards with ease, and they have been highly popular and successful… requiring us to do multiple repeat sessions for other divisions, countries also.

Do learn these simple techniques to create useful, and interactive Dashboards using Excel and beyond. You will be amazed at the ease with which you can track and measure things. Better still, everyone will be on the same page.

Removing confusion from the corporate culture is a major step towards success with Excel Dashboards

Cheers,
Vinai Prakash
Intellisoft Systems Team
Singapore

Work Matters, Make a Difference!

Work Matters. Period.

We do not work just to get paid, just to finish the 9-5 routine.

We want to make a difference, a contribution, a celebration of life, of living. Therefore, work matters!

But are you doing your best today?

Are you excelling at work?

If not, why not. WHY?

W H Y ?

What are you waiting for?

Today, we are not fighting war with the communists. We may not be working on THE project of a lifetime – The Taj Mahal, The Rocket to Moon, The Scaling of South Pole, or The Everest. So therefore, should we do just a mediocre job… just a job to get by?

Or should we make any job, any crummy job as THE PROJECT of my Life… and really excel at it.

Why Not? Do you need anyone’s permission to do an excellent job? And will you do an excellent job, an Wow job only when someone’s life or job is at stake?

Decide today to do Your Best. Excel at anything. Make it the Project of your lifetime. Do such a wonderful job that people will talk about this work ten years from now. Man… those were the days… We worked on THE project of my life. It was such fun, such camaraderie, such great teamwork, such coordination, so much precision, and we pulled it against all odds. Those were the days!!!

Do not think of any job as just a job. Make it a WOW project. THE project of your life. Even if it is a small, simple job. Do with with dedication, do it with perfection. You will enjoy it more. You will be happy. You are not doing it to show off to anyone.But you are doing it to Show it your YOURSELF. You will feel job satisfaction. You will feel that

you are making a difference.

And you will be surprised. Others will see it. Notice it. They have no choice. A good quality work gets noticed pretty quickly. Because it is a rarity today. People are so used to seeing the mediocre job, the average job, that when you do an Excellent job, everyone notices… Automatically. You do not have to announce it.

And even if no one notices, or no one shows that they have noticed…. it is bound to happen. With it come its own rewards. More recognition, more power, more money, more satisfaction, and more success. You will know it first.

I take pride in my work. I find ways to add more value… provide more value. Find ways to give you new tips, tricks, new ways to add value to your work. When I coach, I try to give practical tips, not just theory, so that you can benefit from it immediately. Learn new skills – hard technical skills like Advanced  Excel Techniques, or Soft Skills like Communication Skills… Train yourself, and your staff. There are several benefits of training. Invest in your knowledge, and spread the word.

Make it a point from today onwards. Find ways to transform your work… every day work, into a project that matters. Because Work Matters. Your Life Matters. What You Do matters, and You Matter Too!

– By Vinai Prakash, Founder & Principal Trainer at Intellisoft Singapore

P.S. – Write your comments. Tell me what you think. Does it ring a bell somewhere? Or you simply do not agree with this philosophy. What ever you feel, post a comment, and I’ll be happy to see what you feel, and where you come from. Thanks.

Join our Practical hands-on training on excel pivot table, vlookups in excel, excel functions, advance excel formula & more… Advanced Excel and improve your soft skills like Communication SkillsPresentation SkillsNegotiation Skills and more..

Do You Use These Advanced Features in Microsoft Excel?

Advanced Excel training at Intellisoft
Practical hands-on advanced excel training at Intellisoft
Practical hands-on advanced excel training at Intellisoft

Most people hardly use the huge number of features available in Microsoft Excel. Many are just using Excel as a calculator. This is a gross under use of Excel’s vast potential and feature rich functionality.

Do a quick check, and see if you use these advanced features of Microsoft Excel in your day to day work.

Some of the common things that can be done easily with Excel are:

  1. Finding the Top 10 Customers or Finding the Bottom 10 Performers in the organization
  2. Highlight values that are above or below a certain threshold – like all sales above $25,000 to be highlighted
  3. Sort the values in Ascending, Descending or any customized order – like sorting in order of Manufacturing, Accounts, Sales departments.
  4. Give Names to Range of Cells, and then use them in formulas for easy referencing and decoding
  5. Exploit Pivot Tables to Summarize the data and slice & dice it in any way – finding sales by product groups, or calculating productivity by department
  6. Write Macros to automate routine things that save you a huge amount of time – example creating pivots, charts, tables, and doing complex calculations automatically.
  7. Use advanced filtering conditions, and be able to filter data using multiple different criteria
  8. Create fantastic charts that portray the given business situation perfectly. There are over 50 different types of charts to choose from, and each has its edge, advantages and a reason.
  9. Create management dashboard that are dynamic, and provide a complete snapshot of the key business KPIs in the company – change the chart values at the click of a checkbox or change in a drop-down value
  10. Use Excel’s advanced What-If analysis to do projections for future, forecasting, trend analysis etc. with ease
  11. Use Lookup tables to find any value or corresponding value from a table using advanced functions and formulas

This is just the tip of the iceberg. Microsoft Excel is really extremely powerful. Each version of Microsoft Excel – be it Excel 2007, or Excel 2010 or Excel 2013 adds more and more features to the already powerful dynamite of a package.

At Intellisoft, we teach people how to leverage the maximum power out of Microsoft Excel in short training courses. Some of the popular courses are:

We have a number of Public Classes each month, and we also provided In-House Training to your staff and team at your office, if you have a group of 10+ people, and have a room to hold the training.

So what are you waiting for? If you would like to learn any one or more of such useful features of Microsoft Excel, come for a short Excel Training at Intellisoft.

Go ahead, equip your team with the right skills. Get everyone on board to learn the basic and advanced features of Microsoft Excel, and Be Awesome in Excel!

Email to training@intellisoft.com.sg or call +65-6250-3575 for the next available schedule of Microsoft Excel Training in Singapore.

We are located at Fortune Centre, in Singapore! Location Map of Intellisoft

Cheers,
Vinai Prakash, PMP, ITIL, Six Sigma, GAP,
Master Trainer

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!