Transcript CHAPTER 3

Using Spreadsheets
In Analytical Chemistry
Chap 3. Using Spreadsheets in Analytical Chemistry
(1) Getting started : Excel
(2) The basic usage
 basic usage information
 formula expression
 simple data analysis example
(3) Importing data from Web pages and others
 from web pages : molar masses (IUPAC)
a) dealing with character strings
b) function usage. : FIND, MID, VLOOKUP
 from txt file
a) Graph
b) Complex formula expression
(4) Introduce to useful example using Excel
The opening window in Microsoft Excel
Menu
bar
Tool bar
Active cell
Formula
bar
Entering Text in the Spreadsheet
Double
Click
The sample data analysis
Making Complex Calculation with Excel
Calculation Molar masses using Excel
: Importing Data from Web pages
Dealing with Character Strings
The FIND function
: FIND(find_text,within_text,start_num)
The MID Function
: MID (text,start_num,num_chars)
:
The VLOOKUP Function
VLOOKUP (lookup_value,table_array,col_index_num,range_lookup)