Conditional Formatting in Excel | Excel Tutorials for Beginners
Вставка
- Опубліковано 21 лип 2024
- Take my Full Excel for Data Analytics Course! www.analystbuilder.com/course...
Excel is one of the most used skills in the data world. In this series we will be walking through all of the most important topics that Data Analysts need to know in order to be proficient in Excel.
Excel Conditional Formatting Template: github.com/AlexTheAnalyst/Exc...
Udemy Excel Courses:
Pivot Tables in Excel: bit.ly/3JXCq28
Visualizations and Charts in Excel: bit.ly/3HOyij9
All Excel Essentials: bit.ly/3tf6XCK
____________________________________________
SUBSCRIBE!
Do you want to become a Data Analyst? That's what this channel is all about! My goal is to help you learn everything you need in order to start your career or even switch your career into Data Analytics. Be sure to subscribe to not miss out on any content!
____________________________________________
RESOURCES:
Coursera Courses:
Google Data Analyst Certification: coursera.pxf.io/5bBd62
Data Analysis with Python - coursera.pxf.io/BXY3Wy
IBM Data Analysis Specialization - coursera.pxf.io/AoYOdR
Tableau Data Visualization - coursera.pxf.io/MXYqaN
Udemy Courses:
Python for Data Analysis and Visualization- bit.ly/3hhX4LX
Statistics for Data Science - bit.ly/37jqDbq
SQL for Data Analysts (SSMS) - bit.ly/3fkqEij
Tableau A-Z - bit.ly/385lYvN
Please note I may earn a small commission for any purchase through these links - Thanks for supporting the channel!
____________________________________________
SUPPORT MY CHANNEL - PATREON/MERCH
Patreon Page - / alextheanalyst
Alex The Analyst Shop - teespring.com/stores/alex-the...
____________________________________________
Websites:
GitHub: github.com/AlexTheAnalyst
Instagram: @Alex_The_Analyst
____________________________________________
All opinions or statements in this video are my own and do not reflect the opinion of the company I work for or have ever worked for
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!
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!!!
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.
How’s it going man
Honestly, these videos are excellent. Straight to the point, No BS, tutorials.
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
Thank you.
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!
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 :) ..
Before I just used duplicate values, Now I learned something new in conditional formatting and text that contain is also very useful. Thnx Alex
Thank you Alex. One of the best tutorials explaining conditional formatting. You explained it in such a simple manner.
Watching this video I'm thinking where have you been my whole life. Life changing Honestly. Thank you for your time and Kindness 🌞
boss literally
like I literally understood everyb single thing explained man I watched so many videos but this was the best
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.
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.
i never knew Excel had so many cool features.
Thanks a lot alex, following your videos from Somaliland, you are a real hero, keep the good work 👍 Good content, easy to understand...cooool!
Thanks Alex, waiting for more to come 😎
Thanks Alex, I'm waiting for your Python course.
@@connorlancaster7541 Jesus can teach Python? That's cool, does he have a youtube chanel for that?
@@anidiotsguide757 Wow. Are you an atheist?
@@connorlancaster7541 I was asking how Jesus can help me lear Python, which you said he could. Do you have a link?
@@anidiotsguide757 What even is this?
Starting it next week!
Fantastic video Alex, Thank you so much!
good information - was waiting if you will also illustrate how to compare more than 1 column for taking out duplicates... Thanks !
Can't say thank you enough for your efforts and kindness
Loved your teaching style and hope to get more.
I love your videos it encourages to keep pushing.
Progress. I think the way Alex teaches is just right for me. On to Charts then...
Super glad to hear that! I try to teach the way I learned it so other people can understand it :)
Special thanks for the Dunder Mifflin table!
thankyou so much Alex🥺❤️
On my journey through the boot camp...
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
I thought I'd entered the Matrix at 9:45!
Ps great video thank you!
hahaha same I thought the video was skipping like a record
lol a glitch in the matrix
Thank you Alex for this videos
Thanks for the video Alex!
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?
Thank you Alex!!!
I thought I'd entered the Matrix at 9:45!Ps great video thank you!. I love your videos it encourages to keep pushing..
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.
Done :)
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
looking for conditional formatting based on the NUMBER value of one cell to another. if A2 is bigger than B2 then hightlight B2 green.
Thou art a great Data Analyst
Hi Alex, If you are reading this. Is this tutorial enough for getting a job as an data analyst? My first job
Thank you Alex
I loved it thank you
Tank you Alex!
Hey Alex, is the course you keep returning to the ALL Excel Essentials Course?
Use this on most projects to help w/ data validation
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
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!
I want to create a growing data bar based on a percentage or numerical value.
I thank to Allah that I found you in UA-cam!! 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!
Thank you so much
Well explained
Great course as always! Easy to follow and pick up.Thank you, Alex! Will there be a power query course in the future?
I plan on it :)
Ask Holy Spirit to teach you and to guide
you. I would recommend the UA-cam 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
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.
I will! Coming soon :)
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?
thank you
thanks!
Thanks you
Great But very short ! I wish you had explained about $ ... that could be done in a couple of minutes !
The video is blurry especially the Excel screen view...I hope it improves. Faning your channel always regardless, thanks for the content
BEST
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
7:35 Duplicate Values and how to find them (filter by color)
Alex we are not able to access 2 videos from the excel playlist....can you please have a look
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
They should all be there - I do have some in queue for next week
Hello..
Can I ask why 2 videos are private on MS Excel playlist?
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
Yeah they are just in queue for following weeks - all the available ones should be there
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.
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.
👏
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
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.
@@ashish-bisht thank you so much for the clarification
Done
Is 8gb ram enough for Data analysis?
Definitely can, but 16gb is recommended - 8gb can be sufficient though
small editing glitch @9:45 made me laugh idk why Lol.. so like names. Names. So like. So like names. Names.. xD
13:05 how to remove sort?
I just use Ctrl + Z
Thank you, I also did the same.
First
9:45 "So like names... So like names... So like names."
It kinda scared the hell out of me
Lolol missed an edit there! Sorry for thinking you were going insane :D
Made the simplest things very confusing and over complicated