Tomorrow: Advanced Excel Lookup Functions

Attend upcoming webinar and earn continuing education credits. Live Webinars   |   On-Demand   |   All-Access Plan Manage Preferences    |    View in Browser Advanced Excel Lookup Functions October   23 1 pm - 2:40 pm ET Presenter: David Ringstrom, an author and nationally recognized instructor 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 after the live presentation, or both. Viewing Options: View on your computer, tablet, or smartphone Learn More Register Today Course Description   In this practical webinar, you will learn helpful tweaks from Excel expert, David Ringstrom, CPA, that you can use with the noteworthy VLOOKUP function. Many Excel users rely on VLOOKUP to return data from other locations in a worksheet. However, using VLOOKUP isn't always the most efficient approach. Among other things, you will learn alternatives to use, including the INDEX and MATCH, SUMIFS, SUMPRODUCT, IFNA, and OFFSET functions. You will see each technique demonstrated at least twice: first, on a PowerPoint slide with numbered steps, and second, in Excel 2019. You will identify differences in Excel 2016, 2013, or 2010 and will receive detailed handouts. You will also receive an Excel workbook that includes the examples presented during the webinar. You will learn how to: Eliminate inputs that could cause VLOOKUP to return #N/A with Data Validation Transform numbers stored as text into values by way of the Text to Columns wizard Identify the risks of the LOOKUP function in Excel Utilize Excel's IFERROR function to display alternate values when VLOOKUP returns an error Use VLOOKUP to perform approximate matches Enable VLOOKUP to look up data from the left (instead of only from the right) by using the CHOOSE function Use the SUMIFS function to sum values based on multiple criteria Future-proof VLOOKUP by using Excel's Table feature versus referencing static ranges Remove the Table feature from a worksheet if it's no longer needed Avoid the complexity of nested IF statements with Excel's CHOOSE function Upon course completion, you will be able to: Identify what you can use in place of the word TRUE in VLOOKUP to return an approximate match Recall which menu contains the Text to Columns wizard Define the arguments for the INDEX worksheet function Learn More Register Today About The Presenter   David H. Ringstrom, CPA, is an author and nationally recognized instructor who teaches scores of webinars each year. His Excel courses are based on 25 years of consulting and teaching experience. David's mantra is "Either you work Excel, or it works you," so he focuses on what he sees users don't, but should, know about Microsoft Excel. His goal is to empower you to use Excel more effectively. 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 1,500 on-demand courses Learn More Upcoming Webinars Accounting Methods under the IRC and How They Can Help You October 25 at 1 pm ET Learn More Navigating the HR Bermuda Triangle: ADA, FMLA, and Workers Comp October 28 at 1 pm ET Learn More Onboarding Best Practices for Millennials and All Employees November 7 at 1 pm ET Learn More Questions? Please call us at 703-372-0550 Our Mailing Address: Clear Law Institute | 4601 N. Fairfax Dr., Ste 1200 | Arlington | VA | 22203 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.