Udemy
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
Development
Web Development Data Science Mobile Development Programming Languages Game Development Database Design & Development Software Testing Software Engineering Development Tools No-Code Development
Business
Entrepreneurship Communications Management Sales Business Strategy Operations Project Management Business Law Business Analytics & Intelligence Human Resources Industry E-Commerce Media Real Estate Other Business
Finance & Accounting
Accounting & Bookkeeping Compliance Cryptocurrency & Blockchain Economics Finance Finance Cert & Exam Prep Financial Modeling & Analysis Investing & Trading Money Management Tools Taxes Other Finance & Accounting
IT & Software
IT Certification Network & Security Hardware Operating Systems Other IT & Software
Office Productivity
Microsoft Apple Google SAP Oracle Other Office Productivity
Personal Development
Personal Transformation Personal Productivity Leadership Career Development Parenting & Relationships Happiness Esoteric Practices Religion & Spirituality Personal Brand Building Creativity Influence Self Esteem & Confidence Stress Management Memory & Study Skills Motivation Other Personal Development
Design
Web Design Graphic Design & Illustration Design Tools User Experience Design Game Design Design Thinking 3D & Animation Fashion Design Architectural Design Interior Design Other Design
Marketing
Digital Marketing Search Engine Optimization Social Media Marketing Branding Marketing Fundamentals Marketing Analytics & Automation Public Relations Advertising Video & Mobile Marketing Content Marketing Growth Hacking Affiliate Marketing Product Marketing Other Marketing
Lifestyle
Arts & Crafts Beauty & Makeup Esoteric Practices Food & Beverage Gaming Home Improvement Pet Care & Training Travel Other Lifestyle
Photography & Video
Digital Photography Photography Portrait Photography Photography Tools Commercial Photography Video Design Other Photography & Video
Health & Fitness
Fitness General Health Sports Nutrition Yoga Mental Health Dieting Self Defense Safety & First Aid Dance Meditation Other Health & Fitness
Music
Instruments Music Production Music Fundamentals Vocal Music Techniques Music Software Other Music
Teaching & Academics
Engineering Humanities Math Science Online Education Social Science Language Teacher Training Test Prep Other Teaching & Academics
AWS Certification Microsoft Certification AWS Certified Solutions Architect - Associate AWS Certified Cloud Practitioner CompTIA A+ Cisco CCNA CompTIA Security+ Amazon AWS AWS Certified Developer - Associate
Graphic Design Photoshop Adobe Illustrator Drawing Digital Painting InDesign Character Design Canva Figure Drawing
Life Coach Training Neuro-Linguistic Programming Mindfulness Personal Development Meditation Personal Transformation Life Purpose Emotional Intelligence Neuroscience
Web Development JavaScript React CSS Angular PHP WordPress Node.Js Python
Google Flutter Android Development iOS Development Swift React Native Dart Programming Language Mobile Development Kotlin SwiftUI
Digital Marketing Google Ads (Adwords) Social Media Marketing Google Ads (AdWords) Certification Marketing Strategy Internet Marketing YouTube Marketing Email Marketing Retargeting
Microsoft Power BI SQL Tableau Business Analysis Business Intelligence MySQL Data Analysis Data Modeling Data Science
Business Fundamentals Entrepreneurship Fundamentals Business Strategy Online Business Business Plan Startup Freelancing Blogging Home Business
Unity Game Development Fundamentals Unreal Engine C# 3D Game Development C++ 2D Game Development Unreal Engine Blueprints Blender
30-Day Money-Back Guarantee
Finance & Accounting Accounting & Bookkeeping Accounting

Excel 4 Accounting & Bookkeeping - Master Lookup Functions

Lookup to the right, Lookup to the left, Index, Match and Choose - Master Lookups Now
Rating: 4.3 out of 54.3 (182 ratings)
2,821 students
Created by Paula Guilfoyle CPA & MVP
Last updated 11/2017
English
English [Auto]
30-Day Money-Back Guarantee

What you'll learn

  • 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

Requirements

  • You should have Excel knowledge similar to that offered in the free Udemy Course - Basic Excel for Basic Bookkeeping

Description

Excel for Accounting and Bookkeeping - Master Lookup Functions. A comprehensive course for those that wish to up skill in Excel and Learn advanced lookup formula.

In This Course You Will Learn How Lookup To The Right and the Left, Use Index and Match, Use Combinations of Index, Match and Vlookup, Carry out Lookups with Text And Use The Choose Function.

Do you need to understand and carry out basic or complex lookups in Excel? Then this course is for you!

Course Overview

This course begins with some basic lookup formula but quickly moves into more complex examples, providing solutions to common lookup problems.

This course contains:

Activities are used through out this course and the answer from one activity leads into a later activity.

Workbook to download

Certificate of Completion

******BONUS****** FREE Join a community of other learners where you can interact with each other and with the instructor.

********************************************************************************************

REGISTER NOW and get started with Excel for Accounting and Bookkeeping - Master Lookup Functions

*******************************************************************************************

Your purchase is 100% RISK FREE with a 30 day money-back guarantee. If you don't learn anything new from this course, simply request a refund within your 30 day period for your money back, no questions asked.

Who this course is for:

  • These functions work in all versions of Excel
  • You should take this course if you are interested in becoming more efficient in your daily Excel and Spreadsheets tasks.
  • This course is for you if you wish to improve your Excel skills and Master Lookup functions

Course content

1 section • 12 lectures • 52m total length

  • Preview01:39
  • Course Material
    00:15
  • Preview10:44
  • Index and Match in Excel
    10:27
  • More Dynamic V-lookup
    03:46
  • Lookups to the Left
    03:19
  • The Choose function
    08:11
  • Lookups with Text
    04:29
  • HLookup
    07:08
  • Conclusion
    00:53
  • Course Activities
    00:10
  • Bonus
    01:37

Instructor

Paula Guilfoyle CPA & MVP
Microsoft MVP, CPA Accountant, & Life Long Learner
Paula Guilfoyle CPA & MVP
  • 4.3 Instructor Rating
  • 9,334 Reviews
  • 102,382 Students
  • 26 Courses

Paula is a qualified CPA with over 15 years' experience in the fields of Accountancy, Business Management, Process improvement, Internal Audit, Group accountant, Operations Management and Training. All across a broad range of industries and sectors.  Paula has been Key Speaker at many Accounting Events where her talks on Excel are received very positively. Taken from her experiences in Accounting and business fields, Paula also has Udemy courses for those wishing to upskill, especially in the area of Spreadsheets, Bookkeeping and Accounting.

In 2020 Paula was awarded with a Microsoft MVP award for her dedication to Excel and the Excel community.


  • Udemy for Business
  • Teach on Udemy
  • Get the app
  • About us
  • Contact us
  • Careers
  • Blog
  • Help and Support
  • Affiliate
  • Terms
  • Privacy policy
  • Cookie settings
  • Sitemap
  • Featured courses
Udemy
© 2021 Udemy, Inc.