HRTrainingCenter.com provides Human Resource training on FMLA, COBRA, HIPAA, HRAs (Health Reimbursement Accounts), HSAs (Health Savings Accounts), FLSA, Payroll, Cafeteria Plans, and more through seminars, online training, webcasts, webinars, and audio conferences. Best sellers include FMLA seminars, COBRA seminars, online payroll training, retirement plan training, and HIPAA training.
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

See Other Courses From This Provider
Order:Qty:
Share This: Share on Facebook


Share on Twitter


Share on Google+


Brand New to HR?  Identify The Critical Components Of HR You Need To Know Right Now
Brand New to HR? Identify The Critical Components Of HR You Need To Know Right Now

Tax Reform: Changes To Payroll
Tax Reform: Changes To Payroll

Electronic Record Retention: Mistakes HR Professionals Can Avoid
Electronic Record Retention: Mistakes HR Professionals Can Avoid

Multi-State Employee Handbooks: Legal Pitfalls Need To Know
Multi-State Employee Handbooks: Legal Pitfalls Need To Know

Dress Code Policy Do′s and Don′ts
Dress Code Policy Do′s and Don′ts

Disability Discrimination And The Interactive Process
Disability Discrimination And The Interactive Process

Certificate Program For HR Generalists
Certificate Program For HR Generalists

Internal Investigations Certificate Program
Internal Investigations Certificate Program

How To Get Your Managers To Cooperate With HR
How To Get Your Managers To Cooperate With HR

How Workers′ Compensation Works (Comprehensive 11-Module Course)
How Workers′ Compensation Works (Comprehensive 11-Module Course)

Workers′ Comp 101: The Whats, Whens, And Whys
Workers′ Comp 101: The Whats, Whens, And Whys

Tips For Tracking, Monitoring, And Managing Your Workers′ Comp Claims
Tips For Tracking, Monitoring, And Managing Your Workers′ Comp Claims

Strategic HR Leadership Certificate Program
Strategic HR Leadership Certificate Program

Fraud Alert: Are Your Own Employees Ripping You Off?
Fraud Alert: Are Your Own Employees Ripping You Off?

International Payroll: Payroll Compliance For Inpats And Expats
International Payroll: Payroll Compliance For Inpats And Expats

Certificate Program In FMLA &ADA Compliance
Certificate Program In FMLA &ADA Compliance

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