->
Lynda - Excel 2016 for the Mac: Managing and Analyzing Data - 688533
Lynda - Excel 2016 for the Mac: Managing and Analyzing Data
Large amounts of data can become unmanageable fast. But with the data management and analysis features in Excel 2016, you can keep the largest spreadsheets under control. In this course, Dennis Taylor shares easy-to-use commands, features, and functions for maintaining large lists of data in Excel. He covers sorting, adding subtotals, filtering, eliminating duplicate data, and using the program's Advanced Filter feature and specialized database functions to isolate and analyze data. With these techniques, you'll be able to extract the most important information from your data, in the shortest amount of time.


Table of Contents

  • Introduction
  • 1. Sorting Data
  • 2. Filtering Data
  • 3. Advanced Filter
  • 4. Creating Automatic Subtotals in Sorted Lists
  • 5. Eliminating Duplicate Data
  • 6. Data Analysis Tools
  • Conclusion
  • Lynda - Excel 2016 for the Mac: Managing and Analyzing Data


     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