Formulas & Functions in Microsoft Excel
Formulas & Functions in Microsoft Excel Theresa A Scott, MS. Biostatistician III. Department of Biostatistics Vanderbilt University Table of Contents 1 Introduction 1. Using Excel for Analysis . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1. 2 Formulas and Functions 2. Entering Formulas . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2. Entering Functions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 4. Reference Operators . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 4. Autosum . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5. Function Wizard . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5. A Function instead of a formula . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6. 3 Copying Formulas / Functions and Cell References 7. Relative Cell References.
Section 1 Introduction The distinguishing feature of a spreadsheet program such as Excel is that it allows you to create mathematical formulas and execute functions.
Download Formulas & Functions in Microsoft Excel
Information
Domain:
Source:
Link to this page:
Please notify us if you found a problem with this document: