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

Fundamentals Of Internal Auditing
Fundamentals Of Internal Auditing

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

Project Management Workshop
Project Management Workshop

The Controller′s Workshop
The Controller′s Workshop

How To Use QuickBooks
How To Use QuickBooks

Peachtree Seminars
Peachtree Seminars

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

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

Certified Payroll Administrator
Certified Payroll Administrator

Payroll Records: What To Keep, What To Toss
Payroll Records: What To Keep, What To Toss

FMLA Training &Certification Program
FMLA Training &Certification Program

Become an ′America First′ Certified Business
Become an ′America First′ Certified Business

How To Do A Payroll Audit - Former Auditor′s Expert Advice
How To Do A Payroll Audit - Former Auditor′s Expert Advice

Multi-State Payroll Tax Compliance
Multi-State Payroll Tax Compliance

Guidelines For Taxing Gifts, Awards, &Other Fringe Benefits
Guidelines For Taxing Gifts, Awards, &Other Fringe Benefits

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