Excel Lookup Formula Basics

Live Webinars   |   On-Demand   |   All-Access Plan Manage Preferences    |    View in Browser Excel Lookup Formula Basics August   1 1 pm - 2:40 pm ET Presenter: David Ringstrom, Owner and Founder of Accounting Advisors, Inc. Credits: CPE (Credit Details) Can't attend live? By registering, you will be able to view the course live, view a recording at any time for 6 months, or both. Viewing Options: View on your computer, tablet, or smartphone Learn More Register Today Course Description   Excel lookup functions will transform how you use Excel by allowing you to look up information, including pay rates, item prices, and accounting results, rather than manually linking to specific cells. In this webinar, you'll learn how and when to use lookup functions – including the VLOOKUP function – in Excel, and troubleshooting techniques to ensure your lookup functions are working properly.  Upon completion of this course, you will be able to: Apply the VLOOKUP and HLOOKUP functions to work more efficiently in Excel Improve the integrity of spreadsheets by way of Excel's VLOOKUP function Manage subtle issues that can prevent lookup functions from working properly Use wildcards and multiple criteria within lookup formulas Identify the risks of linked workbooks, determine if a workbook contains links, and describe how links can hide within Excel features Arrange two worksheets from within the same workbook on-screen and at the same time Perform dual lookups to cross-reference the data you need Describe how the HLOOKUP function enables you to perform horizontal matches Recognize when you might wish to use ISERROR or ISNA instead of IFERROR Utilize other excel functions, including: Excel's Filter feature to quickly scan a column for # sign errors Excel's TRIM function to eliminate extraneous spaces that can compromise lookup functions The IFERROR function to display something other than #N/A when VLOOKUP can't find a match The MATCH function to find the position of an item on a list The VLOOKUP to perform approximate matches Learn More Register Today About The Presenter   David H. Ringstrom, CPA, is the owner and founder of Accounting Advisors, Inc., a spreadsheet consulting firm. Mr. Ringstrom provides Microsoft Excel training and consulting services nationwide. He frequently presents on Microsoft Excel at webinars and conferences, regularly publishes articles about spreadsheets, and has edited dozens of books on accounting software. Learn More Register Today All-Access Membership   ● Earn continuing education credit for no additional fee ● Access courses on your computer, tablet, or smartphone ● More than 75 live webinars each month ● More than 750 on-demand courses Learn More Upcoming Webinars Investigative Interviewing for Auditors: What Scientists Have Found Works August 9 at 3 pm ET Learn More Excel's Custom Views Feature August 10 at 1 pm ET Learn More U.S. Taxation of U.S. Citizens Working Abroad August 11 at 1 pm ET Learn More Questions? Please call us at 703-372-0550 Our Mailing Address: Clear Law Institute | 933 N. Kenmore St, Ste 320 | Arlington | VA | 22201 Remove me from future emails. Manage email preferences. This email was sent to virginia.duffy.planetduffy@blogger.com. If you are receiving it in error, please reply to this email.

Multistate Overview of Abandoned Property Laws Across the US

Live Webinars   |   On-Demand   |   All-Access Plan Manage Preferences    |    View in Browser Multistate Overview of Abandoned Property Laws Across the US August   11 1 pm - 2:15 pm ET Presenter: Joseph Endres, Partner at Hodgson Russ LLP Credits: CPE (Credit Details) Can't attend live? By registering, you will be able to view the course live, view a recording at any time for 6 months, or both. Viewing Options: View on your computer, tablet, or smartphone Course Reviews: View Testimonials Can't wait? View previously recorded version now Learn More Register Today Course Description   In this webinar, you'll learn how abandoned property is classified throughout the U.S., the key requirements of state abandoned property laws, and what to expect during an abandoned property audit. Upon completion of this course, you will be able to: Define (and recognize) abandoned property Compare and contrast abandoned property laws across the U.S., including: How abandoned property is classified When you are obligated to contact the property owners What the "dormancy period" is What communication qualifies as a "contact" How gift certificates are treated Identify strategies for monitoring abandoned property List the typical issues that arise in an abandoned property audit Evaluate the pros and cons of voluntary disclosure programs Course Reviews from Past Attendees 100% of attendees said they would recommend this course to others. "Detailed information." "Very good information and very helpful." Learn More Register Today About The Presenter   Joseph Endres is a Partner at Hodgson Russ LLP and leader of the firm's Abandoned Property Audits Practice. Mr. Endres's primary practice is in tax. He regularly counsels clients on sales and use tax issues in the technology industry, as well as on complex compliance and multistate audit issues. Mr. Endres is a graduate of SUNY Buffalo Law School. Learn More Register Today All-Access Membership   ● Earn continuing education credit for no additional fee ● Access courses on your computer, tablet, or smartphone ● More than 75 live webinars each month ● More than 750 on-demand courses Learn More Upcoming Webinars Excel Lookup Formula Basics August 1 at 1 pm ET Learn More Fundamentals of Fraud August 2 at 1 pm ET Learn More Tax Compliance for Household Employers August 4 at 1 pm ET Learn More Questions? Please call us at 703-372-0550 Our Mailing Address: Clear Law Institute | 933 N. Kenmore St, Ste 320 | Arlington | VA | 22201 Remove me from future emails. Manage email preferences.