Jason Howie

To center a range of cells on a printed page in Excel automatically execute the following steps.

This chapter gives an overview of some very useful statistical functions in Excel.

Use the solver in Excel to find the maximum flow from node S to node T in a directed network. Points in a network are called nodes (S A B C D E and T). Lines in a network are called arcs (SA SB SC AC etc).

By default Excel shows the results of formulas. To show the formulas instead of their results press CTRL + ` (you can find this key above the tab key).

To find the closest match to a target value in a data column use INDEX MATCH ABS and MIN in Excel. Use the VLOOKUP function in Excel to find an approximate match.

The Macro Recorder a very useful tool included in Excel VBA records every task you perform with Excel. All you have to do is record a specific task once. Next you can execute the task over and over with the click of a button. The Macro Recorder is also a great help when you don't know how to program a specific task in Excel VBA. Simply open the Visual Basic Editor after recording the task to see how it can be programmed.

If you have more than one option button only one of the option buttons can be selected. To create option buttons in Excel VBA execute the following steps.

To change the case of text in Excel use LOWER UPPER or PROPER. If you're not a formula hero use Flash Fill to change case in Excel.

Below we will look at a program in Excel VBA that compares randomly selected ranges and highlights cells that are unique. If you are not familiar with areas yet we highly recommend you to read this page first.

Below we will look at a program in Excel VBA that checks whether a number is a prime number or not.