Conditional Formatting in Excel | Excel Tutorials for Beginners
ฝัง
- เผยแพร่เมื่อ 2 มิ.ย. 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
i never knew Excel had so many cool features.
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
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
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!
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!
On my journey through the boot camp...
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!!!
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 :)
Honestly, these videos are excellent. Straight to the point, No BS, tutorials.
Before I just used duplicate values, Now I learned something new in conditional formatting and text that contain is also very useful. Thnx Alex
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.
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!
Watching this video I'm thinking where have you been my whole life. Life changing Honestly. Thank you for your time and Kindness 🌞
Fantastic video Alex, Thank you so much!
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 :) ..
Thanks Alex, waiting for more to come 😎
Thank you Alex for this videos
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 for the video Alex!
Loved your teaching style and hope to get more.
Can't say thank you enough for your efforts and kindness
I love your videos it encourages to keep pushing.
boss literally
like I literally understood everyb single thing explained man I watched so many videos but this was the best
thankyou so much Alex🥺❤️
Thank you Alex!!!
Special thanks for the Dunder Mifflin table!
I loved it thank you
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.
Thank you Alex
Tank you Alex!
Well explained
Thou art a great Data Analyst
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 :)
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 TH-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
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
Thank you so much
I thought I'd entered the Matrix at 9:45!Ps great video thank you!. I love your videos it encourages to keep pushing..
Use this on most projects to help w/ data validation
thanks!
Thanks you
Hey Alex, is the course you keep returning to the ALL Excel Essentials Course?
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?
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 :)
thank you
Hi Alex, If you are reading this. Is this tutorial enough for getting a job as an data analyst? My first job
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
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!
looking for conditional formatting based on the NUMBER value of one cell to another. if A2 is bigger than B2 then hightlight B2 green.
Great But very short ! I wish you had explained about $ ... that could be done in a couple of minutes !
I thank to Allah that I found you in TH-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!
The video is blurry especially the Excel screen view...I hope it improves. Faning your channel always regardless, thanks for the content
BEST
I want to create a growing data bar based on a percentage or numerical value.
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
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
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
Done
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
👏
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?
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
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.
7:35 Duplicate Values and how to find them (filter by color)
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
First
13:05 how to remove sort?
I just use Ctrl + Z
Thank you, I also did the same.
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