Excel Basics 8: Default Data Alignment In Excel & How it Can Help

[@mcloughman]

These videos are the real way to make a nation great again.

[@excelisfun]

You are correct about that, and it can be taken one step further, we humans have an innate duty to try and make the world a better place: all of us : ) Since I am good with Excel this is my small attempt at trying to make the world a better place, for free!!!!

[@ZsoltPal23092011]

Visual clues..now there is thing! I have never ever spent a moment of thought as to why thingies, bits and bobs and stuff are aligned differently in Excel. Thank you again for a really useful video!

[@excelisfun]

You are welcome! Thank you so much for your consistent support with comments and Thumbs Up : )

[@Nyuklehead]

You're classes have helped me so much already and I can't thank you enough. These homework assignments would have taken me hours to finish before and now I'm knocking them out in a couple minutes.

[@excelisfun]

There you go. You go it. If you can assimilate the lessons I present, the work world is a MUCH faster and easier place! Good for you for studying and working hard to become awesome with Excel, Nyucklehead : ) : ) : )

[@Lightemuphomie]

These lessons have been really helping me at my current job in data entry. I finished college a year ago, but I want a career in data and numbers of that sort instead. I'm only on lesson 8, but excel has been so fun to learn. Thank you for the excel lessons!

[@excelisfun]

I am glad that the lesson help : )

[@phoomyatpwintsan2005]

Thanks again, sir. I promise that I will watch all videos from this channel start from now.

[@beckyb8929]

THANK YOU! I have been wondering how to modify default alignment for years! I "skimmed" through this video because you were talking sooo slow, then realized I had set youtube to slow down cause I was trying to learn spanish. haha! Nice clear info, thank you for saving me additional aggravation.

[@excelisfun]

Glad it helps at a faster speed now : ) Thanks for always clicking Thumbs Up and leaving a comment to help support the excelisfun channel : )

[@tennispie1]

Best teacher ever. I love you

[@excelisfun]

Thank you for your kind words! I love you too, that is why I post the videos for you and the rest of our Team : )

[@aamir_curious]

i'm loving it prof!

[@excelisfun]

Yes!!!! loving Excel is a great skill to have!

[@seonlofters3778]

Thank you so much for this course...I thought I knew excel turns out I was a novice. You're and excellent teacher and I definitely plan to take your entire MS Office Course!!!

[@excelisfun]

You are welcome so much, Seon!!! You will learn a lot in the full 25 video class and have fun too!!! Here is the full playlist: kzbin.info/aero/PLrRPvpgDmw0n34OMHeS94epMaX_Y8Tu1k And don't forget to do your part and comments and thumbs up on each video and click that Sub button : )

[@MonirulIslam-zj3ve]

Sir, Your every video is more than excellent. I am so confident that there is no other advanced tutorial and trainer like you. I am not interested to follow any other trainer's tutorial if you have tutorial in which I am interested to learn. If it is possible, I will give a lot of Thumbs Up in every of your videos. We need trainer like you to make the world more better. I usually suggest to download and follow your videos whoever want to learn excel meeting with me. Thanks a lot to keep love and patience in your teaching field.

[@excelisfun]

Glad you like them! Thanks for the support with your comments, Thumbs Up and Sub : )

[@curiouscollectiblesAU]

Hey cheers for these Mike. For anyone interested, the true and false are known as booleans in programming. The application of which is not fully known to me yet. Also, you can negate those booleans, as well as any formula from registering, by prefixing it with the apostrophe mark ‘ eg. ‘=count(). That is what comes up on the error when formulas have errors. Nobody reads errors dialogues so there you go. 😅

[@brianxyz]

Is three videos in one day the record? Thanks for all of the great tips and reinforcement of the basics. I love that you put your keyboard shortcuts on the screen as they have been invaluable in learning them and then applying them. They make a huge difference!

[@excelisfun]

Glad it helps! It makes a huge difference for me when you comment and Thumbs up : )

[@ismailismaili0071]

this video looks like it's something easy but it's really important many times we get problems with formulas just because of the cells are not in the normal mode and that lets us be so upset about why the formula is not working so thanks again these are really the great videos that lets us be careful about anything we are working on

[@excelisfun]

You are welcome!

[@kzern]

Those are important tips. Thanks for sharing 👍

[@excelisfun]

There are very important! You are welcome for the share, K. Zern!!!

