“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

I have a spreadsheet that was given to me. Several cells have down lists (list contains 1,0,-1 as options). If you select 1, a green circle appears in the cell with a checkmark. If you select 0, just the empty circle appears. If you select -1, an orange circle appears with an exclamation point. I'm a little familiar with data validation but can't figure out how this is done.

Solved by X. J. in 21 mins

I am trying to insert a decimal point in excel 2016, it is not saving when I check the decimal point box.

Solved by T. Q. in 27 mins

I have a table with categorical data - some data points have just one categorical data point and others have multiple. Can I create a Pivot Table that tabulates each data point individually? In order to do this, is there a way to separate the data points in the column so Excel knows where one data point ends and the next starts - I'm currently using spaces (e.g. "I2b E4c" : I want Excel to read this as one data point for "I2b" and one data point for "E4c", rather than one data point for "I2b E4c").

Solved by D. F. in 20 mins

i want to link a data in excel file with power point chart

Solved by X. W. in 26 mins

I would like to print my milage from point A to point B. I have completed the trips. My manager wants me to send it to her in excel.

Solved by M. H. in 21 mins