- Microsoft Customer Complaints
- Microsoft Vendor Complaint Template Download
- Microsoft Vendor Complaint Template Excel
- Microsoft Vendors List
- Microsoft Vendor Complaint Template Word
Sample Vendor Complaint Forms - 7+ Free Documents in Word, PDF; Sample Consumer Complaint Forms - 10+ Free Documents in Word. Sample Administrative Complaint Forms. Download Hundreds Databases and Templates for Microsoft Access Software. Free MS Access template samples for small business company, non profit organization and personal student. Access Call Tracking Customer Order Complaint Or Request Database. Access 2013 Templates. Access Templates For Employee And Vendor Project Marketing.
Because Microsoft is committed to promoting a positive work environment, we expect our suppliers and their employees, agents, and subcontractors to adhere to the same standards of conduct and behavior that we expect from our own employees while they are on Microsoft property or doing business with or on behalf of Microsoft. Microsoft Office Templates Microsoft Templates. Sh How To Build A Marketing Report Quickly Free Template Coschedule. Vendor comparison list template at xltemplates.org Free Online Complaint Form Template 123FormBuilder.
Customer Relationship Management (CRM) systems and CRM software can help you increase sales by streamlining communications with your potential and current customers. Online CRM software can help you integrate revenue tracking, sales, and email into an all-in-one system. If you don't need heavy integration and are just looking for a simple way to keep track of leads, then try using a spreadsheet template.
I designed the CRM Excel template below based on the request from a few users and have been updating it since 2013. The spreadsheet is set up as a CRM Database, with a main table for showing the current status of customers and sales. Other tables include a Sales Log, Contact Log and Contact Details.
Download
⤓ ExcelLicense: Private Use (not for distribution or resale)
Microsoft Customer Complaints
'No installation, no macros - just a simple spreadsheet' - by Jon Wittwer
Description
A critical feature of any CRM system is to track communications with customers, plan follow-up contacts, update the lead status, and after gaining a customer, schedule future communication that will help you keep them as a customer. Tracking sales is also an important part of CRM.
The CRM template provides a starting point for people looking for a spreadsheet-based CRM solution. It is designed to be easy to customize.
This template is a set of crm database tables formatted to allow sorting, filtering, and display of important customer information - a much more functional version of the Contact List Template.
The most complex part of the spreadsheet has to do with the conditional formatting used to highlight the dates in the Last Contact and Next Contact columns. I'm a fan of conditional formatting, but if you don't like it or want to change the colors, see the article 'How to Use Conditional Formatting in Excel' to learn how to clear or edit conditional format rules. For more information on using these columns, see below.
How to Use the CRM Template in Excel
Sorting and Filtering: This template is designed around the spreadsheet's built-in Sorting and Filtering features. With a couple clicks on the arrow in the column header, you can do things such as:
- Order the table based on the Estimated Sale value
- Filter out customers from the list where the Lead Status is 'loss' or 'cold'
- Sort the table by Next Contact date so you can make the most urgent contacts first
Demographics - For any contact, you'll want to record their name, company, job title or position, email, phone #, etc. Information that may be nice to know what not necessary to refer to on a day-to-day basis could be saved in the optional Contact Details worksheet (which is just the contact list added to this workbook).
Estimated Sale - For active customers, this might be the average monthly or annual sales figure - something to help you easily see the value of keeping that customer. For potential customers, this could be your estimate of the customer's potential monthly or annual sales.
Last Contact - When you make a contact, you record the date in the Last Contact field. The highlighting will make the cell green if the contact was recent, pink if it has been a long time since that last contact, or yellow for somewhere in between. Use the Settings worksheet to customize the number of days that are used for the basis for when the cell should be green/yellow/pink.
Next Contact - Planning follow-up communication is important, so use this column to record the date for the next contact and use the Next Action column to enter a code that describes what your follow-up action will be.
Notes - There are many ways that you can record notes about communications with your leads. You could add cell comments as shown in the screenshot image above. You can use a Notes column with Wrap Text turned on (though for long notes, that will make the table messy). You can also use the optional Contact Log worksheet, to record notes about each individual communication.
Sales Log - If you want to create monthly or quarterly or annual sales reports, you'll need a way to record individual sales. That could be done using the optional SalesLog worksheet. You could then add a Pivot Table to summarize the data, or create your own Excel dashboard to display important summary data.
Using the Other CRM Tables
Contact Log Table
If you want to use the Contact Log worksheet to record details about every contact you make, then you may want to use a formula in the Last Contact column of the CRM worksheet to automatically lookup the date of the last contact for a person. To do that, you can use a MAX-IF Array Formula like this (remember to press Ctrl+Shift+Enter after entering the formula):
If you are using Google Sheets or the most recent version of Excel, you can use MAXIFS:
Sales Log Table
If you want to use the Sales Log worksheet to record every sale that you make, then you may want to summarize the sales in the CRM worksheet. You could use the AVERAGEIFS or SUMIFS function within the Estimated Sale column to show the average or sum of sales for each person. The formula might look like this:
Contact Details Table
If you use the Contact Details worksheet, you can use a VLOOKUP formula within the CRM worksheet to automatically grab the Phone number and other contact information for each person. See my VLOOKUP article to learn how to create these types of formulas.
Team Members Table
The Google Sheets version is now a collaborative crm database and includes a new Team Members table. You can pick a team member in the Contact Log and Sales Log tables and see a summary of the total sales and total contacts in the Team Members table.
CRM References
- [1] Customer Relationship Management - wikipedia.org - This wikipedia page, although lacking substantive information, opened my eyes to the wide variety of ways that businesses use CRM systems - and thus made me realize I only wanted to create the most basic of templates.
- [2] Create a CRM System Using Google Docs - blog.softwareadvice.com - Most of the initial features I added to the CRM template came from the ideas presented in this blog post.
Related Content
Microsoft Vendor Complaint Template Download
Sometimes the squeaky wheel does get the grease! Use our free letter of complaint template to help you write retail stores or service providers concerning issues you are having with their products or services. This template will help when writing complaint letters to companies to let them know of the issues you are having and to seek their help in resolving the issue. Continue reading below for a free sample complaint letter, tips and links to other resources.
Download
⤓ Word (.docx)⤓ Google DocsOnline Form
Customize a Letter Using RocketLawyer.com
Other Versions
Author: Brent Weight and Jon Wittwer
License: Limited Use
Description
Use our free Complaint Letter Template to help voice your frustrations. Just remember to keep it professional and leave the name calling to 5-year-olds. Use the sample letter below or the other referenced sample complaint letters to help you with ideas for wording for specific situations.
Tips: How to Write a Letter of Complaint
- Keep it factual and neutral – avoid making negative or threatening comments
- Make sure your facts are accurate and detailed
- Be concise and stay on topic
- Use a proper business letter format – See our free Business Letter Template
- Provide as much detail as possible including account numbers, serial numbers and model numbers and the date and location where the item was purchased
- Be careful with providing information about credit card numbers or any other personal information that is not required
- Send copies of any documents you have, do not send the originals
Sample Letter of Complaint
David Jones
123 Anywhere Street
Best Town, Best State 88888
1/1/2010
Mr. Bill Stevenson
President
Rain Gutters R Us
456 Somewhere Road
Best Town, Best State 88888
Dear Mr. Stevenson:
Your company recently installed rain gutters on my house in Country Meadows. We paid $4545 for new gutters on every face of our two-story home. The work took place on 10/2/2009. Attached is a copy of the invoice showing the work was completed and paid in full.
We were very happy with the service we received and your crew was very kind and professional. Unfortunately, during the heavy snow storm we had last week, our new rain gutters on the north side of our house fell off. While I am not an expert, it appears that several of the fasteners where inadvertently left out during installation.
We ask that you send your crews back out to complete the job that was paid for, replacing the gutters that have detached and inspecting the remainder of the gutters for similar issues.
We look forward to hearing back from you in the next several days to confirm when you will be returning. We expect to see your crew within the next three weeks and will wait until then before contacting the state contractor’s license board.
Feel free to contact me at (123) 456-7890 to schedule or visit or with any questions or concerns.
Sincerely,
David Jones
More Sample Complaint Letters
- Sample Complaint Letter & Email - consumeraction.gov
More Complaint Letter Templates
There are many sample complaint letters that you can get to by opening Microsoft Word then going to File > New and searching for 'complaint letter.' Below are the titles of some of the letters we found via Word 2016:
- Letter of Complaint About Service
- Letter of Complaint About Insurance Premium Increase
- Apology Letter for Poor Service
- Letter Complaining About Customer Service
- Complaint Letter Requesting Reimbursement for Travel Booking Error
- Letter of Complaint About Misrepresented Vehicle Warranty
- Letter of Complaint Regarding Incomplete Vehicle Repair
Microsoft Vendor Complaint Template Excel
Additional Resources
- Tips for Writing Complaint Letters - writeexpress.com
- Writing a Complaint Letter - doj.nh.gov (New Hampshire Department of Justice)