MS 365 Excel Basics #1 What is Excel?, Formulas, Functions, Formatting, Cell References & Page Setup

[@excelisfun]

I added a homework/practice problem to the end of the downloadable file : ) It is fun to practice and gives you even more power with Excel : )

[@sandipsingh25]

I am from India and this is the best video on excel basics. Period! Thank you so much.

[@IkhlaqAhmed-w3f]

IF I HAVE LEARNT EXCEL TO SOME EXTENT ITS BECAUSE OF YOU. HAVE RECOMMENDED YOUR CHANNEL TO HUNDREDS.

[@klarawijs]

Not a beginner, but I will watch just to hear you explain and you never know what tricks I can pick along the way. Thank you so much, Mike!! ❤❤❤

[@excelisfun]

It should be a fun story, even for Excel pros : ) : )

[@alhaitham_v]

Me too! Thank you so much for this video, Mike. Hope to be a pro like you someday :)

[@excelisfun]

@@alhaitham_v You will be!!! This class that I will release over next two months will definitely help you on your way! Just be sure to have fun and it always seems to work out : )

[@gumbonii]

This is so wonderful! I am an English Lit graduate seeking positions outside of the literary world, so I've never had to touch Excel much. Only 33 minutes in and I feel as if I am unlocking a hidden key to the Universe. Thank you so much for your dedication!

[@excelisfun]

Yep: it is not overstating it to say that one of the keys to the universe is knowing Excel well : ) : )

[@DirkOutdoor]

Dear Mike, even if I consider myself for an advanced Excel user, I enjoy watching all your classes starting with the basis, fixing my knowledge and maybe learning some tiny things I didn't notice that way before. Thanks for all, best wishes for 2025 and many greentings from Koblenz, Germany to you and your family! Dirk ❤

[@excelisfun]

You have been a long time Teammate here at the excelisfun channel!! I am glad that my story telling, even in the basic classes continue to reveal small details. It is the same for me when I create each class : )

[@victorgarzao]

Hi Mike, Every time you make a video explaining the basics of Excel, you add exceptional value by incorporating information about functions and new features in a uniquely effective way. While there are many good, and even excellent, Excel instructors on KZbin, in my opinion, you stand out as the best among them all. I wanted to express my gratitude for your outstanding content. Starting today, I've decided to become a member of your channel to support your work. Thank you for your dedication to teaching Excel!

[@excelisfun]

You are welcome for the dedication, victor!! I have spent 25 years trying to refine the stories that I tell to teach Excel. I have had so much fun doing it. Thank you for your kind words and thanks for being a member : )

[@chrism9037]

Yes! Beginners to Excel will love this Mike! Thanks for all you do for the Team!!

[@excelisfun]

You are welcome, Most Amazing Teammate Chris M!!! In this video #1 I even covered dynamic spilled arrays and BYROW ; ) The new world of basic.

[@jean-phillipecremasco2560]

You are amazing. Thank you for making this available to us and easy to understand!

[@FlowerFestival]

you are the best teacher EVER ! ! ! ! ! !

[@excelisfun]

Thank you, Flower Festival!!! : )

[@mohamedamin3393]

I love this, MVP Mike teaches from the heart. Very inspiring. As the saying goes; “The mediocre teacher tells. The good teacher explains. The superior teacher demonstrates. The great teacher inspires.” William Athur Ward

[@excelisfun]

Thank you for your very kind words : ) I am happy that my story telling is inspiring. I know that I am having fun ding it : )

[@mohamedamin3393]

@ as always , excel is fun with you.

[@peppermintdaises]

Love the way you teach. Thank you for this free and accessible tutorial!! So grateful

[@excelisfun]

You are welcome!!! Happy to help with the fun in Excel : )

[@ExcelUnlocked]

My Favorite MVP, all the love Mike. I believe you are THE inspiration

[@excelisfun]

Thank you for the love, ExcelUnlocked!!!! I just try to have fun and make our Excel Team great!!!!

[@realtoast7036]

Thanks!

[@excelisfun]

Real Toast SQRT(49,505,296), Thank you so much for the kind donation : ) : ) : ) It really helps! Are you new to Excel? Are you using MS 365 Excel? How was this video for you; what did you learn?

[@realtoast7036]

