Offset Formula

=Offset(A2,2,3)

This formula will take you to the cell which is 2 rows down and 3 columns right. Very useful for automation as 2 and 3 can be replaced with cell no. Whatever you want.

For going to upper row and prior column -1 / negation number can be used

Len()

=Len(cellno)
This formula helps you to get number of digits/alphabet/special character in the cell selected.

File Path-Excel Formula

If you want to have "Path" of a file to a particular cell then you can use the below formula.

=CELL("filename",A1)

Dynamic Pivot Table-Excel Formula

                                          

Insert Rows & Columns-Macro Coding

Below is the code to insert Row by VBA in excel

ActiveSheet.Range("b1").EntireRow.Insert

Below is the code to insert Column by VBA in excel

ActiveSheet.Range("b1").EntireColumn.Insert

EOMONTH()

The below formula will help you get the last day of the month for the date you select.

=EOMONTH(cell,0)

Cell : Cell is cell containing dates.

If you want previos months last date than -1 instead on 0.
Same way for next month +1.

Fiscal Year/ Financial Year- Excel Formula

Please Read the whole Explanation to understand better.

Below is the Excel formula for getting Fiscal Year for the date you want in the formulated cell.

=Year(Date(Year(cell),Month(cell)+9,1))

Cell : Cell in the above formula refers to the cell containing the date for which we want the fiscal year.

The above formula is for fiscal year from 1 apr - 31 mar.

After month we have added 9 because after march i.e. last month of our fiscal year there are more 9 months left to complete the celander year.