Sign for Notice Everyday    Sign Up| Sign In| Link|

Our Sponsors

Receive Latest News

Share Us

Demystify Excel: Advanced Lookup Formulas

View: 108

Website | Edit Freely


Deadline: May 18, 2017 | Date: May 18, 2017

Venue/Country: Online

Updated: 2017-03-10 15:08:58 (GMT+9)

Call For Papers - CFP

While many Excel users rely on the VLOOKUP function for basic lookup functionality within their spreadsheets, this is often because they’re unaware of ways to improve the integrity of VLOOKUP. In this comprehensive presentation, Excel expert David Ringstrom, CPA, discusses a variety of alternatives to VLOOKUP, including the INDEX and MATCH, SUMIF, SUMIFS, SUMPRODUCT, IFNA, and OFFSET functions.

Why Should You Attend

Participants will learn a variety of alternatives to the VLOOKUP function, including the INDEX and MATCH, SUMIF, SUMIFS, SUMPRODUCT, IFNA, and OFFSET functions. David also explains how to: use the Table feature to future-proof VLOOKUP, view two worksheets from the same workbook simultaneously, summarize data based on a single criteria, find the position of an item in a list, and reference data from one or more accounting periods.

David’s materials cover Excel 2016, 2013, 2010, and 2007. Depending on the topic, he demonstrates techniques in Excel 2010, 2013, or 2016 while noting differences in other versions of Excel when warranted. David’s detailed handouts, with numbered steps, serve as reference material you can utilize going forward. He also provides an Excel workbook that includes a majority of the examples he uses to demonstrate techniques during the presentation.

Areas Covered in this Webinar

Avoiding the complexity of nested IF statements with Excel’s CHOOSE function.

Learning why the INDEX and MATCH combination often is superior to VLOOKUP or HLOOKUP.

Seeing how the HLOOKUP function enables you to perform horizontal matches.

Using the SUMIF function to summarize data based on a single criterion.

Comparing the MIN, SMALL, MAX, and LARGE functions.

Future-proofing VLOOKUP by using Excel’s Table feature versus referencing static ranges.

Improving the integrity of spreadsheets with Excel’s VLOOKUP function.

Using the MATCH function to find the position of an item on a list.

Using the SUMIFS function to sum values based on multiple criteria.

Discovering how to use wildcards and multiple criteria within lookup formulas.

Seeing how to view two worksheets from within the same workbook at the same time.

Learning about the IFNA function available in Excel 2013 and later.

Learning Objectives

Identify alternatives to the VLOOKUP function.

Identify ways to improve the integrity of the VLOOKUP function.


Who Will Benefit

- Accountants

- CPAs

- CFOs

- Controllers

- Excel Users

- Income Tax Preparers

- Enrolled Agents

- Financial Consultants

- IT Professionals

- Auditors

- Human Resource Personnel

For More Info, Please Click below URL:

Keywords: Accepted papers list. Acceptance Rate. EI Compendex. Engineering Index. ISTP index. ISI index. Impact Factor.
Disclaimer: ourGlocal is an open academical resource system, which anyone can edit or update. Usually, journal information updated by us, journal managers or others. So the information is old or wrong now. Specially, impact factor is changing every year. Even it was correct when updated, it may have been changed now. So please go to Thomson Reuters to confirm latest value about Journal impact factor.