Mastering the Excel Lookup Functions
Valid for one year from purchase date
Self-study - On-Demand
2 CPE (2 non-technical)
Course code: 26SX-0053
View pricing
If your organization is exempt
from sales tax, call us at 952-831-2707 to complete your purchase.
Add to cart
Unlock more for less. This course is included in CPA Crossings Unlimited Self-Study Subscription -- just $299 (plus tax) gets you unlimited access to all CPA Crossings' self-study courses, including this one. Maximize your ROI and learning potential -- order now!
In today's data-driven world, Microsoft Excel has become an essential tool for professionals in any organization. To harness the full potential of Excel, it is crucial to understand and master its lookup functions. This course is designed to equip participants with the knowledge and skills needed to effectively utilize Excel's lookup functions and enhance their data analysis capabilities.
Throughout this comprehensive course, participants will dive deep into the world of lookup functions and gain experience through practical exercises and real-world scenarios. Whether you're a seasoned Excel user looking to fine-tune your skills or a beginner eager to unlock Excel's full potential, this course is tailored to meet your learning needs.
Major subjects
-
A review of the various lookup functions, beyond VLOOKUP.
-
Learn which lookup works best for your situation.
-
How to apply the many lookup functions.
-
Discover advanced lookup techniques like nested lookups, approximate matching, and handling errors effectively.
-
An in-depth review of the following functions:
-
VLOOKUP / HLOOKUP.
-
XLOOKUP.
-
MATCH / INDEX.
-
XMATCH.
-
INDIRECT.
-
FILTER.
-
SORT / SORTBY.
-
UNIQUE.
-
An overview of some newer functions.
Learning objectives
-
Identify which lookup function works for your needs.
-
Distinguish the difference between the many lookup functions.
-
Recall how to effectively utilize Excel's lookup functions.
Who should take this program?
- Any Excel user that wants to learn how to use the LOOKUP functions.
Pricing
|
Standard Member Fee |
$58.00
|
 Standard Nonmember Fee |
$58.00
|
Our records indicate
you are a
nonmember.
If you register, you will be charged
$58.00
(Standard Nonmember Fee).
Members: Please
log in
to receive member fee.
If your organization is exempt
from sales tax, call us at 952-831-2707 to complete your purchase.
Add to cart
Area
of study
Information technology
Field(s)
of study
Computer Software & Applications - Non-Technical (2.0)
Level
Basic
Format
Self-study - On-Demand
Sponsor
NASBA ID#: 108744
Prerequisites
Prereq.
None
Advance
prep
None
Search CPE catalog
