mentor training
Excel 2011 Formulas and Functions
While strongly focused on formulas, this class provides an opportunity to explore multiple Excel functions across several categories. Students should expect to enrich their creative toolbox and to become more comfortable using formulas and functions. They will discover various ways to use logical functions and to make their spreadsheets look cleaner and easier to understand. 4 Hours.

Prerequisite: Excel Level 2

Calculating Data with Advanced Formulas
Using text formulas
Apply Cell and Range Names
Calculate Data Across Worksheets


Use Specialized Functions
Count
CountA
CountBlank
CountIfs
SumIfs
ErrorIf
Concatenate

Analyze Data with Logical and Lookup Functions
IF
And/Or
VLookUp
Match
Index

Large data set cleanup
Help diagnose errors in formulas and understanding the logic of large formulas
Helpful Shortcuts & Formulas
Auditing Formulas
Validation Drop-down lists with Vlookup results
File Size/Performance management skills
Arrays
No id
© 2017 Mentor Training, Inc.