Introduction to MS Excel for Data Analytics

Excel is a widely used program by Microsoft.
Most data analyst can attest to how messy data can me and most use Excel to collect,organise clean data and analyze data.

if one have a dataset as shown below always begin by cleaning it through

Removing duplicates#

As shown below this makes your database less bulky and its more easy to get accurate information.

Ensuring that all columns and rows are set in accordance to what they represents if its in text,values,dates or others.

sort function ensures that the analysts can display their data set in various ways to give the intended outcomes

filter tool helps the analysist to pick what information to dispay at a particular time while hiding the rest of the data,

most common functions in excel which most analysists use includes

1. SUM With this function adding up data is made very easy remember some datasets entails very many rows and columns of data and it would very tedious to use a manual way to add up these data.

one can also use this formulae for summation.

###We have various Logical formulae's used for decision making they includes

1. IFERROR =IFERROR(Q2/P2, "Error")
2. Index AND matching

1. Vlookup

1. Calculating Lead Time

1. Organising distorted informations

1. Creation of Pivot tables to analyse information from datasets

Some of the analysis that one can do with the pivot tables

#Hope you find this helpful and to write more on these in future