It has been two weeks since immersing myself in the world of Data Science, Analytics and AI and all I can say is I love it here. I love working with data, it tells you all you want to know if properly cleaned and analyzed. Data analytics allows us look into data and be able to answer what happened. This basically enables us do analysis of data. Some examples of data analysis tool we have is Excel, SQL, languages like python and Power BI.
I want to focus mainly on Excel which is a microsoft spreadsheet software that allows us collect , organize, analyze, calculate and visualize data efficiently. It is one of the most commonly used and powerful tool for data management.
Uses of Excel in The Real World
Excel is used wherever their is data in every industry, job and every level of an organisation and it is used for organising, handling and analyzing data.
Some of the most common uses include:
- Data Cleaning- preparing messy data for analysis by removing duplicates and fixing inconsistencies.
- Budgeting and Financial Planning- tracking income, expenses, profits and forecast for personal or business finances.
- Data Entry and Organisation- storing and structuring data in rows and columns.
- Project Planning- for tracking tasks, deadlines and team assignments.
- Payroll and HR Management- calculating salaries, deductions and employee records.
Business rely on Excel because it helps turn raw and messy data into an organized and meaningful data used for decision making.
Basic Excel Features I learnt
Some of the basic excel feature I learnt that help with data organisation and analysis include:
- The Excel Interface- it is a user interface made of many tools with the following components; ribbon, quick access toolbar, formula bar,name box, column, rows, cells and worksheet.
- Data sorting- used for arranging data in a specific order either in ascending or descending order.
- Data filtering- allows us display only the rows that meet certain criteria and hide the rest temporarily.
- Data validation- restricts the type of data users can input in a cell.
- Freezing panes- used to keep headers or important columns in view as I scroll.
- Conditional formating- highlights cells automatially based on rules or criteria, helping to spot trends or outliers.
Basic Excel Functions
Before getting to know the excel functions, I first needed to understand a formula is an expression that calculates the value of a cell and it begins with an equal sign(=). Afterwhich I can now define a function as a predefined formula in Excel that performs a specific task.
We learnt about aggregate functions and they include:
- SUM()- adds a range of numbers
- AVERAGE()- calculates the mean of values
- MIN()-finds the smallest number
- MAX()- finds the largest number
- COUNT()-counts how many numbers are in a range
- MEDIAN()- finds the middle number in a column
- MODE()- finds the most appearing number in a column
We also got to look at conditional aggregation like
- COUNT IF()& COUNT IFS()- counts records that match a specific criteria
- SUM IF()& SUM IFS()- adds values that meet one or more conditions
- AVERAGE IF()& AVERAGE IFS()- calculate average based on selected conditions
Before Excel I had Data.After Excel I had Answers
Before properly learning how to use Excel, I used to see it a tool with rows and column whose main purpose was only to organize and record data.
But now I understand it can be used for more than just that it can help tell stories, reveal patterns and make informed decisions.
This basically wraps up my first week of Excel and I can say it a powerful tool as well as very important.
Top comments (0)