| EXCEL: THE BEST TOOL FOR SMALL AND
| |
| | approached us asking for a simplified
|
| MEDIUM SIZED BUSINESSES!
| |
| | label-printing solution. At the time,
|
| Excel is used all over the world for a
| |
| | they used a combination of Excel and
|
| wide range of applications, from simple
| |
| | Word and plenty of manual work to first
|
| calculations, to complicated industrial
| |
| | remove duplicate addresses and then
|
| spreadsheets. Of course, its most
| |
| | print the labels.
|
| common use is in accounting or financial
| |
| | We suggested a solution implemented in
|
| departments, but how many of us really
| |
| | Excel 2007 version which only requires
|
| know that Excel can help almost all
| |
| | pasting the addresses in a specific
|
| departments in a modern company?
| |
| | worksheet of Excel. We used our enhanced
|
| CASE 1: Automated website updating?One of
| |
| | duplicate removing algorithm to "clean"
|
| our customers had the following problem:
| |
| | the data and then created an advanced
|
| he had one of his employees assigned to
| |
| | VBA macro that prints the addresses using
|
| update the company's website everyday
| |
| | the customer's specified label
|
| with new values. The website offers
| |
| | dimensions. The user also has the ability
|
| information services to visitors and
| |
| | to choose whether they want the
|
| potential customers. So, each day, the
| |
| | printing done in one batch or in small
|
| employee had to gather information from
| |
| | packages in case they want better control
|
| other sites, process this information
| |
| | of the printing procedure.
|
| and update the website using an updating
| |
| | There is no end on this list of tasks
|
| system their outsource web creator had
| |
| | inside a company that Excel can improve:
|
| done. This system used SQL Server
| |
| | Almost all departments of an
|
| database to update the site, but the
| |
| | organization can take advantage of this
|
| creator did not supply an option for
| |
| | powerful tool. Some simple examples:
|
| batch updating. This procedure required
| |
| | Logistics and Inventory can print and
|
| the allocation of almost half of
| |
| | manage barcodes or control stock using
|
| everyday's time for this employee.
| |
| | advanced Excel macros. Marketing can
|
| We suggested a simple solution:
| |
| | manage customer lists and apply simple
|
| 1. Excel connects to external
| |
| | CRM tasks. Information Department can
|
| websites that contain the necessary
| |
| | produce or import ASCII files easily or
|
| information
| |
| | improve EDI transactions. Personnel can
|
| 2. It processes the data and
| |
| | program shifts or use Excel as a
|
| formats using specified guidelines
| |
| | Payroll application. Management can have
|
| 3. It batch updates the database
| |
| | dynamic reporting or decision analysis
|
| 4. Excel automatically closes.
| |
| | tools…
|
| All that is needed by the employee is to
| |
| | WHY CUSTOM EXCEL APPLICATIONS? WHY SHOULD
|
| open the application and wait around 3
| |
| | I PREFER YOUR APPLICATIONS?Because you
|
| minutes until it finishes processing and
| |
| | can have innovative applications with
|
| sending the data. Then, he performs a
| |
| | really affordable prices. Excel is
|
| simple check on the website to ensure
| |
| | usually pre-installed in almost any PC,
|
| that everything is updated correctly. We
| |
| | and in case you will need to buy it, it
|
| installed this solution almost one year
| |
| | costs less than $200.
|
| ago and since then it failed two times.
| |
| | By choosing to use a custom application,
|
| In both cases, there were network
| |
| | you pay only for things you really
|
| problems and the application could not
| |
| | need. On the other hand, with stand-alone
|
| connect to external web sites.
| |
| | applications you pay for a bunch of
|
| You do not need Excel to calculate that
| |
| | extra options that do not fit your needs
|
| this company reduced the required time
| |
| | and you are not interested in.
|
| for this procedure by more than 90%! And
| |
| | Just like cost, the time needed to create
|
| they assigned much more creative and
| |
| | a custom application in Excel is much
|
| efficient tasks to this employee, so
| |
| | less than any stand-alone one. In custom
|
| everyone was happy! Some weeks ago, we
| |
| | Excel applications, you do not need to
|
| received a call from our customer,
| |
| | design and implement an interface, this
|
| explaining that they have fully automated
| |
| | is supplied by Excel itself and users
|
| the procedure: with the help of an
| |
| | are familiar with it.
|
| electrician, they created a method to
| |
| | Our applications are free of licensing
|
| start the pc automatically. Once
| |
| | costs and restrictions. You can use our
|
| started, the pc is set to login, start
| |
| | applications in any workstation with no
|
| our application and shut down with no
| |
| | extra cost. And we use a balanced
|
| human interference at all. Nice stuff!
| |
| | philosophy: Simplicity and
|
| CASE 2: Label printing for mass
| |
| | user-friendliness weights for us as much
|
| mailings.Many companies in our days use
| |
| | as the powerful VBA code we use to make
|
| plenty of techniques to communicate with
| |
| | the application work just like you
|
| their customers. Many of them use the
| |
| | require!
|
| mail to send letters, marketing material
| |
| | Please visit our site to learn more or
|
| or product catalogs. One company that
| |
| | download some of our demos.
|
| sends almost 100.000 catalogs each month
| |
| |
|
