July 2012
Beginner
320 pages
9h 29m
English
book
Using Excel for Business Analysis: A Guide to Financial Modelling Fundamentals, + Website
by Danielle Stein Fairhurst
Content preview from Using Excel for Business Analysis: A Guide to Financial Modelling Fundamentals, + WebsiteBecome an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
Index
Absolute referencing
ActiveX controls
Add-ins
Aggregation functions
Alignment
Amortisation schedule
Ampersand
Analysis ToolPak
AND
Area chart
Array formulas
Assumptions documentation
Assumptions layout
Audit tool
AVERAGEIFS
AVERAGE
Axes
Balanced scorecard
Bar chart
Benchmarking
Best practice
Binary code
Boolean logic
Break-even analysis
Break-even point
Bubble chart
Budgeting & Forecasting in Excel (course)
Bulletproofing
Business case
Cell link
Cell referencing
Charts
Chart type
Checkboxes
CHOOSE
Circular reference
Colour coding
Colour scales
Column chart
Combo box drop-down
Communication
Compounding
Conditional formatting
Control key
Cost of capital
COUNT
COUNTIF
COUNTIFS
Cover sheet
CSE formulas
Currency symbols
Custom formatting
Dashboard
Data bars
Data collection
Data tables
Data validation
Data validation drop-down
Data validation input messages
Dates
DAY
DB
DDB
Debt
Declining balance value methods
Depreciation methods
Design skills
Developer tab
Discount rate
Double declining balance method
Drop-down boxes
EFFECT
Effective rates
Enter key
EOMONTH
Equity
Error checks
Excel versions
Excel 2003
Excel 2007
Excel 2010
Exponential operations
F9
File structure
Filter
Financial functions
Fixed declining balance method
Fixed interest rate
Flag
Font
Footnoting
Form control
Format control
Formatting
Formatting:
basic
custom
Formula
Formula errors
Function
Funding
FVSCHEDULE
Golden rules
Grouping
Growth
Hiding
HLOOKUP
Hurdle rate
Hyperlinks
Icon sets
IF
IFERROR
In-cell comments ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access
More than 5,000 organizations count on O’Reilly
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.Julian F.
I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.Addison B.
I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.Amir M.
I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.