@@excelisfun Not new. You've been my go-to for many years. Even bought the big book. I am having my team at work go through this 365 course. I felt honored to pay for it. There's just so much good stuff. Anyone who enjoys problem solving, puzzles, and 3D thinking would love this.

[@realtoast7036]

@@excelisfun Not new. I appreciate the mass of information here. Especially the quick keyboard shortcut tips. I'm in sales and use Excel everyday. Good use of Excel is a magic trick to 99% of the world. I learned this back in the very early '90s, when to learn formulas and everything else, I had to refer to that paperback book that used to ship with the application box.

[@excelisfun]

@@realtoast7036 Awesome! I learned back in the 90s too : ) Enjoy the free videos and files!!

[@michaelbrown8821]

My hero, cos you make excel fun! This is going to be so helpful for so many folks. You've brought me far in 10 years, Mike! I am hoping you will remake some of your most complicated tricks with the new dynamic array formulas. Something to think about. 😊

[@excelisfun]

Thank you for hanging out for 10 years and having fun with Excel with me and our Team!!! The next two classes that I am making are Excel Basics and Finance With Excel. I have made a bunch of videos that show how to use the easier 365 formulas and functions to create many of the complicated formulas that I have posted about in the past. What are you looking for in particular? I am excited to do this Basics class where, even in this video #1 I get to teach dynamic spilled array formulas and even the BYROW and BYCOLUMN functions : )

[@sujeetsamal]

A true teacher...in his own world of creativity... Thanks for your continuous effort 🙏

[@excelisfun]

You are welcome!!! I am happy to still try and create stories to make Excel fun : )

[@johnborg5419]

Thanks Mike. Watching the video now, even though that these are basics , I always enjoy to hear your explanations :) By the way, I hope that Microsoft came to there senses and gave you your much deserved MVP recognition!!!

[@excelisfun]

You are welcome, Formula Guy John!! It is fun for me also to try and explain the basics : ) No, Microsoft will not come to their senses because I no longer fit their criteria for what an MVP is. It's all good: Go Team!!!!

[@kuddusiboztas1998]

altough i have been using excel for 2 years i have learned a lot from this video. Especially those shortcuts you gave will be great timesaver for me. thanks a lot.

[@kuddusiboztas1998]

27:20 i agreee :D

[@excelisfun]

You are welcome!!! Keyboards rule : ) : )

[@adwaitetiwarycfa7087]

Great job, Mike. I learnt so much from your previous series on Excel. Looking forward to the Excel 365 version!

[@excelisfun]

I am glad that you learn so much!! This 365 should be even more fun : )

[@Excelambda]

His Majesty Virtuoso Profesor at work. Great Video our Highness MVP!!✌

[@excelisfun]

Thank you, amazing Teammate Excelambda (wm) : ) : )

[@barttitulaerexcelbart9400]

Hi Mike, nice to see you back! Nice and comprehensive introduction. If you use the Excel files, you don't have to enter manually the marks, but I tried "Insert data from picture" and that worked also...😉

[@excelisfun]

Cool, my friend!!! Insert data from picture is sorta like AI: you never quite know what you are going to get lol

[@aliadeli7799]

amazing, good teaching

[@GkK-to3jr]

Thank you for this basics course.

[@excelisfun]

You are welcome!!! Basics are fun : )

[@zachhom8947]

Love this. Insanely insightful I had basically no excel experience before this. When is the next video coming out??

[@excelisfun]

I am working on the video now. A few days : )

[@kiwikiow]

I got many cool tricks from this video. Thank you Mike 🙂

[@excelisfun]

What tricks did an Excel Master like you learn?

[@kiwikiow]

@@excelisfun I learned about ctrl + * keystroke, data entry in pre-highlighting range, ctrl + selected worksheet to copy it. I'm an Excel user not master. There are many new things to learn. 🙂

[@excelisfun]

@@kiwikiow I love it!!! You got to learn a few cool things : ) The new ghost showed up too!

[@NikhilRawat-ou4tl]

Amazing Sir the way you are speaking it feels like I hearing story 😊

[@excelisfun]

You 100% understand what I do. For 25 years of teaching I have always said: Good teaching is story telling. That's it. But creating a great story is like creating great art: no extraneous elements and everything much be in the right order. Very hard to do, and it takes a long time. But I have been practicing for 25 years. For example, after 25 years, this video took 90 hours to create. And that is fast.

[@excelisfun]

I am so glad that my stories help you!!!

[@marykiandokajoka8703]

Fun Fun Fun :) Go Team !!! Great video with wonderful things to learn :)

[@excelisfun]

Thanks, Teammate Mary : ) Go Team!!!

[@excelisfun]

P.S. You posted Dynamic Spilled Array Basics Video before me : ) : ) : ) Go Team!

[@marykiandokajoka8703]

@@excelisfun that is because I get to work with you and learn from my all time MVP 😍😍😍😍

[@DarrenJHR]

This video is great I just wish the whole series was out already! Do you know when youll have ep2 ready? :)

[@excelisfun]

There should be one each week for next few months : ) The next one will be out in about two days!!

[@karolinab9749]

Thank you!😊

[@excelisfun]

You are welcome, Karolina!!!!

[@Faisal63045]

=IF("The Godfather of Excel is Here!","Amazing Video!")

[@excelisfun]

Thanks for the clever comment : ) : ) : )

[@ninmnisaha]

Thank you so much sir.

[@excelisfun]

You are welcome!!!! More fun to some in this class : )

[@GpcHosur]

Sir kindly upload the other videos soon the dynamic array functions are so useful and fun to learn

[@excelisfun]

Here is a video that has all of array formulas and array functions: Excel Array Formulas & Functions: 50 Examples of How to Become an Array Expert! - 365 MECS 09 kzbin.info/www/bejne/bIvRgId9oNGJqbc

[@Surachetphunsawat]

Excelence thank you

[@thamilanban]

Hello Sir, You have helped me a lot. Thank you. If possible could you please start a series on Python in Excel? Thanks again.

[@excelisfun]

No python for me. But I will create this Excel Basics class and then a Excel Financial Analysis class : )

[@deborahz8735]

Hi Mike first of all thank you so much for your videos! As a slow learner I've really been enjoying this series :D Just a quick question tho to understand a little better: at the 54:00 timestamp where you showed us the average function, I got 1s on the %Grade columns and a 4 in the Decimal grade column instead of the numbers you got. If you have the the time I'd love to know what I got wrong lol cause I'm afraid of just editing those cells as a newbie. Thanks in advance!

[@excelisfun]

Did you use ROUND and round to the ones position by using zero? 4 should be in the second argument of ROUND.

[@excelisfun]

Also, when in doubt, delete and start over : )

[@ERACreative-u6i]

Nice

[@excelisfun]

Glad you like it!!

[@hhattingh]

Good day, I bought the book 'The only APP that Matters" and was wondering if there were any accompanying videos?

[@excelisfun]

Not specifically. But my MECS class covers all in the book: kzbin.info/aero/PLrRPvpgDmw0nre_bTeBfJWjrnixKoyNtW

[@TurboTeen29]

I don't know why I'm here but I'm here because mike is MPV for me

[@excelisfun]

Thanks for stopping by, Turbo Teen!!! Can I guess why you are here? The fun, right ; )

[@TurboTeen29]

@excelisfun offcourse because Excel is fun

[@som8760-y7f]

Please include the following two topics in a detailed manner in one video: 1. Complete usage of Solver 2. Custom formatting in Excel in single video

[@excelisfun]

I have a complete set of Solver video in this playlist (#57 - 63): kzbin.info/aero/PLrRPvpgDmw0mSJCZaqQPFj0eto4qnzkCZ You will not be disappointed : )

[@excelisfun]

For Custom formatting, I have a playlist too: kzbin.info/aero/PLrRPvpgDmw0k3Tjz55OfgvaR0ourukzvG

[@boldonger]

very helpfull video only thing is for me the control + semicolon doesnt work for the current date (EU) any tipps on it?

[@grandhebi]

Hi! my Excel version does not provide a list of available functions when using BYCOL or BYROW. However, I managed to make it work by using the LAMBDA function to specify the desired operation. Here are the formulas I used: Row SUM with BYROW: =BYROW(C8:J13, LAMBDA(row, SUM(row))) Column Average with BYCOL: =BYCOL(C8:J13, LAMBDA(col, AVERAGE(col))) 😎😎

[@excelisfun]

Very good! Thanks for the hot LAMBDA tip : ) LAMBDA is too advanced to show in the first video of a basics class. However, I have many other videos on this topic. In case you want to check out my epic 1.5 hour advanced video on LAMBDA, here is link: kzbin.info/www/bejne/ham5Xnlmq72dbqs

