Introduction to Microsoft 365 Excel & Conventions for Class - 365 MECS 01

Topics in video:
1. (00:00) Introduction
2. (00:14) Intro Song
3. (00:22) Download Files and Create Class Folder
4. (01:45) Change File Extensions in Windows Explorer
5. (02:30) Color Coding Conventions for Class
6. (04:46) Rows, Columns, Cells, Worksheets, Sheet Tabs, Workbooks
7. (06:17) Naming Convention for all objects in class
8. (07:38) Tabs in the Excel Ribbon
9. (08:26) Quick Access Toolbar = QAT. Build Custom QAT
10. (11:04) Navigating through Workbook
11. (12:26) Keyboards: Desktop or Laptop?
12. (13:36) Keyboard Shortcuts
13. (16:41) First Formula: SUM function using a keyboard
14. (18:27) Cursors
15. (18:37) Data & Alignment and how Default Alignment Helps
16. (19:42) Second and Third Formulas yield an error
17. (20:59) Why Default Alignment is important: Fourth & Fifth Formulas
18. (22:10) Default Alignment to track down errors
19. (23:50) Don’t Use Center Alignment!!!
20. (25:09) What Excel Does: Hold Data, Calculations and Data Analysis
21. (27:00) Summary
22. (27:22) Closing and Video Links

#MikeGirvin
#excelisfun
#MikeexcelisfunGirvin
#Microsoft365Excel
#freeclass
#freecourse
#FoundationofExcel
#EfficientExcel
#365MECS01Part2
#365MicrosoftExcelCompleteClass
#LaptopFunctionKeys
#AccessFKeys
#LapTopFkeysnotwork
#LaptopFkeysnotwork.FunctionKeysLaptop
#ChangeSettingforFKeys
#ChangeDefaultSettingsforLaptopfunctionkeys
#RadosławPoprawski
#F2EditMode
#F4CellReferences
#F12SaveAs
#FreeClass
#FreePowerBIClass
#excelisfun
#excelformulas
#excelfunctions
#excelbasics
#excelforbeginner
#excelformulaforjobinterview
#excelforbegginers

[Vandalfoe]

Thanks! Great stuff as usual! I'm looking forward to the rest of the series!!! 8D

[vishnu]

The Man.The Myth.The Legend Mike Girvin!Sir the legacy your videos will create for a generation of students will be invaluable.

[nonoobott]

Mike Girvin is a legend. I started my Excel journey watching this channel. I've learned so much from you. Thanks for being a blessing

[nimrodzik]

Mike...You helped me greatly to flourish my career as a Data Analyst. We are together for more than 5 years now, and I'm still can't wait for your new videos. Thanks for everything. You are my personal hero!:)

[bahar.around.theworld]

I love the way you explain every detail, I think people just forget to press LIKE and SUBSCRIBE bottom, this much effort deserves gratitude🙏

[chrism]

EXCEL-Lent video Mike. Making the world smarter, 1 Excel student at a time!

[raitup]

I can't believe that this is free. Thanks Mike. Your videos are part of my library. Greetings from México 🇲🇽

[abdulhannan-gohl]

I've never seen a teacher like you in my whole life. all of your videos are short and concise. Best of luck and I am looking forward to learning more from your videos. Respect !!

[neogeo]

Thank you so much, Sir!

We citizens of third world countries don't have access to and can't afford quality education but thanks to you, you are making it possible for us as well

[vsrinivasan]

You are our Guru, I have no words to thank, Great Service to Excel community

[DisappointedCat]

what a class. as a beginner this is like finding a gem box. thank you so much

[amekozui]

Excel is something so alien to me... Thank you for explaining this. It feels like I'm doing my first baby step cause this my first interaction with excel

[RikAindow]

I've only just recently begun to delve in to what Excel can do so whilst I'm a bit late to the party, I'm looking forward to working through this series. It looks amazing and very well made. Thank you in advance!

[antique-bsbb]

Excellent as ever. I'm an occasional instructor learning from a master.
For Merge and Centre I find a much better method is
ctrl-1 (Format Cells) -> Alignment tab -> Horizontal drop down box -> Center Across Selection>

That will look the same as Merge and centre but the data will still be in the left hand cell and all the others are empty.
Columns can be selected and all the other problems of merge and center disappear.
So you get the finish of a final report and the usability you need.

[richardhay]

You hit the Target!! You promised 6/29/22 at 6:00 AM PDT and you hit it! You were brave enough to take the RISK and violate the Number One Rule of Forecasting: Give 'em a Number; Give 'em a Date, But NEVER Both at Once!!

[waitplanwp]

boom, the journey is started. good luck mike you are the best!!!

[williamarthur]

As someone who likes my keyboard more than the mouse, this was a really good refresher and intro to some things I 'd never known.

[rolandolau]

Thanks from the bottom of my heart, You are always my teacher and I never stop learning from you.

[nagizadeorxan]

Here is come to another lesson series, I love it from the begining. I am looking forword to see the rest!

[istdrive]

Love it i hope this will help me in my career as a charted accountant and also in freelancing while studying. THANKS A LOT