Excel for Laboratory Calculations

COURSE PROGRAM

1. Introduction
2. Entering Calculations
   • • Entering formulas and functions
     • Most commonly used operators in formulas or functions
     • Inserting a function using the wizard
     • Using expressions as function arguments
     • Using functions as arguments of other functions
     • Displaying formulas on screen
3. Statistical Functions
4. Linear Estimation
5. Data Analysis
   • • Linear Regression
       • Regression using functions
6. Conditional Formatting and Data Validation
7. Conditional Formatting
   • • Adding conditional formatting
     • Copying formats to other cells
     • Changing or removing conditional formatting
8. IF Function
9. Nested Functions
10. Common Lookup and Reference Functions
11. Examples
12. Spreadsheet Validation and Protection (ISO 17025 Requirements)
    • • Protection
        • Protecting cells
        • Protecting the workbook
13. Introduction to Creating an Excel Sheet
    • • Planning spreadsheets
      • Creating spreadsheets
      • Validating spreadsheets
14. Data Analysis Add-in
    • • Generating random numbers
      • Rank, percentile, and histogram
      • Statistical tests
15. Charts
    • • Data presentation tools (introduction)
      • Charts
      • Chart types
16. Tables
    • • Pivot tables