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