Excel is a some what simple tool that is available for most if not all windows but its version varies according to the version of windows being used.
Some of the uses of MS Excel are data organisation and storage and its useful in even clear calculations which is performed using formulas.
When you enter excel in your device, you are presented with a workbook. You can use as many workbooks as you feel obligated to which will be saved to your workbook
Columns in your work sheet are labelled in letters while rows are labelled in numbers
Inputing data
As i stated in the beginning excel can be used to store data. This data is usually simple to input as no formulas or commands are required but rather just a simple input of the exact data you want to work on.You can input data such as names, numbers etc
Lets say you are a clerk in a school, you can input students names, school identification card numbers, even their class...etc
Its not really a must for this to be said but your data has to be presantable so that in future when you need to find a student, it will be easy.
Formulas
Formulas are the kinda commands that are used with numerical values to work on them same as formulas in mathematics. These include sum, average, count, Max, Min...etc. There are many formulas with different uses.
When you select a cell where a formula was used, the formula is displayed at the formula bar above your data
Sum
This formula is used to sum up all the numerical values selected as the name suggests
Average
The formula is used to find the mean of the data selected
Count
It is used to find the number of numbers selected. What i mean is to find how many numbers have been selected to be worked on
Max
Finds out the highest value of the data selected
Min
Finds out the lowest value of the data selected
Sorting and Filtering
Sorting is arranging data in a specific way so that it is more pleasing to the eye and easier to work with
To sort your data, select your data by clicking control + A then go to your home button and click sort to sort your data in a certain way. For numerical data you can arrange it from largest to smallest or smallest to largest while for text-like data you can sort it from A-Z or Z-A.
Filtering is basically working on only a small part of your data at a time of your own preference. This improves efficiency because by working on only a small part especially if you have a large dataset, you get to see exactly what you are working on at the time.
Chart Analytics
Charting is basically displaying your data in form a chart. Charts are more pleasing to the eye than large text-form data therefore inorder to truly view your numerical data clearly, charting is highly advised. There are many types of charts and you can use them according to your preference. They include bar, line...and many more. For a large amount of data, You can use a combo chart which combines different types of charts and different types of data.
Charts are found at the insert part of your workbook
Conclusion
Using MS Excel is not necessarily a hard thing to do but the most advisable is to take it one step at a time so that you can practice any simple thing you do before you move on to the next. This will enhance remembrance rather than rushing through the learning process then later you remember very little.
Top comments (0)