->
Lynda - Excel 2016: Introduction to Formulas and Functions - 576587
Lynda - Excel 2016: Introduction to Formulas and Functions
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.


Table of Contents

  • Introduction
  • 1. Introducing Excel 2016 Functions and Formulas
  • 2. Creating Basic Summary Formulas
  • 3. Managing Named Ranges and Excel Tables
  • 4. Importing, Exporting, and Validating Data
  • 5. Auditing Worksheet Formulas
  • 6. Performing What-If Analysis
  • Conclusion
  • 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.


     Coktum   |  

    Information
    Members of Guests cannot leave comments.




    rss