By Simpliv
Online
Can be taken anytime
Professional Training Course
Yes (Details)
English
$10
Course Overview
About this Course:
Looking up data is a very useful and powerful tool to have when working in Excel. Unfortunately there are common myths going around that Lookups are really difficult and only for the super advanced users!
To Lookup something in a nutshell means to search a particular value from one spreadsheet or workbook against another particular value that we already know. Think of it like searching for a phone number in a telephone directory.
The VLookup and HLookup functions provide the easiest way to search and locate values from both Columns and Rows. By the end of this course you'll be able to match customer details to Purchase Orders retrieve product information from a stock sheet and so much more!
Basic knowledge:
- Students are only required to have a basic understanding of how rows and columns are referenced in Excel
Who should take this course
Who is the target audience?:
- All Excel users from Beginner to Advanced
Accreditation
Course Completion Certificate
Course content
What you will learn:
- What are Lookups their structure and how they work in Excel
- How to use Range Names with Lookups
- Creating a VLookup and HLookup Formula
- Curriculum
- Conquering VLookup and Hlookup
About Course Provider
Simpliv LLC, a platform for learning and teaching online courses. We basically focus on online learning which helps to learn business concepts, software technology to develop personal and professional goals through video library by recognized industry experts or trainers.
Why Simpliv
With the ever-evolving industry trends, there is a constant need of the professionally designed learning solutions that deliver key innovations on time and on a budget to achieve long-term success.
Simpliv understands the changing needs and allows the global learners to evaluate their technical abilities by aligning the learnings to key business objectives in order to fill the skills gaps that exist in the various business areas including IT, Marketing, Business Development, and much more.