Microsoft Excel 6: Lookup and Logical Functions - Hands-on
Microsoft Excel 6: Lookup and Logical Functions
Description
Once a data table has been added to Excel, we regularly want to compare the data against existing data or categories, and find ways to combine the new information with existing concepts. Lookup functions like VLOOKUP allow us to combine tables or find a position within a range, and logical functions like IF allow us to build our own categories.
Topics include:
- Combining and comparing tables with VLOOKUP and INDEX and MATCH
- Upgrading table combinations with XLOOKUP and Power Query
- Categorizing data with logical functions
- Using Boolean comparisons to color-code spreadsheets