This is a "high-level" question - suited perhaps to people who are used to producing financial reports. (Accountants?)
I am a fairly good Excel user with moderate VBA skills.
I have been asked to develop some financial reports for a couple of clients.
The General ledger account balances will be imported into Excel and from there I will create the reports according to clients specification.
I think most of this is easy. I will used named ranges and sensible formulas.
QUESTION: Are there any tricks of the trade that I should be aware of?
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…