MS Excel - Formulas and Functions

Class Sessions: three, 2-hour classes

 

Course Prerequisites: 

The student must have basic Windows skills, includingthe use of files and folders, and have a basic proficiency in the use of Excel.

Course Description:

This class will expand on the information regarding the use and structure of formulas that was provided in the introductory class.We will delve into math, text and logic formulas. We will explore the use of functions that perform complex operations. The class will be taught using examples, and students will be encouraged to bring their own spreadsheet problems for discussion in class. We will use MS Excel version 2010.

Course Objectives:

By the end of this course, you will be able to:

  • Create math, text and logic formulas
  • Understand the construction of complex formulas
  • Select functions and use them in formulas

Modified: 10/30/2017