Size: 365 MB | Duration: 2h 58m | Video: AVC (.mp4) 1280x720 15&30fps | Audio: AAC 48KHz 2ch
Genre: eLearning | Level: Beginner | Language: English
Topics include: More info - https://www.lynda.com/tutorial/576587
* Using operators
* Use cell references in formulas
* Formulas: SUM, AVERAGE, MIN, MAX, MEDIAN, and MODE
* Counting cells
* Summarizing cells conditionally
* Rounding cell values up and down
* Working with list data
* Finding data using VLOOKUP formulas
* Connecting to an external data source
* Cleaning up imported data
* Validating data using rules
* Tracing precedents and dependents
* Identifying errors
* Finding target values using Goal Seek
TO MAC USERS: If RAR password doesn't work, use this archive program:
RAR Expander 0.8.5 Beta 4 and extract password protected files without error.
TO WIN USERS: If RAR password doesn't work, use this archive program:
Latest Winrar and extract password protected files without error.