I have an advanced skill set with Microsoft Excel in real world corporate environments. Twenty years’ experience using this program and developing numerous advanced formulas, techniques and tools. SQL, VB and advanced Macro’s can be used to produce seamless experiences for end users.
Critically, end user reports and tools are designed with one rule in mind:
The end user may have little or no Excel experience. Therefore usability, form and function in the design is paramount.
In relation to optimisation, I have vast experience in finding ways to reduce the footprint and performance impact excel can have. With many methods available to increase calculation performance and reduce file size of a spreadsheet.
The following options can also be incorporated:
Specific screen ratio/resolutions and printing formats can be incorporated.
Securing the sheet to minimise breaking formulas while keeping it usable to all users.
User level access - showing and hiding specific areas based on a user credentials when the file is opened.
Sheet optimisation and formula optimisation.
Error checking and flagging (designed to make the sheet more user friendly while informing an end user of common mistakes).
I am Australian, based out of Mandurah WA. Please contact me if you have any questions or wish to discuss.