Log In
Or create an account ->
Imperial Library
Home
About
News
Upload
Forum
Help
Login/SignUp
Index
Cover
Chapter 0: Introduction
Chapter 1: Key Excel Functions
1.1: SUM
1.2: IF
1.3: IFERROR
1.4: SUMIF
1.5: SUMIFS
1.6: SUMPRODUCT
1.7: VLOOKUP / HLOOKUP
1.8: LOOKUP
1.9: INDEX and MATCH
1.10: CHOOSE
1.11: OFFSET
1.13: EOMONTH and EDATE
1.14: MAX and MIN
Chapter 2: Key Excel Functionalities
2.1: Absolute Referencing
2.2: Number formatting
2.3: Styles
2.4: Conditional Formatting
2.5: Range Names
2.6: Data Validation
2.7: Data Tables
2.8: Goal Seek and Solver
2.9: Hyperlinks
Chapter 3: Best Practice Methodology
Chapter 4: Layout Tips
Chapter 5: Time Series Analysis
Chapter 6: Error Checks
Chapter 7: Model Template Example
Chapter 8: Financial Statement Theory
Chapter 9: Control Accounts
Chapter 10: Example Model Build
10.1: Initial Structure
10.2: Adding Sheets
10.3: Creating the Financial Statements
10.4: Linking the Financial Statement Worksheets
10.5: Revenue
10.6: Costs of Goods Sold
10.7: Operating Expenditure
10.8: Capital Expenditure
10.9: Debt
10.10: Taxation
10.11: Equity
10.12: Single Entry Accounting
10.13: Opening Balance Sheet Revisited
10.14: Indirect Cash Flow Extract
10.15: Case Study Wrap-up
Chapter 11: Self Review
Chapter 12: Ratio Analysis
Appendix
Index
← Prev
Back
Next →
← Prev
Back
Next →