Conditional Formatting in Excel | Excel Tutorials for Beginners

[@sj1795]

THANK YOU Alex!! I'm learning SO much. This Bootcamp series rocks! I love that you talk to us about content/info/functions that you personally use regularly and explain HOW you use it. The duplicates and new rules information was particularly valuable. You are the BEST!

[@ayoolasolarin997]

Completed the Excel videos, and I am super excited. Now, I am moving to SQL while I start an Excel project at the same time. Thank you again, Alex. You are a blessing.

[@Applefanboy2012]

How’s it going man

[@uzairmemon2096]

hey alex i just want to thank you all the way from pakistan. i am currently in my last year of computer science degree. i was learning app development but i couldn code for much hours and here i come to find your bootcamp. i will now become a data analyst. followed your mysql series now on excel and next is tableau. thanks thanks thanks

[@Rizzistor347Mars]

sadly you won't become anything since you're from a third world country with political instability and ties with terrorism

[@yqhanliving]

Really appreciate it that you share the problems that you come across at real-life work scenario the most and how to solve them with the tools. It just makes the tutorial much easier to understand. Thanks Alex!

[@vectoralphaSec]

i never knew Excel had so many cool features.

[@mj-fm4bp]

Timestamps for Conditional Formatting in Excel: 02:03 Using Icon sets, Color scales, Data Bars, Top/Bottom Rules 07:50 Duplicate Values 11:57 Text that Contains 14:13 Create custom rules: New Rule... 19:20 Outro

[@1689JeffChavez]

Thank you.

[@Nikopup]

As always, this video is very helpful. Before watching, I had never even heard of conditional formatting. Now, I have a feeling I will be using this function quite often! Thank you Alex!!!

[@adeelali8417]

Honestly, these videos are excellent. Straight to the point, No BS, tutorials.

[@PhNg1111]

Thanks Alex, I'm waiting for your Python course.

[@anidiotsguide757]

@@connorlancaster7541 Jesus can teach Python? That's cool, does he have a youtube chanel for that?

[@connorlancaster7541]

@@anidiotsguide757 Wow. Are you an atheist?

[@anidiotsguide757]

@@connorlancaster7541 I was asking how Jesus can help me lear Python, which you said he could. Do you have a link?

[@connorlancaster7541]

@@anidiotsguide757 What even is this?

[@AlexTheAnalyst]

Starting it next week!

[@hubaaltraining]

This is Cool Alex. I normally use the Shortcut *CTR+SHIT+L* for Filter, for turning On & Off. It really helped me save a lot time when working on a big Data. Thanks for very important tutorials.

[@sifrank9268]

One little trick to remove the dollar sign: choose the cell range,(Not necessarily all the range contents but at least 3 chars including : sign and 2 char on left and right each), then click F4 three times.

[@AkporHari]

Progress. I think the way Alex teaches is just right for me. On to Charts then...

[@AlexTheAnalyst]

Super glad to hear that! I try to teach the way I learned it so other people can understand it :)

[@siri_igot7]

This Channel deserves more love in millions , I am grateful I found you at right time when I am preparing for my first Data Analyst Job. Thanks Alex for being a great teacher , I am learning so much here than in college :) ..

[@asomya87]

Thank you Alex. One of the best tutorials explaining conditional formatting. You explained it in such a simple manner.

[@stce1121]

Can't say thank you enough for your efforts and kindness

[@richardhoyle8115]

I thought I'd entered the Matrix at 9:45! Ps great video thank you!

[@tbuckyfilms]

hahaha same I thought the video was skipping like a record

[@oluyomifadipe5634]

lol a glitch in the matrix

[@fawzulazimrafid]

boss literally like I literally understood everyb single thing explained man I watched so many videos but this was the best

[@1689JeffChavez]

On my journey through the boot camp...

[@MissP3224]

Watching this video I'm thinking where have you been my whole life. Life changing Honestly. Thank you for your time and Kindness 🌞

[@KC-tz6jo]

Thanks Alex, waiting for more to come 😎

[@Arsalanzeb]

Before I just used duplicate values, Now I learned something new in conditional formatting and text that contain is also very useful. Thnx Alex

[@parsagholampour]

Thank you! These kinda tutrorials work for me. And OMG! How a powerful software Excel is.

[@r7amoscoder]

