1. Are your providing Online Continuing Education Credits?
We are approved to provide CPE/CE credits to Tax Professionals
- IRS
- NASBA
Shopping Cart
{{cart.item_name.toUpperCase()}}
{{cart.type}}
$ {{new Intl.NumberFormat().format(cart.single_amount)}}
Oops! Your cart is empty!
Excel Competency: Intermediate Lookup Functions
- Dec 06, 2019 Friday | 01:00 PM ET | 12:00 PM CT | 10:00 AM PT | Duration: 60 Minutes
Webinar Instruction will be emailed on your registered email address 3 days prior to webinar | Web Download / e-Transcript will be shared in 7 working days from the date of webinar
If you’re concerned about the integrity and resilience of your spreadsheets, you’ll find this webcast presented by Excel expert David Ringstrom, CPA, extremely beneficial. In his intermediate-level presentation, David delves deeper into lookup functions and shares multiple troubleshooting techniques to help you work more efficiently in Excel. He provides an overview of the popular VLOOKUP function and contrasts it with the HLOOKUP and VLOOKUP functions. You’ll also learn how to take advantage of the Data Validation and Table features and how to implement next-level lookup functions, such as MATCH/INDEX, CHOOSE, SUMIF, and SUMIFS.
David demonstrates every technique at least twice: first, on a PowerPoint slide with numbered steps, and second, in the Office 365 version of Excel. David draws your attention to any differences in the older versions of Excel (2019, 2016, 2013, and earlier) during the presentation as well as in his detailed handouts. David also provides an Excel workbook that includes most of the examples he uses during the webcast.
Learning objectives:
- Identify the arguments used by the SUMIF function.
- State how to perform dual lookups.
- Define the areas within a spreadsheet that the MATCH function can look.
Session Highlights:
- 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 in a list.
- Performing dual lookups, which allow you to look across columns and down rows to cross-reference the data you need.
- Identifying situations where VLOOKUP may return #N/A instead of a value.
- Removing the Table feature from a worksheet if it’s no longer needed.
- Using VLOOKUP to perform approximate matches.
- Comparing HLOOKUP to VLOOKUP for performing horizontal matches versus vertical matches.
- Contrasting the INDEX and MATCH combination to VLOOKUP or HLOOKUP.
- Employing the SUMIF function to sum values related to multiple instances of criteria you specify.
- Utilizing Excel’s IFERROR function to display alternate values when VLOOKUP returns an error.
Who should attend:
Practitioners who wish to expand their knowledge of lookup functions to work more efficiently in Excel.
2. When are the continuing education credits reported to the IRS, HRCI, NASBA and other regulatory bodies ?
We reports the educational credits to the respective licensing/regulatory bodies in 5 business days.
3. What should I do if I can’t log my account?
The credentials to log into your account is your EMAIL ADDRESS & PASSWORD used during account creation.
- If you’ve forgotten your password, please go to the login page and click on the ‘Forgot Password.’ Then enter your registered email id to receive the password reset email. Click on the link given in the email to enter your new password.
- If the face any challenge, please reach out to us via email support@pro2learn.com or contact our support team through live chat support. Our support line is 1-937-865-8027.Our support team is available Monday to Friday from 09:00 AM – 06:00 PM EST/EDT
4. How can I view /access the courses that I have registered for?
When you register for any of our webinars/product, you receive will the instruction 24 hours prior to the conference. Also, the instructions are avilable in your account under ‘My Webinars’ section.
5. How can I cancel my registration?
You can cancel your registration to by email at support@pro2learn.com. If you cancel your registration for the paid webinar, the amount shall be credited back in your payment method within 7 business days.
6. How can I download the learning materials/Handouts available for the webinars/Seminar?
The conference materials are available 4 hours prior to the webinar. You can download it from the webinar page or by logging to your account.
7. What are the system requirements to attend a live webinar?
Our seamlessly integrated with ZOOM, WebX and, Goto for delivering continuing education webinars. The system requirements are :
- An internet connection – broadband wired or wireless
- Speakers and a microphone – built-in, USB plug-in, or wireless Bluetooth
8. What are CPE Package Courses?
Our package courses are the bundles of various continuing education courses which have been specially designed to meet your continuing education requirements for a particular Qualification.
9. What is web download and transcript?
- The web download is the recording of the webinar. You will receive a link to download and save the webinar on your computer and watch it anytime and multiple times.
- The transcript is the detailed written material presented during the webinar.
10. What is an On demand session?
On demand session is when we conduct the webinar as per your available dates after the live training. You will get access to the training for 24 hours.
11. How do I access a previously purchased webinar, self-study course, Web Download, or package?
To access a course that you have already purchased, all you must have to create/log in to your account. Click on the "Log In" button in the top right of the screen. Once you are logged in, you will have immediate access to all your purchased CPE courses, packages and other self-service or you can write on support@pro2learn.com.
12. I took a webinar, where is my certificate?
We will email your certificate within 3 working days of the end of the webinar, or you can login your account at www.pro2learn.com. If you don’t receive the email within 3 working days of the end of the webinar, check your spam/junk folder. If it’s not there, we recommend that you send us an email at support@pro2learn.com or connect over the online chatroom.
Our Events
© 2024 Pro2learn, Inc. All rights reserved.
