EXCEL
페이지 정보
본문
Microsoft Excel Tutorial - Beginners Level 1
Want more Excel videos? Here’s my Excel playlist: https://www.youtube.com/playlist?list=PLmkaw6oRnRv8lAKbKbflJRqS-9wuYNWUw This video tutorial will show you how to use Microsoft Excel for beginners. Microsoft Excel is a powerful spreadsheet tool that is part of Microsoft Office. This is a detailed beginners tutorial, the below timestamps will help you navigate through the lessons that are covered. Looking for more? Let me know in the comments below what types of things you would like to learn in Microsoft Excel.
Intermediate Microsoft Excel Lesson 1:
Dive deeper into formulas and functions in excel with this playlist: https://youtube.com/playlist?list=PLmkaw6oRnRv_GeQNcc_hHtnxbRC7gDLST
Creating Charts in Excel:
0:00 Start
1:07 Starting up
1:27 Recent documents and pinning documents
1:54 Templates
2:34 Layout - Tabs, ribbons, and groups in Microsoft Excel
3:48 Rows, Columns, Cells and Ranges
5:49 Worksheets in Microsoft Excel
6:52 View and zooming
7:30 Inputting Data
10:56 Formatting Data
13:38 Wrapping Text
14:22 Insert Row/ Merge \u0026 Center cells
15:41 Currency formatting
16:20 Print view
17:02 Add cell borders and colors
18:18 Basic formulas in Microsoft Excel
21:17 Copy formula
23:45 Freeze Pane
24:52 Basic Microsoft Excel functions
28:59 “Tell Me” in Microsoft Excel
29:43 Inserting charts in Microsoft Excel
Excel for Beginners Tutorial - Level 2:
Excel for Beginners Tuotiral - Level 3:
Excel for Beginners Tutorial - Level 4:
Microsoft Excel for Beginners - Level 5:
VLOOKUP Function for Excel:
Learn Pivot Tables for Beginners:
10 Best Excel Beginners Tips: https://www.youtube.com/watch?v=ZthlSLYc5UQ
Make a Line Graph in Excel: https://www.youtube.com/watch?v=0jdX22qM8JA
I use Camtasia to create my video tutorials: https://techsmith.pxf.io/KYOeN
DISCLAIMER: This video and description contain affiliate links, which means that if you click on one of the product links and end up purchasing it, I’ll receive a small commission. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
Teacher's Tech : Looking for more? Here's a level 2 Excel tutorial for beginners:
Brea Evans : I lied on my resume, got the job, now I'm here
Abdelali Lahlou : can we just take a moment to appreciate this guy for providing this type of content for free ? great help, Thank you sir!
Fjøra : Honestly, this 33min video alone was more helpful than 16 years of schooling when it comes to Excel.. And the in depth and professional way you explain everything truly makes it both easy to understand and enjoyable! Thank you! - Part 2, here I come!
Olivia Keach : I've never been so actively engaged in a tutorial video before. This was EXTREMELY helpful. Pacing was perfect, information was clear, and it was presented in such a way that I didn't feel like there was any unnecessary repetition or need to skip ahead. I'm so glad this exists!
Microsoft Excel Tutorial for Beginners - Full Course
Lean how to use Microsoft Excel from the beginning by creating 6 real-world projects. Most of the content applies to Google Sheets as well.
You will learn how to
- enter data,
- navigate through a spreadsheet,
- create formulas to solve problems,
- create charts and graphs,
- understand relative vs absolute references,
- import and export data,
- implement VLOOKUP,
- use pivot tables,
- split and concatenate text,
- and more.
✏️ Course developed by Shad Sluiter. Check out his YouTube channel: https://www.youtube.com/user/shadsluiter
⭐️ Course Contents ⭐️
⌨️ (0:00:00) Intro
⌨️ (0:04:14) Payroll
⌨️ (0:39:35) Gradebook
⌨️ (0:57:22) Decision Factors
⌨️ (1:04:40) Sales Database
⌨️ (1:23:13) Car Inventory
⌨️ (1:59:29) Problem Solving Templates
⭐️ Special thanks to our Champion supporters! ⭐️
Loc Do
Joseph C
DeezMaster
--
Learn to code for free and get a developer job: https://www.freecodecamp.org
Read hundreds of articles on programming: https://freecodecamp.org/news
Programming w/ Professor Sluiter : If you have comments or questions for me (author) you can post them here or on my channel at http://youtube.com/shadsluiter
Bryan Torres : Can we all just give this man a round of applause for putting this information out here for FREE! Great video man!! Thank you so much for this course!!! I will study it all.
Nolan Schweitzer : Incredibly helpful video. As a senior in college, none of my classes ever went into a deep dive of how to do basic actions in Excel. I didn't even know half of these features existed until I came across this video. Being thrown into an upper level course where Excel is needed, this video will certainly help me excel ; ) Thanks so much for making this FREE !!
Kusala Saminda Dissanayake : Most logical and very easy-to-understand course content. His way of explaining is incomparable to anyone in his profession, and the topic is covered vividly and never feels bored. I gained so strong knowledge immensely in a tiny time. Hat off to the professor. You're the great teacher to me I ever had in this field, sir. Best wishes for your future tutorials and life as well.
Vedant Karale : This content is so amazing! Not just for beginners but also works as a quick refresher for people who've worked on excel previously. There's just one thing that I'd like to add which is not related to Excel or programming or analysis but might prove helpful and save some time.
♦Press Ctrl+ to navigate through rows and columns in excel.
♦Use this in combination with the Shift key and the mouse movement could reduced!
Although this speed-up is very subjectively perceived yet being a programmer, I like using the keyboard more than the mouse. Hope this helps
The Ultimate Excel Tutorial - Beginner to Advanced - 5 Hours!
✅ Download the free course files to follow along
➡️https://www.simonsezit.com/the-ultimate-excel-tutorial-instructor-files/
We've combined some of our very best Excel tutorials in this training video to take you from beginner to Excel expert in under 6 hours! We've split this tutorial into 6 comprehensive topics to make sure we got you covered.
We start off with the basics with Excel Formulas for Beginners, where we teach you some of the common functions used in Excel such as VLOOKUP, COUNT, SUM, and IF and how calculations work in Excel, and Data Cleaning in Excel, where we share 10 data cleaning tips and tricks like Clear Formatting, Removing Duplicates, and using Find \u0026 Replace and how to perform basic cleaning in Power Query.
We then move on to intermediate concepts such as Pivot Tables and Dynamic Array Functions, where we discuss 8 functions that use dynamic arrays to solve problems like XLOOKUP and XMATCH.
We wrap it up by covering Advanced Formulas in Excel, where we dive deeper into Logical Functions and other advanced Excel functions such as INDEX, MATCH, SUMPRODUCT, SUMIFS, and COUNTIFS and finally VBA Macros for Beginners, where we explain what Macros and VBA are and show you how to Record, Save, and Run Macros in Excel. You will also learn how to edit VBA code and assign Macro shortcuts.
We've even included downloadable course files so you can follow along in this course. This will help you put what you are learning into practice and master MS Excel.
✅ https://www.simonsezit.com/the-ultimate-excel-tutorial-instructor-files/
Use the timestamps below to navigate to different sections of the course. If you already know one of these topics, skip ahead!
0:00:00 - Excel Formulas for Beginners
1:07:19 - Cleaning Data in Excel
2:12:55 - Pivot Tables Excel Tutorial
3:03:44 - Dynamic Array Functions
3:45:20 - Advanced Formulas in Excel
4:41:15 - Macros and Basic VBA in Excel
Get unlimited training with Simon Sez IT’s 150+ courses ⏩ https://www.simonsezit.com/courses/
Level up your skills with a free 30-day trial to our complete training library of 8,500+ videos ⏩ https://www.simonsezit.com/ssit-first-month-free
Watch more free popular training tutorials from Simon Sez IT:
Check out our FREE 300+ hour training course playlist here ➡️
https://www.youtube.com/playlist?list=PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU
✅ Check out our free video playlist for Excel beginners https://www.youtube.com/playlist?list=PLzj7TwUeMQ3iZHn4cv_fZagWSN8tubU9Z
✅ Excel 2021 Tutorials for Intermediate Users here https://www.youtube.com/playlist?list=PLzj7TwUeMQ3jhT7yg37LKe8aSTA7OuWn3
✅ Microsoft Excel Tips and Tricks https://www.youtube.com/playlist?list=PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc
✅ Microsoft Office 2021 and Office 365 Training here https://www.youtube.com/playlist?list=PLzj7TwUeMQ3hH_MxteY6LR3OSMHpDkt_j
Stay in touch!
SimonSezIT.com: https://www.SimonSezIT.com/
LinkedIn: https://www.linkedin.com/company/simon-sez-it/
FaceBook: https://www.facebook.com/SimonSezIT
Subscribe to our channel:
https://www.youtube.com/simonsezittraining?sub_confirmation=1
If you enjoyed the video, please give a thumbs up ;-)
Len Mark : I lied in my resume about being awesome with excel. I got the job and now I have 2 weeks to learn everything about excel. At least I got the job though.
Markoline Ojok : What can I say? This is by far the most well laid Excel Masterclass on YouTube. Kudos to @SimonSez and Deb, I've really learnt a lot from you!
humphrey owusu-ansah : Great course, even better tutor. Big thanks to the whole Simon Sez IT team. Definitely recommend. 10/10. God bless!
Judy L. : 2:13:00 Pivot tables
3:03:50 8 functions that use dynamic arrays: FILTER, RANDARRAY, SEQUENCE, UNIQUE, SORT, SORTBY, XLOOKUP, XMATCH
4:42:00 Marcos and VBA
Colin_Gibbons1989 : Thank you for a great tutorial, only 1 hour in and already improving my knowledge so much.
Want more Excel videos? Here’s my Excel playlist: https://www.youtube.com/playlist?list=PLmkaw6oRnRv8lAKbKbflJRqS-9wuYNWUw This video tutorial will show you how to use Microsoft Excel for beginners. Microsoft Excel is a powerful spreadsheet tool that is part of Microsoft Office. This is a detailed beginners tutorial, the below timestamps will help you navigate through the lessons that are covered. Looking for more? Let me know in the comments below what types of things you would like to learn in Microsoft Excel.
Intermediate Microsoft Excel Lesson 1:
Dive deeper into formulas and functions in excel with this playlist: https://youtube.com/playlist?list=PLmkaw6oRnRv_GeQNcc_hHtnxbRC7gDLST
Creating Charts in Excel:
0:00 Start
1:07 Starting up
1:27 Recent documents and pinning documents
1:54 Templates
2:34 Layout - Tabs, ribbons, and groups in Microsoft Excel
3:48 Rows, Columns, Cells and Ranges
5:49 Worksheets in Microsoft Excel
6:52 View and zooming
7:30 Inputting Data
10:56 Formatting Data
13:38 Wrapping Text
14:22 Insert Row/ Merge \u0026 Center cells
15:41 Currency formatting
16:20 Print view
17:02 Add cell borders and colors
18:18 Basic formulas in Microsoft Excel
21:17 Copy formula
23:45 Freeze Pane
24:52 Basic Microsoft Excel functions
28:59 “Tell Me” in Microsoft Excel
29:43 Inserting charts in Microsoft Excel
Excel for Beginners Tutorial - Level 2:
Excel for Beginners Tuotiral - Level 3:
Excel for Beginners Tutorial - Level 4:
Microsoft Excel for Beginners - Level 5:
VLOOKUP Function for Excel:
Learn Pivot Tables for Beginners:
10 Best Excel Beginners Tips: https://www.youtube.com/watch?v=ZthlSLYc5UQ
Make a Line Graph in Excel: https://www.youtube.com/watch?v=0jdX22qM8JA
I use Camtasia to create my video tutorials: https://techsmith.pxf.io/KYOeN
DISCLAIMER: This video and description contain affiliate links, which means that if you click on one of the product links and end up purchasing it, I’ll receive a small commission. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
Teacher's Tech : Looking for more? Here's a level 2 Excel tutorial for beginners:
Brea Evans : I lied on my resume, got the job, now I'm here
Abdelali Lahlou : can we just take a moment to appreciate this guy for providing this type of content for free ? great help, Thank you sir!
Fjøra : Honestly, this 33min video alone was more helpful than 16 years of schooling when it comes to Excel.. And the in depth and professional way you explain everything truly makes it both easy to understand and enjoyable! Thank you! - Part 2, here I come!
Olivia Keach : I've never been so actively engaged in a tutorial video before. This was EXTREMELY helpful. Pacing was perfect, information was clear, and it was presented in such a way that I didn't feel like there was any unnecessary repetition or need to skip ahead. I'm so glad this exists!
Microsoft Excel Tutorial for Beginners - Full Course
Lean how to use Microsoft Excel from the beginning by creating 6 real-world projects. Most of the content applies to Google Sheets as well.
You will learn how to
- enter data,
- navigate through a spreadsheet,
- create formulas to solve problems,
- create charts and graphs,
- understand relative vs absolute references,
- import and export data,
- implement VLOOKUP,
- use pivot tables,
- split and concatenate text,
- and more.
✏️ Course developed by Shad Sluiter. Check out his YouTube channel: https://www.youtube.com/user/shadsluiter
⭐️ Course Contents ⭐️
⌨️ (0:00:00) Intro
⌨️ (0:04:14) Payroll
⌨️ (0:39:35) Gradebook
⌨️ (0:57:22) Decision Factors
⌨️ (1:04:40) Sales Database
⌨️ (1:23:13) Car Inventory
⌨️ (1:59:29) Problem Solving Templates
⭐️ Special thanks to our Champion supporters! ⭐️
Loc Do
Joseph C
DeezMaster
--
Learn to code for free and get a developer job: https://www.freecodecamp.org
Read hundreds of articles on programming: https://freecodecamp.org/news
Programming w/ Professor Sluiter : If you have comments or questions for me (author) you can post them here or on my channel at http://youtube.com/shadsluiter
Bryan Torres : Can we all just give this man a round of applause for putting this information out here for FREE! Great video man!! Thank you so much for this course!!! I will study it all.
Nolan Schweitzer : Incredibly helpful video. As a senior in college, none of my classes ever went into a deep dive of how to do basic actions in Excel. I didn't even know half of these features existed until I came across this video. Being thrown into an upper level course where Excel is needed, this video will certainly help me excel ; ) Thanks so much for making this FREE !!
Kusala Saminda Dissanayake : Most logical and very easy-to-understand course content. His way of explaining is incomparable to anyone in his profession, and the topic is covered vividly and never feels bored. I gained so strong knowledge immensely in a tiny time. Hat off to the professor. You're the great teacher to me I ever had in this field, sir. Best wishes for your future tutorials and life as well.
Vedant Karale : This content is so amazing! Not just for beginners but also works as a quick refresher for people who've worked on excel previously. There's just one thing that I'd like to add which is not related to Excel or programming or analysis but might prove helpful and save some time.
♦Press Ctrl+ to navigate through rows and columns in excel.
♦Use this in combination with the Shift key and the mouse movement could reduced!
Although this speed-up is very subjectively perceived yet being a programmer, I like using the keyboard more than the mouse. Hope this helps
The Ultimate Excel Tutorial - Beginner to Advanced - 5 Hours!
✅ Download the free course files to follow along
➡️https://www.simonsezit.com/the-ultimate-excel-tutorial-instructor-files/
We've combined some of our very best Excel tutorials in this training video to take you from beginner to Excel expert in under 6 hours! We've split this tutorial into 6 comprehensive topics to make sure we got you covered.
We start off with the basics with Excel Formulas for Beginners, where we teach you some of the common functions used in Excel such as VLOOKUP, COUNT, SUM, and IF and how calculations work in Excel, and Data Cleaning in Excel, where we share 10 data cleaning tips and tricks like Clear Formatting, Removing Duplicates, and using Find \u0026 Replace and how to perform basic cleaning in Power Query.
We then move on to intermediate concepts such as Pivot Tables and Dynamic Array Functions, where we discuss 8 functions that use dynamic arrays to solve problems like XLOOKUP and XMATCH.
We wrap it up by covering Advanced Formulas in Excel, where we dive deeper into Logical Functions and other advanced Excel functions such as INDEX, MATCH, SUMPRODUCT, SUMIFS, and COUNTIFS and finally VBA Macros for Beginners, where we explain what Macros and VBA are and show you how to Record, Save, and Run Macros in Excel. You will also learn how to edit VBA code and assign Macro shortcuts.
We've even included downloadable course files so you can follow along in this course. This will help you put what you are learning into practice and master MS Excel.
✅ https://www.simonsezit.com/the-ultimate-excel-tutorial-instructor-files/
Use the timestamps below to navigate to different sections of the course. If you already know one of these topics, skip ahead!
0:00:00 - Excel Formulas for Beginners
1:07:19 - Cleaning Data in Excel
2:12:55 - Pivot Tables Excel Tutorial
3:03:44 - Dynamic Array Functions
3:45:20 - Advanced Formulas in Excel
4:41:15 - Macros and Basic VBA in Excel
Get unlimited training with Simon Sez IT’s 150+ courses ⏩ https://www.simonsezit.com/courses/
Level up your skills with a free 30-day trial to our complete training library of 8,500+ videos ⏩ https://www.simonsezit.com/ssit-first-month-free
Watch more free popular training tutorials from Simon Sez IT:
Check out our FREE 300+ hour training course playlist here ➡️
https://www.youtube.com/playlist?list=PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU
✅ Check out our free video playlist for Excel beginners https://www.youtube.com/playlist?list=PLzj7TwUeMQ3iZHn4cv_fZagWSN8tubU9Z
✅ Excel 2021 Tutorials for Intermediate Users here https://www.youtube.com/playlist?list=PLzj7TwUeMQ3jhT7yg37LKe8aSTA7OuWn3
✅ Microsoft Excel Tips and Tricks https://www.youtube.com/playlist?list=PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc
✅ Microsoft Office 2021 and Office 365 Training here https://www.youtube.com/playlist?list=PLzj7TwUeMQ3hH_MxteY6LR3OSMHpDkt_j
Stay in touch!
SimonSezIT.com: https://www.SimonSezIT.com/
LinkedIn: https://www.linkedin.com/company/simon-sez-it/
FaceBook: https://www.facebook.com/SimonSezIT
Subscribe to our channel:
https://www.youtube.com/simonsezittraining?sub_confirmation=1
If you enjoyed the video, please give a thumbs up ;-)
Len Mark : I lied in my resume about being awesome with excel. I got the job and now I have 2 weeks to learn everything about excel. At least I got the job though.
Markoline Ojok : What can I say? This is by far the most well laid Excel Masterclass on YouTube. Kudos to @SimonSez and Deb, I've really learnt a lot from you!
humphrey owusu-ansah : Great course, even better tutor. Big thanks to the whole Simon Sez IT team. Definitely recommend. 10/10. God bless!
Judy L. : 2:13:00 Pivot tables
3:03:50 8 functions that use dynamic arrays: FILTER, RANDARRAY, SEQUENCE, UNIQUE, SORT, SORTBY, XLOOKUP, XMATCH
4:42:00 Marcos and VBA
Colin_Gibbons1989 : Thank you for a great tutorial, only 1 hour in and already improving my knowledge so much.
... 
댓글목록
등록된 댓글이 없습니다.
