Lynda - Excel 2016: Introduction to Formulas and FunctionsSize: 365 MB | Duration: 2h 58m...
Topics include:
* 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...