In simple terms, 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, that you might already used too while working in Excel, MS Word or other programs.
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.
In this tutorial, you will learn how to password protect a cell, multiple cells, a row and multiple rows in MS Excel.
Freezing the rows or columns while working in a long workbook can be really useful. For example, the top row contains the headers of the workbook and while entering data or analyzing it
The MOD function returns the remainder after a number is divided by the divisor. The general syntax is: = MOD(number, divisor)
Learn Excel division with 7 formulas! Explore practical examples for efficient calculations at excel-learn.com.
The SUBTOTAL function in Excel is used to return the subtotal in terms of sum, average, count, max, min etc. for the specified list, named range or database.
Unlock the power of Excel Weekday Methods with our comprehensive guide at excel-learn.com. Learn the art of retrieving weekdays with ease through 5 examples.
The INDIRECT function is used when you require changing the reference to a cell in a formula while you do not want to change the formula itself.
if you require the count of cells that contain numbers only, use the Excel COUNT function.
To get the count of all cells with numbers, text, dates etc except the blank cells, use the COUNTA function. Similarly, for returning the count of cells based on certain criteriause the COUNTIFS function. To get the count of blank or empty cells, use the COUNTBLANK function.
If you require displaying the date like this 2-Feb-2010 or August 1, 2015 etc. while entering dates you may change the settings in Excel easily.
The Pivot table enables creating another table based on above table and can summarize data for analysis like averages, sum, or other useful reports. With the Microsoft Excel pivot table feature, this is the matter of few clicks
There is no Excel SUBTRACTION function. Instead, you may accomplish the task of subtracting numbers or a cell’s value from the other by using the minus arithmetic operator (-).
The SUMPRODUCT function is used to multiply corresponding arrays or ranges and returns the sum. The SUMPRODUCT function is versatile.
4 Examples to Learn Excel / VBA DateDiff Function 
MS Excel Statistics – Usage by Job, Country, Industry & App Downloads 
How to Get Length of String by VBA Len function? 
How to Close Excel Workbook using VBA Code 
How to Create New Excel Workbook using VBA 
