Latest Blog Posts

How to Hide Zero Values in Excel Chart (5 Easy Ways)

Zero values often create difficulties while visualizing data in a chart. Here are 5 effective methods to hide these values from Excel charts. We will ...

How to Flip Data in Excel Chart (5 Easy Methods)

We’ll use a sample dataset with Salesperson in Column B and Sales in Column C. We'll flip the data in the dataset. Method 1 - Flipping ...

How to ReDim Preserve a 2D Array in Excel VBA – 2 Methods

This is the sample dataset created from a 2D array with three rows and two columns. Method 1 - ReDim Preserve the Last Dimension of a 2D ...

How to Insert a Picture in Excel Using a Formula – 2 Examples

Example 1 - Combining INDEX and MATCH Functions Steps Insert images using the Insert tab. In Insert, go to Illustration. Click Pictures ...

How to Create a Thermometer Chart in Excel (With Easy Steps)

Step 1 - Prepare the Dataset We'll use the information about the cost of total product development and the revenue earned after selling the ...

How to Change Excel Sheet Direction from Right to Left (4 Methods)

The Excel sheet direction is by default from left to right. It shows the row numbers and sheet tabs on the left. The column numbers also start from ...

How to Make Credit Card Debt Reduction Calculator for Excel

The article will show you how to make a credit card debt reduction calculator for Excel. In our daily life, we should spend our money in a ...

How to Change Positive Numbers to Negative in Excel (6 Ways)

The sample dataset contains Months and Loss columns, where we will change Loss to Profit. To do that, we will change the positive numbers to negative ...

 How to Insert Conditional Formatting Icon Sets Based on Percentage in Excel:5 Methods

Method 1 - Inserting Shapes Icon Sets Based on Percentage Steps To calculate the Percentages, select the cell D5, and then enter the following ...

How to Mirror Text in Excel: 5 Easy Ways

Method 1 - Use of Combined Functions to Mirror Text in Excel Steps: Select Cell C5. Insert the following formula. ...

How to Add Custom Icon Sets in Excel Conditional Formatting (2 Ways)

To explore the methods, we’ll use the following dataset, which represents some students' scores on a class test, including the range of remarks. ...

How to Mirror Chart in Excel (2 Suitable Examples)

Example 1 - Mirror a Bar Chart in Excel Steps: Input the months in the range of cells B5:B16 and sales of different products of the ...

How to Create a Meter Chart in Excel (with Easy Steps)

  Watch Video – Create a Meter Chart in Excel Step 1 - Create a Dataset with Proper Parameters We need to create a dataset to ...

How to Calculate Loan Payment in Excel (4 Suitable Examples)

We will use the following dataset, which contains two columns with Payment Details. Method 1 - Using the PMT Function to Calculate Loan ...

How to Flip Excel Sheet from Left to Right (4 Easy Ways)

The sample Excel worksheet shows us the datasheet in the direction of right to left. Method 1 - Changing Default Direction Steps: ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo