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?
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…