“A model should be as simple as possible but not simpler” – Albert Einstein
MICROSOFT EXCEL SPECIALIST
Andy Scott
Thanks for visiting my website. I am a professional consultant, specialising in Microsoft Excel, with over 30 years of industry experience. I'm based in the village of Oakhill, near Bath. I'll help you with a spreadsheet solution that will improve your productivity and save you money. Whether you need just a few hours of hands-on training or the development of a complex bespoke model, I'm here to help.
Take a look around and see what I can do for you today.
ANDY SCOTT
Background information
I have a master's degree in engineering from Cambridge University and worked for a major international oil company for over 30 years in the UK, Norway and the Middle East. I was a petroleum engineer for most of my career and carried out numerous technical and economic studies. I led technical teams and worked with finance and engineering professionals and senior management. I have always had a passion for business modelling with Excel and was recognised as a company expert in this area.
My experience in model building can improve the efficiency of your business.
Get in touch with me today for a free consultation.
Excel Expertise
HOW I CAN HELP YOU
BESPOKE DEVELOPMENT
Data analysis and reporting.
Financial and economic analysis.
Business plans, budgets and cashflow forecasting.
Dashboards and KPIs.
Invoice templates.
Timesheets and payroll.
AUTOMATION
Macros to automate data entry from different sources.
Export of data in different formats e.g. CSV, PowerPoint, Word and PDF files
Optimised VBA code to perform complex calculations.
DATA ANALYSIS
Construction of complex models to handle large amounts of data.
Pivot tables to easily analyse large datasets with several hundred thousand rows.
Advanced visualisation and charting techniques.
Statistical and mathematical analyses.
MODEL REDESIGN
If your model has grown too large and unwieldy it could benefit from a top-to-bottom redesign.
Reduction in model size.
Improved model calculation time.
Redesigned input, calculation and results sections with a common look and feel.
Easier-to-understand formulas and calculation methodologies.
Better visualisation with great looking charts and tables.
MS OFFICE INTEGRATION
Integrate your Excel spreadsheet with other Microsoft Office applications.
Automatically export spreadsheet data and charts to PowerPoint.
Create Word documents from Excel.
Create Outlook calendar entries from Excel.
TRAINING
-
Bespoke on-site courses for any level from beginner to advanced.
-
Individual coaching or group training.
-
Course durations from just a few hours to several days.
-
Hands-on training with your own models and datasets.
-
Any topic e.g. spreadsheet design, functions, charts, pivot tables, formatting, macros.
