Logical and lookup functions in Excel
Learn the purpose of logical and lookup functions and how to use them with Excel for Microsoft 365.
Take Excel from a tool that simply reports historical results and configure it to respond dynamically to changes in scenarios and turn your spreadsheets into business intelligence tools.
This course begins with looking at logical functions, from the ISBLANK() function through a variety of others which can be leveraged at key times. Explore reference functions that allow you to pull information from different worksheet cells as required.
This online, video-led course is performed using Excel for Microsoft 365 and includes an eBook and practical examples that are yours to keep.
Note: This course can be taken individually or as part of the Comprehensive Excel Certificate Program.
You will learn about:
- The purpose of logical functions and how to use them in the real world
- Logical functions such as ISBLANK(), ISNUMBER(), ISTEXT() function, ISFORMULA(), ISLOGICAL(), NOT(), ISODD() and, ISEVEN()
- Reference functions
- How the CHOOSE(), VLOOKUP(), INDEX() and MATCH() functions work
- Creating the VLOOKUP() function
- The difference between approximate and exact matches
Who should attend?
- advanced Excel users
- IT professionals
- business intelligence educators
- consultants
- financial analysts
