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
Info on how to access this course will be sent to you by the Course Provider via email.

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+


How To Avoid Wrongful Termination Claims
How To Avoid Wrongful Termination Claims

Compliance Tips For Gifts, Awards, &Other Fringe Benefits
Compliance Tips For Gifts, Awards, &Other Fringe Benefits

Workers′ Compensation Tips: 31 Practical Tips That Strengthen Your Workers′ Comp Program - And Your Bottom Line
Workers′ Compensation Tips: 31 Practical Tips That Strengthen Your Workers′ Comp Program - And Your Bottom Line

Certificate Program For HR Generalists
Certificate Program For HR Generalists

Internal Investigations Certificate Program
Internal Investigations Certificate Program

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

How To Develop Peak Employee Performance
How To Develop Peak Employee Performance

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

Time Management for HR Professionals
Time Management for HR Professionals

Dealing with Difficult People
Dealing with Difficult People

Integrating FMLA, ADA, COBRA, And Workers′ Compensation Training &Certification Program
Integrating FMLA, ADA, COBRA, And Workers′ Compensation Training &Certification Program

Certificate In Essentials Of Human Resource Management Seminar
Certificate In Essentials Of Human Resource Management Seminar

Payroll Requirements For Terminated Employees
Payroll Requirements For Terminated Employees

HR’s Role In Team Building
HR’s Role In Team Building

How To Improve Employee Attendance: Methods, Metrics, And Trends
How To Improve Employee Attendance: Methods, Metrics, And Trends

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

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