Formulas and worksheet functions are essential to manipulating data and obtaining useful information from your Excel workbooks. The chapters in this part start with a solid foundation in using Excel formulas and gradually introduce more sophisticated concepts such as the new dynamic array functionality in Excel.