Lookup Functions in Excel

Master what lookup functions work best in different scenarios | taught by David Brown
$70.00
Report Automation in Modern Excel
$50.00
Scenario & Sensitivity Analysis Master Class

Course description

Learn to Master the inner workings and correct for the limitations of the core lookup functions: VLOOKUP, INDEX, MATCH, OFFSET, CHOOSE and more
Read More

Instructor

David Brown
David Brown
FCA, Microsoft MVP

David Brown is an ATD Master Trainer and Master Instructional Designer. He is also a Microsoft MVP, an International Consultant to the World Bank, a Chartered Accountant and the founder and Managing Partner of dbrownconsulting, a Lagos-based consulting and Analyst training firm. David is also a regular speaker at International conferences and events.

David and his team at dbrownconsulting develop self-service reporting tools to automate the tedious process of cross reporting on LMS Data, HR & Training Data and Other Data silos in organisations, providing great insights for management with minutes without the need for new software.

He is also a passionate facilitator, he has trained thousands in technical courses such as Financial Modelling, Business Intelligence and Analytics with Power BI, Finance for non-Financial Managers and much more. He develops unique methodologies, frameworks and job aids to simplify tedious tasks at work as well as make the facilitation and learning of complex topics fun and sticky.

He was awarded the Microsoft MVP award in 2018 for his tireless support of the technical community where he hosts monthly online meetups in Excel & Power BI and Financial Modeling, Live events and thought leadership in Excel, Power BI and Data Analytics platforms. He also hosts a monthly webinar on Talent Development.

He leads a team of trainers/instructional designers in developing, designing and implementing blended learning courses for Analyst, his work can be viewed on www.OfficeTrainingHub.com and his firm's corporate website www.dbrownconsulting.net.

Contact him on LinkedIn on https://www.linkedin.com/in/davidbrownprofile/


Reviews (1)

Concise and Valuable Training

by Akinwunmi Bello
Clearly, the use of lookup functions in Excel cannot be overemphasized. Mr. David in less than an hour 30 mins will take you to a realm of possibilities (previously thought of as impossibilities or not thought of at all) through this training. The delivery of the videos was succinct and concise; be prepared to get much value from this training.

Concise and Valuable Training

by Akinwunmi Bello
Clearly, the use of lookup functions in Excel cannot be overemphasized. Mr. David in less than an hour 30 mins will take you to a realm of possibilities (previously thought of as impossibilities or not thought of at all) through this training. The delivery of the videos was succinct and concise; be prepared to get much value from this training.