Excel Full Course Tutorial (4+ Hours)
Excel Full Course Tutorial (4+ Hours)
Get Ad-Free Training by becoming a member today!
/ @learnittraining
Exercise Files: learnitanytime.com/p/exercise...
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...
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
Introduction 1:38:27
Creating Tables 1:38:43
Flash Fill 1:45:43
Introduction to Sorting Data 1:49:50
SORT Function 1:56:35
SORTBY Function 1:59:21
UNIQUE Function 2:01:10
Filters 2:03:33
Slicers 2:09:00
Subtotals 2:12:42
Quick Analysis Tool 2:17:51
Inserting Charts 2:19:00
Formatting Charts 2:21:22
Creating Chart Templates 2:27:19
Printing Charts 2:29:04
Using Sparklines 2:30:18
Introduction to Pivot Tables 2:34:17
Pivot Charts 2:42:32
Using Slicers with Pivot Tables 2:45:29
Data Validation 2:49:42
Conditional Formatting 3:01:25
Custom Conditional Formatting 3:05:05
Linking Data 3:09:40
Conclusion 3:11:28
Introduction 3:12:00
Named Ranges 3:12:14
Multiple Named Ranges 3:16:53
XLOOKUP 3:19:23
Data Mining with XLOOKUP 3:27:30
IF Function 3:35:23
Database Functions 3:42:37
Goal Seek 3:51:01
PMT Data Tables 3:55:23
Macros 4:00:24
IF-THEN Statements 4:07:00
Do Until Loops 4:14:48
Creating Games with Excel VBA Code 4:21:12
Conclusion 4:28:04
#excel #exceltutorial #exceltips #exceltricks
(C) 2024 Learnit, Inc.
Any illegal reproduction of this content will result in immediate legal action.
Пікірлер: 51
Exercise Files: learnitanytime.com/p/exercise-files-excel-full-course-tutorial-2024
This is the only video so far on the internet for excel where I didn't get bored.
@LearnitTraining
13 күн бұрын
👍👍
Great tutorial for Excel, thanks Joe!
@LearnitTraining
Ай бұрын
Glad it was helpful!
Returning to finish the course, this is really good and detailed information.
@LearnitTraining
Ай бұрын
Glad it was helpful!
To anyone watching ×1.25 is the perfect speed.
@LearnitTraining
Ай бұрын
👍
@AMY-yq7ce
14 күн бұрын
for me 2😆
i enjoyed the class, you really are God sent
@LearnitTraining
Ай бұрын
Glad it was helpful!
Waiting 😊
waiting for this
Thank God for this class.. even though my autofill is not working ugggh.. But this is a God sent
@LearnitTraining
Ай бұрын
You are very welcome!
Thank you learnit
@LearnitTraining
Ай бұрын
You are welcome!
This video was definitely awesome & I learned the beginner level very well without any doubt.. Still halfway to go.. Will reply on this comment after completing the whole video ❤
@LearnitTraining
5 күн бұрын
Keep it up!
@homelander9148
5 күн бұрын
@@LearnitTraining just completed the intermediate level & I have to say that the way you explain is easy to understand... Keep up the good work bro. Now I'm going to complete other courses too 🔥
Good thanks
@LearnitTraining
12 күн бұрын
No problem
Really helpful lecture A humble request: Can you please improve audio quality
@LearnitTraining
28 күн бұрын
Sure thing!
Waiting for This
@LearnitTraining
Ай бұрын
Hope you liked it!
Please help me. There's no "sort, sortby, and unique functions on my Microsoft Excel 365". How do I go about it please.
@LearnitTraining man, upgrade your mic. Its an excellent tutorial but the audio quality sucks.
@LearnitTraining
11 күн бұрын
Noted!
WE are here yippeeeee
@LearnitTraining
Ай бұрын
Thanks for joining us!
Waiting
@LearnitTraining
2 ай бұрын
Us too!
Hi, I have an Excel workbook with multiple worksheets. On worksheet One, I want to add buttons to click that will take me to the other worksheets. How can I do that? Thanks
@LearnitTraining
Ай бұрын
Certainly! You can create buttons in Excel that allow you to jump to different worksheets. Here are a few ways to achieve this: Inserting Shapes to Create Buttons: Go to the Insert tab, click on Illustrations, and select Shape. Choose the Rectangle shape. Insert a rectangle into your sheet by dragging it. Format the shape by going to the Shape Format tab. Select a theme style and type the name you want for your button (e.g., “January”). Copy the shape (Ctrl+C) and paste it (Ctrl+V) for other months (e.g., February and March). Right-click on a shape, choose Link, and select the corresponding sheet (e.g., January, February, or March) from the Insert Hyperlink dialog box. Using Form Controls: Go to the Developer tab (if not visible, enable it in Excel options). Click on Insert and choose a Button from the Form Controls section. Draw the button on your sheet. Assign a macro to the button (e.g., “Prevw1_Click”) that activates the desired sheet. Command Button from ActiveX Controls: Go to the Developer tab and click on Insert. Choose a Command Button from the ActiveX Controls section. Draw the button on your sheet. Assign a macro to the button that switches to the desired sheet. Remember to adjust the sheet names and customize the buttons according to your needs. These methods will allow you to create buttons that navigate to different worksheets in your Excel workbook. Happy Excel-ing!
@benosborne413
Ай бұрын
Thanks
Excel 2019 friendly?
@LearnitTraining
Ай бұрын
We have this video series for Excel 2019: kzread.info/head/PLoyECfvEFOjaPZI7IsJKM2bBmPZhRmmbs
9:08 25:58 43:31 1:01:15 1:25:05 1:45:45
@LearnitTraining
13 күн бұрын
👍
@alliance5873
3 күн бұрын
@@LearnitTraininghey i've got a question. When i autofill the date cell, it changes the year instead of the day. How to fix this?
@alliance5873
2 күн бұрын
Nvm, found out my format is dd/mm/yy and yours mm/dd/yy😅
more real world exercise videos joe
@LearnitTraining
Ай бұрын
Noted!
I do not like the whole 365 paradigm. I would rather have software on my own computer. Or max, on a small local network. Therefore, libreoffic Calc is preferable.
@LearnitTraining
13 күн бұрын
We definitely agree that the SAAS is not ideal, especially for small businesses and individuals. The programs for the most part are not being radically updated. All that being said we also see the value in the uptime that SAAS provides.
Hindi me shikha
@LearnitTraining
13 күн бұрын
👍
Great tutorial for Excel, thanks Joe!
@LearnitTraining
Ай бұрын
Glad you enjoyed it!