To anyone who has basic computer knowledge will tell you they know Excel, many will just say it's a software but they might not tell you beyond that. Well they're are not wrong because it's a program developed by Microsoft most 'ignored' but doesn't negate the fact it's a powerful tool that it has a cluster of functions that one can use.
*Excel *- a program developed by Microsoft, it's a spreadsheet used that organizes data into rows and columns and allows you to do mathematical functions.
In real world scenarios Excel is typically used for:
Data entry - allows users to input and organize information into structured rows and columns.
Data management- enables users to input, organise, and analyse information without the need of complex databases.
Data analysis- excel allows users to clean data and perform mathematical functions to analyse data.
Visuals and graphs- Excel has charts, graphs, maps, etc., that provide a simple and accessible way to understand our data and identify trends and outliers within datasets.
Financial modelling - Excel has a built in financial modelling tool that is used to understand and perform analysis on underlying business to guide on decision making.
WEEK 1 OF LEARNING EXCEL
Week 1 of learning has been a rollercoaster, first thing first we explored the toolbar that holds all the tools that can be used in excel. Learning what a cell is, differentiating between a row and a column.
Functions explored:
- MAX () - finds the highest number in range.
MAX (A1:A100)
- MIN () - finds the lowest number in range.
MIN(A1:A100)
- AVERAGE() - calculates the average( arithmetic mean)
AVERAGE(A1:A100)
- SUM() - adds up numbers in range.
SUM(A1:A100)
- COUNT() - counts cells with numbers in range.
COUNT(A1:A100)
Week 1 was a lot of introduction but I loved it, there's is so much to explore in excel, and working with data is really interesting. The best bit is well cleaned and analysed data will always explain the trend and what is happening within a business.
Top comments (0)