How To Copy And Paste In Excel - Excel tutorial

Category: Excel tutorials > Basics - 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.

Use the RATE function in Excel to calculate the Compound Annual Growth Rate (CAGR)

These text functions give you the ability to to extract certain segments of a cell (normally text). Useful if only part of a cell's text contains the information you want..

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.

We often need to format the numbers to display the appropriate number of decimals, dollar signs, percentage, red (for negative dollars), etc. It is best to keep numbers describing similar items as uniform as possible.