Looking for specific values within a data set is the most common task in Excel. In a simple database, you can just write a query for a specified table and look at the results returned. However, in Excel you need to use lookup formulas to complete this task. Having a solid understanding of all the lookup formulas is critical to work more efficiently in Excel.
This webinar by David Ringstrom, CPA, will provide you with some fascinating time-saving functions to help you find the specific information you’re looking for—pay rates, item prices, accounting results, etc.—thereby eliminating the need to manually link to specific cells.
David will introduce you to the VLOOKUP and HLOOKUP functions, and will provide context on when you’re likely to use them. He will demonstrate troubleshooting techniques and prepare you to deal with subtle issues that can prevent lookup formulas from working properly. You’ll also learn how to improve the integrity of your spreadsheets, perform dual lookups, scan a column for # sign errors, identify differences between two lists, and much more.
Who should attend
David Ringstrom CPA
David H. Ringstrom, CPA, is an author and nationally recognized instructor who teaches scores of webinars each year. His Excel courses are based on over 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 shou... More info