# Excel 2013 Formulas

2 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 day-to-day 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

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 real-world experience into his instruction. Michael’s clients include William H. Mercer Inc., Sanford Bernstein Inc., The New School University, Digi-Com Group and the Learning Annex. Michael also authored “The Learning Line: Windows Vista” published by J. Wiley & Sons Inc.

## Session 1

### Section 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
• 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 2

### Section 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: What-If 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

Are you looking for a more general Excel 2013 Course?  Go to our Excel 2013 Course.

For access to a demonstration course or more information, please call 0403006062 or email info@e-resources.com.au or complete the form below.