Excel Tutorials

The IFERROR function enables us to trap and handle the errors that occur in functions or use it independently. Learn more..

Excel DATEDIF function takes the start date, end date, unit and calculates the difference. Learn how to calculate dates in our tutorial.

Horizontal lookup function, HLOOKUP in Excel is used to find the specific value in a row for the table that is arranged horizontally.

Excel MACTH function returns the relative position of the specified item from the given range of cells. See how it works!

Excel AND is a logical function in Excel that determines if all the conditions in a test are TRUE. The other logical function examples are…

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

In certain cases, the cells in Excel worksheet contain text that is bigger than the default width. Learn how to wrap text in this tutorial.

How to expand the width of the Excel column so that it shows the whole content it contains? Use the shortcut…

In this tutorial, I will show you with screen shots, how to unhide the column(s) in Excel. You can also see how to unhide a sheet.

In this tutorial, I will show you how to create a drop-down list in Excel that only shows values that you set along with other examples.

Explore our guide on adding and removing columns in Excel. Learn efficient techniques to customize your spreadsheet layout.

Learn how to hide and unhide columns and rows in Excel with our step-by-step tutorial. We explained it with four examples.

Explore this tutorial and examples on using filters in Excel to streamline data analysis and enhance spreadsheet functionality.

Moving the rows and columns in Excel is just the matter of copy and paste or pressing the short keys Ctrl + X and Ctrl + P

In Excel, freezing the first column (the left most) is pretty easy. Similarly, freezing two or more columns is easy that I will show in this tutorial.