Found 159 Questions for Advanced Excel Function

Compare two columns and add missing values in Excel

Pradeep Kumar
Updated on 10-Sep-2022 08:39:30
We all occasionally find ourselves in the position of having to compare columns in Excel. When it comes to comparing and matching data, Microsoft Excel has a lot of alternatives; however, the majority of these options center on searching in a single column. When you have data organized in two distinct columns, you may need to compare them in order to determine which column is lacking certain information and which column contains information that is already there. Depending on what you hope to achieve from making comparisons, you can approach the task in a number of different ways. Let’s learn ... Read More

Combine the COUNTIF and LEFT functions to count cells that begin with a certain character in Excel

Pradeep Kumar
Updated on 10-Sep-2022 08:39:51
Excel's COUNTIF function is used to determine the number of cells inside a given range that fulfil the requirements of a certain condition. In the criteria, logical operators such as ">,

Change the font / size of row and column headings in Excel

Pradeep Kumar
Updated on 10-Sep-2022 08:40:16
When you use the Excel workbook, have you ever tried to alternate the font or measurement of row and column headings to make the headings larger or extra beautiful? In fact, Excel offers some tricks for you to solve this task. With the futures we have in the Excel workbook, you can change the font and size of the row and column as you like. Change the Font and Size of Row and Column using the Styles Feature in Excel Following are the steps to change the Font/Size and row/column in excel. Step 1 Open the workbook that you want ... Read More

Change chart colour based on the value in Excel

Pradeep Kumar
Updated on 10-Sep-2022 08:40:38
Conditional formatting refers to the process by which you can show distinct value ranges as different colours in a chart. This may be something you wish to do when you insert a chart at times. Because the Excel feature only applies to cells and not charts, we can apply the concept of conditional formatting to column charts by combining different data series. This is because conditional formatting is only applicable to cells. For instance, if the value range is 0–150, the series colour should be shown as blue. If the value range is 151–250, the colour should be shown ... Read More

Add text and number into specified position of cell in Excel

Pradeep Kumar
Updated on 10-Sep-2022 08:41:02
There may be times when you need to insert the identical text into all of the cells that are contained inside a column. It's possible that a specific title needs to go before the names in a list, or that a specific symbol needs to go at the end of the text in each cell. Both of these things need to be done. The task of adding text or numbers to cells in Excel is one of the most often performed tasks. Including things like inserting spaces between names, including prefixes and suffixes in cells, and inserting dashes in social ... Read More

Add currency symbols in Excel

Pradeep Kumar
Updated on 10-Sep-2022 08:41:26
Excel provides a variety of options for users who wish to insert symbols into their work. Utilizing the keyboard and the buttons on the Ribbon, creating a formula, and formatting cells are some examples of these. Due to the fact that different currencies have different values, it is often absolutely necessary to label values with their respective currencies. In this tutorial, we are going to learn about different methods to add currency symbols in excel. Using Format Cells You will need to format the numbers so that they are compatible with currency if you wish to display them as monetary ... Read More

A VBA code to list all add-ins in Excel

Pradeep Kumar
Updated on 10-Sep-2022 08:41:50
Microsoft Excel can receive additional commands and capabilities through the use of add-ins. Because Excel does not make its add-ins immediately accessible by default, you will need to first install and then (in certain situations) activate the add-ins in question before you can make use of them. A group of AddIn objects that collectively represents all of the add-ins that can be used with Microsoft Excel, regardless of whether or not the add-ins have been installed. We can list all add-ins in an Excel sheet through a VBA code. So let’s see the VBA code and how it works ... Read More

How to Convert Date Stored as Text to Date in Excel?

Pradeep Kumar
Updated on 07-Jul-2022 14:25:13
When we need to conduct trend analysis, dates act as essential elements. Dates play an important role and you need to make sure that they are conveyed in the best possible way. There are times when dates might end up being formatted as text and saved in the cells.You may have, for instance, placed a date into a cell in text format, or the date may have been imported or pasted from an external data source as text.Convert Text Dates with Two-Digit Years by Using Error CheckingIn this tutorial, we will discuss two methods to convert text formatted dates to ... Read More

How to AutoSum Multiple Rows and Columns in Excel?

Pradeep Kumar
Updated on 07-Jul-2022 14:16:58
Using the SUM method in Excel, we can normally total up the values in a column or row. In point of fact, rather than manually putting the SUM formula into a cell, we may use the AutoSum formula to calculate the sum of the values in a far more expedient manner. Within Excel, there is a formula known as AutoSum, which I shall explain below. Excel can automatically compute the total of a column or row of numbers when you ask it to do so.Excel will automatically enter a formula to sum the numbers (one that makes use of the ... Read More

How to Combine Data from Multiple Excel Worksheets into One?

Pradeep Kumar
Updated on 07-Jul-2022 14:11:59
There are situations when the data that you require is scattered across numerous sheets in Microsoft Excel, or even multiple files. How wonderful it would be if you could collect all this data in a single document?When you are in a hurry, you can save time by simply copying and pasting the necessary cells onto the same sheet. However, the amount of time and effort required to complete this task may be quite substantial, depending on the data that you are analyzing. Instead, you could think about some of the more intelligent approaches to complete the same task.In this tutorial, ... Read More