Spotlight Visualization in Excel (Part-1) | Dynamic RAG (Red, Amber, and Green) Stoplights

#Infographics #Spotlights
Hello Friends,
In this video, you will learn how to create beautiful spotlight visualization with RAG (Red, Amber, and Green) color. We have used Excel shapes and to change the color dynamically we have used Name Manager and Linked Picture.
Spotlight Visualization in Excel (Part-2)
• Spotlight Visualizatio...
Click here to download the practice file:
www.pk-anexcelexpert.com/spot...
Download our free Excel utility Tool and improve your productivity:
www.pk-anexcelexpert.com/prod...
See our Excel Products:
www.pk-anexcelexpert.com/prod...
Visit to learn more:
Chart and Visualizations: www.pk-anexcelexpert.com/cate...
VBA Course: www.pk-anexcelexpert.com/vba/
Download useful Templates: www.pk-anexcelexpert.com/cate...
Dashboards: www.pk-anexcelexpert.com/exce...
Watch the best info-graphics and dynamic charts from below link:
• Dynamic Graphs
Learn and free download best excel Dashboard template:
• Excel Dashboards
Learn Step by Step VBA:
• VBA Tutorial
Website:
www.PK-AnExcelExpert.com
Facebook:
/ pkanexcelexpert
Telegram:
t.me/joinchat/AAAAAE2OnviiEk5...
Twitter:
/ priyendra_kumar
Pinterest:
/ pkanexcelexpert
Send me your queries on telegram:
@PKanExcelExpert
************ Suggested Books ********
VBA: amzn.to/2TMMikX
Excel Dashboard: amzn.to/2WZi2Fj
Power Query: amzn.to/2Ibd7xR
Power Pivot and Power BI: amzn.to/2DCg8BB
Exam Ref 70-778 (Power BI): amzn.to/2GnWYTN
************ My Stuff ***************
Mic : amzn.to/2TLnF88
Video Editor: screencast-o-matic.com/refer/...

[@JeffersonAlvesDadosCriativos]

Your canal is the best .. congrats

[@vinothprakash1465]

Outstanding, boss!!!
Very useful tutorial

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@MalinaC]

I love your ideas, unique!!! Thanks for sharing :)

[@PKAnExcelExpert]

Thanks for your valuable feedback. Request you to please share this with your friends and colleagues.

[@fernandoperes5164]

Brilliant!!! Very...Very Good... Impressive... Tks for sharing...

[@PKAnExcelExpert]

Thanks for your valuable feedback. Request you to please share this with your friends and colleagues.

[@Luciano_mp]

Very good, beautiful. Thank you!

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@shivambhardwaj4901]

You are the best! I am a big fan of yours!

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@TheDaievans1]

You are awesome PK, Love it mate, you really are the best excel teacher 🤗

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@garciaroldanvictorenrique8565]

Excelente trabajo.
¡Muchísimas gracias!

[@PKAnExcelExpert]

Gracias por ver

[@ilhambaghirzadeh4198]

Perfect video thank you very much

[@sunilkumar-jl7uf]

amazing stuff and waiting for next parts

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@cesarsaldana3429]

Its fantastic.... You are a master....... Best Regards from mexico.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@katerina6495]

Very impressive PK, thank you

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@lucienne4263]

I really like this, looks amazing, thank you

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@Saatt79]

Awesome 👏 sir!!! looks great....

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@pureblissyoutube8562]

You are doing a good job buddy! Keep it up

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@prakashsagar2226]

Amazing, you really know your way with graphic options of excel! Superb :)

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@sharvari.s.vichare]

You are not an expert You are an excel genius and scientist

[@jeissongonzalezmedina7172]

Excelente... saludos desde Colombia.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@muazabdullah3124]

Beautiful 💖

[@VikasSingh-em3ol]

Awesome and unique idea Sir .
Thank you sir

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@user-zx5dy6pb2m]

thanks so much i learn new things. thanks again.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@the_whitepaper]

This is so awesome

[@smrenterprises3152]

U R A Master of charts and dashboard thank q sir

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@NHHT777]

This is awesome!

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@gokulkannan90]

Dude thank you soo much, spot light is soo useful for me to indicate the idle time & production backlog in my office, please make more video regarding this.I'll study a lot from you..

[@PKAnExcelExpert]

Thanks for your valuable feedback. I will definitely try to make such video series

[@ismailhossen7578]

thanks for your informative content.

[@PKAnExcelExpert]

My pleasure!

[@info2satish]

Brilliant trick PK! You're just awesome bhai!!😂

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@JeffersonAlvesDadosCriativos]

Awesome pk

