Overview
Learn to use a variety of Excel functions, including financial and statistical functions to analyze your data. Develop conditional calculations using the logical and lookup functions. Track time-dependent data with date and time functions.
Audience
Prerequisite: Excel Basics, MS Excel Level 1 or equivalent experience.
Length
4 hours
Outline
- Excel Formulas
- Formula Basics
- Working with Names
- Using Functions
- Introduction to Functions
- Working with Text
- Working with Dates
- Sum and Count Techniques
- Using Lookup Functions
- Database Lists
- Conditional Formatting
- Data Validation