Advanced Excel Formulas and Functions

Pages 2 to 29 of these notes consist of Excel features that can be used as a refresher

and/or a source of handy hints and ways of using different functions. Some of these

features include:

• Using the function wizard

• Creating and using range names

• Referencing other worksheets or work files

• Recording macros

• Using the Fill Handle and FILL, SERIES command

• Conditional Formatting