Microsoft
Office remains king of the office world, from simple memos to
multi-page spreadsheets. Like anyone familiar with a computer,
PC or Mac, I know my way around these programs so well that when
I am reworking raw files from a client's web pages or an ancient
third-party inventory program it is not word-processing, it is
word-pureeing. Here are a few of the more practical examples of
my work:
|
|
|
Part of my responsibilities at Tilton Equipment included providing prompt, polite and accurate replies to inquiries which are e-mailed in through our online portals. Most are simple dealer location inquiries, but some require additional information concerning manuals, gas/oil mix ratios, and specials.
As a result, I composed a series of common replies that permits me to quickly reply to the majority of these questions.
Click to see examples
|
Packing List / Cover Letter Correspondence
|
|
I have a great deal of experience handling mass mailings via the U.S. Postal Service, and UPS Shipments to the Tilton Warehouse in Indiana, sales representatives and dealers in Tilton Equipment's national network.
Then there are special projects, such as this packing list that was included with a 13 pound, 1,000+ page proof of performance package I was in charge of assembling and sending to Jonsered's new corporate advertising agency, which explains how the contents are arranged, to ensure that Tilton Equipment will be fully reimbursed for their promotional campaign for Jonsered Power Equipment.
Click to see example
|
|
|
Tilton Equipment Company permits dealers to do their own advertising in return for co-op credits, provided it is done according to the policy letter. One of my duties was to review those advertisements to make sure they were acceptable, log the co-op credit due in Excel and in a ledger, file the documentation, and when neccessary, send a dealer a Co-Op Requirements Reminder letter.
This is a standard letter I composed, which would be modified as needed and a copy would be sent to the dealer, their sales representative, kept with their co-op application papers, and one in a dedicated binder for easy access in the event the dealer called up asking why they did not get the full amount of co-op requested. In those rare cases, I had to calm down the dealer and explain the situation to them to their satisfaction.
Click to see example
|
|
|
The key to any office is to remain organized. But how to demonstrate it?
Here's an example of how I have been setting up a dedicated hard drive for photography on my home iMac computer for years, a system in this case that sorts by time, topic and area, in this case showing a photo of myself at Corfe Castle, England. This was during a trip I took in the spring of 2012, when I took over 4,000 shots in twelve days - and sorted them in short order on my return. Mac OS has color coding to help label noteable photos (red and orange) and poor photos (green and blue).
Whether it is a PC or a Mac, paper or digital, you will find I do my all to keep things organized.
Click
to see example |
Co-Op
Application Form done in Excel
|
|
Tilton Equipment offers co-op credits for dealers who advertise,
on the condition that they provide proof, and fill out this form.
The original file was lost, so I reset it in Microsoft Excel.
It is available for dealers to download from the dealer website
as either a .pdf file for manual entry, or as a spreadsheet file
with preset formulas that may be opened in Excel or Openoffice
to further assist tech-savvy dealers.
Click
to see example |
Fax
Mail Merge Letter done in MS Word and Excel
|
|
Tilton Equipment maintains a mass e-mail list with Constant Contact for dealers who
are interested in special deals. As with any e-mail list, there
are a certain number of bounces due to bad e-mail name entry,
change of names, and other factors.
When this happens, a spreadsheet
is prepared with the dealer information, and mail merged with
this form letter I created. Two attempts are made to fax this,
then it is mailed out to the dealer to get their correct address.
Click
to see example |
Order
Form set up in MS Word
|
|
This is a special display order form used by sales representitves
who are setting dealers up with special display units for Jonsered
Power Equipment. It was set up in MS Word using tables, and was
designed to be easily sent by fax from the dealership to our office
to place the order.
Personally, I have taken orders from dealers, and made arrangements to have unique promotional items such as illuminated signs with their imprint
Click
to see example |
|
|
Of course I can do Powerpoint presentations as needed.
This example was one of a series sent out to dealers as part of their advertising kit CD-ROM that could be quietly run as a sort of screen saver on their store PC, highlighting the key points of A/R Pressure Pump technology.
Click to download example |