Excel Tutorials

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.

If you suddenly start seeing navigating from cell to cell is stopped while pressing the arrow keys and rather navigating in the worksheet then your scroll lock is ON.

Learn Excel MOD function with our guide at jquery-az.com. We also showed how to use INT function as MOD alternative.

Excel SUBTOTAL is used to return the subtotal in terms of sum, average, count, max, min etc. for the specified list, named range or database.