▄▄▄ ▄▄▄
█████▄ ▄▄▄ ▄█████
▄▄▄▄ ▀█████ ▄▄█▓█████▄▄ █████ ▄▄▄ ▄▄▄▄
▄██████████▄████▓ █████████████ ████ ▄█████ ██████
███▓▀▀▀▀█████▓████ █████▀ ▀████▓ ▓███ ▄██▄ █████▓ ▓██████
░▓███▄ ▄████ ████ █████▓ ▓█████▓███ ████ ██████▄ ▄██████▓
████████████▀ ████ █████ █████████ ████▄██▄███████▄███▀████▓
▀███▄ ▄▄▄ ▄████▀ ▓████ █████████ ████████▓███ ▀██▓▀ ████
▀███▄████▄█████ ██████ ████▓█████▄▓████ ▀▀ ████ ▀ ████
▄████▄ ▀▀████████▓ ███████ ▓▓██▀███▀ ▀██████▄██▄ ███ ████
█████████ ▀█▓▀ █████▄▄ ░▓███████▄▄▄████▄██▓ ▀████████████ ████
██████████▄ ▄▄ ▀▀█████▄▄▓████▀███████▀▄███ ▄▄ ████████████ ▓▄▄▄▄ ████▓░
▓█████████████▓▓█▄▄ ▀▀▓▓█████▓░ ▀▀▀ ▄ ▀████▄ ▀██ ████████████ ████▀ ▄███▓
▀███▓▓▓█████████████▄▄▄ ▀▀███▀ ▄███████▄ ▀▀███▄ ▓ ███▓███▓████ ▓█▀ ▄███▀▀
▀▀▀ ▀▀▀▓▓███▄▄▄▄▄███████▀▀▀▀▓ ▀▀ ███▓ ▀▀ ████ ▀ ▀▓▓█▄▄
▀▀▀▀▀▀ ▀▀ ▀██▀ ▀▀▀▀▀
RELEASE NAME....: Lynda.com.Financial.Analysis.Analyzing.the.Bottom.Line.with.Excel-ELOHiM
RELEASE DATE....: 2014-08-04
RELEASE SIZE....: 15x15Mb
FORMAT..........: Bookware
LANGUAGE........: English
URL.............: http://www.lynda.com
Learn how to analyze the bottom line (or profitability) of your company
and identify areas of under- or overperformance with Excel. Rudolph
Rosenberg, author of the Financial Analysis series, shows how to use the
data your company generates every day to break down your gross margin and
operating expenses. He introduces the tools and techniques you can use in
Excel to prepare and analyze that data, including PivotTables and the
invaluable SUMIF function. Plus, you'll learn to identify and analyze
sales and marketing spending, staff expenditures, and productivity
separately, so you can get a really clear picture of your data from
multiple angles.
Want to learn more about financial analysis? Check out Financial Analysis:
Introduction to Business Performance Analysis and Financial Analysis:
Analyzing the Top Line with Excel.
Topics include:
* Finding data points
* Prepping data
* Calculating standard cost and gross margins
* Analyzing overall gross margin performance
* Analyzing individual and overall expenses
Author: Rudolph Rosenberg
Subject: Business, Data Analysis, Spreadsheets
Software: Excel 2007, 2010, 2013
Level: Intermediate
Duration: 1h 32m
Released: Aug 04, 2014