Lynda Excel 2016 Advanced Formulas and Functions

/13. Information Functions/13_03-Using the ISERR, ISERROR, IFERROR, and ISNA errorchecking functions.mp4

/13. Information Functions/13_02-Using ISBLANK, ISODD, ISEVEN, ISTEXT, ISNONTEXT, and ISNUMBER.mp4

/13. Information Functions/13_01-Extracting information with the CELL and INFO functions.mp4

/13. Information Functions/13_04-Tracking and highlighting formula cells with the ISFORMULA function.mp4

/12. Text Functions/12_03-Using the TRIM function to remove unwanted spaces in a cell.mp4

/08. Math Functions/08_01-Working with the ROUND, ROUNDUP, and ROUNDDOWN functions.mp4

/08. Math Functions/08_03-Using the INT and TRUNC functions to extract integer data.mp4

/09. Date and Time Functions/09_02-Using the DATE, YEAR, MONTH, DAY, TIME, HOUR, MINUTE, and SECOND functions.mp4

/08. Math Functions/08_05-Exploring practical uses for the RAND and RANDBETWEEN functions.mp4

/11. Reference Functions/11_03-Using INDIRECT with Data Validation for twotiered pick list scenarios.mp4

/07. Statistical Functions/07_05-Using COUNT, COUNTA, and the status bar.mp4

/08. Math Functions/08_02-Working with MROUND, CEILING, and FLOOR for specialized rounding.mp4

/08. Math Functions/08_07-Using the powerful AGGREGATE function to bypass errors and hidden data.mp4

/11. Reference Functions/11_01-Getting data from remote cells with the OFFSET function.mp4

/11. Reference Functions/11_02-Returning references with the INDIRECT function.mp4

Showing first 15 files of 76 total files