Видео

🔵 Excel file to Download: jopaexcel.com/dashboarddatadze69peaj1s

THANK YOU

Its not working :(

Very very helpful

Jopa, thank you so much for this wonderful training, I followed you to the letter with this formular, but i am having #VALUE! =IF(E13>D13,E13-D13,1-D13)+IF(G13>F13,G13-F13,1-F13+G13)

can I ask for the sample file? i only have android phone.. but i want to test it myself

Please upload Excel file for practice purpose.

thank you

Finally I have found a very useful video Thank you

Show❤

Hi what’s your contact number please

Good idea but there’s one problem I don’t have the developer tab up on my screen ….

barcodeapi.org/api/auto/ Example of use: =IMAGE("barcodeapi.org/api/auto/"&A1)

Thank you sooo much!! This helped me out

idk man im confused i would stick to google docs if my company didn't block it oh well

very helpful. thanks

What did you press sir.😢

Very helpful! ❤

One more thing, how could I make the data entry separate from the database so it´s only "one-way": people feed but has not access to the information PLEASE?

I can only see an option for "Font" when I go to format comment. No "Colors and Lines" category tab.

This is great.....except......it doesn't seem to continue counting automatically. What I mean is, every time I put in a new entry in the coloured field, I then have to click on the count_colour function cell to bring up the edit panel and hit enter for the count to go up by one. Any ideas why that would be happening?

If I want to know how much was sold from 1st -4 th of January 2024

Thank you so much!

@JopaExcel, many many thanks! I found what I wanted. Can you please comment how to clean the form AFTER being filled for a new user/entry PLEASE?

Around 18:16 min you said we should chose the F something key,i cant figure out what you are saying due to the accent and im stock there.please can you tell me the key you were refering to,will really appreciate it thank you

Can you make it so when you choose for example the rent option the expenses label auto populates? So like you skip entering it but its just there already?

at least, i have found this capabilities of Excel!!!

Wow thanks alot you are really master ❤

Loved this video. Steps were clearly described. Thank you!

I really enjoyed your teaching ❤

Super video!!! 🤖

How do we get the formula to subtract 30 minutes for lunch if over 6 hours are worked?

hi, great tutorial! can you do that with font colours/format?

Thanks, Jopa. A couple of thoughts: 1) your idea about first copying/pasting all values into the Form and then copying pasting them again on the Inventory sheet was new to me. However, I thought that whenever one selected "copy values", the formulas naturally wouldn't paste. I'll have to test this out to see what happens. 2) An alternate way to hide the helper cells is to make them all white 3) One should also protect the worksheets so that users can modify only certain cells. That is, the helper cells on the Form and the cells in Inventory should never be directly modified by users.

I can't figure out the gradients, so I just did without them. However, my real problem is getting the percentages (only) to show up inside the colors on the circumfrene of th donut. It shows the legend, the actual value, and then the percentage.

I just have a question regarding the final graph, 6:51. When you have a small dataset, it is easy to figure out by “eye” the points of the graph or the period in which you have a correlation. Do you know if it is possible for Excel to provide you with the most correlated period? For example, in your dataset, can Excel indicate that between wk 3 and 4 was the best period (negative correlation)?

Very nice tutorial. Just wondering if it is possible to automatically refresh the count as I would like to change color let's say in one of the cells?

Thanks

I have seen tons of videos and articles on sorting in Excel, but none meet my needs. I have a database of semiconductor parts such as transistors, ic, ettc. The alphanumeric variations in names are such that none of the sorts actuallly work for it, instead make it messier. An example of some of the name types are: 1N2902, 2n7656, DM74s678, MM74ls545, 74LS343, sn75054, NTE123, LM709, TC21, TMM6754, Z8353, etc. The numbers are all entered as text. Ideaally I could sort my the first lettter. Then second letter, third letter, and fourth letter. But, I would settle for being able to just sort 1 thro z if that is all I could do. Several so called “experts” can’t even understand why I need it, let alone tell me how. (Including 2 from Microst) I Despeartely need help, and appreciate any advice. Thank you.

I was searching this video from last one week

How would I for example calculate the cost of staff travelling & hotel costs, broken down by their names and then the month? Is the principle the same?

What if one of the 3 conditions is alphabetical

If I change a color should the total auto update?

Enjoy your videos but was really hoping this many in you would sort out the audio.

why it is not working on my excel app?