->
Lynda - Excel: Tracking Data Easily and Efficiently - 681084
Lynda - Excel: Tracking Data Easily and Efficiently
Learn how to build a super-charged Excel spreadsheet to help you and your team easily track any kind of data-sales transactions, inventory levels, project statuses, employee paid time off, student progress, household spending, and more. Follow along with Excel MVP Oz du Soleil as he shows how to create a basic spreadsheet and transform it into an effective tracking system for any kind of data that is regularly updated. Learn spreadsheet basics, as well as more advanced techniques such as writing formulas that check that information is complete, protecting and hiding sheets, and creating alerts for deadlines and bad data. Oz wraps up with a challenge that pulls together everything you've learned into a polished final project.


Table of Contents

  • Introduction
  • 1. Intro to Tracking Data
  • 2. Planning Your Data Tracker
  • 3. Tracker Structures
  • 4. Protecting Your Work, Sections, and Calculations
  • 5. Adjusting Inputs and Calculations
  • 6. Pretty It Up!
  • 7. Putting It All Together
  • Lynda - Excel: Tracking Data Easily and Efficiently


     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