Excel Tutorials

How to Move Excel Chart from One Sheet to Another

In certain scenarios, you may require to have data in one sheet and the chart created based on that data on its own sheet. So, in that sheet, no tabular data in Excel cells is visible.

How to Create Area Charts in Excel

Select the data in the sheet that you want to create area chart. We have following sample data of top countries with area in Square Kms.

Create 3-D Column Charts in Excel

Alternatively, you may go to “Recommended Charts” and in the dialog box, click “All Charts”.

3 Examples to Create Clustered Bar Charts in Excel

Go to Insert in the ribbon and click on “Recommended Charts”

5 Examples to Use Conditional Formatting in Excel [Highlight Cells Rules]

Conditional formatting in Excel is the way to stand out or make different certain cells/information to others. For example, making cell red for numbers less than a certain value.

4 Step by Step to Make Excel 3-D Pie Charts

How to create 3-D Pie-Charts in Excel For creating a 3-D Pie-chart, follow these steps….

A little about Excel Dropdown List

In this tutorial, I will show you how to create a dropdown list in Excel that only shows values that you set along with an example of allowing users selecting a value from the available dropdown list plus writing their own.

A brief about show/hide formulas in Excel

In this tutorial, you will learn how to show or hide the formula in the cells and formula bar in Excel.

How to add a new line in Excel Cell?

If you have long text to enter in an Excel cell or just require pushing…

Wrapping Text in an Excel cell

In certain cases, the cells in a worksheet contain text that is bigger than the…

Insert One or multiple rows in Excel

In this tutorial, I will show you how to add one or multiple rows in Excel. With demos, you can also see the shortcut for adding rows.

Unhide columns, rows and sheet in Excel

In the first section, I will show you with screen shots, how to unhide the column(s) in Excel. This is followed by the section to unhide rows and finally, you can see how to unhide a sheet.

Adding Columns in Excel

In this tutorial, you will learn how to add a column in between other existing columns.Two ways of adding the column in for that scenario are explained below.