CPATrainingCenter.com offers CPA exams, accounting degree training, CPE, and professional development for accountants and CPAs
Course/Product Description
Title:

Excel 2013 Formulas

SKU:OT-1003598
Format: Online Training Course
Order:Qty:
Description:

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

About The Provider: LearnKey, Inc., is a premier global provider of self-paced training solutions for corporate, education, government, and personal users.

LearnKey brings the classroom experience to you - where and when you need it.

For nearly two decades, our mission has been to create flexible expert learning solutions - solutions that work for everyone because they are not only easy to use, but they are extremely engaging and interactive.

Our long-term commitment to the learning industry combined with our record of customer satisfaction and years of experience are the reasons LearnKey is recognized as a reputable global company. At LearnKey, we provide expert learning solutions today for tomorrow's leaders.
Price: $90.00
More Info: Contact Us For More Information
Order:Qty:
Share This: Share on Facebook


Share on Twitter


Share on Google+


Sales &Use Tax Workshop
Sales &Use Tax Workshop

Comprehensive Income Tax Course with Career Package
Comprehensive Income Tax Course with Career Package

Certified Tax Specialist  (CTS™)
Certified Tax Specialist (CTS™)

Peachtree Seminars
Peachtree Seminars

How To Use QuickBooks
How To Use QuickBooks

Rules And Requirements For Employee Expense Reimbursements
Rules And Requirements For Employee Expense Reimbursements

Fundamentals Of Internal Auditing
Fundamentals Of Internal Auditing

Internal Audit School
Internal Audit School

Auditing Applications Against SDLC And Coding Standards
Auditing Applications Against SDLC And Coding Standards

Auditing A Cybersecurity Program
Auditing A Cybersecurity Program

Audit Report Writing Boot Camp
Audit Report Writing Boot Camp

Advanced Auditing For In-Charge Auditors
Advanced Auditing For In-Charge Auditors

Series 6 - Live &OnDemand Online Course
Series 6 - Live &OnDemand Online Course

Required Minimum Distributions Training &Certification Program
Required Minimum Distributions Training &Certification Program

Project Management Workshop
Project Management Workshop

Certified Payroll Administrator
Certified Payroll Administrator

Google+CPATrainingCenter.com. 5755 North Point Parkway, Suite 228 | Alpharetta, GA 30022 | 770-410-9941 | support@CPATrainingCenter.com
Copyright CPATrainingCenter.com 2017 | Web Site Development by OTAU
Facebook