->
Lynda - Excel 2007: Introduction to Formulas and Functions - 56970
Lynda - Excel 2007: Introduction to Formulas and Functions
Excel 2007: Introduction to Formulas and Functions shows how to build impressive spreadsheets with the application's built-in capabilities. Excel expert and Microsoft Most Valuable Professional Curt Frye shares his vast knowledge of Excel, demonstrating how to build various arithmetic and statistical analysis formulas. Curt explains how to summarize values in sets of cells, create conditional formulas using IF and other related functions, and use validation rules to make data entry more accurate. He even teaches how to search for data within a list or table using the VLOOKUP and HLOOKUP functions. Exercise files accompany this course.


Table of Contents

  • Introduction
  • 1. Introducing Excel 2007 Functions and Formulas
  • 2. Creating Basic Summary Formulas
  • 3. Sorting and Filtering PivotTable Data
  • 4. Preparing Data for Analysis in Excel
  • 5. Auditing Worksheet Formulas
  • 6. Performing What-If Analysis
  • Conclusion
  • Lynda - Excel 2007: 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