Read all about it

Data Analyst : List of Excel skills required

Data analysis is one of the up and rising skill in Malaysia and globally. It is highly popular. It is frequently link to fancy words like big data and data scientist.

Thanks to AI and real time data processing software the amount of business data collected everyday is enormous. Imagine you work for company like 99Speedmart. What if your boss ask you :” Which hour of the day we have the most amount of customer?” So that he can arrange manpower accordingly.

The cash register at all the branches are now connected and transaction all passed through a POS (Point of Sales) system. This provide the convenience of capturing details from every single transactional. Answering that question is no hassle. Most softwares don’t just record data, they allows data to be exported as csv and the data can be opened in Excel.

Data analysis is getting more common place. It is now a valuable  business skill. Allows records and transactions to be used to understand problems facing an organisation, and to explore data in meaningful ways. Data in itself is merely facts and figures. Data analysis organises, interprets, structures and presents the data into useful information that provides meaningful context for the data. Especially with the use of charts, graphically presenting data has greater meaning.

 

“The use of Excel is widespread in the data analysis industry. Microsoft Excel is a very powerful data analysis tool and almost all big and small businesses use Excel in their day to day functioning. But in order to do data analysis we need a slightly more advanced Excel skills.”

In order to perform Data Analysis you need to have two types of excel skills: Data processing and data visualisation.

Data Processing:
  • The “IF” Command in Excel
  • The “Nested IF” Command in Excel
  • The “VLOOKUP” Function in Excel
  • The “HLOOKUP” Function in Excel
  • Data Filtering
  • Pivot Tables
Visualisation :
  • Line Graphs
  • Bar Graphs and Pie Charts
  • Pivot Charts
  • Scatter Plots
  • Histograms

Learn excel & be certified

With Microsoft Office Specialist (MOS) programs you will be equipped with the skills and the certification to proof it. 

Productivity Hack

Having an exam on the to do list and still getting along with existing commitment need some level of effort?

If you want to be more productive, you should start connecting the things you want to get done to other things you’re already doing.

Why? Because…

Productivity is the result of habit.

Data Analyst : List of Excel skills required

Data analysis is one of the up and rising skill in Malaysia and globally. It is highly popular. It is frequently link to fancy words like big data and data scientist. In order to perform Data Analysis you need to have two types of excel skills: Data processing and data visualisation.

Subscribe To Our newsletter

behind the scenes

Scroll to Top