00:01 Conditional formatting in Excel allows users to visually highlight important values using various formatting options. 01:49 Conditional formatting in Excel allows you to easily visualize data patterns 03:47 Conditional formatting in Excel allows you to use colors, shapes, and indicators to highlight and analyze data. 05:46 Conditional formatting in Excel allows you to highlight cells based on specific rules. 07:42 Conditional Formatting: Highlight Duplicate Values 09:47 Using conditional formatting in Excel to find duplicates in data sets 11:36 Conditional formatting in Excel allows for easier identification of specific data. 13:38 Highlighting cells based on custom formulas in conditional formatting 15:30 Using the dollar sign ($) in Excel allows for hard coding of specific cells. 17:22 Conditional formatting in Excel allows you to highlight specific data based on specific conditions. 19:01 Conditional formatting is a useful and efficient tool for quickly identifying patterns and outliers in large datasets. 20:42 Sponsoring this excel series

[@adenikeglamz]

Thank you Alex for this videos

[@Yana-ns5bn]

Special thanks for the Dunder Mifflin table!

[@Mayaadyby.]

That's a simple explanation to learn like always! Alex could you make a video about Power BI as well? that we could learn that more, Many thanks.

[@AlexTheAnalyst]

Done :)

[@ashrafhussainfahad9497]

Loved your teaching style and hope to get more.

[@mitoali5151]

Bro, my brain was crying in the troubleshooting. Then he explained that you only need to range it before proceeding to the new rules.

[@PAConDRUGS]

Heyyo bruh

[@xamzamoztafa1727]

Thanks a lot alex, following your videos from Somaliland, you are a real hero, keep the good work 👍 Good content, easy to understand...cooool!

[@luxfoodies2701]

I love your videos it encourages to keep pushing.

[@NixonBranch]

I thought I'd entered the Matrix at 9:45!Ps great video thank you!. I love your videos it encourages to keep pushing..

[@polokomonama6526]

Fantastic video Alex, Thank you so much!

[@amigoranjan]

good information - was waiting if you will also illustrate how to compare more than 1 column for taking out duplicates... Thanks !

[@fantasytalker]

Great course as always! Easy to follow and pick up.Thank you, Alex! Will there be a power query course in the future?

[@AlexTheAnalyst]

I plan on it :)

[@connorlancaster7541]

Ask Holy Spirit to teach you and to guide you. I would recommend the KZbin Cleveland street preachers and follow Jesus no man no religion. Be holy and obey Jesus. Hebrews 5:9 "salvation is for those who obey. Jesus says if you love me keep my commandments (John 14:15). He even says if you keep my commandments then you shall abide in my love (John 15:10).h

[@adeebazia3436]

thankyou so much Alex🥺❤️

[@chrissarong9070]

Thank you Alex!!!

[@KuirThuch]

Thou art a great Data Analyst

[@kelthekonqrr]

Use this on most projects to help w/ data validation

[@chrisgill_UK]

Thanks for the video Alex!

[@ricardoandresaldana02]

I loved it thank you

[@Shweta.Sarwalia16]

Hi Alex, whenever I apply conditional formatting on my data and share it to my managers in a excel workbook. The colors I quoted for rule changes to a different colors. How to fix that problem in CF rule?

[@86adiel]

7:35 Duplicate Values and how to find them (filter by color)

[@onomeebe]

Thank you Alex

[@shokoofehheidari5345]

Tank you Alex!

[@ashwinkotwal-z2o]

Could you please tell me when to use Conditional formatting? Asking this because as per my understanding, it is acting as a filter only.

[@mikesalazar3637]

I'm not sure why the first formula is not working for me for the date. I tried it like twenty times. Anyone else have this issue? Great video by the way, Alex!

[@analystgabriel]

Well explained

[@rezamoravej2248]

Great But very short ! I wish you had explained about $ ... that could be done in a couple of minutes !

[@Jethrochukwu]

Hello Alex thank you for the video. Just want to ask a question I tried using( MAX, MIN ) in the NEW RULE option but it seems it does not function, only the regular ( =, ) that function well

[@MrAyushguptaful]

Hi Alex, If you are reading this. Is this tutorial enough for getting a job as an data analyst? My first job

[@syedabu7685]

I thank to Allah that I found you in KZbin!! Genuinely you are a good man! and I hope you keep on doing this good work and thank you so much for sharing your knowledge!

[@Lakshmepw]

Thank u Alex, the way u even explain the use cases of these functions is awesome, u are awesome. Quick doubt tho... what if i use $ sign to absolute reference the return_array range in XLOOKUP formula, do i still get the same output despite adding a new column in place of that required_array range/column ???? I am going to check as well, but ya... wait lemme check...

[@barackusemckhulin2649]

I want to create a growing data bar based on a percentage or numerical value.

[@michaellillyjr.3044]

