Get ad-free training by becoming a member today!
https://www.youtube.com/channel/UCqyBfm_H9ugGirk1ufYA2YA/join

Practice files: https://learnitanytime.com/p/exercise-files-excel-beginner-tutorial-2024

Who it's for: Beginners as well as experienced, everyday users who want 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'll start with the basics and show you Excel's interface and the best ways to navigate. Once you're comfortable with the layout of the software, we'll quickly move on to calculating data with basic formulas and functions. In the Intermediate section, we will show you the different tools and ways to sort and filter data in a timely manner. Next, we'll cover Charts and Sparklines, along with some tips for presenting data in Excel. Next, we'll dive into one of Excel's most popular features; the pivot table. Our advanced training begins with an overview of XLOOKUP, an essential feature for modern Excel users. Then we'll explore complex database functions, give you an introduction to macros, and show you how to save time by automating common Excel tasks.

Join Learnit Anytime for ad-free training, exams, certificates and exclusive content:
https://www.learnitanytime.com

For private group training, please visit:
https://www.learnit.com/private-group-classes-workshops

Manuals: https://bit.ly/30xZb59
Username: manuals
Password: password

Start 0:00 am
Introduction 0:09
What is Excel? 1:16
Excel Interface Overview 2:40
Search and help 9:06
Navigate and select cells 11:48
Enter, replace and delete data 16:05
Adjust Cells 25:56
Calculations, Formulas and Functions 30:29
Basic Functions 43:31
Autocomplete 50:39
Relative and Absolute Cell Reference 55:05
Save and share workbooks 1:01:13
Comments 1:05:11
Insert rows and columns 1:07:39
Cut, copy and paste 1:10:33
Format data with cell styles 1:14:35
Manage Worksheets 1:20:28
Hide row and columns 1:25:04
Create custom views 1:26:57
View worksheets 1:30:24
Print 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.

Please take the opportunity to connect and share this video with your friends and family if you find it helpful.