iCellini Computer Training

San Diego’s Onsite Computer Training Company

home icon email icon

Essentials of Formulas and Functions

Duration: 3½ - 4 hours
Prerequisite: This class is not for absolute Excel beginners. You should be familiar with the Excel environment and know the basics of Excel.
Course Materials: Text Book with exercise file download
Prices: $175 for 1 student (one-on-one training)
$125 each for 2 to 3 students
$110 each for 4 to 6 students
$110 for the first 6 students, $90 for each additional student
Description:

If you want to understand Formulas and Functions and use them to create more powerful worksheets, this class is the first step. It's for experienced Excel users who use Excel in a limited way and want to elevate their skill level to include the effective use of Formulas and Functions.

You will learn the rules of creating formulas. You will understand when and how to use relative, absolute, and mixed cell references in your formulas. You'll learn how to link workbooks using formulas. You'll learn the syntax and description of a function and how to build arguments. You'll create some basic but very useful conditional functions that will automatically make decisions. You'll name ranges and use those names to write more efficient formulas and function statements. And you'll learn a few tips and tricks to help make your life as an Excel user easier and more enjoyable.

This class will also give you a solid foundation to go on to learn more powerful functions.

Class Outline

Fundamentals of Formulas

Understanding Worksheet Functions

Working with Names

Top of Page