Pradeep Kumar has Published 1236 Articles

Add currency symbols in Excel

Pradeep Kumar

Pradeep Kumar

Updated on 10-Sep-2022 08:41:26

1K+ Views

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 ... Read More

Add text and number into specified position of cell in Excel

Pradeep Kumar

Pradeep Kumar

Updated on 10-Sep-2022 08:41:02

15K+ Views

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 ... Read More

Change chart colour based on the value in Excel

Pradeep Kumar

Pradeep Kumar

Updated on 10-Sep-2022 08:40:38

7K+ Views

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 ... Read More

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

Pradeep Kumar

Pradeep Kumar

Updated on 10-Sep-2022 08:40:16

10K+ Views

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, ... Read More

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

Pradeep Kumar

Pradeep Kumar

Updated on 10-Sep-2022 08:39:51

3K+ Views

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 ">,

Compare two columns and add missing values in Excel

Pradeep Kumar

Pradeep Kumar

Updated on 10-Sep-2022 08:39:30

2K+ Views

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 ... Read More

Compare two columns for matches and differences in Excel

Pradeep Kumar

Pradeep Kumar

Updated on 10-Sep-2022 08:38:49

603 Views

The task of comparing columns in Excel is one that will eventually be required of each and every one of us. When comparing and matching data in Microsoft Excel, you may do so in a variety of ways; however, the vast majority of these approaches focus on searching within a ... Read More

Conditional formatting rows or cells if two columns equal in Excel

Pradeep Kumar

Pradeep Kumar

Updated on 10-Sep-2022 08:38:20

1K+ Views

When comparing and matching data in Microsoft Excel, you may do so in a variety of ways; however, the vast majority of these approaches focus on searching within a single column. When you compare and match data in Microsoft Excel, you can do so in a variety of ways. Instead ... Read More

Conditional formatting stacked bar chart in Excel

Pradeep Kumar

Pradeep Kumar

Updated on 10-Sep-2022 08:37:57

682 Views

When working with charts, there will be instances when you wish to emphasise objects in a certain way depending on whether they are positive or negative, or if they are above or below a benchmark or an average. Even while conditional formatting may be applied to cells, it is not ... Read More

Excel COUNTIFS Function – Count cells with multiple criteria – AND logic and OR

Pradeep Kumar

Pradeep Kumar

Updated on 10-Sep-2022 08:37:38

5K+ Views

In Excel, the COUNTIFS function allows you to count cells based on one or more criteria using AND logic. This can be done in the normal course of events. The COUNTIFS Function is one of the statistical functions that is found in Excel. COUNTIFS will count the number of cells ... Read More

Advertisements