This workshop lasts 3 hours, and is part of the certificate series Excel 2010 Advanced End-User
This workshop will explore arrays and conditional functions used to summarize or count data with certain criteria. Discover how to use IF and Nested IF functions to test for specific conditions and how to apply different types of conditional formats. Participants will also explore various techniques to look up values in a range of data using VLOOKUP. Challenge exercises will be provided for reinforcement.
What You'll learn
perform calculations using array formulas
create IF and nested IF functions
use conditional functions to summarize or count data
use the CONCATENATE function to join text
look up data using VLOOKUP
apply different types of conditional formatting
What you need to know
create and manage named ranges
create formulas and functions
create and apply validation criteria
work with tables
sort and filter data
If you don't have those skills, consider first taking the workshop:
IT – Informatics & Communications Technology Complex (ICTC)
535 W. Michigan St.
Indianapolis, IN 46202
There are no upcoming dates for this event.