Excel 2010 More Functions & Formulas
Objective
Learn to use some of Excel's logical, text, lookup & reference,
and conditional functions to process worksheet data more efficiently.
Prerequisite Skills
Course Description
Do you need to do more advanced calculations? Do you want to
learn to use more of the 300+ built-in Excel functions? This class
covers four groups of common functions: logical functions, text
functions, lookup and reference functions, and conditional functions.
Attend this course if you want to:
-
Identify portions of an IF statement.
-
Create simple and nested IF statements.
-
Understand text functions.
-
Eliminate extra spaces within your data.
-
Change text to proper case.
-
Combine cells.
-
Convert text to numbers or numbers to text.
-
Extract a portion of text from a field.
-
Change a formula to a value.
-
Separate text into columns.
-
Look up and merge data.
-
Use the SUMIF, COUNTIF, and AVERAGEIF functions to calculate
records based on certain conditions.
-
Enter formulas directly into cells.
Class Length
90 minutes
Delivery Options
-
Virtual classroom - public
($70 per student; check times and register here)
-
Virtual classroom - dedicated (up to ten
people from the same organization)
($480 per class; contact us for
more details)
-
Virtual classroom - one on one
(Register for a 45-minute 1-on-1
Application Support session. Cost is $70 per student per
session.)
-
On-site instructor-led
(Contact us for details)
