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:
Formula
Formula errors
Function
Funding
FVSCHEDULE
Golden rules
Grouping
Growth
Hiding
HLOOKUP
Hurdle rate
Hyperlinks
Icon sets
IF
IFERROR
In-cell comments ...
Get Using Excel for Business Analysis: A Guide to Financial Modelling Fundamentals, + Website now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
