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 Training: Introduction To VLOOKUP

SKU:WT-1002876
Format: Webinar
Description:

Excel Training: Introduction To VLOOKUP

Excel’s VLOOKUP function adds automation to Excel spreadsheets in that users are freed from having to manually point to a designated cell that contains text or numbers. For instance, you might use look-up formulas to return the price for an inventory item, or use SUMIF or SUMIFS to summarize data based upon one or more criteria.

Implementing look-up functions will transform how you use Excel by allowing you to look up information such as pay rates, item prices, and accounting results, instead of manually linking to specific cells.

In this session Excel expert David Ringstrom, CPA, introduces you to the VLOOKUP function, and then goes beyond the basics with a discussion of the MATCH, CHOOSE, INDEX, SUMIF, SUMIFS, and SUMPRODUCT functions.

He then demonstrates troubleshooting techniques and shares the ins and outs of lookup functions to prepare you to deal with subtle issues that can prevent lookup functions from working properly.

Learning Objectives

By attending this training session, you will learn how to:

  • Understand VLOOKUP and its nuances and restrictions
  • Avoid the complexity of nested IF statements with Excel’s CHOOSE function
  • Compare and contrast IFNA, IFERROR, and ISERROR functions and learn which versions of Excel support these worksheet functions
  • Discover how to use wildcards and multiple criteria within lookup formulas
  • Discover the array of functionality the SUMPRODUCT function offers
  • Future-proof VLOOKUP by using Excel’s Table feature versus referencing static ranges
  • Improve the integrity of your spreadsheets with Excel’s VLOOKUP function
  • Learn how to arrange two worksheets from within the same workbook on-screen and at the same time
  • Learn why the INDEX and MATCH combination often is superior to VLOOKUP or HLOOKUP
  • Perform dual lookups, which allow you to look across columns and down rows to cross-reference the data you need
  • Uncover the limitations of VLOOKUP and learn about alternative functions
  • Use the SUMIF function to summarize data based on a single criterion
  • Use the SUMIFS function to sum values based on multiple criteria
  • Recall VLOOKUP nuances and restrictions
  • Identify alternatives to VLOOKUP, such as MATCH/INDEX, SUMIF, and SUMIFS
About Your Speaker:

David Ringstrom, CPA, is the Tech Editor-at-Large for AccountingWEB and Going Concern. David speaks at conferences nationally and presents dozens of webinars annually on Excel and other topics. He offers Excel training and consulting services nationwide, and has written numerous articles on spreadsheets.


Other Excel Topics

This course is just one of several Excel training courses we offer as part of our Excel training line. Go to www.CPATrainingCenter.com/Excel-Training-For-Accountants.asp to see the full list of Excel training courses.

About The Provider: The Industry Calendar creates and sells webinars, audio conferences, and seminars for busy business professionals.

We've done the work of listing the important, don't-miss events in one convenient location so you can quickly and easily view and register for upcoming events. Simply click on a course title or search by specific industry to get started!
Price: $239.00
More Info: Contact Us For More Information

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


Share on Twitter


Share on Google+


Currently Scheduled Dates For This Webcast
There currently are no scheduled dates for this webcast. Please click here to search for another course.

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

Is It FMLA Or The “Friday-Monday Leave Act”?  How To Identify And Investigate Employees Who Are Gaming The System
Is It FMLA Or The “Friday-Monday Leave Act”? How To Identify And Investigate Employees Who Are Gaming The System

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

Developing HR′s Credibility To Influence Meaningful Change
Developing HR′s Credibility To Influence Meaningful Change

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

Dealing with Difficult People
Dealing with Difficult People

Strategic HR Leadership Certificate Program
Strategic HR Leadership Certificate Program

Basics Of Affirmative Action Planning
Basics Of Affirmative Action Planning

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

9 Ways To Spot, Handle, and Reduce Workers′ Comp Fraud
9 Ways To Spot, Handle, and Reduce Workers′ Comp Fraud

How To Write An Affirmative Action Plan
How To Write An Affirmative Action Plan

The Essentials Of HR Law
The Essentials Of HR Law

Certified Payroll Manager
Certified Payroll Manager

Final Paychecks: Payroll Requirements For Terminated Employees
Final Paychecks: Payroll Requirements For Terminated Employees

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