Archive for the ‘Data’ Category

MS Excel – One of the most useful skills for 2019

Microsoft Excel is the most commonly used spreadsheet package in the world. It is ranked the second most used applications in the MS Office suite. This means that not only individuals but organisations and businesses employ Microsoft Excel in daily transactions.


Better employment options

As more start-ups and established companies delve into new niches of research and development and ultimately new products and services, they look to hire more people with knowledge of Excel. If you can quickly create pivot tables, execute vlookups and use formulas with ease, then it will become easier for you to land a job in many companies.

Manage projects better

When managing projects, the project manager receives data from multiple sources. Excel can then be used to standardise this information and come up with a single “source of truth” report that documents the progress of the project with formulas built in to indicate where potential issues can occur. An example of this is hitting a particular number of action items by a specific date. A formula on the spreadsheet could colour a cell red if the action items are not complete by the specified date.

Understanding Big Data

Leaders of major companies and governments take decisions every day that affect individual lives based on Big Data. These are extremely large datasets which need to be interpreted and cross-referenced to make meaningful reporting to initiate and support decisions. Excel formulas, especially in the latest updates can help make sense of very large datasets. Many consider Excel to be like Lego for Data in the approach to building efficiency.

Getting the skills

Microsoft offers many resources which can help the busy professional, as well as the dedicated student, get various levels of mastery of Excel. The Microsoft Office website has a series of short training videos under the training section covering anywhere from simple topics like cells and columns to complex subjects like “Get more out of Pivot Tables”. They also have forums where you can ask questions and share your experience.

Additionally, there are many third-party free training resources out there. Many public libraries have entire courses from the basic to the expert level for free. It is also easy to find videos on various Excel topics on YouTube. The paid resources come with extras like free data that you can play around with. You can even take it to the next level and hire an Excel Expert with the possibility to obtain an optional certificate with Microsoft Excel training at a fee upon completion.