Data Analysis
is the process of cleaning, changing, and processing raw data and extracting actionable, relevant information that helps business and organizations make informed decisions.
This can be done using software like Ms. Access, Ms. Excel and others.
There are about 100 excel functions for data analysis.
The 8 functions out of the 100 are said to be the easiest and can increase your ability to interpret data.
They are;
- Concatenate (This function is used to combine text from different cell into a single cell)
- Len (This is used to show the character limit on a particular cell)
- Days (This function is used to show the number of calendar days between two dates)
- Net workdays (It is used in calculating the day to day activities of an employee in a particular organization)
- Sumifs (It is used to sum data from different criteria)
- Averageifs (This functions is used to take an average on numerous parameters)
- Countifs (This counts a number of values that satisfy a set of condition) ▪ Counta (This function allows you to find or determine any gap in the dataset).
Watch On YouTube
This page is fabulous. The brilliant substance reveals the distributer’s interest. I’m awestruck and expect further such extraordinary material.
I really enjoyed what you have accomplished here. The outline is elegant, your written content is stylish, yet you seem to have acquired a bit of apprehension over what you aim to convey next. Undoubtedly, I will revisit more frequently, just as I have been doing nearly all the time in case you sustain this upswing.
Stumbling upon this website was such a delightful find. The layout is clean and inviting, making it a pleasure to explore the terrific content. I’m incredibly impressed by the level of effort and passion that clearly goes into maintaining such a valuable online space.