10:24Added 18 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 22 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 18 Views / 0 Likes
1:01:53Added 19 Views / 0 Likes