Welcome to Excel Dictionary, your ultimate source for impactful, digestible Excel tips and tricks. Emma created Excel Dictionary to help others avoid Excel overwhelm and to be the coworker that you can turn to. She was recently awarded the Microsoft MVP award and has built a community of over 5 million people across the globe! Join her across all social channels to learn quick, actionable skills that will make you more efficient, comfortable, and confident in your daily work!
Save your seat now to master Data Cleaning & Analysis for FREE at Miss Excel and I’s free live Excel training: links.miss-excel.com/exceldictionary?ref=exceldictionary&
Absolutely asinine. - extra steps compared to the first thing - result doesn't fix perspective - should be done in a photo editing program before importing the image to excel
If you want to master Data Cleaning & Analysis for FREE, save your seat now for Miss Excel and I’s free live Excel training: links.miss-excel.com/exceldictionary?ref=exceldictionary&
You can also do this using "Format Only Cell that Contain" rule under conditional formatting then click "equal to" instead of "between" which will be shown by default then type your word, in my case I wrote "Done" and format color into green for it then again do it similarly for "Not Done" and set another color for it. This method is easier for those who don't want to memories the formulas. Try it.
Also, if you want, maybe consider launching a new channel reading royalty free literature. I bet if you had a channel aimed at relaxation, insomnia or ASMR, it would do really well...
I dont understand. Is this for some older excel? I do everything exactly as in the video but mine is giving "theres a problem with this formula" and gives me higlighted text (SEARCH(find_text; within_text; (start_num)) Cant get around this. What I am possible doing wrong?
Hi, great video. I have 1 search bar working against my table, however, my table consists of 21 columns. I want to be able to search from more than one column (happy to add a few additional search bars). Is this possible?
Thanks for the nice instruction. I have a question that when I tried to create the search box in different sheet, it does not work. Could you please kindly advise
Most of your videos are cool or helpful but this one was dumb, you can actually just do the very same with the picture points instead of inserting a shape first.
a great video!! the only suggestion I would have would be to create an order of completion % such that all of the semi-circular bars are increasing (lowest to highest).