->
Lynda - Financial Analysis: Analyzing the Top Line with Excel - 173209
Lynda - Financial Analysis: Analyzing the Top Line with Excel
Learn how to analyze the top line (or revenue) of your company and identify areas of under- or overperformance with Excel. Author Rudolph Rosenberg explores essential financial concepts that are necessary to understanding your company's revenue data. Then he introduces the tools and techniques you can use in Excel, including PivotTables and the invaluable SUMIF function, to prepare and analyze the data you have available. Plus, learn how to analyze your customer base, determine revenue per product, and identify upsell opportunities. Rudolph will also show how to make sure you're treating your data fairly, by considering the impact of seasonality, recurrent vs. one-off business, and interdependencies.


Table of Contents

  • Introduction
  • 1. Preparing Your Revenue Information
  • 2. Past Performance
  • 3. Customer Information
  • 4. Product Information
  • 5. Exceptional Revenue
  • 6. Other Considerations
  • Conclusion
  • Lynda - Financial Analysis: Analyzing the Top Line with Excel


     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