what is excel?
Excel is a spreadsheet(s) application with rows and columns that enables a user to input, clean, analyze, visualize and store data.
Functions and formulae
Some of these include average, sum, maximum and minimum values and IF functions for awarding criteria, COUNT for numeric, COUNTA for text data and COUNT IF and COUNTIFS for conditional values as illustrated below
=COUNTIF(range, criteria)
Pivot tables and Dashboards enable the user to summarize large data sets quickly and use charts to visualize data and show relationships.
Use in Real- World
Excel is used in hospital and research settings to;
- Manage client data such as clients' records, surveillance data and progressive results.
- Analysists use excel to calculate different values, identify trends and monitor indicators such as prevalence, incidence and mortality rates.
Learning excel (still learning) has enabled me to learn to look at data differently as I can now ably clean, analyze and draw conclusions from it. This will be very helpful in my research work.
Top comments (0)