Hey Alex, is the course you keep returning to the ALL Excel Essentials Course?

[@krishnathanki999]

Thank you.

[@preritpandya8050]

Hello alex i from India.. i am learning excel as of now. From where i can get data to play with excel tools. Simultaneously i am working on fundamental of statistics.. after excel what should be my next task... Please guide

[@AljIsHere128]

Will you be doing Intro Power BI courses on your channel? I have worked in a book on conditional formatting before. I really enjoyed this course and understand how important those conditionals matter. Especially when there are larger datasets involved.

[@AlexTheAnalyst]

I will! Coming soon :)

[@atchayap2652]

Hi Alex and all, I hope you are all doing well, you are my true inspiration Alex. I decide to be a data analyst last year after watching your video and then I got a job as an intern in PowerBI. THEN now I am working as a data analyst for another company. I am checking your videos and learning a lot. I would like to know one thing. I am working in the people & culture department they use only excel and powerbi which given a role called data analyst. They don't even use SQL, so can you tell without using SQL, is this a data analyst position.? guys just help me and give a response. Thanks

[@ashish-bisht]

Yes, you are doing the job of data analyst. Generally, the excel is used if the dateset is small but if the dataset is large then you have to use SQL for that.

[@atchayap2652]

@@ashish-bisht thank you so much for the clarification

[@luyesterlucky151]

Hello.. Can I ask why 2 videos are private on MS Excel playlist?

[@peters520]

I am assuming he uploads new videos and he has scheduled times to release the videos and hasn’t released them yet and they're labelled to be part of the excel playlist

[@AlexTheAnalyst]

Yeah they are just in queue for following weeks - all the available ones should be there

[@neezahbel]

Thank you so much

[@BodiBlo]

The video is blurry especially the Excel screen view...I hope it improves. Faning your channel always regardless, thanks for the content

[@DataSpook]

looking for conditional formatting based on the NUMBER value of one cell to another. if A2 is bigger than B2 then hightlight B2 green.

[@chetandhingra4041]

Thank you so much for this video, but my age formatting is not working. I did it the same way as you do. Please reply to this as soon as possible.

[@thalitia1]

thanks!

[@Husseini06]

Thanks you

[@Ogie95]

Anyone, who can help, Pls what did you mean when you said "Those dollar signs are something to watch out for?"......I reckon its better to leave the signs off as to not complicate shit afterwards or it something else?. PS, Great Series so far

[@minhkhoi6465]

where can i get free data for my practice, thank you

[@adwaamohamed2674]

thank you

[@alizashakeel4555]

i don't getting the right answer after creating formula ,like in your video i don't get the values greater than 50000 instead i get smaller than it and same goes when i right G2:G10 < 50000 i get all the greater values than 50000 . Can anyone please help me?

[@saadmultani7251]

Alex we are not able to access 2 videos from the excel playlist....can you please have a look

[@peters520]

I am assuming he uploads new videos and he has scheduled times to release the videos and hasn’t released them yet and they're labelled to be part of the excel playlist

[@AlexTheAnalyst]

They should all be there - I do have some in queue for next week

[@jasonparness4077]

small editing glitch @9:45 made me laugh idk why Lol.. so like names. Names. So like. So like names. Names.. xD

[@shayyantashreef5593]

Hi Alex, It's me Tareq from Bangladesh. Can you inform me ? Is it possible to be a data analyst as I am doing a job in a private bank? If I become a data analyst, will it help me to get remote job as a data analyst? Please, explain if possible? Thanks you.

[@AlexTheAnalyst]

Yeah there are a lot of financial analysts and data analysts at banking companies here in the US. I'm sure they hire there as well.

[@reneakunwa]

24/74 Lets go!!

[@manzooraatef-kw2wk]

BEST

[@saadmultani7251]

Is 8gb ram enough for Data analysis?

[@AlexTheAnalyst]

Definitely can, but 16gb is recommended - 8gb can be sufficient though

[@kitakamidesign3186]

13:05 how to remove sort?

[@atem583]

I just use Ctrl + Z

[@kitakamidesign3186]

Thank you, I also did the same.

[@samuelraj5613]

Done

[@emadbaghernia2325]

❤❤❤

[@rajatchopra1411]

9:45 "So like names... So like names... So like names." It kinda scared the hell out of me

[@AlexTheAnalyst]

Lolol missed an edit there! Sorry for thinking you were going insane :D

[@aimenyaugba6892]

👏

[@danielaseen3580]

D13 - October 15, 2024

[@stunninglife5086]

First

[@kannanps1702]

Made the simplest things very confusing and over complicated