[@JJ-yv3xc]

Best free tutorial ever.

[@excelisfun]

Glad you like it, Jia!!!

[@mohamedchakroun4973]

Very well we are glad to have a teacher like you

[@excelisfun]

Thanks! Great to be part of our Online Excel team!

[@milenaarsic8393]

I can't thank you enough for everything. Your classes helped me a lot in mastering excel! T

[@semperdiscendum7439]

Awesome! Please keep the stuff coming! Teach us more! 👍👍👍👍

[@excelisfun]

I'll keep it coming if you keep watching and thumbs uping : )

[@iamhassankarimi]

Love you man

[@sellahjemutai7664]

Great Tutor with lots of in-quantifiable content.Thank you Mgirvin.

[@excelisfun]

You are welcome, SELLAH!!!

[@mohamedamin3393]

Education breeds confidence. Confidence breeds hope. Hope breeds peace.- Confucius

[@nabilnabil1824]

wow ,thx for the quote

[@maths4all726]

Data alignment is Fun. Liked the video.

[@excelisfun]

Yes!!! Thanks for the support, Maths4All : )

[@Monukumar-ze4os]

TRULY A GEM. THANK YOU.

[@kashmirgill9973]

I get so frustrated with formula's and why they sometimes fail to work. This simple "basics" video is the answer to many of my issues. Because of this one video I've decided to work through all of your Excel Basics modules.

[@excelisfun]

There is NO doubt, that if you know the fundamentals, frustrations transforms into happy efficiency. The 25 videos in this series are the result of 20 years of teaching. I hope they will help! Thanks for the support with your comments, Thumbs Up and Sub : ) Please tell all your friends and colleagues to come and learn for free at KZbin : )

[@AbhishekSingh-ju6tq]

I am amazed why you are not charging any fees for this excellent course because if somebody offered this course in India I definitely say he charge huge money for this course

[@excelisfun]

It has been my mission for 11 years here at KZbin to provide free education to the world. My intent is to make the best education and give it away for free : ) However, Abhishek, it is not really free because I do ask that you pay for each video with a comment and thumbs up. If you do that, you support my cause and promote the videos so that more people who would like free education can get it! Thanks for your support, Abhishek!!!!

[@playlistyee8099]

Keep up the great work!!!! Very useful videos

[@DaveDalton-sd3jj]

Bless you! 🙂

[@mostafaahmedzein450]

Another great lesson to learn like always! Thanks Thumbs Up!

[@excelisfun]

Glad you like it, Mostafa!!!! Thanks for your consistent support : )

[@TikFunTok-bx5uw]

Very useful video

[@excelisfun]

Glad that it is useful !!

[@yhbukhari]

so much better with 1.25x the normal speed.

[@akhtaruzzamanjoy8524]

when I rewatch the video for practice, I watch it with 1.25 speed!

[@chandu7spark]

Informative. I never observed that much particulary the SUM function is not working if numbers are there in Text Alignment. Tanq once again sir.:)

[@excelisfun]

Yes, those text numbers just don't add up in SUM ; )

[@shubhampawar8506]

Thanks a lot 😍 great vedio

[@zveringaable]

Thanks!

[@excelisfun]

You are welcome, Yew!!!

[@kisslaci36]

thanks again. feel like I am really learning. it will be interesting to see how I'll cope with some of the more advanced videos I watched before starting this basic 25 video tutorial after I watched this series :)

[@excelisfun]

This series covers all the foundations of what you need in Excel. Thanks you for your continual support of my efforts here at excelisfun. kisslaci36 : )

[@guymagen1944]

Great stuff! thank you again!

[@alamine6214]

thank you man

[@excelisfun]

You are welcome!

[@nateleroy5219]

Hi Professor, quick question - For those working in countries with who follow the European date model of Day/Month/Year, how can I have my dates be aligned to the right? Going off of the example you used, if I wanted to enter February 14, 2022 as 14/2/2022 and have it right aligned? These videos are all extremely helpful and them being free makes it all the better! Thank you!

[@excelisfun]

You would have to change the default settings for date in Control Panel, Regional Settings

[@AoiTodo998]

if i finish this course , what i study next from your channel? which playlist you advise me to start next

[@excelisfun]

