Spreadsheet Experts are waiting to help you!

We can help with Tables, Charts, Formulas, Macros and VBA coding. 

FORMULAS

We can help with advanced and nested formulas

CHARTS

We can create great charts and data driven dashboards

PIVOT TABLES 

We know all about pivot and power pivot tables for big data

DATA CONNECTIONS

We connect you with SQL data or APIs like Shopify 

MACROS / VBA

We can help with programming for ultimate automation

Need Help? 

This is how we work!

We help make your Spreadsheet amazing. Here's how we do it.

1) Just get in touch with us and explain your task.

2) We will give you a free quote and target delivery time. Small jobs will be billed in units starting at just $40.

3) If you wish to proceed then upload or share your xls and once we have payment we will carry out the work with our money-back guarantee.

 

HOW WE WORK

GETTING EXCEL TASK HELP AS EASY AS 1 -2 -3
1
Just get in touch and tell us which task you need help with.

Just let us know your task, big or small we are happy to discuss it with you and work through to the ideal solution for your spreadsheet job. Fill in our task form or request a call and we will get back to you ASAP. We love spreadsheet challenges so no matter what the task, you know we keen to get involved.

2
We give you a no-obligation quote and delivery timeframe.

Once we have your task we will give you a price and time-frame to complete it as well as provide you with any immediate feedback or information we think may help you. We will outline clearly what work we will be doing so you can be sure you are getting the best value for your Money. Fixed priced jobs come with our 100% money back gaurantee.

3

Once you give us the green light its all GO! XLS Experts will complete your task and provide you with the final solution.  Its really that simple. When you need XLS help we are here waiting to assist you. Want to get started just let us know the task and we will get things moving.

Push GO and we deliver a gauranteed solution.

Spreadsheets are often undervalued assets within a business. Most computer users are able to navigate and use Excel and with correct modelling and/or some programming Excel can become an extremely powerful and agile business tool.

 

Many Excel users can produce adequate spreadsheets but can benefit from some helpful expertise. This is where we come in. Assistance with those advanced features when you need it!

 

SIMPLE PRICING FOR ALL SIZED TASKS

 

SMALL TASKS

FROM $40

Small tasks are billed in 30-minute units of $40 each. Need some help on that formula, chart or macro then time-based task pricing makes everything easy to understand and all our work is backed by our 100% money back guarantee 

projects

fixed pricing

For larger tasks/projects we can analyse your requirements, evolve them with you and provide a fixed price and specify deliverables. We can manage all aspects of the project including staff training.

Consulting

hourly billing

For certain projects it may be more suitable to work on an hourly basis. This is accompanied by task estimates and detailed progress reports to ensure task value is visible to the client.

SOME SPREADSHEET EXPERTISE

CASE STUDIES

 

PRICE INCREASE ANALYSIS TOOL

SQL DB Connectivity, VBA, Workbook linking, Dashboard

Recognising the agility of Excel formulas it was decided to analyse price increase policies within Excel as opposed to developing a similar utility within the organisations ERP system.  As such we developed a tool that collected data from the Oracle DB, processed and massaged pricing policies within the data and summarised the impact of pricing scenarios in a dashboard for management. Once finalised the pricing data was returned to Oracle for final processing by the ERP system and published out to several other workbooks .

This project demonstrates Excels excellent ability to act as an agile and rapid development environment that includes data processing and reporting along with its inbuilt spreadsheet functionality. 

PRICE INCREASE ANALYSIS TOOL

SQL DB Connectivity, VBA, Workbook linking, Dashboard

Recognising the agility of Excel formulas it was decided to analyse price increase policies within Excel as opposed to developing a similar utility within the organisations ERP system.  we developed a tool that collected data from the Oracle DB, processed and massaged pricing policies within the data and summarised the impact of pricing scenarios in a dashboard for management. Once finalised the pricing data was returned to Oracle for final processing by the ERP system and published out to several other workbooks .

This project demonstrates Excels excellent ability to act as an agile and rapid development environment that includes data processing and reporting along with its inbuilt spreadsheet functionality. 

RANGE PLANNING AND OPEN TO BUY TOOLS

SQL DB Connectivity, VBA, Workbook linking, Financials

Inheriting a restricted spreadsheet model of many linked workbooks sharing workbook based data we implemented a SQL database backend for Range Planning data and connected the plans directly to the POS / Retail Management software for sales and stock data. This allowed the travelling buyers to use their spreadsheets conveniently whilst sharing data with each other and management. We also carried out extensive formula analysis and optimisation on the Open To Buy plan ensuring accurate management reporting and budgeting.  

This project demonstrates Excels strength as a front end tool for multi-user data-driven applications and its ability to aggregate data from various sources.

E-COMMERCE SITE PRODUCT ADMIN

SQL DB Connectivity, VBA, Outlook Connection

Operating a custom ASP.NET - MS SQL E-commerce site it was more agile to develop product management within Excel than to create complex product admin forms within the app. This allowed for easy use of pricing formulas, product categorisation as well as simple product creation, updating and deletion.  Excel was also used to manage various site admin settings as their necessity was realised. Additionally, site enquiry data such as contact details were automatically processed using a connection to the Outlook Object model.

 

This project demonstrates Excels ability to act as an effective product catalogue administration tool and website admin tool.

CLAIM ANALYSIS REPORTING TOOL

