Week 17: tools to improve work place productivity
MACROs
To improve the processes in sales I created some Macros in Microsoft Excel and Publisher.
This is the approximate process in the sales department:
- call customer and agree to a product price proposal
- Enter data into SalesForce
- Enter some of the same data into Microsoft Excel
- Create new folders on company network
- Enter some of the same data into Microsoft Publisher
- Create a pdf of proposal to send to the customer through SalesForce
The macros also automatically set up the new folder structure and save the completed files into the folders. This reduced the processing time from about 45 minutes per customer proposal to 10 minutes.
RatchetSoft
Ideally I would also like the fields to auto complete across applications. So data entered into Salesforce automatically went into Excel and Publisher. And just the weekend I found a new product offering which enables this to happen without manual copying and pasting: the data only needs to be entered once by the Sales team. The product is by RatchetSoft (see www.ratchetsoft.com) . This product allows tedious tasks to be completed easily by software, without needing to learn to code or change anything about the products you are working with.
Google Notebook
Another good way to improve productivity when researching is to use google notebook, the notebooks can be shared between numerous other people and everyone can work on it at the same time. This is useful when the boss asks for some research.
EFAX
This service was being used by Netchemia when I arrived, it allows faxs to be sent to the company as email and pdf documents. This saves a great deal of paper and allows the right person to recieve the fax much more efficiently. See www.efax.com for more information.
Printing Documents
To save paper in the office you can change the default printing options for most printers to print on both sides. This halves the paper bill and saves the environment.
This is what i've found useful in the office so far.
Labels: internship, Netchemia






