Excel
Sparklines in Excel: What is, How to Use, Types & Examples
What is Sparklines in Excel? Sparkline in Excel is a small graph which is used to represent a series...
In this tutorial, we are going to cover the following topics.
Data validation is very important in the sense that it helps us avoid mistakes that can be avoided. Let's assume you are recording student exam marks and you know the minimum is 0 and the maximum is 100. You can take advantage of validation features to ensure that only values between 0 and 100 are entered.
Add a new sheet in your workbook by clicking on the plus button at the bottom of the worksheet.
Add a column for S/N, Name and Score. Your sheet should look as follows
S/N | Name | Score |
1 | Jane | |
2 | James | |
3 | Jones | |
4 | Jonathan | |
5 | John |
Data filters allow us to get data that matches our desired criteria. Let's say we want to show the results of all the students whose names start with "ja" or get scores that are less than, greater than or equal to a certain value, we can use filters to get such data.
Select the name and scores columns as shown below
Groups allow us to view easily and hide unnecessary details from either columns or rows. In addition to that, we can also use groups to analyse data that belongs to a common category. Let's illustrate this with an example. We will use the student scores example above.
We will now group the females together and display their average score and do the same for the males.
You will get the following window
Click on Subtotal drop down button under DATA tab
You will get the following window
At times, you would like to brand the documents printed in excel with letterhead information and print with the company logo, etc. Excel has features that allow you to import images into Excel. The command for adding images is found under the INSERT tab on the ribbon.
You will get the following dialogue window
Use the INSERT tab pictures command to add a picture of your choice to the worksheet.
In this article, we have learnt how to perform basic arithmetic operations using Excel, format the data, and apply validation rules, filter data and how to take advantage of groups to further analyse data and improve presentation.
What is Sparklines in Excel? Sparkline in Excel is a small graph which is used to represent a series...
Excel is the most powerful tool to manage and analyze various types of Data. This eBook covers...
In this tutorial, we are going to import data from a simple external database powered by Microsoft Access...
Excel is a spreadsheet software included in the Microsoft office suite. It widely is used to...
Download PDF We have organized the most commonly asked Microsoft Excel Interview Questions and...
In this tutorial, we are going to perform basic arithmetic operations i.e. addition, subtraction,...