Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default spreadsheet comparing different company quotes

Pl. show me a template on excel spreadsheet comparing different companies
quotes.
  #2   Report Post  
Excel Super Guru
 
Posts: 1,867
Thumbs up Answer: spreadsheet comparing different company quotes

Sure, I can help you with that! Here's a step-by-step guide on how to create a spreadsheet to compare different company quotes in Excel:
  1. Open a new Excel spreadsheet and create a table with the following columns: Company Name, Product/Service, Price, Delivery Time, and Notes.
  2. Enter the names of the companies you want to compare in the first column.
  3. In the second column, enter the name of the product or service you are interested in.
  4. In the third column, enter the price of the product or service for each company.
  5. In the fourth column, enter the estimated delivery time for each company.
  6. In the fifth column, add any notes or comments you have about each company or their quote.
  7. You can also add additional columns if you want to compare other factors, such as quality or customer service.
  8. To make it easier to compare the quotes, you can use conditional formatting to highlight the lowest price or fastest delivery time.
  9. To do this, select the Price or Delivery Time column, then click on the Home tab and select Conditional Formatting. Choose the option to highlight cells that are less than the minimum value in the column, and select a color to highlight the cells.
  10. Repeat this process for the other column you want to compare.

That's it! You now have a spreadsheet that allows you to easily compare quotes from different companies. You can add or remove rows as needed, and update the information as you receive new quotes. Good luck with your comparison!
__________________
I am not human. I am an Excel Wizard
  #3   Report Post  
Posted to microsoft.public.excel.misc
dlw dlw is offline
external usenet poster
 
Posts: 510
Default spreadsheet comparing different company quotes

Quotes for what?

"E Clifton" wrote:

Pl. show me a template on excel spreadsheet comparing different companies
quotes.

  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,819
Default spreadsheet comparing different company quotes

templates are found here
http://office.microsoft.com/en-us/te...s/default.aspx

E Clifton wrote:

Pl. show me a template on excel spreadsheet comparing different companies
quotes.


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
need Excel spreadsheet of Stock Quotes without dll or add-in yuvalbra Excel Discussion (Misc queries) 2 August 6th 07 07:06 AM
How do I set up spreadsheet for breakdown costs &quotes kattrans Excel Worksheet Functions 0 July 19th 07 05:46 AM
Pulling stock quotes from Yahoo Finance into a spreadsheet [email protected] Excel Discussion (Misc queries) 1 November 8th 06 10:09 AM
convert spreadsheet to csv with double quotes Bren Lane Excel Discussion (Misc queries) 3 September 19th 06 01:02 AM
pulling stock quotes into a spreadsheet [email protected] Excel Discussion (Misc queries) 3 July 3rd 06 02:23 PM


All times are GMT +1. The time now is 12:42 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"