Excel Consulting - Past Project Examples and
Possible Uses
Excel custom macro programs can be created for a variety of tasks that
are not always obvious. If
you have an excel spreadsheet problem, help could be closer than you think.
If it is something that we have done before, we can probably do it again, maybe
faster.J
Some uses are listed below. MaKro Consulting has created Excel
(XL) spreadsheets and visual basic macro programs
(VBA) that automatically do the tasks listed below:
 | High speed input forms and keyboard methods to maximize
speed of data entry while minimizing input effort. Make it easier on
your worker and hopefully make them happier and more productive. |
| Repair files with the dreaded
Too many
different cell formats problem. |
| High speed estimators- create customer price estimates
for manufactured buildings, print supply requests, leasing, etc based on
specific products (1-10,000) that you are selling. |
| Aliasing program to convert various file types in
non-standard format to a standard format for use in updating online
parts database. Used to reflect current inventory from many different
suppliers. |
| Updating 100s of existing spreadsheets to reflect the
latest version (new equations, union agreement changes, product changes,
VBA code changes or additions, etc) Do it automatically instead of
manually over and over and over again. |
| Rollup 100s of data entry worksheets into a summary
report with a single click. |
| Automatic recommendations and reports based on high speed input questionnaire. |
| Calendar creation to put your calculated time sensitive
events on an easy to read Excel created calendar. |
| Spreadsheets that both READ from WRITE BACK to online
Quickbase databases. |
| Smart spreadsheets that automatically update themselves
from a Quickbase database. |
| Estimating spreadsheets that update themselves
(interest rates, etc.) from a file placed on a web site. |
| Pull down menus for your products that allow quick data retrieval and
lookup. |
| Special excel programs to do special editing, row deletion, formatting,
and searches. |
| High speed data search macro and location within an Excel database. |
| Selective data retrieval from Microsoft Access or other databases. |
| Automatic import of data from Quick Books to XL for special
reports and calculations. |
| Automatic data formatting macro to allow easy export from XL to programs
such as Quick Books |
| Custom excel program to draw and dimension technical products using
database values. |
| Specialized invoices with customized input for different customers,
projects, & properties. |
| Custom data formatting for data transfer between different programs
or spreadsheets |
| Specialized payroll and analysis (with high speed input) for a phone sales force. |
| Enable/Disable protection systematically to prevent worksheet/program
damage. |
| Perform extensive, detailed engineering calculations. |
| Special excel programs to download data, format data, and create Excel databases
from information on the internet. |
| And many more. |
