Services

We offer a variety of solutions custom-tailored to suit your specific business needs. Take a look at the examples below for an idea of the functionality that can be built into a custom Excel solution. You can download these generic examples and test them as you see fit. Make sure to select "Enable Macros" (don't worry, the files are safe) when given the prompt to do so.

For some specific examples of AEO's prior work, click here.

For information on corporate training, click here.

Present Information in an Intuitive and Interactive Way

This example demonstrates how Excel can be used to quickly and easily present important information about business performance.

Automatically Parse Disorganized Information

This example demonstrates how a cleverly designed macro can be used to separate lumped-together information into appropriate rows for easy organization or transfer to a database.

Sometimes a large amount of unstandardized data has to be checked for errors. A macro or custom function can often be created to automate the process and reduce the workload significantly. Note that you have to install the custom function as an add-in (the .xlam file) for the example to work properly.

Automate Data QC Processes
  • LinkedIn Classic

© 2013 by Advanced Excel Optimization
EXCEL is a registered trademark of the Microsoft Corporation. Advanced Excel Optimization is not sponsored by nor affiliated in any way with the Microsoft Corporation.

EXCEL is a registered trademark of the Microsoft Corporation. Excel Rain Man is not sponsored by nor affiliated in any way with the Microsoft Corporation. - See more at: http://www.excelrainman.com/index.php#sthash.MShWtkmF.dpuf