Become a Lookup Expert!

Price: $47.50

CPE Credits: 5.0

Category: ,

Course Number: CXLOOKMC

Excel Lookup function

Description:
This course provides a comprehensive examination of the Lookup and Reference category in Excel. It covers the LOOKUP and VLOOKUP functions.
With VLOOKUP, you will learn how to: use Wildcards; search through multiple sheets for a match; and what to do if a match is not in the first column of your table. The course also explores HLOOKUP. It explains the advantages and disadvantages of INDEX MATCH versus VLOOKUP. It reviews the OFFSET function, which allows you to write calculations that automatically update as new data is added. With the INDIRECT function, you will learn how to find data on other worksheets sheets.  Finally, HYPERLINK is briefly discussed. Table of Contents

Delivery Method:
Online QAS Self Study.

Level: Intermediate

Version: Excel 2010/2013/2016 . This course was written for Excel 2016 however users with earlier versions should have no issues.

Prerequisites: Assumes familiarity with Excel and how to use basic functions such as SUM and COUNT.
Assumes the user understands what an absolute cell reference is.

Advanced Preparation: None

Author: Patricia McCarthy

Publication: February 2014
Updated:  February 2017

Format: PDF and Exercise Files

Passing Grade: 70%

Exam Policies: Exam may be retaken. Course must be completed within one year of purchase.

CPE Sponsor Info : NASBA/QAS #109234. Click here to view specific state approvals.

By the end of the course participants should be able to:
1. Differentiate among a variety of functions.
2. Recognize lookup functions syntax and how to use them in calculations.
3. Recognize the steps to incorporate data validation.
4. Recognize the importance of a range name and how to create one.
5. Recognize how to incorporate wildcards into functions
6. Understand how to incorporate other functions, such as COLUMN and ROW, into Lookup and Reference functions.

 

Below are Customer’s Comments:

Overall Course Rating: 5 – Angela B. 6/2018

“I thoroughly enjoyed the course the way it is currently structured. I appreciated the review problems that forced me to apply what I learned without spoon feeding. ” Ellen N.
“I am floored by the amount of tips I have from this course.”  – Marissa .D.
“Learned a great deal. Wow you really are an Excel-Diva. By the way, enjoyed the YouTube vid. It was very insightful.” -Brandon A.
“I learned new Excel functions and I am happy to report the days of using an IF statement to check work are gone and replaced with a greater utility function!”- Brenda S.

Description:
This course provides a comprehensive examination of the Lookup and Reference category in Excel. It covers the LOOKUP and VLOOKUP functions.
With VLOOKUP, you will learn how to: use Wildcards; search through multiple sheets for a match; and what to do if a match is not in the first column of your table. The course also explores HLOOKUP. It explains the advantages and disadvantages of INDEX MATCH versus VLOOKUP. It reviews the OFFSET function, which allows you to write calculations that automatically update as new data is added. With the INDIRECT function, you will learn how to find data on other worksheets sheets.  Finally, HYPERLINK is briefly discussed. Table of Contents

Delivery Method:
Online QAS Self Study.

Level: Intermediate

Version: Excel 2010/2013/2016 . This course was written for Excel 2016 however users with earlier versions should have no issues.

Prerequisites: Assumes familiarity with Excel and how to use basic functions such as SUM and COUNT.
Assumes the user understands what an absolute cell reference is.

Advanced Preparation: None

Author: Patricia McCarthy

Publication: February 2014
Updated:  February 2017

Format: PDF and Exercise Files

Passing Grade: 70%

Exam Policies: Exam may be retaken. Course must be completed within one year of purchase.

CPE Sponsor Info : NASBA/QAS #109234. Click here to view specific state approvals.

By the end of the course participants should be able to:
1. Differentiate among a variety of functions.
2. Recognize lookup functions syntax and how to use them in calculations.
3. Recognize the steps to incorporate data validation.
4. Recognize the importance of a range name and how to create one.
5. Recognize how to incorporate wildcards into functions
6. Understand how to incorporate other functions, such as COLUMN and ROW, into Lookup and Reference functions.

 

Below are Customer’s Comments:

Overall Course Rating: 5 – Angela B. 6/2018

“I thoroughly enjoyed the course the way it is currently structured. I appreciated the review problems that forced me to apply what I learned without spoon feeding. ” Ellen N.
“I am floored by the amount of tips I have from this course.”  – Marissa .D.
“Learned a great deal. Wow you really are an Excel-Diva. By the way, enjoyed the YouTube vid. It was very insightful.” -Brandon A.
“I learned new Excel functions and I am happy to report the days of using an IF statement to check work are gone and replaced with a greater utility function!”- Brenda S.

  • Thank you Patricia. I really love your courses. I learned so much about excel this weekend!”

    - Connie K.

  • Great course! Price was right and the material was very thorough.

    - Alex

  • “The course on ethics was one of the best correspondence courses I ever used.  It was well organized and the examples used were extremely helpful.”

    - Tommy R.