Excel Formulas and Functions

Class length: 1 day
Hours: 10:00 am - 5:30 pm
Cost: $350



Xpress Workout: Excel Formulas and Functions

Workout Outline:

Next Scheduled Class:

Click here to request a
specific date for this class.

Onsite Training:

This class is available for
onsite training
. For more
information or to book
an onsite class, please
click here.

Do you want to learn more about using functions in Microsoft Excel? This Xpress Workout will review some basic
formulas and functions and then let you explore functions you may not even know exist!

 

Course Outline:

 

  • Arithmetic operators
  • Order of precedence
  • Creating a formula
  • Creating a formula with the point and click method
  • Types of functions
  • Writing functions
  • Using SUM, AVERAGE, MAX, and MIN
  • Using Autocalculate
  • The Function Wizard
  • Copying formulas
  • Relative cell references
  • Absolute cell references
  • Mixed cell addresses
  • Using an IF Statement function
  • Three-dimensional cell references in formulas
  • Using range names in formulas
  • The SUBTOTAL function
  • The SUMIF function
  • The SQRT function
  • The ROUND function
  • The INT function
  • Logical functions
  • Calendar functions
  • Financial functions
  • Using VLOOKUP