Question about Microsoft Office Standard for PC

1 Answer

I have data in excel

I have to do a lot of work in excel i always have to coampare the sales and have to solve different qureys which my boss ask right now i have data which has comparivitve sales of 3 months i want to use colours to tell wher sales is dipping and sort by colour

Posted by KIRAN80 on

  • KIRAN80 Sep 11, 2007

    its real urgent

×

Ad

1 Answer

Gareth Cockram

  • Level 3:

    An expert who has achieved level 3 by getting 1000 points

    All-Star:

    An expert that got 10 achievements.

    MVP:

    An expert that got 5 achievements.

    Vice President:

    An expert whose answer got voted for 100 times.

  • Master
  • 661 Answers

Excel cannot search by colour, however you can rank by adding a column, in which you place a ranking value (if you colour code as well you can appear to rank by colour), sorting by the ranking column will give you the same ranked rows together in numerical order.

Posted on Sep 11, 2007

Ad

Add Your Answer

×

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

2helpful
4answers

Cannot open file. Error message reads: Excel cannot open

Use Excel Repair Toolbox is efficient corrupt XLSX file repair software, suitable for all data recovery activities, applied to Microsoft Excel documents.

For more: https://www.xlsxrepairtoolbox.com/
0helpful
1answer

Is there A Replacement for Oiless Big Boss Fryer? for the burner?

TRY THE GOODWILL STORES AND THRIFT STORES ,
THAT'S THE PLACES TO GO TO AND GARAGE SALES WHEN
YOU GO TO THE GARAGE SALE ASK FOR WHAT YOU'R
LOOKING FOR SOME TIMES PEOPLE HAVE STUFF THAT
THEY DON'T USE,.SO YOU ASK.?
D,R,CLAUDIO
0helpful
1answer

I export to excel .excel sheet format is different. i want excel sheet format how to change the excel sheet

you should export data in xml format from tally your problem will solved for any problem kindly contact 09310947557 (Narendra Chaudhary)
1helpful
3answers

Export the data from excel to tally

  1. make a sale entry in tally
  2. Export the voucher from tally in xml format (this is to give u how the xml looks)
  3. Open the excel file where all the data is ther.
  4. open a word file, so that we can prepare the xml for mutiple vouchers. For this we will use Mail Merge facility
  5. in the XML which we did in step two, copy the data from "<TALLYMESSAGE xmlns:UDF="TallyUDF">" till the </TALLYMESSAGE>
  6. Now open the word file, go to mail merger, select the fields which needs to be changed, that is the Debtors and the amount (for normal sale entries) which should change for every sale voucher.
  7. create the mail merge.
  8. copy the data what you got in word file to a note pad and name it as sample.
  9. open again the step 2 - copy data from " <ENVELOPE> to <REQUESTDATA>" and paste in the begining of the notepad sample
  10. go the end of the notepad sample and copy the data from first file -"step 2" from " </REQUESTDATA> to </ENVELOPE>" and save the file
  11. Open tally
  12. go to import vocuhers
  13. specify the path of the notepad sample and yes ur data got imported.
2helpful
1answer

What's data series in excel

When you are creating charts in Excel a data series refers to the sets of values that are going to be on the chart, be it a line chart, a bar chart, a pie chart etc. Different types of charts can work with different kinds of series. If you select the data you want to chart, and use the Chart Wizard, it will detect what data you have chosen and define it into series for the purposes of being on the chart. You can do things like give names to the series or set colours for them or put titles and legends on the charts for them, and lots of other things. When you are working with a chart, a Chart menu will appear on the menu bar and there are options in it to do things with the different series that are in it.

0helpful
1answer

Excel 2007 question

Ok, I realized that I wasn't paying attention when I created my test spreadsheet. My first cell wasn't sorting properly because it started with a ";" instead of a letter, so it always stayed at the top. I removed the extra character and repalced it with another letter, tried it again and it worked. If there's only 1 column, it doesn't ask to expand the selection. If there are nearby data cells, it asks you what you want to do. I was able to get it to work every time by selecting "Continue with existing selection" instead of "Expand selection".
0helpful
1answer

Boss 1180 Hard Drive Error

Im Sure You Solved This Problem But For Other User Yes There Is A Way To Save Your Data If Your Hard Drive Is Still Operable. You Can Put Your Boss Hard Drive Into Your Computer And Copy Its Contents To Your Computers Hard Drive. Some Say That If The Hard Drive Is Not Operating You Can Put It In A Ziplock And Then Stick It In The Freezer For An Hour Then Attempt To Retrieve Your Info. Remember Always Back Up Your Data On Hard Drive Recorders As They Are Not Fail Safe.
0helpful
3answers

Excel password removing

could you please supply us with the version of Excel you are using? it's under Help About Excel
0helpful
1answer

Microsoft excel(data analysing)

Microsoft Excel is an application used for building spreadsheets. It has many built in calculation and graphics tools. Some people use it to track expenses while other use it to graph numbers for charting process. As far as data analyzing it all depends on the data. Whether is sales figures or budget information. It all can be done inside of excel using it built in formulas and functions.
Not finding what you are looking for?
Microsoft Office Standard for PC Logo

Related Topics:

99 views

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

k24674

Level 3 Expert

8092 Answers

Jax Planet
Jax Planet

Level 2 Expert

923 Answers

Brad Brown

Level 3 Expert

18686 Answers

Are you a Microsoft Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...