This is the third class in our Excel 2010 Expert Series. It picks up where Expert Level 2 left off. The focus of this course is working with logic functions in Excel. Topics covered include:

- Understanding logic (boolean) values
- True, False, And, Or, Not
- Using the IF function to make decisions
- Nested IF functions for multiple options
- Calculating sales tax IF customer is in-state
- Assigning a pass/fail grade to a student
- Giving a student a letter grade (A-F)
- Time sheet calculations that cross midnight
- Is a given cell blank, text, number, etc.

Subscribe to Excel 2010 Expert 3
Get notifications when this page is updated