This is video 8. There are 25 in this class. Did you watch them all? Anyway, Advanced Excel is next class. I hope you are subbed and have been to my home page where all my classes are listed. Otherwise, go to my home page: youtube.com/@excelisfun Advanced class is number 4. But you should probably watch the autoplay video on my home page, which a 2 miniute introduction to my channel - it will show all the various classes : )

[@vikrammalhotra6891]

Hi, great video! I had a query - I could not understand the part where you click on the cell and it moves to the above part. Also, I cannot see this tab by default in my ribbon - I have to click on cell styles. Is there a workaround for this? Also, I am able to still add the numbers despite text and left aligned formatting, I think - what am I doing wrong?

[@wajirawijesooriya7333]

Great, thank you with love (:)

[@excelisfun]

Thanks for the love. Glad the videos help, Wajira!!!

[@andreacarr3199]

I love changing formats...guess I'll have to get out of that habit when working with data sets :)

[@excelisfun]

Yes!!!! : )

[@julianjam]

When I did the HW2 pivot table task, the sorting order of names could only be sorted as ascending/descending alphabetical order. How can I set them to sort like the way you shown in the answer?

[@gauravsharma-ws2xo]

Fantastic Videos. In the video 8, for the HW8, while using the pivot, the names of the Sales Rep are always displayed in the ascending alphabetic order. How to display the names of the sales rep, in the same order as they are defined in the question? thanks .

[@nabilnabil1824]

thank you , Teacher really appreciate it ^^ ^^ ^^

[@amehziishike4061]

Hello, Mr Mike, in the 3rd homework on excel basics 6-8, how did you get the sum of sales? i couldn't get it. every time i placed the sales in the field, it just shows count of sales and not sum of sales. please is there something I'm not doing right? M

[@bavajikj3267]

good work, appreciate it

[@excelisfun]

You are welcome, thanks for the consistent support - it is good!

[@mailfiroz]

Hi sir, Your videos are interesting to watch and I am learning a lot from the exercises. In this homework exercise, in the HW2, when i create the pivot table in a new sheet, the values are matching but the order is not matching. Mine is coming from A-Z, whrereas in the HW(AN) sheet it shows "Jeremy" as the first name. Where am I going wrong?

[@swimfit57]

How did they get to get the numbers to align wrong plus the Text?..

[@paulpiket6757]

First, I have to echo all the comments about how well-done these videos are, and how much I'm learning. Thank you! I have a question about Homework 2 on this one: for my PivotTable, the SalesRep names are in alphabetical order (by first name, of course). On your answer sheet, the names are in the order in which they appear in the data set. (By comparison, in Video 5/Homework 2, the order of the SalesRep names appears to be random -- no pattern that I can discern.) I know the sort order can be changed once the PivotTable is created, but does the process that creates a PiviotTable have a method for ordering the data, and a way to change that method? Thanks.

[@excelisfun]

PivotTable Row Area items always come sorted. You can change it if you want.

[@excelisfun]

Thanks for the support with your comments, Thumbs Up and Sub : ) Please tell all your friends and colleagues to come and learn for free at KZbin : )

[@siddharthsatpathy2443]

Hello, Thanks a ton for all the videos you have created. I am learning a lot. I have a question regarding home work no:3 in this video and I apologise if you have already answered this question. The third home work requires us to clean up the data and then prepare a Pivot table. However when I compare my work against your answer there is a discrepancy in the sales total. It looks like numerical count is 23 while the total count is 25. It appears that I am missing something. Any suggestions? Thanks Siddharth

[@alialbayati9368]

Thanks for this tutorial.

[@excelisfun]

You are welcome!

[@ndelpurg]

MANY THANKS GREAT TEACHING

[@excelisfun]

Many "you are welcomes"!

[@ahmedali-oi9wv]

Thanks for this tutorial

[@excelisfun]

You are welcome, ahmed!!!!!

[@Nikol0zi]

And again! thanks!

[@excelisfun]

You are welcome again, Nika!!! Thanks for the support with your comments, Thumbs Up and Sub : )

[@jrpeyas4038]

Nice

[@excelisfun]

Glad you like it!

[@anandsrivastava5887]

can anyone help me in EB8 HW3 Date formatting? Do we need to do it manually or is their any formula/shortcut to arrange dates in proper format?

[@thamgiang7975]

Hi! Can I have a quick question? In this video, there are some data that is not aligned with default alignment. You didn't show how to fix it yet, right? Cause in the HW3 exercise, we are supposed to solve that manually? Is there any quick ways? Hope to hear from you soon. Thank you!

