[show less]

• Updated their existing Excel Reports to ensure a standard layout and presentation incorporating their company design standards
• Modified tables and graphs for enhanced readability and to best represent company performance
• Created a menu driven system to simplify use of the model and to give the user greater control
• Added User Parameters to rapidly update variable information
• Automated the import of their ERP financial reports with validation of data and formats
• Automated the summarisation of data required for the report
• Automated the update of all tables and graphs
• Automated production of the Table of Contents and Printing (printer or PDF)
• Locked model reduces the risk of unplanned changes
• Eliminates many hours of work and accelerates production of the report
• Ensures accuracy of data entry
• Error checking and cross-checking to ensure data accuracy and consistency
• Provides fast and efficient updates if financial results are modified
• Includes training videos demonstrating use of the model
• This model was built in Excel using VBA to Automate repetitive functions

[show less]

[show less]

• Read in multiple lists of assets
• Converted each list into a standard format
• Combined the data into a single table with over 700,000 rows
• Automated the analysis of each line to identify asset number, type and location
• Cross checked the Asset number against a master list to identify anomalies
• Produced a summary of assets by type and location
• Eliminated months of work
• Provided a single updated asset register with all required information
• This model was built in Excel using VBA to Automate repetitive functions

[show less]

[show less]

• Created an Excel pricing model
• Incorporated product search function to speed up product selection
• Automated optional extras where applicable
• Standardised complex pricing calculations
• Produced Order summary for review
• Uploaded Order automatically to Invoicing system
• Created a menu driven system to simplify use of the model and to give the user greater control
• Reduced time to produce a quote
• Reduced staff training required
• Eliminated keying of data into Invoicing system
• More accurate quoting
• This pricing model was built in Excel using VBA and Python to Automate API calls

[show less]