*Basic skills in using Excel** *

Produced by Graham Currell, University of the West of England, Bristol, in association with:, and

● Royal Society of Chemistry, 'Discover Maths for Chemists' website

*●*

**Essential Mathematics and Statistics for Science**, 2nd Edition**Graham Currell and Antony Dowman, Wiley-Blackwell, 2009**

This study unit uses **video** to demonstrate basic skills in the use of Excel.

It is possible to:

- Use Excel
**functions**to perform specific calculations

e.g. =SQRT(B4) will calculate the square root of the value in cell B4. - Write
**equations**directly into Excel cells,

e.g. =B5*B6/SQRT(B4) will multiply the contents of B5 and B6 and divide by the square root of B4. - Use
**Data Analysis**tools. These are not normally loaded when Excel is first installed, but can be added later (see video) using Add-Ins.

Additional video help on the use of Excel 2007 is available:

**Basic skills**: Formatting, Editing, Calculations and equations, Functions, Addressing,

+ associated Excel file**XY Graphs**: Drawing x-y graph; 'Best-fit' trendlines; Error bars; Regression & Correlation (Slope & Intercept); Data Analysis Tools + associated Excel file

Important notes on calculations in Excel:

**Equations and functions**are**dynamic**. Their results change if the source data is changed, e.g. the value of SQRT(B4) will change if the value in B4 is changed.- The calculations in the
**Data Analysis**tools are**static**. They are a single-shot calculation, whose results do NOT change if the source data changes.

**Study Guide for the straight line and linear regression**:

- Mathematics of the straight line, 'best-fit' straight line, linear regression and linear calibration