Excel 4 Accounting & Bookkeeping - Master Lookup Functions

  • Course provided by Udemy
  • Study type: Online
  • Starts: Anytime
  • Price: See latest price on Udemy
Udemy

Course 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
  • Course Material
    00:15
  • 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

Microsoft MVP, CPA Accountant, & Life Long Learner
  • 4.3 Instructor Rating
  • 9,975 Reviews
  • 110,749 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.


Expected Outcomes

  1. 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 Show more Show less Course content 1 section • 12 lectures • 52m total length Bookkeepers and Accountant - Master Lookup functions 12 lectures • 53min Introduction Preview 01:39 Course Material 00:15 Basic V-lookups in Excel Preview 10: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 4.3 Instructor Rating 9,975 Reviews 110,749 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. Show more Show less Udemy Business Teach on Udemy Get the app About us Contact us Careers Blog Help and Support Affiliate Impressum Kontakt Terms Privacy policy Cookie settings Sitemap © 2021 Udemy, Inc. window.handleCSSToggleButtonClick = function (event) { var target = event.currentTarget; var cssToggleId = target && target.dataset && target.dataset.cssToggleId; var input = cssToggleId && document.getElementById(cssToggleId); if (input) { if (input.dataset.type === 'checkbox') { input.dataset.checked = input.dataset.checked ? '' : 'checked'; } else { input.dataset.checked = input.dataset.allowToggle && input.dataset.checked ? '' : 'checked'; var radios = document.querySelectorAll('[name="' + input.dataset.name + '"]'); for (var i = 0; i (function(){window['__CF$cv$params']={r:'677b38102a6c425d',m:'2eda41d4acfeee4c72b8e584c7034d1678ed5292-1627780565-1800-AeD+WaRhO1vSvYABbpm05VoTwqDYuQRkFYQ/xKXlGp+WDmKAr+Pc+HDBCwcK/SY9fc5CFip9TPkQ9elg7fCK6tDEQKccFLlia/zhoxjgVO1yFvCIn0KyKOkJbhN5PHfzhtDDduZoZeWGiorIBHJSzTwwicinRnY1baC8FDbBCeuJjFsLWlZTzEANZTX9n2AXbg==',s:[0x9fdfe3c0c0,0x331eb26495],}})();
  2. 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 Show more Show less Course content 1 section • 12 lectures • 52m total length Bookkeepers and Accountant - Master Lookup functions 12 lectures • 53min Introduction Preview 01:39 Course Material 00:15 Basic V-lookups in Excel Preview 10: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 4.3 Instructor Rating 9,975 Reviews 110,749 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. Show more Show less Udemy Business Teach on Udemy Get the app About us Contact us Careers Blog Help and Support Affiliate Impressum Kontakt Terms Privacy policy Cookie settings Sitemap © 2021 Udemy, Inc. window.handleCSSToggleButtonClick = function (event) { var target = event.currentTarget; var cssToggleId = target && target.dataset && target.dataset.cssToggleId; var input = cssToggleId && document.getElementById(cssToggleId); if (input) { if (input.dataset.type === 'checkbox') { input.dataset.checked = input.dataset.checked ? '' : 'checked'; } else { input.dataset.checked = input.dataset.allowToggle && input.dataset.checked ? '' : 'checked'; var radios = document.querySelectorAll('[name="' + input.dataset.name + '"]'); for (var i = 0; i (function(){window['__CF$cv$params']={r:'677b38102a6c425d',m:'2eda41d4acfeee4c72b8e584c7034d1678ed5292-1627780565-1800-AeD+WaRhO1vSvYABbpm05VoTwqDYuQRkFYQ/xKXlGp+WDmKAr+Pc+HDBCwcK/SY9fc5CFip9TPkQ9elg7fCK6tDEQKccFLlia/zhoxjgVO1yFvCIn0KyKOkJbhN5PHfzhtDDduZoZeWGiorIBHJSzTwwicinRnY1baC8FDbBCeuJjFsLWlZTzEANZTX9n2AXbg==',s:[0x9fdfe3c0c0,0x331eb26495],}})();
  3. 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 Show more Show less Course content 1 section • 12 lectures • 52m total length Bookkeepers and Accountant - Master Lookup functions 12 lectures • 53min Introduction Preview 01:39 Course Material 00:15 Basic V-lookups in Excel Preview 10: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 4.3 Instructor Rating 9,975 Reviews 110,749 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. Show more Show less Udemy Business Teach on Udemy Get the app About us Contact us Careers Blog Help and Support Affiliate Impressum Kontakt Terms Privacy policy Cookie settings Sitemap © 2021 Udemy, Inc. window.handleCSSToggleButtonClick = function (event) { var target = event.currentTarget; var cssToggleId = target && target.dataset && target.dataset.cssToggleId; var input = cssToggleId && document.getElementById(cssToggleId); if (input) { if (input.dataset.type === 'checkbox') { input.dataset.checked = input.dataset.checked ? '' : 'checked'; } else { input.dataset.checked = input.dataset.allowToggle && input.dataset.checked ? '' : 'checked'; var radios = document.querySelectorAll('[name="' + input.dataset.name + '"]'); for (var i = 0; i (function(){window['__CF$cv$params']={r:'677b38102a6c425d',m:'2eda41d4acfeee4c72b8e584c7034d1678ed5292-1627780565-1800-AeD+WaRhO1vSvYABbpm05VoTwqDYuQRkFYQ/xKXlGp+WDmKAr+Pc+HDBCwcK/SY9fc5CFip9TPkQ9elg7fCK6tDEQKccFLlia/zhoxjgVO1yFvCIn0KyKOkJbhN5PHfzhtDDduZoZeWGiorIBHJSzTwwicinRnY1baC8FDbBCeuJjFsLWlZTzEANZTX9n2AXbg==',s:[0x9fdfe3c0c0,0x331eb26495],}})();
  4. 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 Show more Show less Course content 1 section • 12 lectures • 52m total length Bookkeepers and Accountant - Master Lookup functions 12 lectures • 53min Introduction Preview 01:39 Course Material 00:15 Basic V-lookups in Excel Preview 10: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 4.3 Instructor Rating 9,975 Reviews 110,749 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. Show more Show less Udemy Business Teach on Udemy Get the app About us Contact us Careers Blog Help and Support Affiliate Impressum Kontakt Terms Privacy policy Cookie settings Sitemap © 2021 Udemy, Inc. window.handleCSSToggleButtonClick = function (event) { var target = event.currentTarget; var cssToggleId = target && target.dataset && target.dataset.cssToggleId; var input = cssToggleId && document.getElementById(cssToggleId); if (input) { if (input.dataset.type === 'checkbox') { input.dataset.checked = input.dataset.checked ? '' : 'checked'; } else { input.dataset.checked = input.dataset.allowToggle && input.dataset.checked ? '' : 'checked'; var radios = document.querySelectorAll('[name="' + input.dataset.name + '"]'); for (var i = 0; i (function(){window['__CF$cv$params']={r:'677b38102a6c425d',m:'2eda41d4acfeee4c72b8e584c7034d1678ed5292-1627780565-1800-AeD+WaRhO1vSvYABbpm05VoTwqDYuQRkFYQ/xKXlGp+WDmKAr+Pc+HDBCwcK/SY9fc5CFip9TPkQ9elg7fCK6tDEQKccFLlia/zhoxjgVO1yFvCIn0KyKOkJbhN5PHfzhtDDduZoZeWGiorIBHJSzTwwicinRnY1baC8FDbBCeuJjFsLWlZTzEANZTX9n2AXbg==',s:[0x9fdfe3c0c0,0x331eb26495],}})();
  5. 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 Show more Show less Course content 1 section • 12 lectures • 52m total length Bookkeepers and Accountant - Master Lookup functions 12 lectures • 53min Introduction Preview 01:39 Course Material 00:15 Basic V-lookups in Excel Preview 10: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 4.3 Instructor Rating 9,975 Reviews 110,749 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. Show more Show less Udemy Business Teach on Udemy Get the app About us Contact us Careers Blog Help and Support Affiliate Impressum Kontakt Terms Privacy policy Cookie settings Sitemap © 2021 Udemy, Inc. window.handleCSSToggleButtonClick = function (event) { var target = event.currentTarget; var cssToggleId = target && target.dataset && target.dataset.cssToggleId; var input = cssToggleId && document.getElementById(cssToggleId); if (input) { if (input.dataset.type === 'checkbox') { input.dataset.checked = input.dataset.checked ? '' : 'checked'; } else { input.dataset.checked = input.dataset.allowToggle && input.dataset.checked ? '' : 'checked'; var radios = document.querySelectorAll('[name="' + input.dataset.name + '"]'); for (var i = 0; i (function(){window['__CF$cv$params']={r:'677b38102a6c425d',m:'2eda41d4acfeee4c72b8e584c7034d1678ed5292-1627780565-1800-AeD+WaRhO1vSvYABbpm05VoTwqDYuQRkFYQ/xKXlGp+WDmKAr+Pc+HDBCwcK/SY9fc5CFip9TPkQ9elg7fCK6tDEQKccFLlia/zhoxjgVO1yFvCIn0KyKOkJbhN5PHfzhtDDduZoZeWGiorIBHJSzTwwicinRnY1baC8FDbBCeuJjFsLWlZTzEANZTX9n2AXbg==',s:[0x9fdfe3c0c0,0x331eb26495],}})();
  6. 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 Show more Show less Course content 1 section • 12 lectures • 52m total length Bookkeepers and Accountant - Master Lookup functions 12 lectures • 53min Introduction Preview 01:39 Course Material 00:15 Basic V-lookups in Excel Preview 10: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 4.3 Instructor Rating 9,975 Reviews 110,749 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. Show more Show less Udemy Business Teach on Udemy Get the app About us Contact us Careers Blog Help and Support Affiliate Impressum Kontakt Terms Privacy policy Cookie settings Sitemap © 2021 Udemy, Inc. window.handleCSSToggleButtonClick = function (event) { var target = event.currentTarget; var cssToggleId = target && target.dataset && target.dataset.cssToggleId; var input = cssToggleId && document.getElementById(cssToggleId); if (input) { if (input.dataset.type === 'checkbox') { input.dataset.checked = input.dataset.checked ? '' : 'checked'; } else { input.dataset.checked = input.dataset.allowToggle && input.dataset.checked ? '' : 'checked'; var radios = document.querySelectorAll('[name="' + input.dataset.name + '"]'); for (var i = 0; i (function(){window['__CF$cv$params']={r:'677b38102a6c425d',m:'2eda41d4acfeee4c72b8e584c7034d1678ed5292-1627780565-1800-AeD+WaRhO1vSvYABbpm05VoTwqDYuQRkFYQ/xKXlGp+WDmKAr+Pc+HDBCwcK/SY9fc5CFip9TPkQ9elg7fCK6tDEQKccFLlia/zhoxjgVO1yFvCIn0KyKOkJbhN5PHfzhtDDduZoZeWGiorIBHJSzTwwicinRnY1baC8FDbBCeuJjFsLWlZTzEANZTX9n2AXbg==',s:[0x9fdfe3c0c0,0x331eb26495],}})();
  7. 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 Show more Show less Course content 1 section • 12 lectures • 52m total length Bookkeepers and Accountant - Master Lookup functions 12 lectures • 53min Introduction Preview 01:39 Course Material 00:15 Basic V-lookups in Excel Preview 10: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 4.3 Instructor Rating 9,975 Reviews 110,749 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. Show more Show less Udemy Business Teach on Udemy Get the app About us Contact us Careers Blog Help and Support Affiliate Impressum Kontakt Terms Privacy policy Cookie settings Sitemap © 2021 Udemy, Inc. window.handleCSSToggleButtonClick = function (event) { var target = event.currentTarget; var cssToggleId = target && target.dataset && target.dataset.cssToggleId; var input = cssToggleId && document.getElementById(cssToggleId); if (input) { if (input.dataset.type === 'checkbox') { input.dataset.checked = input.dataset.checked ? '' : 'checked'; } else { input.dataset.checked = input.dataset.allowToggle && input.dataset.checked ? '' : 'checked'; var radios = document.querySelectorAll('[name="' + input.dataset.name + '"]'); for (var i = 0; i (function(){window['__CF$cv$params']={r:'677b38102a6c425d',m:'2eda41d4acfeee4c72b8e584c7034d1678ed5292-1627780565-1800-AeD+WaRhO1vSvYABbpm05VoTwqDYuQRkFYQ/xKXlGp+WDmKAr+Pc+HDBCwcK/SY9fc5CFip9TPkQ9elg7fCK6tDEQKccFLlia/zhoxjgVO1yFvCIn0KyKOkJbhN5PHfzhtDDduZoZeWGiorIBHJSzTwwicinRnY1baC8FDbBCeuJjFsLWlZTzEANZTX9n2AXbg==',s:[0x9fdfe3c0c0,0x331eb26495],}})();
  8. 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 Show more Show less Course content 1 section • 12 lectures • 52m total length Bookkeepers and Accountant - Master Lookup functions 12 lectures • 53min Introduction Preview 01:39 Course Material 00:15 Basic V-lookups in Excel Preview 10: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 4.3 Instructor Rating 9,975 Reviews 110,749 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. Show more Show less Udemy Business Teach on Udemy Get the app About us Contact us Careers Blog Help and Support Affiliate Impressum Kontakt Terms Privacy policy Cookie settings Sitemap © 2021 Udemy, Inc. window.handleCSSToggleButtonClick = function (event) { var target = event.currentTarget; var cssToggleId = target && target.dataset && target.dataset.cssToggleId; var input = cssToggleId && document.getElementById(cssToggleId); if (input) { if (input.dataset.type === 'checkbox') { input.dataset.checked = input.dataset.checked ? '' : 'checked'; } else { input.dataset.checked = input.dataset.allowToggle && input.dataset.checked ? '' : 'checked'; var radios = document.querySelectorAll('[name="' + input.dataset.name + '"]'); for (var i = 0; i (function(){window['__CF$cv$params']={r:'677b38102a6c425d',m:'2eda41d4acfeee4c72b8e584c7034d1678ed5292-1627780565-1800-AeD+WaRhO1vSvYABbpm05VoTwqDYuQRkFYQ/xKXlGp+WDmKAr+Pc+HDBCwcK/SY9fc5CFip9TPkQ9elg7fCK6tDEQKccFLlia/zhoxjgVO1yFvCIn0KyKOkJbhN5PHfzhtDDduZoZeWGiorIBHJSzTwwicinRnY1baC8FDbBCeuJjFsLWlZTzEANZTX9n2AXbg==',s:[0x9fdfe3c0c0,0x331eb26495],}})();