Date: | July 8, 2016 - 1:00pm - 2:30pm |
Timezone: | (GMT-05:00) Eastern Time (US & Canada) |
Location: | AtoZ Compliance 2754 80th Avenue, New Hyde Park, NY 11040, New Hyde Park, NY, 11040, United States |
Website for Event: | http://bit.ly/1UlShW5 |
Topic: | Distance Learning and E-Learning |
Description: | Key Take Away: Learn to transcend VLOOKUP in Microsoft Excel by using the MATCH function to overcome a data integrity risk and how the SUMIF and SUMIFS functions can serve as alternatives to VLOOKUP. Overview: Look-up formulas such as VLOOKUP allow you to return data from other locations in your spreadsheets without linking to individual worksheet cells. However, VLOOKUP can't always return the data that you need. Why Should You Attend: Compare and contrast IFNA, IFERROR, and ISERROR, and see which versions of Microsoft Excel training support each of these worksheet functions Areas Covered In This Webinar: Perform dual lookups, where you look across columns and down rows to cross reference the data you need Learning Objectives: Understand how to use VLOOKUP to perform both exact and approximate matches Who Will Benefit: CFO’s Speakers Profile: David Ringstrom For more detail please click on this below link: Email: support@atozcompliance.com Fax: +1-516-300-1584 |
Contact Name: | AtoZ comliance |
Contact Email: | referrals@atozcompliance.com |
Contact Phone: | 5169005509 |