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
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
Re: i have data in excel
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.
- If you need clarification, ask it in the comment box above.
- Better answers use proper spelling and grammar.
- Provide details, support with references or personal experience.
Tell us some more! Your answer needs to include more details to help people.You can't post answers that contain an email address.Please enter a valid email address.The email address entered is already associated to an account.Login to postPlease use English characters only.
Tip: The max point reward for answering a question is 15.
Use Excel Repair Toolbox is efficient corrupt XLSX file repair software, suitable for all data recovery activities, applied to Microsoft Excel documents.
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
Export the voucher from tally in xml format (this is to give u how the
xml looks)
Open the excel file where all the data is ther.
open a word file, so that we can prepare the xml for mutiple vouchers.
For this we will use Mail Merge facility
in the XML which we did in step two, copy the data from
"<TALLYMESSAGE xmlns:UDF="TallyUDF">" till
the </TALLYMESSAGE>
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.
create the mail merge.
copy the data what you got in word file to a note pad and name it as
sample.
open again the step 2 - copy data from " <ENVELOPE>
to <REQUESTDATA>" and paste in the begining of the notepad sample
go the end of the notepad sample and copy the data from first file
-"step 2" from " </REQUESTDATA> to </ENVELOPE>" and save the
file
Open tally
go to import vocuhers
specify the path of the notepad sample and yes ur data got imported.
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.
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".
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.
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.
its real urgent
×