Excel 2013 Formulas
Online Course: ID# 1003598
Price: $90.00
Qty:
About This Course:
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
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
Info on how to access this course will be sent to you by the Course Provider via email.