Excel Beginner Tutorial
61,129
Published 2024-04-05
Get Ad-Free Training by becoming a member today!
youtube.com/channel/UCqyBfm_H9ugGirk1ufYA2YA/join
Exercise Files: learnitanytime.com/p/exercise-files-excel-beginner…
Who it's for: Beginners, as well as experienced, everyday users looking to sharpen their skills and increase efficiency in Microsoft Excel.
What it is: Microsoft’s spreadsheet application used to organize and analyze data.
What you'll learn: We start with the basics, showing you Excel’s interface and the best ways to navigate. Once you’re comfortable with the software’s layout, we quickly move on to calculating data with basic formulas and functions. In the Intermediate section, we show you the various tools and ways to sort and filter data in a timely manner. Next, we cover Charts and Sparklines, along with some tips on presenting data in Excel. Then, we dive into one of Excel’s most popular features; the Pivot Table. Our Advanced training starts with an overview of XLOOKUP, a vital function for modern-day Excel users. After that, we explore complex Database functions, provide you with an introduction to Macros, and demonstrate how to save time by automating common Excel tasks.
Join Learnit Anytime for ad-free training, exams, certificates, and exclusive content:
www.learnitanytime.com/
For Private Group Trainings please visit:
www.learnit.com/private-group-classes-workshops
Manuals: bit.ly/30xZb59
Username: manuals
Password: password
Start 0:00
Introduction 0:09
What is Excel? 1:16
Excel Interface Overview 2:40
Search and Help 9:06
Navigating and Selecting Cells 11:48
Entering, Replacing, and Deleting Data 16:05
Adjusting Cells 25:56
Calculations, Formulas, and Functions 30:29
Basic Functions 43:31
AutoFill 50:39
Relative and Absolute Cell Reference 55:05
Saving and Sharing Workbooks 1:01:13
Comments 1:05:11
Inserting Rows and Columns 1:07:39
Cut, Copy, and Paste 1:10:33
Formatting Data with Cell Styles 1:14:35
Managing Worksheets 1:20:28
Hiding Row and Columns 1:25:04
Creating Custom Views 1:26:57
Reviewing Worksheets 1:30:24
Printing Worksheets 1:33:37
Conclusion 1:38:19
#excel #exceltutorial #exceltips #exceltricks
(C) 2024 Learnit, Inc.
Any illegal reproduction of this content will result in immediate legal action.
All Comments (21)
-
Exercise Files: learnitanytime.com/p/exercise-files-excel-beginner…
-
Thank you so much for making this readily available and free. I need it for my new job, but couldn't afford to pay for a course, so you not only saved the day but also saved my new job. I'm sorry I can only offer you a modest "Thank you", but I did like the video and subscribed as well. Not to mention, I will talk about it to others. I want to help you as much as you helped me.
-
I lied in my resume..Now I'm here..
-
You explained it so simply and repeated instructions which was SO helpful. THANK YOU SO MUCH
-
So helpful, thank u buddy! Keep it up!
-
The tutorial was so profound and interesting.... Can't wait for the intermediate tutorial...
-
Thank you so much for your informative and excellent presentation.
-
Best trainer tht i ever have
-
Excellent Training!! Thank You!
-
Thank you, i got new knowledge here
-
This guy seems to be head over heels in love with Excel... Quite a lunatic!
-
Completed this tutorial and I really Like it.
-
There are so many Excel courses from different years on this channel. The videos and dedication is superb but it is confusing for me as a beginner on which excel courses I need to learn. Will I become good in Excel if I just follow 2024 Excel courses alone? The quality of teaching is amazing btw.
-
Thank you.
-
So helpful. Thanks alot
-
Excellent, I'm enjoying this lesson
-
Content is awesome Thank you so much
-
Thank u a lot that really helped me✨
-
I learned 😌 💯 Excel starting in 2004 at Wake Technical Community College 😅A Mandatory Excel Project is required 👌 👍 in 🇳🇬 👌 every science and 🤓 mathematics course 😉 🎉❤
-
This is wow. It kept me awake till 3am 😂 Thanks so much Joe