Excel 2016: Introduction to Formulas and Functions
This post was published 7 years ago. Download links are most likely obsolete. If that's the case, try asking the uploader to re-upload.
Size: 365 MB | Duration: 2 hours and 58 minutes | Video: AVC (.mp4) 1280x720 | Audio: AAC 48KHz 2ch
Genre: eLearning | Level: Beginner | Language: English
Starting to build a spreadsheet from a blank worksheet is less intimidating if you are familiar with functions and how to create formulas in Excel.
* 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
Screenshots
Quick check before we show the links
Helps us keep automated scrapers from hammering the filehosts.