- Trending Categories
Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
Physics
Chemistry
Biology
Mathematics
English
Economics
Psychology
Social Studies
Fashion Studies
Legal Studies
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
Found 696 Articles for Advanced Excel Function
![Pradeep Kumar](https://www.tutorialspoint.com/assets/profiles/483469/profile/60_891162-1657084658.jpg)
4K+ Views
A period is nothing but a dot(.) symbol which we can use after each number in the list of numbers. A period is used in Excel to generally represent that a number has ended. Adding a period can be done in two ways in Excel. The first one is by using the formula and the other by using the Format option. Read through this tutorial to find out how you can add period marks after numbers list in Excel in a simple and efficient manner. Adding Period After Numbers List using Formula Let us take a simple example to understand ... Read More
![Pradeep Kumar](https://www.tutorialspoint.com/assets/profiles/483469/profile/60_891162-1657084658.jpg)
7K+ Views
When you have to add a Percentage symbol to an existing set of data in Excel, you have two ways to do so. The first one is to select the data and click the Percentage symbol under the Home menu and the other method is to select the cells and format cells for percentage. These two methods will not only add the "%" symbol but also multiply the numbers with 100. This tutorial will help you understand how you can add "%" symbol without changing the value of the numbers. How to Add Percentage Symbol for Multiple Numbers in Excel ... Read More
![Pradeep Kumar](https://www.tutorialspoint.com/assets/profiles/483469/profile/60_891162-1657084658.jpg)
682 Views
Generally, strikethrough is used in Excel to represent that the data present in the cell is an error or the event is completed. Strikethrough is also used to represent that the event or the process has successfully completed without any error and mistakes. In this tutorial, we will show you a simple process to add or remove strikethrough in Excel. How to Add Strikethrough in Excel? Let us see a simple process to see how to add strikethrough in Excel. Step 1 We will use the following data and add strikethrough in a selected few cells. To add ... Read More
![Pradeep Kumar](https://www.tutorialspoint.com/assets/profiles/483469/profile/60_891162-1657084658.jpg)
868 Views
We can add a vertical/average line to a bar chart in Excel by using the horizontal bar graph. The average line is used to analyse the data value in the graph but checking whether we have reached the average or not in the particular interval. Adding vertical average line to a bar chart in Excel is a simple but lengthy process. In this tutorial, we will show you the step-by-step process to add a vertical/average line to bar chart in Excel. Step 1 First, we need to create a horizontal bar chart. Select the data and then click "Insert". Then ... Read More
![Pradeep Kumar](https://www.tutorialspoint.com/assets/profiles/483469/profile/60_891162-1657084658.jpg)
2K+ Views
Displaying alternate row colours in a normal table is a very simple process which can be done using the conditional formatting concept but creating alternate row colour in pivot table is simple problem. A pivot table in Excel is an interactive table which helps in quickly summarizing the data. When we want to add alternate row colour in a pivot table is a lengthy and simple problem.so let us see a simple trick to end this problem. Let us see a simple process to add alternate row colours in an Excel pivot table. Step 1 Let us consider the table ... Read More
![Pradeep Kumar](https://www.tutorialspoint.com/assets/profiles/483469/profile/60_891162-1657084658.jpg)
640 Views
As we all know that we can change the colour of alternate rows with different colours very easy in excel but have you ever wondered can alternate row colour based on the condition the condition can be anything. We will try to choose the colour for the row based on a single condition. We can achieve this by just following this simple process to alternate row colour based on group in excel Let us see a simple process to alternate row colour in Excel based on group. Step 1 Let us assume a situation where we have a data where ... Read More
![Pradeep Kumar](https://www.tutorialspoint.com/assets/profiles/483469/profile/60_891162-1657084658.jpg)
30K+ Views
Let us assume we have a situation where we have collected names of people from two sources and you want to know the names of the people who have registered from the both sources and we want to make a list of then them so we can use this simple process to list the names of people present in both lists. We can also find the duplicate names present in the both lists. Let us see a simple process to align duplicate or matching values in two columns in Excel. Step 1 Open an Excel sheet where there are two ... Read More
![Pradeep Kumar](https://www.tutorialspoint.com/assets/profiles/483469/profile/60_891162-1657084658.jpg)
3K+ Views
When we create a pivot table in excel where there is a list of items and you want to know their share in the list in percentage. Read through this tutorial to understand how you can create a new column where it shows the percentage of grand total or subtotal column in a excel pivot table in a simple process. How to Add Percentage of Grand Total Column in Excel Pivot Table Let us see a simple process to add percentage column of total column in an Excel pivot table − Step 1 Let us assume the Excel sheet where ... Read More
![Shibanshu Manna](https://www.tutorialspoint.com/assets/profiles/519058/profile/60_931183-1663228686.jpg)
248 Views
Do you often encounter too much data and spend a lot of time selecting and clearing Excel sheets? If so, this tutorial will be helpful to you. When analysing elaborative Excel worksheets, removing non-relevant information often makes it easier to study them. This tutorial explains how to clear an entire spreadsheet and a specified range in MS Excel using two simple methods Method 1: How to Clear The Entire Sheet? This is an easy procedure. If you want to clear the entire sheet, you can use a keyboard shortcut or from the corner cell. We learn how to do ... Read More
![Shibanshu Manna](https://www.tutorialspoint.com/assets/profiles/519058/profile/60_931183-1663228686.jpg)
4K+ Views
It is commonly known that when you right-click on an Excel file, you can see its properties and size. But what about when you want to know the size of individual worksheets within the file? Accountants and data analysts maintain large Excel workbooks with multiple worksheets. Understanding the file size can help determine the best way to analyze it. Some might want to begin with the heavy worksheet, or some may start with the lighter one. It often turns out that one sheet takes up the majority of the space in the workbook. This tutorial explains how to identify the ... Read More