Date: | July 30, 2015 - 1:00pm - 3:00pm |
Timezone: | (GMT-05:00) Eastern Time (US & Canada) |
Location: | Compliance Global Inc. 2754 80th Avenue, New Hyde Park, NY 11040, New Hyde Park, NY, 11040, United States |
Website for Event: | https://www.complianceglobal.us/product/700160 |
Topic: | Distance Learning and E-Learning |
Description: | Overview: Excel expert David Ringstrom, CPA often likens Excel spreadsheets to the old West, where anything goes. Users are generally free to enter anything they like in any worksheet cell, often at the expense of data integrity. In this webinar David will show you how to use features and techniques in Excel to future-proof spreadsheets and ensure that users work within the required constraints. These techniques minimize spreadsheet maintenance, improve the user’s experience, and bolster spreadsheet integrity. David will teach from primarily from Excel 2010, but will demonstrate new features in Excel 2013 when warranted, as well as disclose any differences in Excel 2007. Coverage of Excel 2003 will be limited to questions raised by the audience. David's webinars are fast-paced, and even experienced. Excel users are certain to learn several new tips and tricks. David welcomes your questions and is happy to answer Excel questions unrelated to the webinar during the question and answer session. Why Should You Attend: Spreadsheet templates are often like the Wild West where anything goes. Users are free to type anything they wish into any worksheet cell, and in many cases overwrite formulas or input invalid data. In this webinar you’ll see how to manage this risk by implementing internal control procedures that enforce proper spreadsheet usage. Data integrity checks are minimized because users cannot circumvent formulas and procedures. Ease of use is added to the spreadsheet by way of drop-down lists and internal tips. Areas Covered in the Session: • Understand VLOOKUP function in Excel, including argument structure and shortcuts. Look-up formulas save users from having to copy and paste data from one area of as spreadsheet to another. Instead, Excel does the work by finding requested data, such as a product ID in the first column of a supporting list and then returning related data, such as product description or price Learning Objectives: • Use look-up formulas to look up data automatically from lists Who Will Benefit: This course will provide valuable assistance and guidance to all industry for spreadsheet design techniques that minimize spreadsheet maintenance and improve spreadsheet integrity. The following job titles/ positions will benefit from attending this seminar: Level: Intermediate For more detail please click on this below link: https://www.complianceglobal.us/product/700160 Email: referrals@complianceglobal.us |
Contact Name: | Compliance Global Inc |
Contact Email: | referrals@complianceglobal.us |
Contact Phone: | +1-516-900-5515 |