1. ▄▄▄ ▄▄▄
  2. █████▄ ▄▄▄ ▄█████
  3. ▄▄▄▄ ▀█████ ▄▄█▓█████▄▄ █████ ▄▄▄ ▄▄▄▄
  4. ▄██████████▄████▓ █████████████ ████ ▄█████ ██████
  5. ███▓▀▀▀▀█████▓████ █████▀ ▀████▓ ▓███ ▄██▄ █████▓ ▓██████
  6. ░▓███▄ ▄████ ████ █████▓ ▓█████▓███ ████ ██████▄ ▄██████▓
  7. ████████████▀ ████ █████ █████████ ████▄██▄███████▄███▀████▓
  8. ▀███▄ ▄▄▄ ▄████▀ ▓████ █████████ ████████▓███ ▀██▓▀ ████
  9. ▀███▄████▄█████ ██████ ████▓█████▄▓████ ▀▀ ████ ▀ ████
  10. ▄████▄ ▀▀████████▓ ███████ ▓▓██▀███▀ ▀██████▄██▄ ███ ████
  11. █████████ ▀█▓▀ █████▄▄ ░▓███████▄▄▄████▄██▓ ▀████████████ ████
  12. ██████████▄ ▄▄ ▀▀█████▄▄▓████▀███████▀▄███ ▄▄ ████████████ ▓▄▄▄▄ ████▓░
  13. ▓█████████████▓▓█▄▄ ▀▀▓▓█████▓░ ▀▀▀ ▄ ▀████▄ ▀██ ████████████ ████▀ ▄███▓
  14. ▀███▓▓▓█████████████▄▄▄ ▀▀███▀ ▄███████▄ ▀▀███▄ ▓ ███▓███▓████ ▓█▀ ▄███▀▀
  15. ▀▀▀ ▀▀▀▓▓███▄▄▄▄▄███████▀▀▀▀▓ ▀▀ ███▓ ▀▀ ████ ▀ ▀▓▓█▄▄
  16. ▀▀▀▀▀▀ ▀▀ ▀██▀ ▀▀▀▀▀
  17. RELEASE NAME....: Lynda.com.Excel.for.Mac.2016.Advanced.Formulas.and.Functions-ELOHiM
  18. RELEASE DATE....: 2016-05-29
  19. RELEASE SIZE....: 25x50Mb
  20. FORMAT..........: Bookware
  21. LANGUAGE........: English
  22. URL.............: http://www.lynda.com
  23. Conquer some of the most daunting features in Microsoft Excel: formulas
  24. and functions. In this Excel for Mac 2016 update to his popular series,
  25. author Dennis Taylor presents numerous formulas and functions in Excel and
  26. shows how to use them efficiently. The course begins with tips and
  27. keyboard shortcuts to accelerate the way you work with formulas within one
  28. or multiple worksheets. Dennis then covers how to perform logical tests
  29. with the IF, AND, OR, and NOT functions; search and retrieve data with
  30. lookup functions (VLOOKUP, MATCH, and INDEX); analyze data with
  31. statistical functions; use text functions to clean up worksheets; work
  32. with array formulas and functions, and master date and time calculations.
  33. Dennis focuses on practical examples that transition effortlessly to
  34. real-world scenarios. Start watching to take advantage of the tremendous
  35. power offered by Excel formulas and functions.
  36. Topics include:
  37. * Understanding how the hierarchy of operators affects formula results
  38. * Knowing when to use absolute vs. relative references
  39. * Using Formula Builder for unfamiliar functions
  40. * Displaying a worksheet's formulas and highlighting formula cells
  41. * Converting formulas to values
  42. * Creating 3D formulas to gather data from multiple sheets
  43. * Creating and expanding nested IF functions; using AND, OR, and NOT with
  44. IF
  45. * Looking up information with VLOOKUP, HLOOKUP, MATCH, and INDEX
  46. * Analyzing data with the statistical functions: MEDIAN, MODE, etc.
  47. * Using the power functions: COUNTIF, SUMIF, COUNTIFS, AVERAGEIFS, and more
  48. * Calculating financial data such as payments
  49. * Performing basic math
  50. * Calculating dates and times
  51. * Editing text with functions
  52. * Using array formulas and functions
  53. * Referencing data in other cells and files
  54. * Extracting information from Excel worksheets
  55. Subjects: Business, Spreadsheets, Excel for Mac, Office, Office 365
  56. Author: Dennis Taylor
  57. Level: Intermediate
  58. Duration: 6h 52m
  59. Released: 5/26/2016