LinkedIn Learning - Excel Formulas and Functions Quick Tips

Files Included :

01 - Calculate data with ease in Excel.mp4 (3.18 MB)
MP4
01 - Build a formula in a cell with =.mp4 (2.49 MB)
MP4
02 - Create a named range.mp4 (2.59 MB)
MP4
03 - Reference cells and worksheets.mp4 (4.09 MB)
MP4
04 - Join text with an ampersand.mp4 (3.58 MB)
MP4
01 - Calculate a total with SUM.mp4 (1.85 MB)
MP4
02 - Sum values that meet specific criteria with SUMIF.mp4 (2.26 MB)
MP4
03 - Find the mean value with AVERAGE.mp4 (2.1 MB)
MP4
04 - Test for valid data with IF.mp4 (4.13 MB)
MP4
05 - Create complex tests with AND and OR.mp4 (4.25 MB)
MP4
06 - Find record values with MAX, MIN, SMALL, and LARGE.mp4 (2.33 MB)
MP4
07 - Perform date calculations with TODAY().mp4 (2.23 MB)
MP4
01 - Count cells that contain numbers with COUNT.mp4 (2.49 MB)
MP4
02 - Count nonblank cells with COUNTA.mp4 (1.95 MB)
MP4
03 - Return a number of occurrences with COUNTIF.mp4 (6.35 MB)
MP4
04 - Check-in with Jess.mp4 (4.5 MB)
MP4
01 - Format numbers and dates with TEXT.mp4 (4.41 MB)
MP4
02 - Extract characters with LEFT AND RIGHT.mp4 (3.78 MB)
MP4
03 - Extract substrings with MID.mp4 (2.55 MB)
MP4
04 - Count characters with LEN.mp4 (2.4 MB)
MP4
05 - Identify where a character occurs with FIND.mp4 (5.44 MB)
MP4
06 - Join strings with delimiters with TEXTJOIN.mp4 (4.14 MB)
MP4
07 - Change text with SUBSTITUTE and REPLACE.mp4 (5.22 MB)
MP4
01 - Retrieve a specific value with XLOOKUP.mp4 (5.64 MB)
MP4
02 - Use INDEX and MATCH to retrieve a value.mp4 (5.58 MB)
MP4
01 - Remove leading spaces with TRIM.mp4 (3.81 MB)
MP4
02 - Include IFERROR to trap errors in formulas.mp4 (3.81 MB)
MP4
01 - Learn more complex features of Excel.mp4 (877.58 KB)
MP4