10:24Added 23 Views / 0 Likes
Lynnette Mann explains the IF function in Microsoft Excel 2013. The IF function returns one value if a condition you specify evaluates to TRUE, and another value if that condition evaluates to FALSE.
15:23Added 26 Views / 0 Likes
Lynette Mann explains the use of Boolean logical operators in Excel 2013. Not only can users use an expression to match records, but they can combine expressions using the And, OR, NOT, and XOR operators.
30:18Added 29 Views / 0 Likes
Lynette Mann explains the LOOKUP and reference functions in Microsoft Excel 2013. The LOOKUP function finds a value in a single row or column and matches it with a value in the same position in a different row or column. HLOOKUP and VLOOKUP are used for r
1:15:10Added 23 Views / 0 Likes
1:01:53Added 24 Views / 0 Likes