SQL DB Connectivity, VBA, Financials

Collecting claims analysis data from an MS SQL back end we created a set of management dashboards highlighting the data trends. Additionally, the data could then be further analysed by staff due to Excels familiar interface and staff skillsets. 

 

This project demonstrates Excels ability to act as a user familiar analysis tool where doing so within custom software or ERP systems would not be time or cost-effective.

PRODUCT MANAGEMENT SYSTEM

VBA, EDI Formats

This Excel workbook produced product SKU lines from a style and colour product level and then assigned auto-generated barcodes to products. Export formats were then prepared for import into the POS/E-commerce systems. Lookup tables generated for multiple currency functions. Nested lookups created for Category, Subcategory etc.

This project demonstrates Excels ability to use formulas and VBA programming logic to create data sets.

PRODUCT MANAGEMENT SYSTEM

VBA, EDI Formats

This Excel workbook generated product SKU lines from a style and colour product level and then assigned auto-generated barcodes to products. Export formats were then prepared for import into the POS/E-commerce systems. Lookup tables generated for multiple currency functions. Nested lookups created for Category, Subcategory etc.

 

This project demonstrates Excels ability to use combined formulas and VBA programming logic to create data sets.

SHOPIFY SALES & FULLFILLMENTENT TOOL

VBA, Shopify API, Sales Analytics

Selling healthcare products to Americans via Shopify this client required a solution to sales analytics and logistics. Extracting sales from Shopify order shipping, addresses are then formatted for fulfilment and data sent to the logistics provider. Sales are then analysed for trends across multiple marketing channels as well as stock management. Some of these functions can be achieved with Shopify plugins but Excel offers a more powerful formula based approach as well as ease of data massaging using VBA. 

 

This project demonstrates Excels excellent ability to act as a Shopify order management and sales analytics tool that is powerful and familiar to users.

BIG DATA CLIENT DATA ANALYSIS

Power Pivot, Charting, Analytics, VBA, EDI

After receiving granular client data from the clients' data warehouse service we analysed over 30M records. Data was then massaged as required using VBA to best shape the data for use with Pivot Tables using Power Pivot and Charts. Data was presented to the client as Trend summaries and charts.

 

This project demonstrates Excels ability to receive, massage and analyse large Enterprise datasets.

FLEET OPERATING ANALYTICS

Charting, Analytics

After receiving various data feeds from the clients ERP system, other Excel wokbooks and user inputs we aggregated the waste management fleet operational data from > 30 locations. Data was analysed over fleet type, operating time, downtime, fuel costs etc. Data and chart-based reports were produced identifying granular operating costs per vehicle as well as any exceptions to fleet type, route type averages. 

 

This project demonstrates Excels ability to provide powerful table based analysis using formulas alone.

SALES ANALYSIS AND E-COMMERCE ADMIN

Charting, Analytics, VBA

Selling footwear across 100 stores globally, sales data reporting was limited within the ERP system. Excel proved to be a wise choice offering agility with reporting formats and allowing staff to dig deeper into specific datasets. Additionally, Excel was used to manage various processes within the e-commerce site such as switching discounts, price bands and product categories. 

 

This project demonstrates Excels ability to provide users with reports that can then be further manipulated/analysed as required.

HERE ARE A FEW COOL THINGS WE CAN DO IN EXCEL FOR YOU

Communicate with other Office Applications

All Microsoft Office applications have a programmable object model which means we can access their structure from within Excel and manipulate items they contain. For example, we can send emails through Outlook from within Excel without the user leaving the Excel interface. We can also access Outlook Items such as Emails and automatically parse their data into Excel for analysis or use Excel data to create MS Word reports/letter runs.

The possibilities here are endless.

XLS EXPERTS ARE A TEAM OF SKILLED SPREADSHEET TECHS

 

Mike Colwill

PROJECT MANAGER / XLS GURU

With over 20 years experience constructing and programming spreadsheets across a wide variety of business sectors Mike acts as Project Manager / XLS Guru on all projects in order to ensure every project meets our standards

Jason

ADVANCED FORMULAS | CHARTS | REPORTING

Jason is our go-to guy for advanced nested formulas and great looking charts and reports. 

Sitti

GENERAL XLS ALLROUNDER

Sitti is well skilled in all aspects of XLS and helps out the team on tasks wherever she is needed.

Wilder

SENIOR SOLUTION ARCHITECT

With a bachelors in Engineering, a Masters in Computer Engineering, and an MBA, as well as over 10 years of hands-on experience Wilder, is truly an XLS Guru. 

Kay

DATA ANALYSIS | POWER PIVOT | TABLEAU

With strong skills in manual and programmatic data analysis and presentation Kay oversees all work related to B.I tasks

Parker

POWER BI | VBA | SQL 

Parker is an experienced VBA developer and Data Analysts with excellent SQL and Database skills.

HOW CAN WE HELP YOU?

Ready to discuss your Excel or MS Office Automation task with us or simply have a question? Get in touch and we will get back to you ASAP. 

Call us or simply fill in the form below and we can get back to you with more information and/or pricing.
AUS: (02) 8003 4192
NZ : (09) 889 1545  | 021 783 967
USA: (561) 459 2054
Skype: mikecolwill

Tell us about your Task.

What does your your task/enquiry concern? (optional)