| Price per person: | $129 |
| Length of class: | three hours |
| Version covered: | for Office 365 |
| Delivery format: | live over Zoom |
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.
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.
We have a self-assessment tool to help determine if this class would benefit you. Download this skills assessment file and open it up. See if you can perform the tasks listed in it. It will test you on the exact skills you would learn in this class.
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