Excel, Creating Formulas and Functions

During this half-day class, you will explore many of the built-in Excel functions and formulas.

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