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: Focus On Formulas

SKU:WT-1001760
Format: Webinar
Description:

You know that Microsoft Excel® crunches numbers extremely well.

But did you know that more than half of Excel users never learn how to use 9 out of 10 of its most powerful features? Don't be one of those people!

If you don't have a good foundation for the way formulas work, then you can use only a small part of Excel's amazing capabilities.

Excel: Focus on Formulas will take you from the foundational concepts that almost every self-taught Excel user missed to essential functions for numbers and text. You'll learn:

  • How to construct formulas the right way to get the results you expect.
  • The difference between an absolute and relative cell reference, and why you should know it!
  • What conditional functions are and how they can cut your work in half.
  • How to use IF and VLookUp to create data you need but can't seem to get.
In addition to showing you how to correctly write formulas, Microsoft® Certified Trainer Melissa Esquibel will explain how to troubleshoot and reverse engineer formulas, too! She makes this content relevant for both new formula writers and intermediate-level users who just want to sharpen their formula-building skills. The seminar is presented from Microsoft Office 2010, but will be applicable to all versions of Excel.

In about an hour, we'll give you the foundation for the way formulas work. You'll have your data working for you in no time.

About The Provider: The HR Specialist family of products helps HR professionals quickly resolve their daily challenges. From state-specific employment law to compensation and benefits, our experts give you the HR advice you need to know.

Whether you're new to HR or an experienced pro - a department of one or 10 - you can trust the practical, plain-English advice from HR Specialist. We'll save you time and headaches by focusing on what you need to know, when you need to know it. That makes you the HR expert your company can rely on and gets you the recognition you deserve.
Price: $197.00
More Info: Contact Us For More Information
Share This: Share on Facebook


Share on Twitter


Share on Google+


Keywords For This Course:

Excel, formulas, spreadsheets, presentations, Microsoft Office

Currently Scheduled Dates For This Webcast
Course TitleDatePrice
Excel: Focus On FormulasCD/On-Demand$197.00

How To Properly Complete A Form I-9
How To Properly Complete A Form I-9

Workplace Investigations 101: The Basics For Conducting Workplace Investigations
Workplace Investigations 101: The Basics For Conducting Workplace Investigations

Certificate Program For HR Generalists
Certificate Program For HR Generalists

Employee Handbook Updates for 2017: How To Ensure Legal Compliance And Avoid Liability
Employee Handbook Updates for 2017: How To Ensure Legal Compliance And Avoid Liability

PTO Plan Or Traditional Vacation And Sick Time? The Pros and Cons Of A Paid-Time-Off Plan
PTO Plan Or Traditional Vacation And Sick Time? The Pros and Cons Of A Paid-Time-Off Plan

Pre-Employment Screening: Can I Ask That Question?
Pre-Employment Screening: Can I Ask That Question?

 Agile Basics For HR
Agile Basics For HR

Strategic HR Basics: A Practical Approach To Working More Strategically In HR
Strategic HR Basics: A Practical Approach To Working More Strategically In HR

Internal Investigations Certificate Program
Internal Investigations Certificate Program

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

Basics Of Affirmative Action Planning
Basics Of Affirmative Action Planning

How To Identify And Investigate Claims Of Bullying
How To Identify And Investigate Claims Of Bullying

How To Change The Perception Of The HR Department
How To Change The Perception Of The HR Department

The Essentials Of HR Law
The Essentials Of HR Law

FMLA Training &Certification Program
FMLA Training &Certification Program

ADA Training &Certification Program
ADA Training &Certification Program

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