Lynda.com - Financial Analysis Analyzing the Top Line with Excel

seeders: 1
leechers: 0
Added on August 7, 2014 by pitsosin Other > Tutorials
Torrent verified.



Lynda.com - Financial Analysis Analyzing the Top Line with Excel (Size: 534.35 MB)
 scraping_data.xlsx8.28 KB
 scraping_data_finish.xlsx8.61 KB
 db_format.xlsx17.36 KB
 SUMIF.xlsx17.36 KB
 sumif_finish.xlsx18.57 KB
 pivot_tables.xlsx17.31 KB
 pivot_tables_finish.xlsx25.71 KB
 Consolidation.xlsx25.69 KB
 consolidation_finish.xlsx29.83 KB
 compare_to_past.xlsx28.91 KB
 compare_to_past_finish.xlsx29.42 KB
 customer_count.xlsx28.91 KB
 customer_count_finish.xlsx29.58 KB
 revenue_per_customer.xlsx29.58 KB
 revenue_per_customer_finish.xlsx30.69 KB
 new_vs_returning_customers.xlsx30.22 KB
 new_vs_returning_customers_finish.xlsx29.4 KB
 revenue_per_product.xlsx19.86 KB
 revenue_per_product_finish.xlsx29.38 KB
 upsell_opportunities.xlsx28.45 KB
 upsell_opportunities_finish.xlsx31.09 KB
 exceptional_business.xlsx28.45 KB
 exceptional_business_finish.xlsx29.68 KB
 00_01-welcome.mp46.73 MB
 00_02-need_to_know.mp46.95 MB
 00_03-ex_files.mp44.01 MB
 01_01-basics.mp410.05 MB
 01_02-data_points.mp416.26 MB
 01_03-assembling.mp416.61 MB
 01_04-prep_data.mp442.27 MB
 01_05-pivot_sumif.mp48.59 MB
 01_06-sumif.mp418.18 MB
 01_07-pivot.mp419.52 MB
 01_08-consolidation.mp450.06 MB
 02_01-seasonality.mp437.96 MB
 02_02-combining.mp423.67 MB
 03_01-customer_info.mp413.51 MB
 03_02-current_cust.mp416.58 MB
 03_03-rev_per_cust.mp430.53 MB
 03_04-new_vs_return.mp438.21 MB
 04_01-prod_info.mp417.56 MB
 04_02-rev_per_prod.mp426.5 MB
 04_03-upsell.mp415.7 MB
 05_01-identifying.mp417.85 MB
 05_02-isolating.mp443.69 MB
 05_03-analyzing.mp424.34 MB
 06_01-dependencies.mp413.89 MB
 06_02-KPIs.mp49.88 MB
 07_01-next_steps.mp44.69 MB


Description

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.

Want to learn more about financial analysis? Check out Financial Analysis: Introduction to Business Performance Analysis and Financial Analysis: Analyzing the Bottom Line with Excel.
Topics include:

Preparing your revenue information
Comparing past performance
Analyzing customer data
Analyzing product information
Identifying exceptional revenue

http://www.lynda.com/Excel-tutorials/Financial-Analysis-Analyzing-Top-Line-Excel/173209-2.html

tags: Business, Data Analysis, Spreadsheets, Excel


files type mp4
total videos time 1h 38m
includes exercise files

Related Torrents

torrent name size seed leech

Sharing Widget


Download torrent
534.35 MB
seeders:1
leechers:0
Lynda.com - Financial Analysis Analyzing the Top Line with Excel