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
11 ай бұрын
How’s it going man
@sj1795
9 ай бұрын
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!
@hubaaltraining
2 жыл бұрын
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
2 жыл бұрын
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.
@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
10 ай бұрын
Honestly, these videos are excellent. Straight to the point, No BS, tutorials.
@vectoralphaSec
Жыл бұрын
i never knew Excel had so many cool features.
@yqhanliving
10 ай бұрын
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!
@MissP3224
4 ай бұрын
Watching this video I'm thinking where have you been my whole life. Life changing Honestly. Thank you for your time and Kindness 🌞
@mitoali5151
2 ай бұрын
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
@fawzulazimrafid
8 ай бұрын
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...
@adeniikeeee
Жыл бұрын
Thank you Alex for this videos
@xamzamoztafa1727
2 жыл бұрын
Thanks a lot alex, following your videos from Somaliland, you are a real hero, keep the good work 👍 Good content, easy to understand...cooool!
@ashrafhussainfahad9497
11 ай бұрын
Loved your teaching style and hope to get more.
@PhNg1111
2 жыл бұрын
Thanks Alex, I'm waiting for your Python course.
@anidiotsguide757
2 жыл бұрын
@@connorlancaster7541 Jesus can teach Python? That's cool, does he have a youtube chanel for that?
@connorlancaster7541
2 жыл бұрын
@@anidiotsguide757 Wow. Are you an atheist?
@anidiotsguide757
2 жыл бұрын
@@connorlancaster7541 I was asking how Jesus can help me lear Python, which you said he could. Do you have a link?
@connorlancaster7541
2 жыл бұрын
@@anidiotsguide757 What even is this?
@AlexTheAnalyst
Жыл бұрын
Starting it next week!
@adeebazia3436
2 жыл бұрын
thankyou so much Alex🥺❤️
@chrissarong9070
Жыл бұрын
Thank you Alex!!!
@mj-fm4bp
2 жыл бұрын
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.
@KuirThuch
8 ай бұрын
Thou art a great Data Analyst
@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..
@kelthekonqrr
Жыл бұрын
Use this on most projects to help w/ data validation
@krishnathanki999
Ай бұрын
Thank you.
@chrisgill_UK
2 жыл бұрын
Thanks for the video Alex!
@fantasytalker
2 жыл бұрын
Great course as always! Easy to follow and pick up.Thank you, Alex! Will there be a power query course in the future?
@AlexTheAnalyst
2 жыл бұрын
I plan on it :)
@connorlancaster7541
2 жыл бұрын
Ask Holy Spirit to teach you and to guide you. I would recommend the KZitem 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
@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.
@shokoofehheidari5345
Жыл бұрын
Tank you Alex!
@analystgabriel
2 жыл бұрын
Well explained
@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.
@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?
@neezahbel
Жыл бұрын
Thank you so much
@rezamoravej2248
2 жыл бұрын
Great But very short ! I wish you had explained about $ ... that could be done in a couple of minutes !
@adwaamohamed2674
4 ай бұрын
thank you
@Lakshmepw
21 күн бұрын
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...
@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.
@atchayap2652
2 жыл бұрын
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
2 жыл бұрын
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
2 жыл бұрын
@@ashish-bisht thank you so much for the clarification
@BodiBlo
2 жыл бұрын
The video is blurry especially the Excel screen view...I hope it improves. Faning your channel always regardless, thanks for the content
@reneakunwa
Ай бұрын
24/74 Lets go!!
@manzooraatef-kw2wk
7 ай бұрын
BEST
@preritpandya8050
2 жыл бұрын
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
@odikaconfidence5164
Жыл бұрын
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
@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
@86adiel
Жыл бұрын
7:35 Duplicate Values and how to find them (filter by color)
@AljIsHere128
2 жыл бұрын
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
2 жыл бұрын
I will! Coming soon :)
@alizashakeel4555
8 ай бұрын
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?
@samuelraj5613
Жыл бұрын
Done
@r7amoscoder
5 ай бұрын
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
@saadmultani7251
2 жыл бұрын
Alex we are not able to access 2 videos from the excel playlist....can you please have a look
@peters520
2 жыл бұрын
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
2 жыл бұрын
They should all be there - I do have some in queue for next week
@shayyantashreef5593
2 жыл бұрын
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
2 жыл бұрын
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.
@aimenyaugba6892
2 жыл бұрын
👏
@jasonparness4077
2 жыл бұрын
small editing glitch @9:45 made me laugh idk why Lol.. so like names. Names. So like. So like names. Names.. xD
@rajatchopra1411
2 жыл бұрын
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
@richardhoyle8115
2 жыл бұрын
I thought I'd entered the Matrix at 9:45! Ps great video thank you!
@tbuckyfilms
2 жыл бұрын
hahaha same I thought the video was skipping like a record
@oluyomifadipe5634
2 жыл бұрын
lol a glitch in the matrix
@AkporHari
2 жыл бұрын
Progress. I think the way Alex teaches is just right for me. On to Charts then...
@AlexTheAnalyst
2 жыл бұрын
Super glad to hear that! I try to teach the way I learned it so other people can understand it :)
@Mayaadyby.
2 жыл бұрын
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 :)
@KC-tz6jo
2 жыл бұрын
Thanks Alex, waiting for more to come 😎
@luyesterlucky151
2 жыл бұрын
Hello.. Can I ask why 2 videos are private on MS Excel playlist?
@peters520
2 жыл бұрын
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
2 жыл бұрын
Yeah they are just in queue for following weeks - all the available ones should be there
@Yana-ns5bn
2 жыл бұрын
Special thanks for the Dunder Mifflin table!
@stunninglife5086
2 жыл бұрын
First
@amigoranjan
2 ай бұрын
good information - was waiting if you will also illustrate how to compare more than 1 column for taking out duplicates... Thanks !
@Arsalanzeb
2 жыл бұрын
Before I just used duplicate values, Now I learned something new in conditional formatting and text that contain is also very useful. Thnx Alex
@asomya87
3 ай бұрын
Thank you Alex. One of the best tutorials explaining conditional formatting. You explained it in such a simple manner.
@barackusemckhulin2649
6 ай бұрын
I want to create a growing data bar based on a percentage or numerical value.
@ricardoandresaldana02
2 жыл бұрын
I loved it thank you
@siri_igot7
8 ай бұрын
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 :) ..
@Husseini06
2 жыл бұрын
Thanks you
@MrAyushguptaful
2 жыл бұрын
Hi Alex, If you are reading this. Is this tutorial enough for getting a job as an data analyst? My first job
@michaellillyjr.3044
2 жыл бұрын
Hey Alex, is the course you keep returning to the ALL Excel Essentials Course?
@mikesalazar3637
2 жыл бұрын
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!
@stce1121
6 ай бұрын
Can't say thank you enough for your efforts and kindness
@thalitia1
2 жыл бұрын
thanks!
@polokomonama6526
Жыл бұрын
Fantastic video Alex, Thank you so much!
@onomeebe
Жыл бұрын
Thank you Alex
@saadmultani7251
2 жыл бұрын
Is 8gb ram enough for Data analysis?
@AlexTheAnalyst
2 жыл бұрын
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.
@syedabu7685
2 жыл бұрын
I thank to Allah that I found you in KZitem!! 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!
@kannanps1702
2 жыл бұрын
Made the simplest things very confusing and over complicated
Пікірлер: 107