iCellini Computer Training

San Diego’s Onsite Computer Training Company

home icon email icon

Microsoft Excel 2007 - 2013 Formulas and Functions Class 2

Duration: 1 day (about 6 hours)
Prerequisite: Microsoft Office Excel 2007 - 2013 Formulas and Functions Class 1
Course Materials: Course manual with CD containing exercises
Prices: $225 for 1 student (one-on-one training)
$160 each for 2 to 3 students
$130 each for 4 to 6 students
$130 for the first 6 students, $100 for each additional student
Description:

This is the second day of our Excel Formulas and Functions course so you should be well-acquainted with the function syntax, operators, and the basics of formulas and functions. In this class, students are introduced to financial and rounding functions. One of the most important and useful Excel function is the IF function, which we thoroughly explore in this class. We also learn more about text, date, and logical functions on an Intermediate level. Finally, we learn about Array formulas.

This is the second day of a 3-day Excel Formulas and Functions class. You can choose to take all three days of training or to cherry-pick topics for a custom class.

Text Functions

Date-Related and Time-Related Functions

Advanced Counting and Summing Formulas

The Anatomy of an IF Function

Basic Lookup Functions

The Anatomy of the VLOOKUP Function

Top of Page

Microsoft Excel 2007 - 2013 Formulas and Functions Class 3

Return to Microsoft Excel Formulas list of classes