O'Reilly logo

Using Excel for Business Analysis: A Guide to Financial Modelling Fundamentals, + Website by Danielle Stein Fairhurst

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required