[@ricardo5178]

What is the difference between MS365 Excel Basic vs Excel MECS?

[@excelisfun]

MECS has every single possible thing about Excel, Power Query and Power BI. It starts at zero like Excel Basics, but it moves fast and is very packed with every possible nugget of Excel coolness that there is. If you really are brand new to Excel, go with Excel Basics. Please also go to my excelisfun KZbin home page and watch the 2 minute intro video that explaines it all: kzbin.info kzbin.info/www/bejne/bmK6ZniQn9yHp80

[@taniavallorani9336]

Great video !! I'm going to practise every day until i become an expert :P the CTRL+ARR DWN ===>or ARR UP

[@excelisfun]

The web version is missing many features, especially when we get to the second 1/2 of the class and study Data Analysis. THE only version to have is MS 365 Excel. No other version is even close. It is worth the money by far.

[@HappyFamily-.]

Is this usefol for a beginner in learning Excel ?

[@excelisfun]

This is for beginners who want to learn Excel : )

[@sabirkuliev5313]

Hi, is your "Excel Basics Free Course" from 7 years ago applicable for Excel 365? Thank you!

[@excelisfun]

That class is amazing if you have never done Excel before : ) The one thing it does not cover is dynamic spilled array formulas. For the above video and the related class, I am still posting videos, and it is the most up to date class, but it will be about a month before most of the videos are posted (I am still working to make all the videos for this class).

[@sabirkuliev5313]

@@excelisfun Thank you!

[@sabirkuliev5313]

Watched almost the entire playlist, was very helpful. Now I will watch this one and practice. Thank you once again!

[@codingjhames]

i don't know if is a issue from Excel on windows 10, but in this particular moment from the video 30:07, i can't see that little options menu to select about the days of the week, i tried on MS excel online and doesn't appeared too.

[@excelisfun]

I wonder if smart tags or Ctrl options are turned off in Options?

[@codingjhames]

@@excelisfun i made some practice and suddenly the options appeared as you in the video

[@M_A_A2301]

Hi and Huge Thanks for this Video ! Why when i put =BYROW(C8:J13;SUM) and press ctrl enter, it show me this Error : #VALUE!

[@excelisfun]

Huge you are welcome! BYROW is brand new and MS had not released it to all yet. Soon, I hope. But MS timeline is never predictable.

[@M_A_A2301]

@@excelisfun thanks for your reply ! what should i do to make it work ? any other option ?

[@M_A_A2301]

@@excelisfun Okay ive open a new excel file, copied the table name, delet the Total Value and did all the steps and it worked! but in my Gradebook sheet it doesnt work !! 😅

[@smonkey86]

When doing the Weekdays for dates it didn't go to next weeks dates for Monday but it did for Tuesday and onward. Then when doing the %Grade my column didn't autofill so I tried dragging down the angry rabbit and it gave me those Div/0 errors like when we didn't lock in the k5 cell. Any Ideas?

[@smonkey86]

Spill worked after an update but the Weekday part is still wrong

[@excelisfun]

@@smonkey86 Are there hidden columns or rows? You can tell if the column letters or row numbers are not in sequential order.

[@dhirenpippal8532]

sir i don't have byrow and bycol function how do i add them? i have got a standalone excel version and not MS365, please help

[@excelisfun]

It is only in 365.

[@johank4361]

Pls get me a Formula to count meals (breakfasts, lunches & Diners) between 2 dates in different columns i.e 20/11/2024 Diner to 24/11/24 Breakfast BF (Column) 4nos Lunch (Column) 3nos Diner (Column) 4nos If you give me a solution i will be very greatful.

[@jorgealfredocarvalho]

Why do you nead a hed? Good by

[@excelisfun]

I am not sure what you are asking. Can you re-ask the question?

[@johank4361]

Pls get me a Formula to count meals (breakfasts, lunches & Diners) between 2 dates in different columns i.e 20/11/2024 Diner to 24/11/24 Breakfast BF (Column) 4nos Lunch (Column) 3nos Diner (Column) 4nos If you give me a solution i will be very greatful.

[@johank4361]

Pls get me a Formula to count meals (breakfasts, lunches & Diners) between 2 dates in different columns i.e 20/11/2024 Diner to 24/11/24 Breakfast BF (Column) 4nos Lunch (Column) 3nos Diner (Column) 4nos If you give me a solution i will be very greatful.