By WIISE
Online
Can be taken anytime
Professional Training Course
Yes (Details)
English
$10
Course Overview
Lookup functions on an excel sheet make's it extremely easy for people who work on multiple excel sheets to match data in various places. This course helps you understand and learn 6 plus lookup functions and become an expert in using them.
MS Excel & 6 lookup functions
Learning Objectives:
- Carry out Basic V-lookups and H-lookups in Excel
- Use the Index and Match functions in isolation and combined
- Combine V-lookup with Match for a more dynamic formula
- Carry out a lookup to the left
- Use the V-lookup function with Text
- Use the Choose function to lookup values
- Workbooks to download
- Activities to complete
Who should take this course
It is available for all the learners.
Accreditation
WIISE
Course content
What will you cover?:
- Master Lookup functions for Bookkeepers and Accountants
- Introduction 0:01:39
- Vlookup basics 0:10:44
- Index match 0:10:27
- Left lookup 0:03:19
- Vlookup match 0:03:46
- Lookup text 0:04:29
- Choose function 0:08:11
- H lookup 0:07:08
- Conclusion
About Course Provider
WIISE is a 'Professional Learning Network' with a global outreach that helps anyone to learn anything to achieve personal and professional goals.
We bring top-rated interactive learning courses & certifications from across the world through respected Global Academic Institutes and Industry experts to our learners.
WIISE for Teams is a Smart training solution suitable for growing businesses (SMB’s) - deliver online cost-effective, on-demand training, staff engagement & Upskilling to their employees and customers. WIISE incorporates the latest micro-learning & social-learning techniques that provides fast and engaging training at a fraction of cost of traditional training methods.
WIISE is brought by respectable Learning services & Skill development company - PositiveShift Group - Silicon Valley CA USA, India (www.positiveshift.in). The company has been awarded unique Innovation partnership with National Skill Development Corporation (NSDC) and Ministry of Skill Development and Entrepreneurship, Govt of India.