->

Lynda - Excel 2016: Introduction to Formulas and Functions
Size: 365 MB | Duration: 2h 58m | Video: AVC (.mp4) 1280x720 15&30fps | 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. This course covers creating formulas, managing named ranges and tables, importing, exporting, validating data, and more. Learn how to maintain the integrity of your original data, audit your formulas for correctness, and adjust values to be able to calculate how to reach outcome goals.


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 rules
* Tracing precedents and dependents
* Identifying errors
* Finding target values using Goal Seek

 

More info - https://www.lynda.com/tutorial/576587

 

Lynda - Excel 2016: Introduction to Formulas and Functions


 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.


 Gamystyle   |  

Information
Members of Guests cannot leave comments.




rss