Index
A
- Absolute referencing
- Access (Microsoft)
- ActiveX controls
- Add-ins
- Aggregation functions
- Alignment
- Amortisation schedule
- Ampersand
- Analysis ToolPak
- AND
- Area chart
- Array formulas
- Assumptions documentation
- Assumptions layout
- Audit tool
- AVERAGE
- AVERAGEIFS
- Axes
B
- Balanced scorecard
- Bar chart
- Benchmarking
- Best practice
- Binary code
- Boolean logic
- Break-even analysis
- Break-even point
- Bubble chart
- Bulletproofing
- Business case
C
- Cell link
- Cell referencing
- Charts
- Chart type
- Check boxes
- CHOOSE
- Circular reference
- Colour coding
- Colour scales
- Column chart
- Combination charts
- Combo box drop-down
- Communication
- Compounding
- CONCATENATE
- Conditional formatting
- Control key
- Cost of capital
- COUNT
- COUNTIF
- COUNTIFS
- Cover sheet
- CSE formulas
- Cumulative totals
- Currency symbols
- Custom formatting
D
- 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
- #DIV/0!
- Donut charts
- Double declining balance method
- Drop-down boxes
E
- Edit links
- EFFECT
- Effective rates
- Enter key
- EOMONTH
- Equity
- Error checks
- Excel 2003 (Microsoft)
- Excel 2007 (Microsoft)
- Excel 2010 (Microsoft)
- Excel (Microsoft) versions
- Exponential operations
F
- F9
- File size
- File structure
- Filter
- Financial functions
- Fixed declining balance method
- Fixed interest rate
- Font
- Footnoting
- Format control
- Formatting
- Formatting: basic
- Formatting: custom
- Form control ...
Get Using Excel for Business Analysis: A Guide to Financial Modelling Fundamentals, Edition Revised for Excel 2013 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.
