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 Creating Effective Excel Budget Spreadsheets July 21 at 1 pm ET Learn More IRS Form 941 Reporting Update July 22 at 1 pm ET Learn More Forming a Nonprofit & Applying for Tax Exemption July 25 at 3 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.