Excel in Excel learning what LookUp Functions are and how to use them!
Course Description
What you’ll learn
- Identify and utilize a dozen of the most popular lookup functions.
- Understand the language used in functions.
- Achieve an understanding and use of nested functions.
- Identify Dynamic Array functions and how to use them.
Course Content
- Introduction –> 6 lectures • 26min.
- Reference Functions –> 3 lectures • 8min.
- Nested Functions –> 5 lectures • 15min.
- Dynamic Array Functions –> 3 lectures • 5min.
- Summary –> 1 lecture • 1min.
Requirements
Course Description
This course will introduce you to what LookUp Functions are and how to use them. You will also learn the language Excel uses to better understand what you are doing when you assemble the function. Additional tools will be provided to help you engage with the program and make thing happen more quickly and more efficiently.
We will be covering
· VLookUp
· HLookUp
· XLookUp
· Index
· Match
· GetPivotData
· Choose
· Unique
· Sort
· SortBy
· Transpose
The IF and IFError functions are also included, though these are not LookUp functions, but they aid in the presentation of information in a more professional manner and we want to look as good as we can!
Additional tools are also provided to aid you in producing a more efficient product more quickly. Several keyboard shortcuts are included; AutoFill shortcuts and the use of the “F” keys, as well as a way to select large amounts of information in functions. These tools can be applied to other formulas and functions in the future.
This course is presented for Beginning to Intermediate level students. The length of the class is short enough to keep your attention but long enough to give you as much information as possible for your knowledge level. Please, make sure you download the document (Resource) we will be using in the class. You can work along with me or open it up later and work on it. Either way you want the document to further hone your Excel skills.
What are we waiting for? Let’s get started!