[@excelisfun]

In Excel you can remove the formatting and get back to the default by going to Home Ribbon Tab, Editing group (all the way on Right) and click the Clear dropdown arrow, then click on Clear Formats.

[@excelisfun]

Thanks for your Thumbs Ups and Comments on each video that you watch : )

[@Simlaoui]

intersting video THUMBS UP! awesome . thank you for your awesome.

[@excelisfun]

You are welcome!

[@obigariharitharoyal3659]

Hi sir, how to download homework files? There is no link provided.

[@excelisfun]

The link is below video at KZbin. Click ...more in the description. : )

[@alyssamcwhorter7905]

Love the idea of not formatting cells to be centered in the formatting. I am usually a "center-aholic". This may sway my thinking. Thank you!

[@excelisfun]

You are welcome!!! No more centeraholic!!! Thanks for the support with your comment, Thumbs Up and Sub : )

[@Whyvardhann]

Awesome!

[@excelisfun]

Glad you like it! Thanks for your support : )

[@239ubaidullahkhan7]

I found you , it my luck 🤞

[@ionescudan9784]

Hi. I've done exercise HW2 from lesson 8, and in my pivot table the names were put automatic in alphabetical order. In your homework answer is not. Why is that happening ? Thx.

[@lavitaneja4161]

Hi, Mike thanks for the videos i have learned lots of things form these. just one request as i could not find any on youtube can make some videos about google spreadsheet if possible.

[@excelisfun]

No I can not. I know nothing about Google Sheets : (

[@lavitaneja4161]

okay! Mr. Mike. appreciate your being very honest.

[@excelisfun]

Always : )

[@arpitsrivastava9400]

you are great

[@excelisfun]

I am glad you like the videos, arpit!!!!

[@BK-kp6rr]

Thank you!

[@excelisfun]

You are welcome! Thanks for the support with your comment, Thumbs Up and Sub : )

[@Erkhil_khan]

👍👍👍

[@johnborg6005]

Thanks Mike

[@excelisfun]

You are welcome!

[@Kidvicious707]

download links not working :(

[@ScooterMcGraw]

Links taking to EB06. Doing it on number 7 too.

[@excelisfun]

All three pdf files are in that one pdf file. If you download it you will have all three pdf files.

[@faiyazsharif6416]

Thank you

[@excelisfun]

You are welcome, faiyaz!!! Thanks for your support with your comment, Thumbs Up and Sub : )

[@chrisbishop1969]

Can you make a video about how to make Delta E values for color? I have the equation but i have no clue how to transfer it to Excel.

[@excelisfun]

No I can not. I know nothing about Delta E values for color. : (

[@pmsocho]

Thumbs up!

[@excelisfun]

Thanks foe the Thumbs Up, Teammate : )

[@bigjuicefolife]

After we do the basics videos, what should I do next?

[@excelisfun]

Here is adavcned playlist: kzbin.info/aero/PLrRPvpgDmw0lcTfXZV1AYEkeslJJcWNKw Here is the 2 min. intro. video to my channel that shows you all the important playlists of videos that you may want to choose from: kzbin.info/www/bejne/omKQYpSMnKunnpY

[@excelisfun]

Let me know if you need more guidance in finding the videos.

[@scottdoerner1784]

Just a funny bit of trivia, 14/2/2017 is the proper setting for date "feb 14 2017" in europe, Australia, Brazil, and several others. (dd/mm/yyyy)

[@excelisfun]

Yes, indeed, on the computer I use that would be test, and if you used the dates mm/dd/yyyy it might show up as text on your computer. Thanks for watching and supporting, Scott!!

[@tocodelray]

Thumbs up

[@excelisfun]

Thanks, tacodelray : ) : )

[@nareshnani7333]

Couldnt download

[@excelisfun]

I just checked. The links seems t o be working. I am not sure what is going on.

[@nareshnani7333]

@@excelisfun plz can u share the notes of excel to my mail I'd please... [e-mail]

[@Kizo_55]

Thank you!

[@excelisfun]

You are welcome, Kizo! Keep going : )

[@Erkhil_khan]

👍👍👍

[@excelisfun]

: ) : ) : )

[@SyedMuzammilMahasanShahi]

Thanks Mike

[@excelisfun]

You are welcome!