[@dora9320]

Master show!! 😍 I love it 😍💙

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@sharvari.s.vichare]

Good.
We will watch the 2nd part of video.
Gracias por ver aur gracias video.

[@sharvari.s.vichare]

This video I liked

[@HuyMinhTV]

Thnks you very much. I'll hope study a lot of from you🥰🥰

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@yosephambawofficial7961]

ur the best

[@ayacleopa5467]

You are an excellent being on excel

[@PKAnExcelExpert]

Thanks🙏

[@ivairferrari]

master show!

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@ericiriarte2880]

Me encanto

[@lisay5302]

Amazing!

[@PKAnExcelExpert]

Most welcome🙏

[@hazemali382]

WOW PK ♥

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@brightvictor7868]

Wow awesome bro

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@rajivsd69]

Thank you so much 💕

[@PKAnExcelExpert]

Most welcome

[@tatyasahebshevale117]

Keep it up bro... 👍👍👍👌👌🤟

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@hasanhunain3071]

Awesome

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@zafarvlog6865]

Wooooow😳😮😮

[@PKAnExcelExpert]

Thanks for your valuable feedback🙏

[@felixgonzalez7283]

excellent...............

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@VijayKumar-yd3zs]

Thank u very much

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@68111]

Wao sir .....so nice of you

[@PKAnExcelExpert]

It's my pleasure

[@BenDieselBasicAutomotive]

Amazing video... I hope l can replicate it.. for my report. Thank you again, Sir.. I'm an avid fan.. .

[@PKAnExcelExpert]

Thanks

[@bouchraben6973]

Great

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@bzflowerbee]

Can this apply to a pivot table with slicer? Thanks.

[@muhammadazeem5857]

Superb

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@TechAndBest]

Can we make this type of design in any of the excel version?

[@pa2happiness13]

Super ♥️👌

[@PKAnExcelExpert]

Thanks

[@gennaroscarpati8675]

Greta, bravo

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@mahsamalekshahi609]

so good

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@maddinenirajeshbabu3143]

Hi Pk,
Thanks in advance.
I have 5 laksh recrods are there I need to apply vlookup formula using VBA I am applying it's taking to much time and also hanging the excel application is there any way to doing fast vlookup kindly help this

[@shaliniashokan8215]

Dear sir I have a doubt, in this project since I executed it for my office project and getting outlines, I utilised no outline options but still i am getting it. Kindly advise?

[@heikoheimrath7514]

pretty cool :-)

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@sharvari.s.vichare]

Cool video.
Like it.
Link given on description box in Your Link??

[@medkari]

i don't how i thank you my best brother and helper

[@PKAnExcelExpert]

Thanks for your appreciation

[@MohammadEkram-hm9ug]

Thank You so Much

[@PKAnExcelExpert]

Most welcome🙏

[@PKAnExcelExpert]

Most welcome🙏

[@sanjayshivhare2596]

Nice

[@PKAnExcelExpert]

Thanks for your valuable your valuable

[@shivamsinghal2716]

Big brother i try this. Not same but i made it. Thank u so much.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@shivamsinghal2716]

@@PKAnExcelExpert but i have a query when you turned the base face in ul side so the yellow color remains same. Not turned accordingly. Please suggest me?

[@kunk5666]

😀

[@PKAnExcelExpert]

Thanks

[@MrRanjitsihag]

Very nice Bhai saab 👌👌👌👌

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@MrRanjitsihag]

@@PKAnExcelExpert welcome Bhai saab bahut mast video banate ho yaar

[@ilhambaghirzadeh4198]

Excuse me but i didnt understand randbetween function. what was it for?

[@adrianransome304]

Doesn't appear to work in all versions of excel. Using excel for Mac v16.71 and it does not allow you to copy the finished spotlight to the data page with all the formats in place. Also not allowing you to link to the data to change colours. Still very interesting video on how to be creative with your outputs.

[@dcalbums]

There is no bevel option in my excel

[@tanusen6012]

Sir. Jab hum "="sign press krke "service -level" likh ke enter Press krne se "service not valid "aa raha hai

[@harrietgomez9769]

Can this be done in Google Sheets?

[@albertoisturiz8269]

Click here to download the practice file:
www.pk-anexcelexpert.com/spot...
????

[@Ramniya]

But sir its not running in my excel

[@pradeepkevre139]

सर हिन्दी में भी वीडियों बनाइये please

[@chrisnaidoo4596]

His ideas and tricks are good however he works so fast in some cells that when you follow his downloaded file and watch the video again, you can't always get it right.

[@tanusen6012]

Plz help sir

[@MD-lk4qr]

waste of time