Excel Basics

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

Excel Formula to Lookup Value in Table (3 Suitable Examples)

When working with an enormous dataset, it is a very frequent need for us to find some value in the table of the dataset. Finding it manually and ...

How to Stop AutoFill Formula in Excel Table (2 Suitable Ways)

If you are searching for the solution or some special tricks to stop autofill formula in Excel table then you have landed in the right place. There ...

How to Use Format Painter to Copy Formatting in Excel

Format Painter is one of the most used tools to copy formatting in Excel. Format Painter drastically reduces the load of formatting for each cell ...

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 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: ...

How to Zoom in Excel Graph: 5 Methods

Method 1 - Create Dataset Put some months in column B. Insert the total unit sales of each month in column C. Finally, the total amount of ...

How to Remove Drawing Tools in Excel (3 Easy Methods)

    The dataset that we will use to remove the drawing tools contains various shapes as Excel objects. We put in multiple shapes to ...

How to Automatically Hide Rows with Zero Values in Excel – 2 Methods

This is the sample dataset. Method 1 - Apply Excel VBA to Automatically Hide Rows with Zero Values 1.1 With an InputBox STEPS: Go ...

How to Print Gridlines in Excel Online (2 Easy Ways)

In Excel online, gridlines are applied to the worksheets by default. But when we print the worksheets, no gridlines are visible on the printed copy. ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo