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
Order:Qty:
Share This: Share on Facebook


Share on Twitter


Share on Google+


Certificate Program For HR Generalists
Certificate Program For HR Generalists

Compensation Basics
Compensation Basics

The Do′s &Don′ts Of Handling Applicants And Employees Who Have Had A Brush With The Law
The Do′s &Don′ts Of Handling Applicants And Employees Who Have Had A Brush With The Law

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

How To Shift HR′s Role To Being A Strategic Business Partner
How To Shift HR′s Role To Being A Strategic Business Partner

How To Keep HR From Being The Employee Complaint Department
How To Keep HR From Being The Employee Complaint Department

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

Internal Investigations Certificate Program
Internal Investigations Certificate Program

I-9 Administrator Training - Top 10 Mistakes To Avoid In Completing, Storing, And Destroying Form I-9
I-9 Administrator Training - Top 10 Mistakes To Avoid In Completing, Storing, And Destroying Form I-9

H-1B Visa Training
H-1B Visa Training

HRCI / SHRM 60 Hour Re-Certification Training Suite
HRCI / SHRM 60 Hour Re-Certification Training Suite

Bring Our Training Courses To Your Location
Bring Our Training Courses To Your Location

Strategic HR Leadership Certificate Program
Strategic HR Leadership Certificate Program

The Top 7 Behaviors That Make An HR Manager A Rising Star
The Top 7 Behaviors That Make An HR Manager A Rising Star

Active Shooter Preparedness Plan
Active Shooter Preparedness Plan

Certified Payroll Manager
Certified Payroll Manager

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