How To…

 

HOW TO CREATES EXCEL/DOC/PPT.FILE UPDATES REPORT WITHIN 500 KB FILE SIZE.

 

•Set the font size using 10 or lower with Arial Narrow font type.

•Minimizes insert color on the cells of data.

•Attached pictures/object using : Click Insert ~> click pictures ~> Click from file ~> browse from your file folder. Avoid copy and paste option as much as possible due to it will double the size content.

•Each pictures size suggests to have 15~50kb size file or less for each thumbnails anytime you insert pictures on file.

•How to creates 15kb or less pictures sizes =

-Open pictures using Microsoft Photo Editor.

-Click Image tab ~> click Resize tab ~> set the units on pixel format (right bottom)~> put 150 on width column and let the software calculates the height in auto mode. And then save. This will make the file size to be around 10 to 20kb.

-Another software is using Microsoft Office Pictures manager that you can resize all pictures in folder at once.

•When you finish insert all pictures . Hold the shift button and click all pictures one by one, click right mouse ~> grouping ~> group. If you would like  to copy pictures to another excel file.

•Deleted the unnecessary row.

•Minimizes additional logo/banner/clipboard on pictures. Anyways if you would like to adds any arrow circle/rectangle on pictures, you may insert it using paint/adobe Photoshop software and save it with JPG format. This will create the pictures accessories to be in single file pic file.

•After finish insert all data requires. If the file size above 500kb you need to ZIP the file for better e-mail data transfer.

•Another option is :

1.convert excel/doc/PPT file into PDF file.

2.Optimize PPT file with NXPowerlite software.

3.Optimizes PDF file with Abode PDF Optimizer.

Ways to Lose/Keep Customer 

#	Ways to Lose a Customer	Ways to Keep a customer
1	Threat them as if they are one of many.	Take time to make each customer feel their needs are most important.
2	Say ” I don’t know”.	Say ” I don’t know, but I’ll find out and call you back’”
3	Don’t follow -up after making a commitment	Take time to follow up. If you are going to be late, call them in advance and explain the situation so they don’t have to call you.
4	Tell them ” It’s not my job, you need to call sally”. We call this Cubical Volleyball…	Explain that it isn’t your job, but you will find the right person and have them call them back. Then follow -up to make sure it hasn’t been done.
5	Make sure your voice sounds bored and uninterested. Slouch in your conference chair. Don’t maintain eye contact.	Stay engaged in the conversation. Maintain a body position and eye contact that reflects real interest in the conversation.
6	Blame or Accuse the internal customer	Remember the old motto….” The customer is always right”. Be creative in meeting their needs. While achieving your company’s objectives. Tae criticism on the chin, and stay positive.
7	The words ” You will have to” will alienate any customer.	Take time to explain the reason for the process, and give them available options.
8	let them know you are too busy to help them.	If you are too busy, get additional help for this customer…..but don’t tell your customer you can’t help
9	Make the customer feel inferior	Customer Are the Reason we Exist (CARE). Without customers, there’s no need for my job.
10	Be sure to use a lot of jargon.	Don’t use purchasing expressions like sourcing, demand management, FOB Destination, etc. When explaining a purchasing transaction to a customer.