Microsoft Excel: Deadly sins of maintaining list in Excel sheet Part 3

This will be the Part 3 of the Deadly Sins of Maintaining List in Excel which we have covered the first 2 part earlier.

Part 1 : Microsoft Excel : Deadly sins you should not do in Excel (Part 1)

Part 2: Microsoft Excel : Deadly sins of maintaining list in Excel sheet (Part 2)

Each data belongs to its own column

While you’re designing a table or list in Excel, plan ahead is extremely important. Always remember, while you’re designing a table, plan and think of what you need, what kind of the report that you will need to create at the end month or the end of the year. From there, you will roughly know what sort of data you’re require to collect during data entry.

First, you must plan how many columns you need, name each column as what you need to collect in its column. Each column only limited to one types of data type.

If you have seen this kind of tabulated data and calling it a table. Well, you’re not quite right. This is a report, static report not a table or list.

Continue reading “Microsoft Excel: Deadly sins of maintaining list in Excel sheet Part 3”

How To Be an Effective Social Media Influencer

Social Media Influencer Marketing is a very tricky industry for brands and Social Influencers. It used to be an effective avenue for brands to create awareness and even get some sales, but lately it hasn’t been working. This is because Social Influencers have been destroying the industry as they forget what brands want. Instead, they just focus on the number game required to get endorsements and collaboration deals.

That said, Social Media Influencer Marketing still works, but now brands have to put in more effort to identify which influencers are worth the investment and which are just pretenders. To be a proper Social Media Influencer, one has to look at the big picture and ask real questions like How will this help the brand reach their KPI or How do I influencer more people to buy this product? If you, like the other 6 billion other people in the world, dream of becoming a successful Social Media Influencer, here are some good tips to follow:

Find a Niche and Stick To It

Marketers always say that “If everyone is your target Audience, then you have no Target Audience.” Start by figuring out which topic you want to talk about. Anything from Food, Travelling, Books, Football and Cars will work. Continue reading “How To Be an Effective Social Media Influencer”

Info Trek Events Highlight in June 2018

The Synergy between ITIL, Agile, Lean IT and DevOps workshop was organised on 7 June 2018 by Info Trek with the collaboration of Quint Wellington Redwood. We are proud to invite the CEO of Quint, Mr. Maurice and the Director Consulting Asia for Quint, Mr. Michiel to speak for the workshop.

With the fast-paced digital world, many organisations have turned to leading workflow models and concepts to adapt more sustainably to the rapid shifting technology landscape, specifically: ITIL, Agile, DevOps, Lean IT.

ITIL is referred as the best practice framework for IT service management (ITSM) from the business and customer outlook. It aims to deliver quality IT services with continuous measurement and improvement.

Agile is a time-boxed iterative approach that builds and delivers software incrementally. Unlike the traditional waterfall model which is based on presumptions and assumptions, it seeks feedback right from the beginning of the project to optimise software development. Continue reading “Info Trek Events Highlight in June 2018”

Digital transformation and how to realize it

Our world is going through a huge digital transformation. The technology push, information push and social push bring with them major, disruptive changes. Organizations have no choice: they must undergo a digital transformation to become a digital organization. The question is, how? New technology and new kinds of information change the lives of individuals and organizations alike. Every organization, whether for-profit or non-profit, needs to ask itself what opportunities all these new possibilities offer, and what threats they bring. And most importantly: what must be done differently from now on?

This paper addresses that question through an action plan consisting of five main steps.

Step 1: Focus on short cycles

Step 2: Create a digital foundation

Step 3: Become more agile

Step 4: Investigate new technologies

Step 5: Surprise your customers

Download the whitepaper here.


What is Personal Data Protection Act (PDPA) 2010?

You received a call from an unknown number, asking if you would like to have your house rented out or perhaps take up a loan? You’re not too sure who or how these people got your phone number, you haven’t provided anyone with such information recently. Then it dawns on you, you recently provided your home’s management office with your personal details; somehow your information was transferred without your authorization to other parties.

What can you do? What are your rights in this digital age with regards to your digital data? Here’s what you need to know, to get up to speed on the Personal Data Protection Act 2010.

My Story with Data Abuse

Long story short, I was filling a complaint to our apartment’s management team, and they requested personal data such as our home unit number, full name and MyKad number. Few days later, home owners like me who had filed complaints with the management team, had our complaints with all of our unit numbers and MyKad details published publicly. Is this legal? Definitely not.

So what is considered personal data? Basically any information that can be used to personally identify you, your whereabouts, your history and your actions. Here’s a common list, but not limited to: Continue reading “What is Personal Data Protection Act (PDPA) 2010?”