This three-hour session for Windows and Mac users teaches you how to write formulas in Excel. You will perform calculations using functions like SUM, AVERAGE, write arithmetic formulas by hand, parse text strings with the LEFT, MID, RIGHT and SEARCH functions, and perform calculations on dates. You will use HLOOKUP and VLOOKUP to retrieve data based on matching values, and also learn when and why to use absolute referencing (like $A$4) when duplicating formulas.
Prerequisites
This class is ideally suited for people with basic Excel skills, either from taking our Excel Beginning 1 and 2 classes or using Excel regularly for three months or more.
Outline
Using Simple Functions
- writing formulas to sum or average values
- writing simple arithmetic formulas
- LEFT, MID, RIGHT and SEARCH to extract text
Math with Dates
- understand how dates are stored
- calculate future dates
- calculate difference between two dates
- using date functions like EDATE and EOMONTH
Lookup Functions
- HLOOKUP function
- VLOOKUP function
Copying Formulas
- duplicate formulas into neighboring cells
- understand relative vs. absolute referencing
- changing referencing style
- create and use named ranges in formulas
