Financial Analysis: Analyzing the Top Line with Excel
Offered By: LinkedIn Learning
Course Description
Overview
Learn how to analyze the top line (aka revenue) for your company and identify areas of under- or overperformance with Excel.
Syllabus
Introduction
- Welcome
- What you need to know
- Using the exercise files
- The basics of revenue analysis
- Finding the data points
- Assembling the data
- Preparing the data
- Introducing PivotTables and SUMIF
- Using the SUMIF function
- Using PivotTables
- Adding consolidation levels
- Past performance and seasonality
- Comparing to past performance
- Analyzing customer information
- Identifying current customers
- Determining revenue per customer
- New vs. returning customers
- Analyzing product information
- Determining revenue per product
- Determining upsell opportunities
- Identifying recurrent vs. one-off business
- Isolating recurrent vs. one-off business
- Analyzing recurrent vs. one-off business
- Identifying dependencies
- Analyzing further revenue with key performance indicators (KPIs)
- Next steps
Taught by
Rudolph Rosenberg
Related Courses
Effective Problem-Solving and Decision-MakingUniversity of California, Irvine via Coursera Introduction to Metrics for Smart Cities
IEEE via edX The Business of Social
Northwestern University via Coursera Las redes sociales en acción
Tecnológico de Monterrey via Coursera Coaching Practices
University of California, Davis via Coursera