Location
Online
Dates
Can be taken anytime
Course Type
Professional Training Course
Accreditation
Yes (Details)
Language
English
Price
$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.

Frequently asked questions

{{ item.question }}