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

About the Trainer

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
  • 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 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.

Name *
Name