End of Month function in Excel - Excel tutorial

Category: Excel tutorials > Functions - Difficulty:

The Count function in Excel will return the number of entries (actually counts each cell that contains number data) in the selected range of cells.

In conditional formatting, you have to specify a condition or criteria for formatting.

Workbook-level protection- You can apply protection to workbook elements and you can protect a workbook file from viewing and changes.

Learn how to group and ungroup rows and columns so that you can easily hide or unhide the rows and columns you are interested in.

There are two types of procedures you can create in Excel VBA: a Sub procedure and a Function procedure. What’s the difference between the two types of procedures? It’s whether or not the procedure returns a value you can use elsewhere in the program. A procedure defined as Sub can not pass its result to any other procedure in the program while a procedure defined as Function has the capability to return a value or result.