Quick Links
Home
. . Introduction
. . Why Business Functions
. . Whats New
. . For Property People
. . . . Why For Property
. . . . PCS Seminar
. . Why Free
. . Awards
. . Key Users
. . Forum
. . Excel 12
Products
. . Overview
. . Business Functions
. . . . Summary
. . . . Function Selector
. . . . Function Finder
. . . . Trace
. . . . Help
. . . . Function Examples
. . . . Tutorials
. . . . Monte Carlo
. . . . GoalSeek
. . . . Utilities
. . . . Callable from VBA
. . . . Array Functions
. . . . CashFlow Administrator
. . . . Select Function
. . . . Number Formats
. . . . Functions Overview
. . CashFlow Administrator
. . SelectFunction
. . NumberFormats
Services
. . Services Overview
. . Bespoke Model Development
. . Implementation Assistance
. . Custom Editions
Download
Reference
. . Function Categories
. . Function Families
. . Data Types
. . Variables
. . Topics
. . Features
. . Version History
. . Technical
Forum
Templates
. . Templates Home
. . Loans
. . Interest Rates
. . Finance
. . Budgeting
. . Math and Stats
. . Dates
. . Accounting
. . Real Estate
. . Real Estate (UK Specific)
. . Petroleum Economics
. . Techniques
. . Non Business Functions
Resources
. . Resources
. . Bookshop
. . Support
. . Tips & Articles
. . . . Tips
. . . . Business Functions
. . . . Excel
Company
. . Company
:: Resources
:: Tips & Articles
:: Excel
Home
Introduction
Why Business Functions
Whats New
For Property People
Why Free
Awards
Key Users
Forum
Excel 12
Products
Overview
Business Functions
CashFlow Administrator
SelectFunction
NumberFormats
Services
Services Overview
Bespoke Model Development
Implementation Assistance
Custom Editions
Download
Reference
Function Categories
Function Families
Data Types
Variables
Topics
Features
Version History
Technical
Forum
Templates
Templates Home
Loans
Interest Rates
Finance
Budgeting
Math and Stats
Dates
Accounting
Real Estate
Real Estate (UK Specific)
Petroleum Economics
Techniques
Non Business Functions
Resources
Resources
Bookshop
Support
Tips & Articles
Forum
Company
Tips & Articles
Tips
Business Functions
Excel
Articles Home
Business Functions
|
Excel
Home
>
Articles
>
Excel
Excel
Accessing External Data
[2]
Using Microsoft Query
Dealing With Actuals
Structure
[5]
Employ Calculation Margins
Use a Globals Sheet
Make the workbook look like the printout
Don't Hide Sheets, Rows or Columns - in fact, don't hide anything
Use Manual Recalculation
Interface
*
Colour Input Cells
Calculation
*
Formulas
[15]
Cell Referencing
[4]
Don't use range context formulae
Don't use named formula (But know they are there)
Don't use Excel's R1C1 notation (But know it's there)
Relative Row and Column Ranges
Understand Array Formula
Understand what a date is
Don't be afraid of Array Formulae
Understand Excels error messages
Use range names
Make best use of Dollaring
How to make timebase-consistent formulae
Are the Arguments Against Array Formulas Valid?
Formatting
[4]
Understand Number Formatting
Use Data Validation to improve useability
Get to know Excels Number Format Syntax
Excel's Function Library
[6]
Get to know Excel's date function
Use INDIRECT for common formulae
Don't do megaformulae
Excel Charts
[3]
VBA
[5]
Consider Returning Arrays From Custom Functions
Avoid VBA If Possible
More Information
[6]
Blogs
Tutorial Sites
Tips Sites
Excel forums on the web
Special Techniques
[3]
Establishing if You have a Corrupt Workbook
About the Camera Control
Excel's Non-Contiguous Ranges
Industries
[6]
Property
[5]
Having an Excel Property Model work with a database
A General Structure
Do Some Property Modellers Ignore Partial Periods?
The Upcoming Excel 12
331
