 Excel 2013 Formulas2 Sessions 
6 Hours of Interactive Training
 Join LearnKey expert Michael Meskers in our new Excel Formulas course. If you use Microsoft Excel for data analysis, reporting, or daytoday tracking this course will teach you helpful formulas and hints that will bring ease and accuracy to your work.. Benefits Learn time saving formulas that increase accuracy and functionality
 Gain confidence while working in Excel 2013

 About The Author  Michael Meskers is more than just a trainer. With a B.A., two Masters Degrees and fluent in six languages, Michael is highly adept at helping students understand the complexities of applications in many languages. With 19 years of combined experience as an investment banker, supervisor and manager for commercial airlines, Michael brings realworld experience into his instruction. Michael’s clients include William H. Mercer Inc., Sanford Bernstein Inc., The New School University, DigiCom Group and the Learning Annex. Michael also authored “The Learning Line: Windows Vista” published by J. Wiley & Sons Inc.

 Session 1Section A: Course Introduction Basic Formulas
 CONCATENATE
 CONCATENATE, Exponential Formulas
 Text Formulas
 Edit Formulas
Section B: Convert Formulas to Text Split Cell Contents Apart
 Formulas to Text Values
 UPPER, LOWER, PROPER
 LEFT
 RIGHT
 MID
 Fixed with Possibility
 Split Data into Three Columns
 TRIM
 SUBSTITUTE
 REPLACE
Section C: Basic Numerical Formulas AutoSum
 SUM
 AVERAGE, MIN/MAX, COUNT/COUNTA
 Status Bar
 Linked Formulas
 Add Grand Totals
 Data Consolidation
Section D: AND/OR/NOT Working with AND/OR/NOT
 AND
 OR
 NOT
 Subtotal
 Go To
 MEDIAN
 RANK
 Reverse Order RANK
 LARGE
 SMALL
 ISNUMBER
 ISTEXT
 IFERROR
Session 2Section A: SUMIF and AVERAGEIFS SUMIF
 AVERAGEIF
 COUNTIF
 SUMIFS
 Formula Wizard SUMIFS
 AVERAGEIFS
 COUNTIFS
 IF Formulas
 ABS Formula
Section B: Nested Formulas Working with Nested Formulas
 Calculating Nested Formulas
 Nesting other Formulas inside an IF
 IF(AND
 FIND
 Nest FIND Formula
 INDIRECT Formula
 Column and Row
Section C: Date Formulas DATE Formula
 Calculating DATE Formula
 Weekdays
 NETWORKDAYS
 Working with NETWORKDAYS
Section D: Conditional Formatting New Conditional Formatting Rule
 Conditional Formatting by Formula
 Conflicts in Formatting
Section E: VLOOKUP What is VLOOKUP?
 VLOOKUP Arguments
 VLOOKUP Approximate Match
 VLOOKUP Exact Match
 Testing Exact Match
Section F: WhatIf Analysis Goal Seek
 Solver
 Solver Parameter
 Scenario Manager
 Input Tables
 Dual Input Tables
 MATCH
 INDEX
 INDEX MATCH
Section G: Array Formulas SUM and MULTIPLICATION
 SUMPRODUCT
 SUBTRACTION and AVERAGE
 TRANSPOSE
