Educational
#excel #earnmoneyonline
FREE Live Masterclass. Register Now. 🔥🔥
https://event.webinarjam.com/register/13/m4851s2
Download the file:
https://docs.google.com/spreadsheets/d/1dkX2X1E9sJzu-ggt-Clt5Wd16eTPzfME/edit?usp=sharing&ouid=113878292614815469124&rtpof=true&sd=true
IMPORTANT ----- Steps to download the file.
Step 1 - Click on the link above.
Step 2 - Click on "File" from top left corner
Step 3 - Click on Download and then on Microsoft Excel to save the file on your system...
Welcome to our Intermediate Excel Mastery Series! In this comprehensive tutorial, we delve deep into pivotal Excel features and share insider tips to revolutionize your spreadsheet capabilities.
🚀 What's Inside:
✅ Master Pivot Tables & Pivot Charts: From basic setup to advanced layouts, learn everything you need to create dynamic reports.
✅ Uncover secrets of VLOOKUP: Step beyond basics with advanced applications and hidden tricks.
✅ Create Multiple Dependent Drop-Down Lists: A game-changer for data organization.
✅ Discover the power of UNIQUE Function: Effortlessly extract unique values from datasets.
✅ Implement Data Validation: Control user input with precision.
✅ Master a Nested FILTER Function: Combine with UNIQUE for ultra-precise data filtering.
🌟Perfect for All Levels: Whether you're a student, professional, or a passionate Excel enthusiast, this video series caters to all. Follow our step-by-step approach and apply these techniques to elevate your data analysis and presentation skills.
🔍 Detailed Timestamps for Easy Navigation:
0:00 Introduction to Advanced Excel
1:12 PivotTable Creation from Range/Table
2:16 Crafting Recommended PivotTables
3:01 Detailed PivotTable from Range/Table
3:55 PivotTable Fields: Adding & Reporting
4:50 Customizing PivotTable Field Layouts
7:20 Sorting PivotTable Columns/Rows
8:58 Integrating Filter Fields in PivotTables
9:59 Employee-Specific Report Generation
11:51 PivotTable Advanced Tips & Tricks
15:43 Integrating a PivotChart
19:02 VLOOKUP Function: Advanced Uses
27:42 Crafting Multiple Dependent Drop-Down Lists
29:42 UNIQUE Function: Data Extraction Simplified
30:40 Excel Data Validation: Techniques and Tips
32:03 Nested FILTER & UNIQUE Functions: Advanced Data Manipulation
35:58 VLOOKUP: Final Result Optimization
📈 Take Your Excel Skills to New Heights: Watch, learn, and transform the way you handle data in Excel. Don't forget to like, share, and subscribe for more expert Excel tutorials!
Practice Sheet PivotTables: https://bit.ly/PivotTable_data
Practice Sheet VLOOKUP: https://bit.ly/VLOOOKUP_data
Practice Sheet Multiple Dependant Drop-downs: https://bit.ly/Drop-Down_list
Check out this Intermediate Excel class: https://youtu.be/Ir22TLCjdto
Keep learning with these Excel classes:
How to use Power Query: https://youtu.be/MHIV0bYryiw
How to use Power Pivot: https://youtu.be/kyGhgreDNUQ
How to use the XLOOKUP Function: https://youtu.be/tPaXEZRh9_k
Drop-down lists with XLOOKUP: https://youtu.be/fjn4vlWwpCo
Drop-down with the INDIRECT function: https://youtu.be/oYF162_Cmwc
Excel beginners video tutorials: https://youtube.com/playlist?l....ist=PLmkaw6oRnRv8lAK
Function Lessons in Excel: https://youtube.com/playlist?l....ist=PLmkaw6oRnRv_GeQ
Excel 2016 Intermediate Tutorial
Get Ad-Free Training by becoming a member today!
https://www.youtube.com/channe....l/UCqyBfm_H9ugGirk1u
Exercise Files: https://bit.ly/2HDoEpM
Who it's For: Anyone currently using Microsoft Excel, or anyone who wants to learn how!
What it is: Excel is a popular Microsoft application that organizes and analyzes data.
What You'll Learn: Our beginner videos start with simple tasks like selecting cells and entering data, then quickly move to calculating data with basic formulas and functions. The intermediate portion shows you how simple it is to sort and filter and then moves to one of Excel’s most popular features, Pivot Tables. Our advanced videos start with functions like IF and VLOOKUP and finish up with Macros.
For ad free training and certificates please join Learnit Anytime:
https://www.learnitanytime.com
For Private Group Trainings please visit:
https://www.learnit.com/privat....e-group-classes-work
Exercise Files: https://bit.ly/2HDoEpM
Manuals: https://bit.ly/30xZb59
Username: manuals
Password: password
Start 0:00
Flash Fill 0:03
List Design & Single Level Sorting 2:28
Multi-Level Sorting 4:52
Custom Sorting 8:20
Filtering 11:33
Multi-Level Filtering 15:40
Search Filtering 17:34
Format as Table 21:47
Table Style Options 25:13
Remove Duplicates 29:12
Convert to Range 34:07
Subtotal 34:51
Multi-Level Subtotaling 40:32
Remove Subtotals 42:59
Quick Analysis Charts 43:29
Inserting Data Charts 46:53
Formatting Data Charts 51:46
Chart Templates 57:21
Sparklines 1:01:28
Printing Charts 1:06:18
Importing From Web 1:08:18
MS Query 1:14:33
Exporting Overview 1:21:12
Pivot Tables 1:22:50
Multiple-Field Pivot Tables 1:31:03
Drill Down Reports 1:36:10
Pivot Charts & Grouping Fields 1:38:52
Slicer Tool 1:47:18
Data Validation 1:54:28
Additional Data Validation 2:03:12
Cell & Sheet Protection 2:09:30
File Encryption 2:14:58
Conditional Formatting 2:17:28
Linking Data 2:25:34
Inserting Comments 2:32:25
#Excel
(C) 2021 Learnit, Inc.
Any illegal reproduction of this content will result in immediate legal action.
✅ Download the free course exercise files to follow along
➡️https://www.simonsezit.com/dat....a-analytics-in-excel
In this Introduction to Data Analysis with Excel training, we show you how to use Excel spreadsheets for data analysis. We start off by identifying the data types in Excel and viewing and entering data. We then move on to the basics of Excel formulas and explore more Excel functions that are helpful for data analysis.
We'll also discuss how to clean and manage your data in Excel. We'll cover an introduction to data quality, importing file data, identifying data attributes, and more.
We've even included downloadable course exercise files from our paid-for courses so you can follow along and complete the exercises in this course. This will help you put what you are learning into practice.
✅ https://www.simonsezit.com/dat....a-analytics-in-excel
📝 Use the timestamps below to navigate to different sections of the course. If you already know one of these topics, skip ahead!
00:00:00 - Simon Sez IT Intro
00:00:21 - Course Introduction
00:01:53 - Navigating Excel
00:15:15 - Data Types in Excel
00:21:12 - Viewing, Entering and Copying Data
00:30:08 - Formatting and Data Types in Excel
00:36:53 - Excel Formula Basics
00:48:37 - Exploring Excel Functions
00:58:16 - Referencing Data in Formulas
01:07:11 - Exercise 01
01:11:28 - Introduction to Data Quality
01:21:28 - Importing File Data
01:27:05 - Removing Duplicate Data
01:34:55 - Identifying Data Attributes
01:43:19 - Cleaning Data
01:50:59 - Exercise 02
🌍 Get unlimited training with Simon Sez IT’s 160+ 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/playli....st?list=PLzj7TwUeMQ3
✅ Check out our free video playlist for data visualization 👉https://www.youtube.com/playli....st?list=PLzj7TwUeMQ3
✅Power BI Tutorials for Beginners video playlist 👉 https://www.youtube.com/playli....st?list=PLzj7TwUeMQ3
✅ Microsoft Excel Beginner's Training here 👉 https://www.youtube.com/playli....st?list=PLzj7TwUeMQ3
✅ Data Analysis using Microsoft Tools here 👉 https://www.youtube.com/playli....st?list=PLzj7TwUeMQ3
💬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/simons....ezittraining?sub_con
If you enjoyed the video, please give a thumbs up 👍🏽 ;-)
The ultimate compilation of Excel tips and tricks to enhance your productivity using Excel. Updated for 2020! I've combined long-established tips and tricks with new ones Microsoft added in 2019 and 2020. You'll find solutions to the most common challenges you face in Excel.
Support me with your Amazon purchases, click here: https://amzn.to/2Kxp533
Contents 0:00
1. Move Data 0:35
2. XLOOKUP() 1:04
3. Filter List 2:24
4. Ideas 3:04
5. Remove Blanks 3:54
6. Quick Analysis Tool 4:28
7. AutoFit Column Width 5:27
8. Absolute Cell Reference 5:57
9. Paste Special Values 7:19
10. Drop-Down List 8:05
11. FILTER() 9:15
12. Remove Duplicates 10:43
13. Difference Between Lists 11:31
14. Flash Fill 12:15
15. AutoFill 13:06
16. Data Types 13:53
17. Transpose 15:11
18. Freeze Panes 15:37
19. Text to Columns 16:27
20. Recommended Pivot table 17:25
21. Slicers 18:04
22. Conditional Formatting 19:01
23. IF() 20:29
24. 3D References 21:12
25. Forecast Sheet 22:45
26. SUMIFS() 24:00
27. IFERROR() 25:15
28. Ctrl-Arrow Keys 26:03
29. Filled Maps 26:26
30. PMT() 27:13
31. Show Formulas 28:20
32. Advanced Select 29:10
33. Named Range Shortcut 29:56
34. Hide Cells 30:47
35. COUNTBLANK() 31:30
36. Natural Language Query 31:59
37. Goal Seek 33:08
38. Insert Screenshot 34:30
39. Power Pivot 35:14
40. 3D Maps 36:16
41. ISBLANK() 39:08
42. Analysis ToolPak 39:45
43. CONVERT() 40:48
44. Get Data from Web 41:24
45. People Graph 42:59
46. SORT() 44:18
47. Status Bar Info 45:36
48. Insert Multiple Rows 46:22
49. CHOOSE() 46:53
50. UNIQUE() 48:50
#seletraining #excel #tipsandtricks
MS Excel - Vlookup in Excel Video Tutorials
Lecture By: Mr. Pavan Lalwani Tutorials Point India Private Limited
To Buy Full Excel Course: https://bit.ly/38Jyu3p
Use coupon "YOUTUBE" to get FLAT 10% OFF at Checkout.
Check out latest Video Courses and eBooks : https://www.tutorialspoint.com/market/index.php
Pivot tables allow you to automatically summarize your complex data in simple ways and analyze the data. This means you can replace lots of hand-typed summary calculations with more automated reporting.
For more updates on courses and tips follow us on:
Facebook: https://www.facebook.com/tutorialspointindia
Twitter: https://twitter.com/tutorialspoint
LinkedIn: https://www.linkedin.com/company/tutorialspoint
Want more Excel videos? Here’s my Excel playlist: https://www.youtube.com/playli....st?list=PLmkaw6oRnRv In this 2020 video, I will show you to use pivot tables in excel. This excel pivot table tutorial for beginners will show you how to create a pivot table, analyze the data in a pivot table and how to graph in your pivot table data. Learning pivot tables can save you a lot of time and are easy to use.
Download sample data used in the video. Make sure to click the download arrow in the top right corner: https://drive.google.com/file/....d/1O0QypAIUuQ90OCphY
Other Microsoft Excel Tutorial:
Microsoft Excel Tutorial - Level 1: https://youtu.be/k1VUZEVuDJ8
Microsoft Excel Tutorial - Level 2: https://youtu.be/bhZckWTLkJM
Microsoft Excel Tutorial - Level 3: https://youtu.be/47yu50CsH00
VLOOKUP Function Tutorial: https://youtu.be/Lw03WcG4mt4
How to Make a Line Graph: https://youtu.be/0jdX22qM8JA
10 Best Excel Tips for Beginners: https://youtu.be/ZthlSLYc5UQ
formula to find percentage in excel
#shorts #excel #exceltips
In this video, will learn about VLOOKUP in Excel. What is a VLOOKUP, what is the use of VLOOKUP, how to use VLOOKUP and options in VLOOKUP.
We have taken a sample data to use VLLOKP formula i.e. VLOOKUP example to help you understand the topic in better way.
Topic: How to use VLOOKUP formula in Excel | VLOOKUP in Excel Tutorial
VLLOKUP Practice Data (download link): https://bit.ly/3PmsWij
Timestamp:
0:00 Intro: VLOOKUP & use
0:39 How to use VLOOKUP formula
2:55 Mistakes in VLOOKUP
4:14 VLOOKUP value
Key keywords: vlookup in excel, vlookup formula in excel, how to use vlookup in hindi, vlookup example, free online excel course
➖➖➖➖➖➖➖➖➖➖➖➖➖
Instagram id: https://instagram.com/rishabhnmishra/
Linkedin: https://www.linkedin.com/in/rishabhnmishra/
Twitter – https://twitter.com/rishabhnmishra
➖➖➖➖➖➖➖➖➖➖➖➖➖
If this is the first ever video you're watching allow me to introduce myself, Hey I'm Rishabh and currently working as Senior Data Analyst at Bangalore. On this channel I like to guide and help my juniors and data science aspirants regarding Data Science jobs and useful tips for college students.
If you like this video I highly suggest you to check out some other fun videos on this channel 😉
■ How to Become Data Analyst in 2022 | Data Analyst Roadmap
https://www.youtube.com/watch?v=TiWGpLmYJD4
■ Microsoft Excel Tutorial for Beginners - FREE Online Excel Course | Excel Tutorial Part 1
https://www.youtube.com/watch?v=B5lMVJoaQnA
■ Microsoft Excel Tutorial for Beginners - FREE Online Excel Course | Excel Tutorial Part 2
https://www.youtube.com/watch?v=mGu1CzsVUPc
■ Create Pivot Tables In Excel | Use of Pivot Table - Pivot Table Tutorial
https://www.youtube.com/watch?v=lCoPTPsTJ4s
➖➖➖➖➖➖➖➖➖➖➖➖➖
Comment your doubts and queries, so that we can answer them.
SUBSCRIBE to stay tuned to more fun and informative content, consider hitting LIKE button on this video for the sake of YouTube Algorithm!! Have a great day!
#vlookup #vlookupformula
Welcome to the The Beginner's Guide course to Excel. This Excel Full Course enables you to Learn MS Excel in simple and easy steps. In this Microsoft Excel Basics Tutorial series we will start from the basics and gradually move towards the Expert level in Microsoft Excel. This MS Excel course provides the Beginners to Intermediate Excel Skills, Tips, and Tricks. In this course we will learn how to Enter and edit Excel data, Format numbers, fonts and alignment, Make simple pivot tables and charts, Create simple Excel formulas, How to Use Excel Functions IF and VLOOKUP. Learn common Excel functions used in any Office, How to Create dynamic reports, Build Excel formulas to analyze date, text fields, values and arrays and much more advanced stuff.
🌍 Microsoft Excel Course🌍
1- 00:02:38 - Introduction to MS Excel
2- 00:13:48 - Organizing Data
3- 00:25:10 - Basic Excel Formulas | Important Formulas for Beginners
4- 00:35:47 - How to use the Excel IF function
5- 00:46:54 - Pivot Tables in Excel | How to Create a Pivot Table in Excel
6- 00:57:04 - Text Functions in Excel | Excel TEXT Function - Formula and Examples
7- 01:07:29 - Cell Reference in Excel with Examples
8- 01:18:29 - Text to Columns in Excel | How to Use Text-to-Columns in Excel
9- 01:28:04 - How to Use Paste Special + How to Use Speak Cells Feature in Excel
10- 01:39:10 - Custom List in Excel + Using Advanced Fill in Excel
11- 01:49:30 - Flash Fill in Excel + Series features
12- 01:59:48 - Nested IF, AND, IF ERROR Function ( Logical Functions in Excel)
13- 02:11:51 - Comments and Custom Views
14- 02:22:03 - How to Make Charts and Graphs in Excel
15- 02:32:59 - Excel DATE function with examples + Mathematical Functions
16- 02:44:33 - How to Rotate Text in Cells in Excel + How to Print in Excel
17- 02:55:04 - How to use Header and Footer in MS Excel
18- 03:05:24 - Data validation in Excel
19- 03:15:49 - How to Record a Macro in Excel
20- 03:27:12 - Relative References in Excel
21- 03:38:13 - How to Make a Macro in Excel | Write Macros in Excel
22- 03:49:51 - Name Array in MS Excel
23- 04:00:21 - How To Use VLOOKUP in Excel
24- 04:10:12 - Approximate Match and VLOOKUP rules
25- 04:21:21 - Consolidate Data in Excel | Excel Consolidate Function
26- 04:32:04 - Count Functions in MS Excel
27- 04:43:00 - Single Criteria Statistical functions
28- 04:53:42 - Multiple Criteria Statistical Functions in Excel
29- 05:04:26 - How to use Index, Match, Lookup and HLookup in Excel
30- 05:16:22 - Protection Rules in MS Excel | Protecting a Worksheet's Format Excel
31- 05:26:55 - Create Hyperlinks in Excel | Links in MS Excel
32- 05:37:41 - Data Sorting In MS Excel | How to Sort Lists in Excel
33- 05:48:07 - Filtering Data | How to Filter in Excel
34- 05:58:48 - Advanced Filters in MS Excel
35- 06:09:14 - Chart Shortcuts in MS Excel | Create Excel Chart With Shortcut Keys
36- 06:19:37 - Combo Charts and Pie Charts in MS Excel
37- 06:31:07 - Spark Line Charts in MS Excel
38- 06:41:26 - Pivot Chart in MS Excel
39- 06:52:25 - Conditional Formatting in Excel : Part 1
40- 07:02:52 - Conditional Formatting in Excel : Part 2
41- 07:13:13 - Conditional Formatting for Icon Sets - How to use Icon Sets
42- 07:23:35 - Advanced Conditional Formatting Formulas in MS Excel
43- 07:32:17 - Customizing Pivot Tables Part 1
44- 07:43:40 - Customizing Pivot Tables Part 2
45- 07:53:55 - Pivot Table Item Slicers | Excel Pivot Table Slicers
46- 08:04:52 - Slicer and Timeline over Pivot Table in MS Excel
47- 08:15:03 - Dependent Dropdown Lists in MS Excel
48- 08:25:36 - Summary Report in MS Excel | How to Create an Excel Summary Report
49- 08:35:34 - Objects In Ms Excel | Excel Worksheet Objects
50- 08:45:58 - Table vs Cell Range in MS Excel
51- 08:56:10 - Slicers on Charts in MS Excel | Slicer Controlled Interactive Charts
52- 09:06:40 - How to Create a Linked Object in Microsoft Excel
53- 09:16:46 - Ctrl Shortcuts in MS Excel
54- 09:27:08 - Function Keys Shortcut In Microsoft Excel
55- 09:37:23 - Alt Key Shortcuts in MS Excel (Keyboard shortcuts in Excel)
56- 09:46:55 - Shift + Function Key shortcuts in MS Excel
57- 09:57:54 - Ctrl + Function Key Shortcuts In Ms Excel
58- 10:08:22 - Alt And Shift With Special Keys Shortcuts In Ms Excel
59- 10:19:28 -
#Excel #MSExcel #MicrosoftExcel #ExcelTutorial #excelTutorial #excelTutorialForBeginners #excel #excelCompleteCourse
🔥Post Graduate Program In Data Analytics: https://www.simplilearn.com/pgp-data-analytics-certification-training-course?utm_campaign=13Sep2023LGLoopEvening1-8Ob8Hre_SnI&utm_medium=Descriptionff&utm_source=youtube
🔥IIT Kanpur Professional Certificate Course In Data Analytics (India Only): https://www.simplilearn.com/iitk-professional-certificate-course-data-analytics?utm_campaign=13Sep2023LGLoopEvening1-8Ob8Hre_SnI&utm_medium=Descriptionff&utm_source=youtube
🔥Caltech Data Analytics Bootcamp(US Only): https://www.simplilearn.com/data-analytics-bootcamp?utm_campaign=13Sep2023LGLoopEvening1-8Ob8Hre_SnI&utm_medium=Descriptionff&utm_source=youtube
🔥Data Analyst Masters Program (Discount Code - YTBE15): https://www.simplilearn.com/data-analyst-masters-certification-training-course?utm_campaign=13Sep2023LGLoopEvening1-8Ob8Hre_SnI&utm_medium=Descriptionff&utm_source=youtube
Advanced Excel Full Course 2023 by Simplilearn is complete Excel tutorial that helps aspiring data analysts with excel data analytics fundamentals. This Microsoft Excel Tutorial For Beginners will cover basic topics of excel like data validation, conditional formatting, spreadsheet fundamentals to advanced excel topics like time series analysis, filters, slicers, excel dashboarding, data visualization, and much more.
This Excel Full Course will cover the following topics:
00:00:00 introduction to Microsoft Excel Full Course
00:01:52 Excel Basic Knowledge
00:18:45 How To Change Lower Case To Upper Case In Excel?
00:19:58 How To Add Rows In Excel?
00:21:32 How To Add Columns In Excel?
00:24:29 How To Select Entire Column In Excel?
00:27:16 How to Compare Two Columns In Excel?
00:34:36 How To Convert Rows To Columns In Excel?
00:36:13 How to Group Rows in Excel?
00:37:55 How To Remove Blank Rows In Excel?
00:41:44 How To Freeze Row In Excel Tutorial
00:44:12 How to Convert Numbers to Words in Excel?
00:46:59 Combining Data From Multiple Cells In Excel
00:49:27 How To Merge Cells In Excel
00:54:12 How to Add Date in Excel?
00:55:48 How To Change Date Format In Excel (dd/mm/yyyy) To (mm/dd/yyyy)
00:59:55 How To Calculate Age In Excel From A Date Of Birth?
01:01:37 How To Calculate Time Difference in Excel?
01:03:15 DAX In Excel Explained
01:08:20 Checkboxes In Excel
01:12:31 How to Insert Excel in PPT?
01:14:40 How To Insert Image In Excel?
01:18:05 How To Insert PDF in Excel Sheet?
01:21:40 How To Convert PDF To Excel
01:26:05 How to Insert Tick Mark in Excel?
01:29:05 How to add Watermark in Excel?
01:32:00 How to Increase Cell Size in Excel?
01:34:50 How to create Barcode In Excel
01:38:08 Excel Flash Fill
01:43:00 How to Add Hyperlink In Excel
01:55:44 Excel Round-Off Formula
01:58:18 How To Calculate Standard Deviation In Excel?
02:04:50 Index Match In Excel
02:09:10 How to Sort by Date in Excel?
02:10:40 How to Use AutoSum In Excel
02:13:47 How To Sort Data In Excel?
02:23:56 Slicer and Filter in Excel
02:27:49 How to Add Filters in Excel
02:29:20 Goal Seek In Excel
How to Create Drop-Down List In Excel?
02:44:46 Data Validation In Excel
02:44:50 How To Lock(Protect) Cells In Excel
03:17:55 How To Calculate Average In Excel?
03:18:43 Excel Print Page Setup
03:36:47 Page Break In Excel For Beginners
03:08:53 Conditional Formatting In Excel
03:41:56 How to Count Colored Cells in Excel?
03:47:54 DateDif In Excel Explained
03:51:08 Remove Duplicates In Excel
03:55:05 SUMIFS Formula in Excel
04:02:40 How To Create Pivot Tables In Excel
04:07:00 Autofill In Excel Explained
04:10:22 How to Calculate Percentage In Excel
04:12:08 How To Highlight Duplicates In Excel?
04:16:04 Charts In Excel
04:21:56 Progress Tracker In Excel
04:25:50 Excel Gantt Chart Tutorial
04:28:48 Pivot Tables In Excel
04:57 Pivot Charts in Excel and How to Create a Pivot Table Using Multiple Sheets in Excel
06:45:02 Time Series Analysis in Excel
07:37:00 Excel Dashboard Design
08:47:00 Excel Power Query Tutorial For Beginners
09:44:44 Excel Budget Template
09:51:37 Excel Interview Questions And Answers
⏩ Check out the Excel tutorial videos: https://www.youtube.com/watch?v=nPkmWE4JCfE&list=PLEiEAq2VkUUKf8aLrspLg3zuyJ5S-5K5S
#HowtoGroupRowsinExcel #ExcelTutorial #ExcelGrouping #ExcelTips #MSExcel #Excel #ExcelTraining #LearnMSExcel #ExcelBasics #ExcelTutorialForBeginners #simplilearn
➡️ About Post Graduate Program In Data Analytics
This Data Analytics Program is ideal for all working professionals and prior programming knowledge is not required. It covers topics like data analysis, data visualization, regression techniques, and supervised learning in-depth via our applied learning model with live sessions by leading practitioners and industry projects.
👉 Learn More at: https://www.simplilearn.com/pgp-data-analytics-certification-training-course?utm_campaign=13Sep2023LGLoopEvening1-8Ob8Hre_SnI&utm_medium=Description&utm_source=youtube
🔥🔥 Interested in Attending Live Classes? Call Us: IN - 18002127688 / US - +18445327688
This video covers the basics of Excel and is meant for people who beginners in Excel and are just starting with Excel.
This is the first video of this FREE Online Excel training and covers all the basics of Excel and how to get started with it.
Its starts with the different parts of Excel and how to navigate through it. It also forms the foundation of all the other videos in this Free Excel course.
The following topics are covered in this video on getting started with Excel for beginners:
-- Structure of the Excel working area,
-- How to navigate in Excel,
-- Ribbons and tabs,
-- Quick Access Toolbar (QAT)
-- Dialog Box & Task Panes,
-- Customizing ribbons and QAT,
-- What is an active cell
-- How to use ALT shortcuts
☕ If you're the videos useful and would like to support me, you can buy me a coffee - https://www.buymeacoffee.com/SumitB
This video is a part of my Free Excel course where I show you how to use Excel from the basics and also cover a lot of advanced topics.
You can also get this training and more resources here: https://trumpexcel.com/learn-excel/
Free Excel Course - https://trumpexcel.com/learn-excel/
Paid Online Training - https://trumpexcel.com/excel-training/
Best Excel Books: https://trumpexcel.com/best-excel-books/
⚙️ Gear I Recommend:
Camera - https://amzn.to/3bmHko7
Screen Recorder - techsmith.z6rjha.net/26D9Q
USB Mic - https://amzn.to/2uzhVHd
Wireless Mic: https://amzn.to/3blQ8uk
Lighting - https://amzn.to/2uxOxRv
Subscribe to get awesome Excel Tips every week: https://www.youtube.com/user/t....rumpexcel?sub_confir
Note: Some of these links here are affiliate links!
#Excel #ExcelTips #ExcelTutorial
MS EXCEL Full Course for Beginners in 3 HOURS (FREE) - 2024 Edition
🔴 To learn Data Analytics Course online with regular LIVE CLASSES, enroll now: https://www.wscubetech.com/landing-pages/online-data-analytics-course.html?utm_source=YouTube&utm_medium=msexcelcourse&utm_campaign=RV
Timestamps 👇
00:00:00 - Intro
00:01:15 - Introduction to MS Excel and Beginner's Guide
00:11:43 - Autofill, Flashfill, and Text-to-Columns
00:18:02 - Data Validation in Excel
00:23:58 - Conditional Formatting
00:30:02 - Basics of Formatting in Excel
00:34:20 - Sorting Data in Excel
00:39:11 - Filtering Data in Excel
00:42:35 - Dealing with Null Values
00:48:43 - Dealing With Duplicate Values
00:51:44 - Trimming Whitespaces
00:54:30 - Fixing Column Formats
00:57:15 - Text Functions in Excel
01:04:24 - If, AND, and OR Functions in Excel
01:14:42 - Date & Time Functions in Excel
01:19:12 - COUNTIF, COUNTIFS, SUMIF, SUMIFS - Functions in Excel
01:25:45 - Lookup and VLOOKUP in Excel
01:39:17 - INDEX MATCH in Excel
01:44:52 - XLOOKUP in Excel
01:50:35 - Data Connectors in Excel
01:54:53 - Power Query in MS Excel
02:01:40 - Cleaning and Transformation in Power Query
02:17:22 - Cleaning Null Values in Power Query Editor
02:24:31 - Combine Files Using Power Query
02:32:39 - Data Modeling and Its Importance
02:38:14 - Cardinality and Filter Direction in Power Pivot
02:45:02 - Pivot Tables in Excel
02:52:21 - Pivot Charts in Excel
02:59:51 - Slicer in Excel
03:09:17 - Measures in Excel
03:17:51 - Buttons in Excel
03:21:03 - How to Create a Dashboard in Excel
03:28:19 - Forecasting in Excel
03:32:04 - What-if Analysis in Excel
🔴 To learn Data Analytics Course online with regular LIVE CLASSES, enroll now: https://www.wscubetech.com/landing-pages/online-data-analytics-course.html?utm_source=YouTube&utm_medium=JAN2024&utm_campaign=RV
WsCube Tech is a Vernacular Upskilling platform revolutionizing the way you learn and develop your career skills.🚀
WsCube Tech stands out as a leading EdTech platform, offering comprehensive education in Python, Machine Learning, and various Data Science skills. Our approach involves both online and classroom training, featuring hands-on projects delivered practically by seasoned industry experts.
With WsCube Tech, you'll gain hands-on skills that make you globally competitive. Our courses are designed to prepare over 100 million career aspirants for the 'Bharat' of the future. 😊
👉 Want to learn and acquire skills in English? Visit WsCube Tech English channel: https://bit.ly/2M3oYOs
📌 𝗩𝗼𝘁𝗲 𝗳𝗼𝗿 𝗼𝘂𝗿 𝗻𝗲𝘅𝘁 𝘃𝗶𝗱𝗲𝗼: https://bit.ly/share-topic-ideas
Watch Now our Trending App Development Playlist & Videos:
👉 Learn Python Programming in One Video - https://www.youtube.com/watch?v=sCOw5y1RQpY
👉 DSA Full Course - https://www.youtube.com/watch?v=hCrO_cR7kno
👉 20 Python Projects in One Video - https://www.youtube.com/watch?v=OKuiyX5k6zg
👉 Excel Full Course for Data Analysis - https://www.youtube.com/watch?v=SA_SDo-cqpg
For any queries, call us on: +91-7878985501
✅ CONNECT WITH THE FOUNDER (Mr. Kushagra Bhatia) -
👉 Instagram - https://www.instagram.com/kushagrabhatiaofficial
👉 LinkedIn - https://www.linkedin.com/in/kushagra-bhatia
👉 Facebook - https://www.facebook.com/kushagrawscubetech
Connect with WsCube Tech on social media for the latest offers, promos, job vacancies, and much more:
😄 Facebook: https://www.facebook.com/wscubetech.india
🐦 Twitter: https://twitter.com/wscubetechindia
📱 Instagram: https://www.instagram.com/wscubetechindia/
👨🏻💻 LinkedIn: https://www.linkedin.com/company/wscubetechindia/
🔺 Youtube: http://bit.ly/wscubechannel
🌐 Website: http://wscubetech.com
--------------------------------------| Thanks |---------------------------
#msexcel #excelfullcourse #msexceltutorial
SUMIF Formula in excel | advanced excel tutorial #excel #exceltips #exceltutorial #exceltutorial
Excel Practice File
https://docs.google.com/spreadsheets/d/1Ku_cx318IWzmGMm5ST9Ygm-4Srkxr76q/edit?usp=sharing&ouid=101431276211418881474&rtpof=true&sd=true
YEARFRAC Formula in excel
WEEKNUM Formula in excel
REPLACE Formula in excel
MOD Function in Excel
SQRT formula in excel
SQRT function in excel
Consolidate in excel
3D Sum in excel
Running Total in Excel
SMALL formula in excel
SMALL function in excel
LARGE formula in excel
LARGE function in excel
Rank formula in excel
How use rank formula in excel
how use rank function in excel
rank function in excel
SUMIF formula in excel
SUMIF function in excel
REPT formula in excel
REPT function in excel
Char formula in excel
Char function in excel
Date function in excel
Date formula in excel
Time formula in excel
Time function in Excel
Filter formula in excel
Advanced Filter formula in excel
MAX formula in excel
MAX function in excel
MIN formula in excel
MIN function in excel
XLOOKUP formula in excel
XLOOKUP function in excel
Filter in excel
Advanced Filter in excel
ISTEXT formula in excel
ISTEXT function in excel
Random formula in excel
Random function in excel
Randbetween formula in excel
Randbetween function in excel
Choose formula in excel
Choose function in excel
MATCH formula in excel
MATCH function inexcel
TRUE formula in excel
TRUE function in excel
ISNUMBER function in excel
ISNUMBER in formula in excel
INDEX formula in excel
INDEX function in excel
Paste Special in Excel
Paste Special in ms Excel
IFERROR Formula in excel
IFERROR Function in excel
LEN formula in excel
Substitute formula in excel
SUMPRODUCT formula in excel
LEN function in excel
Substitute function in excel
SUMPRODUCT function in excel
LEN formula in ms excel
Substitute formula in ms excel
SUMPRODUCT formula in ms excel
LEN function in ms excel
Substitute function in ms excel
SUMPRODUCT function in ms excel
count formula in excel
count function in ms excel
excel
excel shorts
excel tutoring
excel formula
ms excel
vlookup in excel
excel formula for job interview
ms excel number format
excel tricks
developer excel
excel tips and tricks
data entry
sparklines in excel
data entry work in excel
excel data entry work in hindi
excel shortcuts and tricks
excel for fresher
excel shortcut keys
hlookup in excel
ms excel full course in hindi
paste special in excel
advanced excel formula
freeze in excel
ms excel shorts
advance excel
excel formula hacks
excel tutorial
excel vlookup
print titles in excel
short excel
conditional formatting in excxel
countif formula in excel
data entry interview questions
data tab
drop down list in excel
excel formulas
excel shortcut
excel tricks and tips
excel vlookup formula
excel tricks and tips shorts
excel vlookup formula excel world
format painter in excel
google sheet
index formula in excel
learn more
pivot table excel in hindi
shortcut key for excel
use of excel in computer
computer class
vlook up
vlookup
vlookup formula in excel
xlookup in excel
advanced excel
advanced excel course
advanced excel full course
advanced excel jobs
advanced filter excel
basic computer
computer excel
computer knowledge
computer shortcut keys
computer xl work
concatenate excel
data clearing
data entry operator ky hota hai
data manipulation
data representation
data tab in excel
data table
data validation in excel
data visualization in excel
excel all formulas and functions in hindi
excel border formatting
excel calendar 2022
excel chart
excel column formatting
excel count
excel data model
excel formula number
excel formulas and functions
excel full playlist in hindi
excel function
excel header and footer
excel hlookup
excel in English
excel keyboard shortcuts
excel me home tab
excel multiply formula
excel paste special
excel print page setup
excel series number tricks
excel short video
excel shortcut keys in mobile
excel shortcuts
excel sum formula
excel sumif formula
excel video
exel
flash fill
flash fill in excel
forecast in excel
freeze panes in excel column and row
google sheets tutorial
how to calculate time in excel
Microsoft excel
microsoft office word
ms excel formula
ms excel full course
ms excel eme marksheet banana
ms excel tricks
pivot
pivot table
excel data entry work
excel full course in hindi
excel me salary sheet kaise banaya
excel me table kaise banaye
excel row and column functions
excel test for job interview 2022
excel working
excel world hindi
Excel Interview Question Day Month Year in Excel #excel #exceltips #exceltutorial #msexcel #shorts
YEARFRAC Formula in excel
WEEKNUM Formula in excel
REPLACE Formula in excel
MOD Functoin in Excel
SQRT formula in excel
SQRT function in excel
Consolidate in excel
3D Sum in excel
Running Total in Excel
SMALL formula in excel
SMALL function in excel
LARGE formula in excel
LARGE function in excel
Rank formula in excel
How use rank formula in excel
how use rank function in excel
rank function in excel
SUMIF formula in excel
SUMIF function in excel
REPT formula in excel
REPT function in excel
Char formula in excel
Char function in excel
Date function in excel
Date formula in excel
Time formula in excel
Time function in Excel
Filter formula in excel
Advanced Filter formula in excel
MAX formula in excel
MAX function in excel
MIN formula in excel
MIN function in excel
XLOOKUP formula in excel
XLOOKUP function in excel
Filter in excel
Advanced Filter in excel
ISTEXT formula in excel
ISTEXT function in excel
Random formula in excel
Random function in excel
Randbetween formula in excel
Randbetween function in excel
Choose formula in excel
Choose function in excel
MATCH formula in excel
MATCH function inexcel
TRUE formula in excel
TRUE function in excel
ISNUMBER function in excel
ISNUMBER in formula in excel
INDEX formula in excel
INDEX function in excel
Paste Special in Excel
Paste Special in ms Excel
IFERROR Formula in excel
IFERROR Function in excel
LEN formula in excel
Substitute formula in excel
SUMPRODUCT formula in excel
LEN function in excel
Substitute function in excel
SUMPRODUCT function in excel
LEN formula in ms excel
Substitute formula in ms excel
SUMPRODUCT formula in ms excel
LEN function in ms excel
Substitute function in ms excel
SUMPRODUCT function in ms excel
count formula in excel
count function in ms excel
excel
excel shorts
excel tutoring
excel formula
ms excel
vlookup in excel
excel formula for job interview
ms excel number format
excel tricks
developer excel
excel tips and tricks
data entry
sparklines in excel
data entry work in excel
excel data entry work in hindi
excel shortcuts and tricks
excel for fresher
excel shortcut keys
hlookup in excel
ms excel full course in hindi
paste special in excel
advanced excel formula
freeze in excel
ms excel shorts
advance excel
excel formula hacks
excel tutorial
excel vlookup
print titles in excel
short excel
conditional formatting in excxel
countif formula in excel
data entry interview questions
data tab
drop down list in excel
excel formulas
excel shortcut
excel tricks and tips
excel vlookup formula
excel tricks and tips shorts
excel vlookup formula excel world
format painter in excel
google sheet
index formula in excel
learn more
pivot table excel in hindi
shortcut key for excel
use of excel in computer
computer class
vlook up
vlookup
vlookup formula in excel
xlookup in excel
advanced excel
advanced excel course
advanced excel full course
advanced excel jobs
advanced filter excel
basic computer
computer excel
computer knowledge
computer shortcut keys
computer xl work
concatenate excel
data clearing
data entry operator ky hota hai
data manipulation
data representation
data tab in excel
data table
data validation in excel
data visualization in excel
excel all formulas and functions in hindi
excel border formatting
excel calendar 2022
excel chart
excel column formatting
excel count
excel data model
excel formula number
excel formulas and functions
excel full playlist in hindi
excel function
excel header and footer
excel hlookup
excel in English
excel keyboard shortcuts
excel me home tab
excel multiply formula
excel paste special
excel print page setup
excel series number tricks
excel short video
excel shortcut keys in mobile
excel shortcuts
excel sum formula
excel sumif formula
excel video
exel
flash fill
flash fill in excel
forecast in excel
freeze panes in excel column and row
google sheets tutorial
how to calculate time in excel
Microsoft excel
microsoft office word
ms excel formula
ms excel full course
ms excel eme marksheet banana
ms excel tricks
pivot
pivot table
excel data entry work
excel full course in hindi
excel me salary sheet kaise banaya
excel me table kaise banaye
excel row and column functions
excel test for job interview 2022
excel working
excel world hindi
Excel Tutorial For Beginners in Hindi | Complete Microsoft Excel Tutorial
Excel tutorial for beginners in Hindi, this is complete Microsoft excel tutorial basic to advance including Excel Introduction, Excel formulas and functions, Excel tips and tricks, How to use Pivot table in excel, how to use VLOOKUP formula in excel and many formulas which is used in big companies to manage and analyze data like data analyst, data entry jobs, business analyst, etc
I am working in Data Science industry and while making this Excel tutorial i have tried to share the industry level knowledge, tips and tricks that even i use in my office work on daily basis. Hope you learn something new and this video add some value to your skill set. :)
Feeling low ? Pro tip: शिक्षा की जड़ें कड़वी होती हैं लेकिन फल मीठा होता है। tho lage rahe!!!
👍 Subscribe for more such tutorials: https://bit.ly/3Fc7Gc6
Resources used in this Excel course
VLOOKUP Practice Data (download link): https://bit.ly/3PmsWij
Pivot Practice Data (download link): https://bit.ly/3BbEyRJ
➖➖➖➖➖➖➖➖➖➖➖➖➖
List of important Excel topics and respective time
Timestamps
00:00 Excel Course Intro
01:41 Excel Basic Features
10:38 Basic Formatting
14:05 Using Formulas
21:29 Save File
22:31 Filter & Sorting
25:19 Conditional Formatting
26:11 Insert & Delete Columns or Rows
27:23 Find & Remove Duplicates
29:11 Merge & Centre
32:29 Rounding of Numbers
34:54 Autofill in Excel
36:38 Add or edit comment
37:41 Filters
40:01 Sorting on multiple columns
42:32 Insert Table
43:42 Slicers
45:10 Insert picture or shapes
48:19 Add link or Hyperlink
51:31 Add drop down list
53:29 Split Text
55:38 Charts in excel
58:16 VLOOKUP formula
01:03:32 Pivot Table
01:15:29 Outro
➖➖➖➖➖➖➖➖➖➖➖➖➖
Want to connect with me? Check out these links:
Instagram: https://www.instagram.com/rishabhnmishra/
LinkedIn: https://www.linkedin.com/in/rishabhnmishra/
Twitter: https://twitter.com/rishabhnmishra
➖➖➖➖➖➖➖➖➖➖➖➖➖
Other Useful Videos:
Data Analyst Roadmap, Skills and Jobs: https://www.youtube.com/playli....st?list=PLdOKnrf8EcP
SQL Course: https://www.youtube.com/playli....st?list=PLdOKnrf8EcP
Excel Course: https://www.youtube.com/playli....st?list=PLdOKnrf8EcP
➖➖➖➖➖➖➖➖➖➖➖➖➖
Hope you liked this video and learned something new.
See You Soon, until then Bye-Bye!
excel tutorial, excel, ms excel tutorial, Excel tutorial for beginners, advanced excel tutorial, excel tutorial in hindi, microsoft excel, excel basics for beginners, microsoft excel tutorial, advance excel in hindi, excel tutorial in hindi, excel tutorial for beginners in hindi, excel in hindi, excel in hindi, excel in hindi tutorial, excel hindi tutorial, basic computer course, excel formulas and functions, Microsoft Excel, excel by rishabh mishra, excel tutorials, Complete Microsoft Excel tutorial, excel in hindi full course, excel for beginners 2023, excel full course hindi, learn excel in hindi, complete excel tutorial in hindi, excel basic to advance, complete excel course in hindi
#exceltutorialforbeginners #exceltutorialinhindi
🔥Advanced Excel Full Course 2024 🔴LIVE | Excel Tutorial For Beginners | Excel Training | Simplilearn
🔥Post Graduate Program In Data Analytics: https://www.simplilearn.com/pgp-data-analytics-certification-training-course?utm_campaign=19Feb2024LGLoopEvening1-8Ob8Hre_SnI&utm_medium=Descriptionff&utm_source=youtube
🔥IIT Kanpur Professional Certificate Course In Data Analytics (India Only): https://www.simplilearn.com/iitk-professional-certificate-course-data-analytics?utm_campaign=19Feb2024LGLoopEvening1-8Ob8Hre_SnI&utm_medium=Descriptionff&utm_source=youtube
🔥Caltech Data Analytics Bootcamp(US Only): https://www.simplilearn.com/data-analytics-bootcamp?utm_campaign=19Feb2024LGLoopEvening1-8Ob8Hre_SnI&utm_medium=Descriptionff&utm_source=youtube
🔥Data Analyst Masters Program (Discount Code - YTBE15): https://www.simplilearn.com/data-analyst-masters-certification-training-course?utm_campaign=19Feb2024LGLoopEvening1-8Ob8Hre_SnI&utm_medium=Descriptionff&utm_source=youtube
Advanced Excel Full Course 2023 by Simplilearn is complete Excel tutorial that helps aspiring data analysts with excel data analytics fundamentals. This Microsoft Excel Tutorial For Beginners will cover basic topics of excel like data validation, conditional formatting, spreadsheet fundamentals to advanced excel topics like time series analysis, filters, slicers, excel dashboarding, data visualization, and much more.
This Excel Full Course will cover the following topics:
00:00:00 introduction to Microsoft Excel Full Course
00:01:52 Excel Basic Knowledge
00:18:45 How To Change Lower Case To Upper Case In Excel?
00:19:58 How To Add Rows In Excel?
00:21:32 How To Add Columns In Excel?
00:24:29 How To Select Entire Column In Excel?
00:27:16 How to Compare Two Columns In Excel?
00:34:36 How To Convert Rows To Columns In Excel?
00:36:13 How to Group Rows in Excel?
00:37:55 How To Remove Blank Rows In Excel?
00:41:44 How To Freeze Row In Excel Tutorial
00:44:12 How to Convert Numbers to Words in Excel?
00:46:59 Combining Data From Multiple Cells In Excel
00:49:27 How To Merge Cells In Excel
00:54:12 How to Add Date in Excel?
00:55:48 How To Change Date Format In Excel (dd/mm/yyyy) To (mm/dd/yyyy)
00:59:55 How To Calculate Age In Excel From A Date Of Birth?
01:01:37 How To Calculate Time Difference in Excel?
01:03:15 DAX In Excel Explained
01:08:20 Checkboxes In Excel
01:12:31 How to Insert Excel in PPT?
01:14:40 How To Insert Image In Excel?
01:18:05 How To Insert PDF in Excel Sheet?
01:21:40 How To Convert PDF To Excel
01:26:05 How to Insert Tick Mark in Excel?
01:29:05 How to add Watermark in Excel?
01:32:00 How to Increase Cell Size in Excel?
01:34:50 How to create Barcode In Excel
01:38:08 Excel Flash Fill
01:43:00 How to Add Hyperlink In Excel
01:55:44 Excel Round-Off Formula
01:58:18 How To Calculate Standard Deviation In Excel?
02:04:50 Index Match In Excel
02:09:10 How to Sort by Date in Excel?
02:10:40 How to Use AutoSum In Excel
02:13:47 How To Sort Data In Excel?
02:23:56 Slicer and Filter in Excel
02:27:49 How to Add Filters in Excel
02:29:20 Goal Seek In Excel
How to Create Drop-Down List In Excel?
02:44:46 Data Validation In Excel
02:44:50 How To Lock(Protect) Cells In Excel
03:17:55 How To Calculate Average In Excel?
03:18:43 Excel Print Page Setup
03:36:47 Page Break In Excel For Beginners
03:08:53 Conditional Formatting In Excel
03:41:56 How to Count Colored Cells in Excel?
03:47:54 DateDif In Excel Explained
03:51:08 Remove Duplicates In Excel
03:55:05 SUMIFS Formula in Excel
04:02:40 How To Create Pivot Tables In Excel
04:07:00 Autofill In Excel Explained
04:10:22 How to Calculate Percentage In Excel
04:12:08 How To Highlight Duplicates In Excel?
04:16:04 Charts In Excel
04:21:56 Progress Tracker In Excel
04:25:50 Excel Gantt Chart Tutorial
04:28:48 Pivot Tables In Excel
04:57 Pivot Charts in Excel and How to Create a Pivot Table Using Multiple Sheets in Excel
06:45:02 Time Series Analysis in Excel
07:37:00 Excel Dashboard Design
08:47:00 Excel Power Query Tutorial For Beginners
09:44:44 Excel Budget Template
09:51:37 Excel Interview Questions And Answers
⏩ Check out the Excel tutorial videos: https://www.youtube.com/watch?v=nPkmWE4JCfE&list=PLEiEAq2VkUUKf8aLrspLg3zuyJ5S-5K5S
#HowtoGroupRowsinExcel #ExcelTutorial #ExcelGrouping #ExcelTips #MSExcel #Excel #ExcelTraining #LearnMSExcel #ExcelBasics #ExcelTutorialForBeginners #simplilearn
➡️ About Post Graduate Program In Data Analytics
This Data Analytics Program is ideal for all working professionals and prior programming knowledge is not required. It covers topics like data analysis, data visualization, regression techniques, and supervised learning in-depth via our applied learning model with live sessions by leading practitioners and industry projects.
👉 Learn More at: https://www.simplilearn.com/pgp-data-analytics-certification-training-course?utm_campaign=19Feb2024LGLoopEvening1-8Ob8Hre_SnI&utm_medium=Description&utm_source=youtube
🔥🔥 Interested in Attending Live Classes? Call Us: IN - 18002127688 / US - +18445327688
►Free Download Screen Recording&Video Editing Software DemoCreator: https://bit.ly/359N8jj
►Claim A Free License here: https://bit.ly/3jPPkVr
DemoCreator is an easy screen recording & video editing tool by Wondershare. It's an intuitive and user-friendly 2-in-1 tool that enables users to capture video demos, tutorials, presentations, games and edit them quickly like a Pro
#DemoCreator #wondershare
This tutorial is all about Excel basics for Beginners step by step explanation.
For Online Class: geomouse1715@gmail.com
Follow me on Twitter & Facebook
https://twitter.com/EndlessKnowled1
https://www.facebook.com/enlessknowledge
Click the Link below to learn. (Subscribe for more upcoming Tutorials)
Important Excel Shortcut Keys in Tamil
https://youtu.be/E9KtIb_YKXQ
SUMIFS Formula in Excel in Tamil
https://youtu.be/qb5FySdwYq0
HLOOKUP in Excel in Tamil
https://youtu.be/uuuLInpMTOI
Excel Conditional Formatting in Tamil
https://youtu.be/-LYkGBlwmOM
RANK Formula in Excel in Tamil
https://youtu.be/qWBBaJ8HRW8
Nested IF Condition in Excel in Tamil
https://youtu.be/BeRPPyYNkSc
IF And Formula in Excel in Tamil
https://youtu.be/2vuAK6VLs-U
IF Condition in Excel in Tamil
https://youtu.be/XBRRgYaH_Cg
SUMIF Formula in Excel in Tamil
https://youtu.be/34DcgedJkso
How to Create a Data Entry Form in Excel in Tamil
https://youtu.be/vCYW1IEgVYY
Top 10 Excel Shortcuts for Beginners
https://youtu.be/GfabR6cBZcg
VLOOKUP in Excel in Tamil
https://youtu.be/CiDhLTRRt-E
Recommended Pivot Table in Excel in Tamil
https://youtu.be/6gjR-n2-sH4
Slicer in excel in Tamil
https://youtu.be/CVTrkm2YLck
MS Excel Pivot Table in Tamil
https://youtu.be/S68AyYZeZrQ
COUNTIF formula in excel in Tamil
https://youtu.be/FaySkf5zYG8
#excelbasicsintamil #endlessknowledge
Learn Excel VBA essentials in 15 minutes to automate excel tasks.
🔥 Get 20% OFF our Excel VBA & Macros Course just for the next 7 days! https://www.careerprinciples.c....om/courses/vba-macro
🆓 DOWNLOAD Free Excel file for this video: https://view.flodesk.com/pages..../64679d3c76364508a70
In this video, you'll learn VBA essentials in just 15 minutes. First, you'll learn to set up the visual basic editor using the developer tab, and insert a new module to start coding. As a first scenario, we'll create a custom function to calculate discount percentages if a certain condition is true. Second, we'll create a sub procedure to clear the contents from a dataset in one click. We'll also add a message box and a button to confirm we want to clear the data. Finally, we'll learn to automate how to send an email from Excel containing a subject, a body, and the Excel file attached. Overall, learning VBA will boost your office productivity as you'll be able to autoamte any repetitive task.
LEARN:
🔥Power BI for Business Analytics: https://www.careerprinciples.c....om/courses/power-bi-
📈 The Complete Finance & Valuation Course: https://www.careerprinciples.c....om/courses/finance-v
👉 Excel for Business & Finance Course: https://www.careerprinciples.c....om/courses/excel-for
🚀 All our courses: https://www.careerprinciples.com/courses
SOCIALS:
🎬 My Company YouTube Channel: https://www.youtube.com/@careerprinciples
📸 Instagram - https://www.instagram.com/careerprinciples/?hl=en
🤳 TikTok - https://www.tiktok.com/@career_principles
🧑💻 LinkedIn - https://www.linkedin.com/company/careerprinciples/
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
Chapters:
0:00 - Excel VBA Introduction
1:50 - Building Custom Functions
4:40 - Automating Clearing Data
6:46 - Creating Message Box & Button
10:53 - Sending an email from Excel in 1 click
Disclaimer: I may receive a small commission on some of the links provided at no extra cost to you.
In this video, we'll guide you through creating a simple and effective Excel table from scratch. Learn how to set up your data, insert and manage columns and rows, and apply basic formatting to improve the table's readability. We'll also cover essential Excel functions and formulas for various calculations, and demonstrate how to use conditional formatting to easily highlight important information. By the end of this tutorial, you'll be equipped with the knowledge to create your own custom Excel table for any purpose. Be sure to like, subscribe, and leave any questions in the comments. Thanks for watching!
#excel
#exceltutorial
#tableexcel
#microsoftoffice
#excelforbeginners
#excelspreadsheet
To support the author financially - https://www.donationalerts.com/r/semyon_solomin
AD: Sign up to enroll for a 7-day free trial with Coursera now! https://imp.i384100.net/c/4021....125/1347618/14726?u=
Learn all the fundamentals of Data Analysis on Excel in 10 minutes!
🆓 DOWNLOAD Free Excel file for this video: https://view.flodesk.com/pages..../63f8abed3e1e4ad2834
#coursera #courserapartner @coursera
This video will teach you all the fundamentals of data analysis in just 10 minutes. First, we'll go over how to transform or clean up a raw set of data on Excel. This will include using features like the trim formula, data types, removing duplicates, and more. Then, we'll look at descriptive statistics using the data analysis feature on Excel. This will give us important numbers like the average, min, max, quartiles etc. We'll also create a box and whisker chart for analysing outliers. Third, we'll analyze the data using pivot tables. Finally, we'll create a small report using conditional formatting, xlookups, sumifs and more.
LEARN:
📈 The Complete Finance & Valuation Course: https://www.careerprinciples.c....om/courses/finance-v
👉 Excel for Business & Finance Course: https://www.careerprinciples.c....om/courses/excel-for
🚀 All our courses: https://www.careerprinciples.com/courses
SOCIALS:
🎬 My Company YouTube Channel: https://www.youtube.com/@careerprinciples
📸 Instagram - https://www.instagram.com/careerprinciples/?hl=en
🤳 TikTok - https://www.tiktok.com/@career_principles
🧑💻 LinkedIn - https://www.linkedin.com/company/careerprinciples/
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
Chapters:
0:00 - Intro
0:30 - Transforming Data
4:41 - Descriptive Statistics
8:10 - Data Analysis
10:43 - Dashboard for showing your findings
Disclaimer: I may receive a small commission on some of the links provided at no extra cost to you.
Excel Interview Question Tips and Tricks #excel #exceltips #exceltutorial #msexcel #developer #microsoftexcel #shorts
Consolidate in excel
3D Sum in excel
Running Total in Excel
SMALL formula in excel
SMALL function in excel
LARGE formula in excel
LARGE function in excel
Rank formula in excel
How use rank formula in excel
how use rank function in excel
rank function in excel
SUMIF formula in excel
SUMIF function in excel
REPT formula in excel
REPT function in excel
Char formula in excel
Char function in excel
Date function in excel
Date formula in excel
Time formula in excel
Time function in Excel
Filter formula in excel
Advanced Filter formula in excel
MAX formula in excel
MAX function in excel
MIN formula in excel
MIN function in excel
XLOOKUP formula in excel
XLOOKUP function in excel
Filter in excel
Advanced Filter in excel
ISTEXT formula in excel
ISTEXT function in excel
Random formula in excel
Random function in excel
Randbetween formula in excel
Randbetween function in excel
Choose formula in excel
Choose function in excel
MATCH formula in excel
MATCH function inexcel
TRUE formula in excel
TRUE function in excel
ISNUMBER function in excel
ISNUMBER in formula in excel
INDEX formula in excel
INDEX function in excel
Paste Special in Excel
Paste Special in ms Excel
IFERROR Formula in excel
IFERROR Function in excel
LEN formula in excel
Substitute formula in excel
SUMPRODUCT formula in excel
LEN function in excel
Substitute function in excel
SUMPRODUCT function in excel
LEN formula in ms excel
Substitute formula in ms excel
SUMPRODUCT formula in ms excel
LEN function in ms excel
Substitute function in ms excel
SUMPRODUCT function in ms excel
count formula in excel
count function in ms excel
excel
excel shorts
excel tutoring
excel formula
ms excel
vlookup in excel
excel formula for job interview
ms excel number format
excel tricks
developer excel
excel tips and tricks
data entry
sparklines in excel
data entry work in excel
excel data entry work in hindi
excel shortcuts and tricks
excel for fresher
excel shortcut keys
hlookup in excel
ms excel full course in hindi
paste special in excel
advanced excel formula
freeze in excel
ms excel shorts
advance excel
excel formula hacks
excel tutorial
excel vlookup
print titles in excel
short excel
conditional formatting in excxel
countif formula in excel
data entry interview questions
data tab
drop down list in excel
excel formulas
excel shortcut
excel tricks and tips
excel vlookup formula
excel tricks and tips shorts
excel vlookup formula excel world
format painter in excel
google sheet
index formula in excel
learn more
pivot table excel in hindi
shortcut key for excel
use of excel in computer
computer class
vlook up
vlookup
vlookup formula in excel
xlookup in excel
advanced excel
advanced excel course
advanced excel full course
advanced excel jobs
advanced filter excel
basic computer
computer excel
computer knowledge
computer shortcut keys
computer xl work
concatenate excel
data clearing
data entry operator ky hota hai
data manipulation
data representation
data tab in excel
data table
data validation in excel
data visualization in excel
excel all formulas and functions in hindi
excel border formatting
excel calendar 2022
excel chart
excel column formatting
excel count
excel data model
excel formula number
excel formulas and functions
excel full playlist in hindi
excel function
excel header and footer
excel hlookup
excel in English
excel keyboard shortcuts
excel me home tab
excel multiply formula
excel paste special
excel print page setup
excel series number tricks
excel short video
excel shortcut keys in mobile
excel shortcuts
excel sum formula
excel sumif formula
excel video
exel
flash fill
flash fill in excel
forecast in excel
freeze panes in excel column and row
google sheets tutorial
how to calculate time in excel
Microsoft excel
microsoft office word
ms excel formula
ms excel full course
ms excel eme marksheet banana
ms excel tricks
pivot
pivot table
excel data entry work
excel full course in hindi
excel me salary sheet kaise banaya
excel me table kaise banaye
excel row and column functions
excel test for job interview 2022
excel working
excel world hindi
മൈക്രോസോഫ്റ്റ് എക്സൽ ഇത് വരെ ഉപയോഗിച്ചിട്ടില്ലാത്തവർക്കും, ഉപയോഗിച്ച് തുടങ്ങിയവർക്കും വേണ്ടി.
Microsoft Excel Malayalam Tutorial for beginners.
Intro (0:00)
1. Open Excel and create a new workbook (0:50)
2. Workbook & Worksheet (1:20)
3. Cell and address of cell (2:33)
4. Formula bar (5:11)
5. Name box (6:36)
6. Range (7:40)
7. Enter, copy, move, replace and erase data (8:36)
8. Excel Ribbon (13:26)
9. Data Entry (16:26)
10. Formatting data (22:30)
Outro (28:04)
മൈക്രോസോഫ്റ്റ് എക്സൽ കോഴ്സിൽ എൻറോൾ ചെയ്യുന്നതിന് വേണ്ടിയുള്ള ലിങ്ക് ചുവടെ...
https://www.udemy.com/course/m....icrosoft-excel-begin
Subscribe to the channel @AjayAnandXLnCAD for more.
http://www.youtube.com/c/AjayAnandXLnCAD
#ExcelMalayalam #MalayalamExcel #MalayalamTutorial
Learn the only Excel formulas you need as an Analyst in 2023 to get most things done.
🚀Get FREE Excel chart templates from Hubspot: https://clickhubspot.com/y21
🆓 DOWNLOAD Free Excel file for this video: https://view.flodesk.com/pages..../63ef8457a48787c3c5f
In this video we go over 10 excel formulas you need as a business analysts, financial analyst, or data analyst. The formulas are: iferror, concatenate, string functions (left, mid, right), filter, edit, sumifs, xlookup, large/small, sequence, and indexmatch.
The types of formulas covered include data cleaning functions, date & time functions, lookup functions, and sum functions.
LEARN:
👉 Excel for Business & Finance Course: https://www.careerprinciples.c....om/courses/excel-for
📈 The Complete Finance & Valuation Course: https://www.careerprinciples.c....om/courses/finance-v
🚀 All our courses: https://www.careerprinciples.com/courses
SOCIALS:
🎬 My Company YouTube Channel: https://www.youtube.com/@careerprinciples
📸 Instagram - https://www.instagram.com/careerprinciples/?hl=en
🤳 TikTok - https://www.tiktok.com/@career_principles
🧑💻 LinkedIn - https://www.linkedin.com/company/careerprinciples/
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
Disclaimer: I may receive a small commission on some of the links provided at no extra cost to you.
Join 400,000+ professionals in our courses here 👉 https://link.xelplus.com/yt-d-all-courses
This video is perfect for Excel beginners or anyone who wants to feel more comfortable using formulas and functions in Excel. It offers a detailed, easy-to-follow guide on common functions and formulas, along with a special trick to simplify using any type of function in Excel.
⬇️ DOWNLOAD the workbook here: https://pages.xelplus.com/formulas-functions-file
✨ Key Highlights:
▪️ Basic Mathematical Formulas: Learn how to write and use basic mathematical formulas in Excel.
▪️ Using Sum, Average, and Count Functions: Explore how to sum, average, and count data in your Excel sheets.
▪️ Inserting Functions in Excel: Discover the process of finding and inserting the right Excel functions for your data analysis needs.
▪️ Advanced Functions Like AVERAGEIFS: Get insights into using more complex functions like AVERAGEIFS for specific conditions.
▪️ Practical Examples: See real-life examples using sample datasets for a practical understanding of Excel functions.
These Excel functions work for ALL versions of Excel (Excel 2007, Excel 2010 all the way to Excel for Office 365). The basic Excel functions we cover are: SUM, COUNT, COUNTA, MIN, MAX and the AVERAGE function. We also cover AutoSum and the AVERAGEIFS functions.
00:00 How to Use Formula and Functions in Microsoft Excel
00:29 How to Write a Mathematical Formula in Excel
01:44 How to Sum Columns / Rows in Excel
03:24 How to Insert a Function in Excel
03:52 How to Use AutoSum in Excel
05:00 How to Calculate an Average in Excel
05:39 How to Count Numbers in Excel
06:29 How to Count Text in Excel
07:07 How to Calculate Min and Max Values in Excel
07:33 How to Use AVERAGEIFS in Excel
10:06 Wrap Up
More Excel Tutorials for Beginners: https://www.youtube.com/playli....st?list=PLmHVyfmcRKy
Intermediate Excel Functions (including the Excel IF and VLOOKUP functions): https://www.youtube.com/playli....st?list=PLmHVyfmcRKy
__________________
Get access to my Excel Essentials course: https://www.xelplus.com/course..../learn-excel-essenti
➡️ Join this channel to get access to perks: https://www.youtube.com/channe....l/UCJtUOos_MwJa_Ewii
👕☕ Get the Official XelPlus MERCH: https://xelplus.creator-spring.com/
🎓 Not sure which of my Excel courses fits best for you? Take the quiz: https://www.xelplus.com/course-quiz/
🎥 RESOURCES I recommend: https://www.xelplus.com/resources/
🚩Let’s connect on social:
Instagram: https://www.instagram.com/lgharani
LinkedIn: https://www.linkedin.com/company/xelplus
Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
#excel
🔥 Learn Excel in just 2 hours: https://kevinstratvert.thinkific.com
Learn how to use PivotTables in Excel with this step-by-step tutorial for beginners. Find out how to insert pivot tables and how to use recommended pivot tables. Learn what filter, column, row, and value mean. See how to use calculated fields to quickly analyze data in a pivot table. See how to summarize and show your values in different ways. Lastly, learn how to insert pivot charts, what defer layout update means, and how to access Excel for free online using office.com.
In this tutorial, I use Excel that comes with Office 365; however, this should also work with all previous versions of Excel, like Excel 2019, Excel 2016, Excel 2013, Excel 2010, Excel 2007, and Excel 2003.
📚 RESOURCES
- Access the sample data: https://1drv.ms/x/s!AmxrofZZlZ-wg_xUE4vA3D_5qdbRjA
⌚ TIMESTAMPS
00:00 Introduction
02:19 Insert Pivot Table
03:22 Main Pivot Table view
05:24 Calculated fields
06:55 Sorting
07:12 Value field settings
08:10 Show values as
09:27 Insert Pivot Chart
10:23 Defer layout update
11:13 Pivot Table on the web
12:24 Wrap up
📺 RELATED VIDEOS
- Playlist with all my Excel videos: https://www.youtube.com/playli....st?list=PLlKpQrBME6x
🙌 SUPPORT THE CHANNEL
- Hit the THANKS button in any video!
- Amazon affiliate link: https://amzn.to/3kCP2yz (Purchasing through this link gives me a small commission to support videos on this channel -- the price to you is the same)
🔽 CONNECT WITH ME
- Official web site: http://www.kevinstratvert.com
- LinkedIn: https://www.linkedin.com/in/kevinstratvert/
- Discord: https://discord.gg/kHuujY2pZf
- Twitter: https://twitter.com/kevstrat
- Facebook: https://www.facebook.com/Kevin....-Stratvert-101912218
- TikTok: https://www.tiktok.com/@kevinstratvert
- Instagram: https://www.instagram.com/kevinstratvert/
🎁 TOOLS AND DISCOUNTS
✅ 🎙️ Voicemod AI Voice Changer | 5% off | https://link.xsolla.com/KZBi89AY
✅ 🌐 Squarespace Websites | https://squarespace.syuh.net/XYaqYM
✅ 🔍 Grammarly | https://grammarly.go2cloud.org/SH3nL
✅ 🛍️ Shopify | https://shopify.pxf.io/XY9rPa
✅ 📋 Notion | https://affiliate.notion.so/rffva4tr71ax
✅ 🖼️ Figma | https://psxid.figma.com/lqjg97licpry
✅ 🤖 ElevenLabs Text-to-Speech | https://try.elevenlabs.io/taqepq60mptr
🎒 MY COURSES
- Excel for Beginners in under 2 hours: https://kevinstratvert.thinkific.com/
🙏 REQUEST VIDEOS
https://forms.gle/BDrTNUoxheEoMLGt5
🔔 SUBSCRIBE ON YOUTUBE
https://www.youtube.com/user/k....evlers?sub_confirmat
⚖ DISCLOSURE
Some links are affiliate links. Purchasing through these links gives me a small commission to support videos on this channel. The price to you is the same.
#stratvert
🔥 Learn Excel in just 2 hours: https://kevinstratvert.thinkific.com
In this step-by-step tutorial for beginners, learn how to create a pivot table in Microsoft Excel. With an Excel Pivot Table, you can very quickly and easily analyze data without needing to use any formulas or functions. You can generate insights just by dragging and dropping fields. We start with how to prep your data and then walk through all the core functionality of pivot tables, including sorting, filtering, inserting charts, slicers, timelines, and more. By the end of this tutorial, you'll be confident using pivot tables in Excel.
📚 RESOURCES
- Exercise workbook to follow along: https://1drv.ms/x/s!AmxrofZZlZ....-whO06YVUWhUW1CWJ93A
- Excel for Beginners course: https://kevinstratvert.thinkific.com/
⌚ TIMESTAMPS
00:00 Introduction
00:41 Overview of data
01:56 Prep data
02:48 Turn data into table
03:43 Insert pivot table
04:16 Pivot table interface
04:59 Build basic pivot table with rows and values
06:27 Change formatting
06:40 Summarize values by
07:59 Remove fields
08:43 Sorting
09:47 Filtering
11:03 Show values as
11:54 Custom field headers
12:19 Multiple rows
12:50 Columns
13:30 Design
14:13 Pivot charts
14:44 Insert slicer
15:25 Insert timeline
15:56 Copy pivot table
16:13 Calculated fields
17:25 Refresh for new data
18:20 Source data
18:33 Recommended and Analyze Data
20:02 Wrap up
📺 RELATED VIDEOS
- Playlist with all my videos on Excel: https://youtube.com/playlist?l....ist=PLlKpQrBME6xLYou
📩 NEWSLETTER
- Get the latest high-quality tutorial and tips and tricks videos emailed to your inbox each week: https://kevinstratvert.com/newsletter/
🔽 CONNECT WITH ME
- Official website: http://www.kevinstratvert.com
- LinkedIn: https://www.linkedin.com/in/kevinstratvert/
- Discord: https://bit.ly/KevinStratvertDiscord
- Twitter: https://twitter.com/kevstrat
- Facebook: https://www.facebook.com/Kevin....-Stratvert-101912218
- TikTok: https://www.tiktok.com/@kevinstratvert
- Instagram: https://www.instagram.com/kevinstratvert/
🎁 TOOLS AND DISCOUNTS
✅ 🎙️ Voicemod AI Voice Changer | 5% off | https://link.xsolla.com/KZBi89AY
✅ 🌐 Squarespace Websites | https://squarespace.syuh.net/XYaqYM
✅ 🔍 Grammarly | https://grammarly.go2cloud.org/SH3nL
✅ 🛍️ Shopify | https://shopify.pxf.io/XY9rPa
✅ 📋 Notion | https://affiliate.notion.so/rffva4tr71ax
✅ 🖼️ Figma | https://psxid.figma.com/lqjg97licpry
✅ 🤖 ElevenLabs Text-to-Speech | https://try.elevenlabs.io/taqepq60mptr
🎒 MY COURSES
- Go from Excel novice to data analysis ninja in just 2 hours: https://kevinstratvert.thinkific.com/
🙏 REQUEST VIDEOS
https://forms.gle/BDrTNUoxheEoMLGt5
🔔 SUBSCRIBE ON YOUTUBE
https://www.youtube.com/user/k....evlers?sub_confirmat
🙌 SUPPORT THE CHANNEL
- Hit the THANKS button in any video!
- Amazon affiliate link: https://amzn.to/3kCP2yz
⚖ DISCLOSURE
Some links are affiliate links. Purchasing through these links gives me a small commission to support videos on this channel. The price to you is the same.
#stratvert #excel
Join 400,000+ professionals in our courses here 👉 https://link.xelplus.com/yt-d-all-courses
Discover how to create a pivot table in Excel. Ideal for anyone looking to quickly analyze data, create reports, or gain insights without complex formulas. Pivot Tables make data analysis accessible and efficient.
⬇️ Download the file I used in the video from here: https://pages.xelplus.com/pivot-tables-basics-file
Learn hidden productivity tips when working with Excel Pivot Tables. At first Pivot Tables might seem like a complex tool but they are one of Excel's EASIEST features to work with. They help you summarize data really FAST.
What You'll Learn:
▪️ Setting Up Data for Pivot Tables: Learn how to prepare your data for Pivot Tables, including organizing it in a tabular format and converting it into an official Excel table.
▪️ Creating Pivot Tables: Understand the basics of inserting Pivot Tables, including using the 'Recommended PivotTables' feature for a quick start.
▪️ Customizing Pivot Tables: Dive into sorting values, changing number formats, adding filters, and adjusting the design and layout of your Pivot Tables.
▪️ Advanced Pivot Table Features: Explore how to show values as percentages of grand totals, connect slicers to multiple Pivot Tables, and ensure automatic updates with new data.
We'll also cover how to add Pivot Slicers to get a professional visual to apply filters to our Pivot Table.
00:00 How to Create Pivot Table in Excel?
01:35 Convert Data to Excel Tables
02:46 Create Pivot Table
04:08 Change aggregation in Pivot Table to average or count
04:40 Adjust number format in Pivot Table
05:10 Add filter to Pivot Table
05:28 Add column fields to Pivot Table
05:50 Removing Grand Totals and Sub Totals in Pivot Table
06:27 Update Pivot Table layout and design
07:14 How to bring back Pivot Table Fields dialog box
07:42 Update Pivot Table column header without errors (pivot table field name not valid)
08:33 Sort values in Pivot Table
08:41 Lock column width on Pivot Table refresh
09:00 Add Value as percentage of grand total in Pivot Table
10:22 Add Pivot Table Slicers to Filter Data
11:10 Connect Slicer to multiple Pivot Tables
11:50 Refresh Pivot Tables
12:40 Benefits of Pivot Tables
➡️ Join this channel to get access to perks: https://www.youtube.com/channe....l/UCJtUOos_MwJa_Ewii
🎓 Not sure which of my Excel courses fits best for you? Take the quiz: https://www.xelplus.com/course-quiz/
🎥 RESOURCES I recommend: https://www.xelplus.com/resources/
🚩Let’s connect on social:
Instagram: https://www.instagram.com/lgharani
LinkedIn: https://www.linkedin.com/company/xelplus
Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
#excel
Want more Excel videos? Here’s my Excel playlist: https://www.youtube.com/playli....st?list=PLmkaw6oRnRv This video tutorial will show you how to use Microsoft Excel for beginners level 2. Click here to go to level 1 for beginners https://youtu.be/k1VUZEVuDJ8 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: https://youtu.be/PqczHnsNFdM
Dive deeper into formulas and functions in excel with this playlist: https://youtube.com/playlist?l....ist=PLmkaw6oRnRv_GeQ
Subscribe to Teacher's Tech: http://bit.ly/Subscribe_TeachersTech
0:00 Introduction
1:12 Simple copy/paste
3:23 Transpose paste in Excel
5:21 Copy and paste formulas in Excel
6:53 Paste a link
8:47 Special paste in Microsoft Excel
10:18 How to use Flash Fill in Excel
12:53 Different ways to use Flash Fill
15:28 Hyperlinks in Excel (link to websites)
19:16 Create a directory or table of contents with internal links
***More Videos on Microsoft Excel***
Dive deeper into formulas and functions: https://youtu.be/tyGaEl3ec8o
Microsoft Excel for Beginners - Level 1: https://youtu.be/k1VUZEVuDJ8
Microsoft Excel for Beginners - Level 2: https://youtu.be/bhZckWTLkJM
Microsoft Excel for Beginners - Level 4: https://youtu.be/c8qePWuYleg
Microsoft Excel for Beginners - Level 5: https://youtu.be/sK4-Jk7SCPg
VLOOKUP Function for Excel: https://youtu.be/Lw03WcG4mt4
Learn Pivot Tables for Beginners: https://youtu.be/igSovq_H24A
How to QUICKLY Use 3D Formulas in Excel: https://youtu.be/Ad5QbfQLM2s
How to Create Drop-Down List in Excel: https://youtu.be/sgB7xUnX4O8
10 Best Excel Tips for Beginners: https://youtu.be/ZthlSLYc5UQ
How to Make a Line Graph in Excel: https://youtu.be/0jdX22qM8JA
I use Camtasia to create my videos:
Use this coupon code: TEACHCAM10
Camtasia purchase with 10% OFF code applied: https://techsmith.z6rjha.net/c/1264585/701976/5161
Camtasia EDU 10% OFF with code applied: https://techsmith.z6rjha.net/c/1264585/704928/5161
Camtasia Download page: https://techsmith.z6rjha.net/c/1264585/489271/5161
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 the support!
In this video, I will teach you the most basic functions in Microsoft Excel to get you familiar with the program. You will learn rows, columns, text formatting and more. You'll create your first spreadsheet, a very basic contact list. More videos in this series to come!
Subscribe to my channel to get notified when I release NEW content for you!:
http://www.youtube.com/AskYour....ComputerGuy?sub_conf
Help support this channel!
Scott's Computer Stuff wish list: https://www.amazon.com/hz/wish....list/ls/2CUVNWTUF9J1
Scott's YouTubey stuff wish list:
https://www.amazon.com/hz/wish....list/ls/POI6B4LK90RH
ALL my tools that I *highly* recommend and use personally every day...
Hardware ---
- 142-piece magnetic electronics precision screwdriver set with 120 bits
https://amzn.to/3exdNeb
- StarTech 4-bay USB 3.0 hard drive docking station 6Gbps
https://amzn.to/3z6zNpG
- StarTech 2-bay USB 3.0 hard drive docking station SATA 6Gbps
https://amzn.to/3sAGZt0
- Netgear A6100 wifi adapter
https://amzn.to/3DWUp5p
- Godshark NVME to USB adapter M.2 SSD to Type-A USB 10Gbps
https://amzn.to/3FGw3O8
- Cordless, rechargeable air duster 6000mAh 10w fast-charging
https://amzn.to/3pzJWIa
Virus/malware cleaning software ---
Avast (absolutely the best FREE anti-virus program available anywhere!):
https://bit.ly/3nK9rFL
MalwareBytes - protect your important files and keep malware off your computer
https://bit.ly/30PerjA
RogueKiller (a great malware/virus removal tool):
https://bit.ly/3CLOyhV
HitMan Pro (another great malware/virus removal tool):
https://bit.ly/3GuYD5c
CCleaner (used to clean up temporary files and get rid of forgotten junk on your PC):
http://www.ccleaner.com
Rkill (used to block active malware processes so you can clean your computer):
https://www.bleepingcomputer.com/download/rkill/
TronScript (one of the most amazing PC cleanup tools you'll ever use, and FREE!):
https://www.softpedia.com/get/....Tweak/System-Tweak/T
Helpful/useful everyday software ---
Backup your CRITICAL data automatically with Carbonite!
https://bit.ly/3qvWMqe
Ninite (used to automatically download and install your favorite software):
http://www.ninite.com
Defraggler (used to defragment and organize your files):
http://www.defraggler.com
Open Office (Microsoft Office FREE replacement)
http://www.openoffice.org
Hey, do you want even MORE in-depth techie stuff? Check out my friend Nico's page, Nico Knows Tech:
https://www.youtube.com/nicoknowstech
*** FIND ME ON SOCIAL MEDIA: ***
YouTube: https://www.youtube.com/AskYourComputerGuy
Twitter: https://www.twitter.com/AskMeComputers
Facebook: https://www.facebook.com/askyourcomputerguy
LinkedIn: https://www.linkedin.com/in/as....k-your-computer-guy-
Instagram: https://www.instagram.com/askyourcomputerguy/
Discord: https://discord.gg/jPwMdc3MVW
*** Affiliate link notice ***
Some links included in this video are affiliate links. The creator may make a small percentage
from any products you purchase through one of these links. This comes at ZERO extra cost to you, and greatly helps to support the growth of this channel. Thanks so much for watching!
Photo and image credits:
Photo by Ketut Subiyanto from Pexels
Photo by Kindel Media from Pexels
Photo by Lukas from Pexels
Image by OpenIcons from Pixabay
Image by StockSnap from Pixabay
Image by mohamed Hassan from Pixabay
Image by OpenClipart-Vectors from Pixabay
Image by Denys Vitali from Pixabay
Image by Clker-Free-Vector-Images from Pixabay
Image by Christian Dorn from Pixabay
Video credits:
Boardroom collaboration: https://www.videvo.net/video/o....verhead-view-of-male
Stock charts: https://www.videvo.net/video/t....racking-in-stock-mar
Here's my entire playlist of Excel tutorials: http://bit.ly/tech4excel
Learn many of the intermediate skills, tips, and tricks that you'll need in order to be able to use Excel effectively. This is the second of several video tutorials on Excel. Please consider watching my other video: The Beginner's Guide to Excel. In this intermediate video you'll learn some advanced formatting tools such as conditional formatting, how to save time by using the Autofill Handle, the basics of formulas and functions, sorting and filtering, and a few random useful tips such as Freeze Panes. Find my whole Excel playlist here: http://bit.ly/tech4excel
Join this channel to get access to perks:
https://www.youtube.com/channe....l/UCYUPLUCkMiUgiyVul
***Consider supporting Technology for Teachers and Students on Patreon***: https://www.patreon.com/techno....logyforteachersandst Here's the practice file that goes with the video: http://bit.ly/intermexcel
Click below for more information about some of the movies mentioned in this tutorial:
Dirty Rotten Scoundrels: http://amzn.to/2xTpck1
The Princess Bride: http://amzn.to/2yk3tDc
Ladyhawke: http://amzn.to/2xOhLsA
Stardust: http://amzn.to/2yjJvs9
Young Sherlock Holmes: http://amzn.to/2xaJJNv
Mystery Men: http://amzn.to/2yRmQ3r
Excel 2021 Beginner Tutorial
Get Ad-Free Training by becoming a member today!
https://www.youtube.com/channe....l/UCqyBfm_H9ugGirk1u
Exercise Files: https://bit.ly/3xZKDiw
Who it's for: Beginners - experienced, everyday users looking to sharpen their skills and increase efficiency in Microsoft Excel.
What it is: Microsoft’s spreadsheet application used to clean and organize data.
What you'll learn: We start with the basics, showing you the user interface and quick 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. Then, we dive into one of Excel’s most popular features; the Pivot Table. Our Advanced training starts with basic functions like the IF function. After that, we explore complex Database functions, provide 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 Trainings please visit:
https://www.learnit.com/privat....e-group-classes-work
Manuals: https://bit.ly/30xZb59
Username: manuals
Password: password
Start 0:00
Introduction 0:03
Start Screen 2:35
Excel Interface 7:03
Zooming, Navigating, and Shortcuts 13:31
Performing Excel Calculations 28:19
Simple Excel Functions 36:53
ABS, REF, and AutoFill Functions 42:25
Checking Compatibility 47:51
Inserting, Moving, and Cutting 49:29
Cell Styles 54:30
Themes 59:41
Showing and Hiding Worksheets 1:03:16
Grouping Worksheets 1:06:19
Freeze Panes 1:08:45
Custom Views 1:14:15
Saving Templates 1:16:09
Spell Check 1:18:36
Print Preview 1:20:09
Conclusion 1:23:17
#excel #excel2021 #exceltutorial
(C) 2022 Learnit, Inc.
Any illegal reproduction of this content will result in immediate legal action.
Here is the sample file: https://www.codybaldwin.com/sample-file-pivot. Interested in learning more. You can use the following link to enroll in my course, "Become a Microsoft Excel Wizard in 1 Hour": https://www.codybaldwin.com/excel-course.
Learn pivot tables in 6 minutes... Pivot tables allow you to automatically summarizes your data... so you can “slice-and-dice” in a million ways. This means you can replace lots of hand-typed summary calculations with more automated reporting. To create a pivot table, select a cell in your table and click “PivotTable” on the “Insert” tab.
Looking for a Career Switch? Check out: https://www.chikat.in/
Book a free 15 minute Career Counselling session with us: https://forms.gle/gfUcetraXDu3XXyp9
***********************************************************************
Download this Practice Workbook HERE: https://forms.gle/MLtkd5gBmWhkNkLE6
********************************************************
Welcome to the second video of the Complete MS Excel Course for Beginners!
1. In the first video, we have learnt about the various job opportunities that require MS Excel as a skill, along with how you can access MS Excel for free.
2. The second video (which is this one!) is a Complete MS Excel Tutorial for Beginners. I have also created a practice excel workbook for you, that you can download and practise those features along with me while watching the video. (Scroll down for link!)
3. And in the third video, we are going to cover 10 most commonly asked MS Excel Interview Questions along with their answers. (Link to download this Interview practice sheet is in the description of Video 3)
Today’s Agenda:
1. Basics of a Workbook
2. What are Flash-Fill and Auto-Fill
3. What is an MS Excel Ribbon?
4. The Home tab features .. including find, search and replace.
5. View tab features… Split and Freeze Pane
6. What are Functions and Formulas? What is the difference between Function and Formulas?
7. What is Absolute and Relative Referencing
8. Logical Functions
9. Text Functions
10. LookUp function
11. Tables and Charts
12. Pivot Tables
13. And last but not the least, how to handle the most commonly encountered errors in MS Excel.
So it doesn’t matter if you are a beginner or someone looking to brush up their basics right before an interview, I promise, by the end of these 3 videos you’ll excel at your excel skills.
Don’t forget to comment and tell me what job role you are learning Excel for. It will help me decide what career videos to make next for you.
Let’s start learning! :)
*********************************************************
TIMESTAMPS:
0:00 - Introduction
2:18 - Workbook Basics
2:58 - Cell Name/Cell Address and Cell Range
5:09 - Insert/Delete and Hide Rows/Columns
7:06 - Introduction to the MS Excel Ribbon
8:21 - Autofill and Flashfill
14:22 - Home Tab Features
14:44 - Formatting Options
15:52 - Wrap Text
16:15 - Merge and Centre
16:50 - Number Formats
17:33 - Conditional Formatting (Highlight Cell Rules, Data Bars, Icon Sets, Colour Scales, Clear Rules..)
19:50 - Auto-fit Column Width
20:11 - Find, Select and Replace
22:22 - Sort & Filter
25:50 - Split and Freeze Pane (View Tab Features)
28:59 - Difference Between Split and Freeze Pane
29:38 - Functions and Formulas
29:49 - Sum, Average, Max, Min
31:50 - Count, CountA, CountBlank
32:45 - Difference between Formula and Function
33:54 - Relative and Absolute References
38:38 - Mixed References
42:12 - Logical Functions
42:29 - IF Function
44:14 - Nested IF
45:09 - AND Function
46:22 - OR Function
47:40 - SumIF Function
49:44 - CountIF Function
50:30 - Text Functions
50:52 - Left, Right, Mid
51:40 - Upper, Lower, Proper
52:05 - Len and Trim
52:55 - Concat and TextJoin
54:15 - VLOOKUP
57:42 - VLOOKUP Limitation
59:57 - MS Excel Tables (Creation and Features)
1:04:14 - Slicers
1:06:30 - Charts
1:10:20 - Different Chart Types
1:12:04 - Pivot Tables (Cleaning Data, Create Pivot Table and Analyse Data Option)
1:21:27 - MS Excel Errors
1:25:25 - IFError Function
*********************************************************
LINKS TO OUR MS EXCEL COURSE:
1) Get MS Excel for FREE (Video 1): https://youtu.be/Uy3LK0aJGP4
2) Complete MS Excel Tutorial for Beginners (Video 2): https://youtu.be/4Mft-zhm3PQ
3) Most Commonly asked MS Excel Interview Questions and Answers (Video 3): https://youtu.be/rmJvLSUS4s0
Our Interview Preparation Course (12+ Videos): https://youtu.be/mu7T6PYUcBE
*********************************************************
OUR OTHER VIDEOS YOU MIGHT LIKE:
1) Stock Market for Beginners: https://youtu.be/x0G4WtO0LCQ
2) Zerodha Trading Tutorial for Beginners: https://youtu.be/QaKbnXndWUY
*********************************************************
#MSExcel #CompleteExcelTutorial #Excel2023 #LearnExcel
Excel allows us to filter data with a dedicated tool. We can even access it with an Excel shortcut. However, if we have to use the filtered data for further processing, it is not of much help.
This is where Excel FILTER Function helps us in writing Excel formulas that can get us filtered lists or filtered data. Excel filter function makes the whole process extremely easy as this function is an array function and data will simply spill over to cells to accommodate all the matching results.
In this tutorial, we are learning how to use Excel FILTER Function with an example to get dynamic filtered lists in Excel.
Lets Excel!
Access or Download Practice workbook for this Excel tutorial: https://1drv.ms/x/s!Apno7889bC....yLj1EYvIsJh92wI36F?e
For more Excel tips, tricks and tutorials don't forget to subscribe to @Learn Excel to excel YT channel.
Learn #Excel your way:
===================
Website: https://learnexceltoexcel.com/
--------------------------------------
Pick your favourite social page:
Fb: https://bit.ly/3yM3dvd
Tiktok: https://bit.ly/3wFllpf
Tw: https://bit.ly/3wGCRYU
Pin: https://bit.ly/3NsjKIU
Yt: https://bit.ly/3wxKL8a
Insta: https://bit.ly/3wtT9oW
Music by: https://youtube.com/ikson
#removeduplicatesexcel #exceltutorial #exceltips
✅ Download the free exercise files to follow along ➡️https://www.simonsezit.com/exc....el-2021-beginner-to-
This Microsoft Excel 2021 Beginner to Advanced training course covers everything from the basics of Excel to intermediate and advanced skills.
Topics covered include logical IF functions, Excel lookup functions, formatting, statistical functions, and more. Downloadable exercise files from the paid-for course are included, helping users master Excel.
The course covers how to launch Excel, explore the interface, use ribbons, tabs, and menus, utilize the Quick Access Toolbar, and more.
Additionally, the course covers intermediate topics such as cell styles, data input, navigation buttons, and more.
Finally, the course covers advanced topics such as dynamic arrays, two-way lookups, median and mode, rounding values, and more.
📝 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 - Introduction
0:00:22 - Course Intro
0:02:42 - Excel 2021 vs Excel 365
0:08:21 - Launching Excel
0:12:00 - The Start Screen
0:22:12 - Exploring the Interface
0:33:51 - Ribbons, Tabs and Menus
0:42:20 - Backstage Area
0:47:00 - Quick Access Toolbar
0:56:45 - Useful Keyboard Shortcuts
01:06:27 - Getting Help
01:13:04 - Exercise 01
01:15:27 - Working with Templates
01:24:30 - Workbooks and Worksheets
01:32:04 - Saving Workbooks
01:40:50 - Entering and Editing Data
01:50:43 - Navigating and Selecting Cells, Rows and Columns
01:58:02 - Exercise 02
02:03:22 - Formulas and Functions Explained
02:15:06 - SUM Function
02:22:44 - COUNT Function
02:30:10 - AVERAGE Function
02:34:27 - MIN and MAX Function
02:36:52 - Handling Errors in Calculations
02:45:34 - Absolute vs Relative Referencing
02:52:29 - Autosum and Autofill Options
03:02:12 - Flash Fill
03:07:15 - Exercise 03
03:12:26 - What are Named Ranges
03:21:33 - Managing Named Ranges
03:25:22 - Using Named Ranges
03:30:42 - Exercise 04
03:35:00 - Applying Number Formats
03:45:03 - Applying Date and Time Formats
03:50:41 - Formatting Cells, Rows and Columns
03:59:20 - Format Painter
04:04:00 - Exercise 05
04:08:21 - Intermediate Course Introduction
04:14:39 - Improve Readability with Cell Styles
04:19:36 - Controlling Data Input
04:27:55 - Adding Navigation Buttons
04:36:42 - Logical Functions
04:50:01 - The IF Function
04:55:27 - Nested IFs
05:03:29 - The IFs Function
05:09:34 - Conditional IFs
05:16:19 - Multiple Criteria
05:23:30 - Error Handling
05:29:33 - Exercise 01
05:37:02 - VLookup (Exact Match)
05:47:43 - VLookup (Approximate Match)
05:52:09 - HLookup
05:57:46 - INDEX and MATCH
06:08:18 - XLookup and XMatch
06:18:26 - OFFSET Function
06:29:16 - INDIRECT Function
06:38:22 - Exercise 02
06:47:27 - Sorting on Multiple Columns
06:50:31 - Soring Using a Custom List
06:54:05 - SORT and SORTBY Functions
07:04:04 - Advanced Filter
07:10:58 - UNIQUE Function
07:16:16 - FILTER Function
07:25:45 - Exercise 03
07:31:26 - How Date and Times are Stored
07:35:38 - Custom Data and Time Formats
07:42:47 - Time and Date Functions
07:51:33 - WORKDAY and WORKDAY.INTL Functions
07:55:22 - NETWORKDAYS and NETWORKDAYS.INTL Functions
07:58:19 - DATEDIF
08:04:32 - EDATE and EOMONTH
08:12:15 - Advanced Course Introduction
08:15:04 - Exercise 01
08:17:08 - Dynamic Arrays
08:19:23 - Spill and Arrays
08:30:18 - Extract and Count Unique Entries
08:36:33 - Unique vs. Distinct
08:39:54 - Unique with Multiple Criteria
08:43:07 - Unique Values by Column
08:47:30 - SORT Function
08:56:25 - Horizontal Sort
09:02:30 - SORTBY Function
09:08:40 - Horizontal SORTBY
09:11:47 - Sequence and Unstacking Records
09:21:54 - Filter Function
09:28:54 - Using Filter with Logic Plus Operator
09:33:41 - Using Filter with Logic Asterisk Operator
09:39:19 - Using Filter with Logic Equals Operator
09:43:32 - Using Filter with Logic Minus Operator
09:48:21 - RANDARRAY and RANDBETWEEN
09:58:06 - XLookUp
10:10:26 - XMatch
10:16:50 - Exercise 02
10:29:57 - Two-way Lookups
10:38:23 - CHOOSE Function
10:48:25 - SWITCH Function
10:52:58 - Exercise 03
11:00:03 - Median and Mode
11:06:20 - Using LARGE and SMALL
11:13:51 - Ranking Data
11:21:33 - COUNTBLANK Function
11:26:19 - Exercise 04
11:33:24 - Rounding Values
11:40:23 - Specialized Rounding
11:44:52 - Aggregate Function
11:49:26 - Exercise 05
🌍 Get unlimited training with Simon Sez IT’s 160+ 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
Check out our Microsoft Excel Long Tutorials playlist here
🔥https://www.youtube.com/playli....st?list=PLzj7TwUeMQ3
✅ PivotTable training here 👉 https://www.youtube.com/playli....st?list=PLzj7TwUeMQ3
💬Stay in touch!
SimonSezIT.com: https://www.SimonSezIT.com/
LinkedIn: https://www.linkedin.com/company/simon-sez-it/
Excel 2021 Full Course Tutorial (3+ Hours)
Get Ad-Free Training by becoming a member today!
https://www.youtube.com/channe....l/UCqyBfm_H9ugGirk1u
Exercise Files: https://learnitanytime.com/p/e....xercise-files-excel-
Who it's for: Beginners - experienced, everyday users looking to sharpen their skills and increase efficiency in Microsoft Excel.
What it is: Microsoft’s spreadsheet application used to clean and organize data.
What you'll learn: We start with the basics, showing you the user interface and quick 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. Then, we dive into one of Excel’s most popular features; the Pivot Table. Our Advanced training starts with basic functions like the IF function. After that, we explore complex Database functions, provide 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 Trainings please visit:
https://www.learnit.com/privat....e-group-classes-work
Manuals: https://bit.ly/30xZb59
Username: manuals
Password: password
Start 0:00
Introduction 0:03
Start Screen 2:35
Excel Interface 7:03
Zooming, Navigating, and Shortcuts 13:31
Performing Excel Calculations 28:19
Simple Excel Functions 36:53
ABS, REF, and AutoFill Functions 42:25
Checking Compatibility 47:51
Inserting, Moving, and Cutting 49:29
Cell Styles 54:30
Themes 59:41
Showing and Hiding Worksheets 1:03:16
Grouping Worksheets 1:06:19
Freeze Panes 1:08:45
Custom Views 1:14:15
Saving Templates 1:16:09
Spell Check 1:18:36
Print Preview 1:20:09
Conclusion 1:23:17
Introduction 1:23:59
Formatting Lists as Tables 1:25:19
Flash Fill 1:34:16
Custom Sorting 1:37:03
Subtotals 1:41:15
QA Tool 1:45:55
Data Charts 1:49:01
Sparklines 1:56:29
Introduction to Pivot Tables 2:01:26
Advanced Pivot Tables Options 2:13:32
Data Validation 2:21:01
Conditional Formats 2:27:34
Comments and Notes 2:34:05
Linking Data 2:36:40
Privacy and Protection 2:39:41
Conclusion 2:43:16
Introduction 2:43:41
Nesting Functions 2:46:48
Database Functions 2:54:40
XLOOKUP 3:03:11
UNIQUE 3:11:03
SORT and SORTBY 3:16:54
FILTER 3:22:48
LET 3:29:18
Consolidate 3:34:42
Introduction to Macros 3:39:27
Recording and Playing Macros 3:42:02
Conclusion 3:47:27
#excel #excel2021 #exceltutorial
(C) 2023 Learnit, Inc.
Any illegal reproduction of this content will result in immediate legal action.
MS Excel - Pivot Table Example 1 Video Tutorials
Lecture By: Mr. Pavan Lalwani Tutorials Point India Private Limited
To Buy Full Excel Course: https://bit.ly/38Jyu3p
Use coupon "YOUTUBE" to get FLAT 10% OFF at Checkout.
Check out latest Video Courses and eBooks : https://www.tutorialspoint.com/market/index.php
Pivot tables allow you to automatically summarize your complex data in simple ways and analyze the data. This means you can replace lots of hand-typed summary calculations with more automated reporting.
For more updates on courses and tips follow us on:
Facebook: https://www.facebook.com/tutorialspointindia
Twitter: https://twitter.com/tutorialspoint
LinkedIn: https://www.linkedin.com/company/tutorialspoint
✅ Download to follow along and complete the exercises ➡️https://www.simonsezit.com/exc....el-2021-beginner-and
In this Excel 2021 Beginner to Intermediate training course, go from zero to hero as we cover the basics and expand to intermediate Excel skills. We'll go over Excel logical IF functions, Excel lookup functions such as VLOOKUP and XLOOKUP, importing data into Excel, formatting, and so much more!
We've even included downloadable exercise files from our paid-for course, which means you can complete the exercises in this Microsoft Excel 2021 Tutorial and put what you are learning into practice. This will help you master the various Excel tips and tricks taught.
✅https://www.simonsezit.com/exc....el-2021-beginner-and
📝Use the timestamps below to navigate to different sections of the course. If you already know one of these topics, skip ahead!
00:00:00 - Introduction
00:00:22 - Course Intro
00:02:42 - Excel 2021 vs Excel 365
00:08:21 - Launching Excel
00:12:00 - The Start Screen
00:22:12 - Exploring the Interface
00:33:51 - Ribbons, Tabs and Menus
00:42:20 - Backstage Area
00:47:00 - Quick Access Toolbar
00:56:45 - Useful Keyboard Shortcuts
01:06:27 - Getting Help
01:13:04 - Exercise 01
01:15:27 - Working with Templates
01:24:30 - Workbooks and Worksheets
01:32:04 - Saving Workbooks
01:40:50 - Entering and Editing Data
01:50:43 - Navigating and Selecting Cells, Rows and Columns
01:58:02 - Exercise 02
02:03:22 - Formulas and Functions Explained
02:15:06 - SUM Function
02:22:44 - COUNT Function
02:30:10 - AVERAGE Function
02:34:27 - MIN and MAX Function
02:36:52 - Handling Errors in Calculations
02:45:34 - Absolute vs Relative Referencing
02:52:29 - Autosum and Autofill Options
03:02:12 - Flash Fill
03:07:15 - Exercise 03
03:12:26 - What are Named Ranges
03:21:33 - Managing Named Ranges
03:25:22 - Using Named Ranges
03:30:42 - Exercise 04
03:35:00 - Applying Number Formats
03:45:03 - Applying Date and Time Formats
03:50:41 - Formatting Cells, Rows and Columns
03:59:20 - Format Painter
04:04:00 - Exercise 05
04:08:11 - Working with Rows and Columns
04:16:36 - Deleting and Clearing Cells
04:23:02 - Aligning Text and Numbers
04:34:15 - Applying Themes and Styles
04:42:13 - Course Introduction
04:48:31 - Improve Readability with Cell Styles
04:53:30 - Controlling Data Input
05:01:49 - Adding Navigation Buttons
05:10:36 - Logical Functions
05:23:56 - The IF Function
05:29:25 - Nested IFs
05:37:24 - The IFs Function
05:43:27 - Conditional IFs
05:50:13 - Multiple Criteria
05:57:25 - Error Handling
06:03:27 - Exercise 01
06:10:56 - VLookup (Exact Match)
06:21:36 - VLookup (Approximate Match)
06:26:02 - HLookup
06:31:40 - INDEX and MATCH
06:42:09 - XLookup and XMatch
06:52:18 - OFFSET Function
07:03:10 - INDIRECT Function
07:12:17 - Exercise 02
07:17:19 - Sorting on Multiple Columns
07:24:25 - Soring Using a Custom List
07:28:00 - SORT and SORTBY Functions
07:37:49 - Advanced Filter
07:44:52 - UNIQUE Function
07:50:10 - FILTER Function
07:49:40 - Exercise 03
08:05:20 - How Date and Times are Stored
08:09:32 - Custom Data and Time Formats
08:16:42 - Time and Date Functions
08:25:26 - WORKDAY and WORKDAY.INTL Functions
08:29:16 - NETWORKDAYS and NETWORKDAYS.INTL Functions
08:32:13 - DATEDIF
08:38:28 - EDATE and EOMONTH
08:45:52 - Exercise 04
08:50:45 - Importing Data into Excel
09:00:40 - Removing Blank Rows, Cells and Duplicate Entries
09:06:02 - Changing Case and Removing Spaces
09:15:07 - Splitting Up Data Using Text to Columns
09:22:08 - Splitting Up Data Using Text Functions
09:30:13 - Flash Fill
09:35:13 - CONCAT
09:42:44 - Formatting Data as Table
🌍 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/playli....st?list=PLzj7TwUeMQ3
✅ Check out our free video playlist for Excel beginners 👉https://www.youtube.com/playli....st?list=PLzj7TwUeMQ3
✅ Excel 2021 Tutorials for Intermediate Users here 👉https://www.youtube.com/playli....st?list=PLzj7TwUeMQ3
✅ Microsoft Excel Tips and Tricks 👉https://www.youtube.com/playli....st?list=PLzj7TwUeMQ3
✅ Microsoft Office 2021 and Office 365 Training here 👉https://www.youtube.com/playli....st?list=PLzj7TwUeMQ3
💬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/simons....ezittraining?sub_con
If you enjoyed the video, please give a thumbs up 👍🏽 ;-)
🔥 Go from Excel novice to data analysis ninja in just 2 hours with my Excel for Beginners course: https://kevinstratvert.thinkific.com
Learn how to use formulas in Excel, including the following functions & formulas:
⌚ Timestamps
0:00 Introduction
0:55 Add
1:55 Subtract
2:18 Multiply
2:50 Divide
3:20 Sum
4:46 Min
5:05 Max
5:30 Count
6:15 Counta
6:48 Average
7:20 Median
7:54 Concatenate
8:29 If
9:10 Countif
9:40 Vlookup
10:58 Sumif
11:46 Current Time
📃 Watch related playlists and videos
- Excel: https://www.youtube.com/playli....st?list=PLlKpQrBME6x
- Pivot Tables: https://youtu.be/m0wI61ahfLc
- Vlookup & hlookup: https://youtu.be/8okA22yMwTs
- Mail Merge: https://youtu.be/_Efb_oMgxEs
- Learn the fundamentals of Excel in just 2 hours: https://kevinstratvert.thinkific.com
Thinking about subscribing to Office 365? You get the Word, Excel, and PowerPoint desktop apps and up to 6 TB cloud storage. Check the latest pricing on Amazon: https://amzn.to/2UgyoJ4 (as a disclaimer, purchasing through this link gives me a small commission to support videos on this channel -- the price to you is the same).
Let me know if you have any questions. Also, let me know if there are other topics that you would like to see videos on.
🚩 Connect with me on social
- LinkedIn: https://www.linkedin.com/in/kevinstratvert/
- Discord: https://discord.gg/kHuujY2pZf
- Twitter: https://twitter.com/kevstrat
- Facebook: https://www.facebook.com/Kevin....-Stratvert-101912218
- TikTok: https://www.tiktok.com/@kevinstratvert
- Instagram: https://www.instagram.com/kevinstratvert/
🙏 Request How To Tutorial Videos
https://forms.gle/BDrTNUoxheEoMLGt5
🔔 Subscribe to my YouTube channel
https://www.youtube.com/user/k....evlers?sub_confirmat
🎬 Want to watch again? Navigate back to my YouTube channel quickly
http://www.kevinstratvert.com
🛍 Support me with your Amazon purchases: https://amzn.to/3kCP2yz
⚖ As full disclosure, I use affiliate links above. Purchasing through these links gives me a small commission to support videos on this channel -- the price to you is the same.
#stratvert #excel
🔥 Learn Excel in just 2 hours: https://kevinstratvert.thinkific.com
In this step-by-step tutorial, learn how to use VLOOKUP, HLOOKUP, AND XLOOKUP in Microsoft Excel. With VLOOKUP, you can find things in a table or a range by row. For example, look up a price of an automotive part by the part number, or find an employee name based on their employee ID.
👋 Additional resources:
- Sample file to follow along: https://1drv.ms/x/s!AmxrofZZlZ....-whK4bPgcKpfbw0Iub5A
- Learn the fundamentals of Excel in just 2 hours: https://kevinstratvert.thinkific.com
⌚ Timestamps
0:00 Introduction
1:47 Organize data properly for VLOOKUP
5:38 VLOOKUP Exact match
9:34 Improve error message with IFERROR
11:10 VLOOKUP Closest match
14:48 VLOOKUP Across sheets
15:43 HLOOKUP
18:21 XLOOKUP Simple example
22:53 XLOOKUP Combined with other functions
24:54 XLOOKUP Returns an array
26:42 XLOOKUP Match modes
28:30 XLOOKUP Search modes
31:24 Wrap up
📃 Watch related playlists and videos
- Playlist with all my videos on Excel: https://youtube.com/playlist?l....ist=PLlKpQrBME6xLYou
📩 NEWSLETTER
- Get the latest high-quality tutorial and tips and tricks videos emailed to your inbox each week: https://kevinstratvert.com/newsletter/
🔽 CONNECT WITH ME
- Official website: http://www.kevinstratvert.com
- LinkedIn: https://www.linkedin.com/in/kevinstratvert/
- Discord: https://bit.ly/KevinStratvertDiscord
- Twitter: https://twitter.com/kevstrat
- Facebook: https://www.facebook.com/Kevin....-Stratvert-101912218
- TikTok: https://www.tiktok.com/@kevinstratvert
- Instagram: https://www.instagram.com/kevinstratvert/
🎁 TOOLS AND DISCOUNTS
✅ 🎙️ Voicemod AI Voice Changer | 5% off | https://link.xsolla.com/KZBi89AY
✅ 🌐 Squarespace Websites | https://squarespace.syuh.net/XYaqYM
✅ 🔍 Grammarly | https://grammarly.go2cloud.org/SH3nL
✅ 🛍️ Shopify | https://shopify.pxf.io/XY9rPa
✅ 📋 Notion | https://affiliate.notion.so/rffva4tr71ax
✅ 🖼️ Figma | https://psxid.figma.com/lqjg97licpry
✅ 🤖 ElevenLabs Text-to-Speech | https://try.elevenlabs.io/taqepq60mptr
🎒 MY COURSES
- Go from Excel novice to data analysis ninja in just 2 hours: https://kevinstratvert.thinkific.com/
🙏 REQUEST VIDEOS
https://forms.gle/BDrTNUoxheEoMLGt5
🔔 SUBSCRIBE ON YOUTUBE
https://www.youtube.com/user/k....evlers?sub_confirmat
🙌 SUPPORT THE CHANNEL
- Hit the THANKS button in any video!
- Amazon affiliate link: https://amzn.to/3kCP2yz
⚖ DISCLOSURE
Some links are affiliate links. Purchasing through these links gives me a small commission to support videos on this channel. The price to you is the same.
#stratvert #vlookup #excel
Dive into the world of Excel with our comprehensive 3-hour course, "How to Use Excel - A 3-Hour Path to Confidence and Skills." Whether you're just starting out or looking to enhance your existing skills, this tutorial is designed to build your proficiency and confidence in using Excel effectively. These Microsoft Excel lessons are laid out in a step-by-step approach to make learning Excel fun and easy..
What You'll Learn:
✔️Excel Basics: Get familiar with the Excel interface, basic functions, and how to navigate seamlessly.
✔️Formulas and Functions: Understand how to use essential formulas and functions to automate calculations and tasks.
✔️Data Management: Learn techniques for sorting, filtering, and managing large datasets efficiently.
✔️Charts and Graphs: Master the art of visualizing data with Excel's charting tools to make your information stand out.
✔️Tips and Tricks: Discover shortcuts and professional tips to enhance your productivity and make your work with Excel easier.
Who This Video Is For:
✔️Beginners eager to learn Excel from scratch.
✔️Intermediate users wanting to sharpen their skills and learn new techniques.
✔️Professionals seeking to leverage Excel for more efficient data management and analysis.
Why Choose This Tutorial?
✔️Step-by-Step Guidance: Our structured approach ensures you gain hands-on experience with practical exercises.
✔️Real-World Applications: Learn how to apply Excel skills in real-world scenarios, enhancing your learning experience.
✔️Expert Tips: Benefit from expert insights that will save you time and increase your efficiency in Excel.
All Practice Files: https://go.teachers.tech/All_Practice_Files
More videos to dig deeper into Microsoft Excel
🎥How to Print in Excel - https://youtu.be/KO4s0s7xvR0
🎥Formulas and Functions in Excel - https://youtu.be/tyGaEl3ec8o
🎥Charting in Excel = https://youtu.be/64DSXejsYbo
🎥How to use Power Query: https://youtu.be/MHIV0bYryiw
🎥How to use Power Pivot: https://youtu.be/kyGhgreDNUQ
🎥How to use the XLOOKUP Function: https://youtu.be/tPaXEZRh9_k
🎥Drop-down lists with XLOOKUP: https://youtu.be/fjn4vlWwpCo
🎥Drop-down with the INDIRECT function: https://youtu.be/oYF162_Cmwc
Video Chapters
0:00 - Introduction to Excel for Beginners
0:46 - Opening Microsoft Excel: A Beginner's Guide
2:41 - How to Create a Blank Workbook in Excel
2:48 - Understanding Basic Excel Terminology and Layout
5:09 - Navigating the Excel Interface: Tabs, Ribbons, and Groups
6:47 - Saving Your Excel Workbook: Best Practices
8:17 - How to Enter Column Headers in Excel
9:38 - Formatting Columns and Rows for Better Readability
11:49 - Enhancing Your Data: Formatting Text and Cells in Excel
15:50 - Utilizing Cell Styles for Professional-Looking Spreadsheets
16:29 - Mastering Text Wrapping and Merging Cells
19:34 - Financial Formatting: Adding Dollar Symbols and Number Formatting
20:58 - Printing Excel Spreadsheets: Tips and Tricks
22:26 - Organizing Your Work: Creating and Naming New Sheets
23:04 - Formula Basics: Creating Formulas with Cell References
27:44 - Absolute Cell Referencing: Locking in Your References
30:13 - Enhancing Your Analysis: Adding Functions in Excel
34:52 - Data Management: Sorting and Filtering Your Data
37:35 - Visualizing Data: Adding Charts in Excel
43:57 - Customizing Your Excel Ribbon for Efficiency
46:24 - Mastering Autofill: A Key Time-Saver in Excel
51:19 - Flash Fill: Automating Data Entry with Ease
55:25 - Combining Cells Efficiently in Excel
1:02:11 - Essential Keyboard Shortcuts for Column & Row Adjustments
1:03:45 - Advanced Techniques for Sorting Data in Excel
1:06:11 - Implementing Filters for Efficient Data Management
1:07:11 - Advanced Filtering in Excel: A Step-by-Step Guide
1:09:30 - Simplifying Data Extraction with the FILTER Function
1:12:14 - Maximizing Efficiency with Excel Tables
1:17:31 - Interactive Data Filtering: Adding Slicers in Excel
1:20:19 - Understanding Cell Referencing: Relative vs. Absolute
1:29:14 - Making Decisions in Excel with the IF Function
1:33:15 - Enhancing the IF Function with AND Conditions
1:36:05 - Complex Decision Making: Nested IF and AND Functions
1:39:03 - Streamlining Data Entry with Dropdown Lists
1:42:57 - Easy Reference: Building Named Ranges in Excel
1:44:16 - Unlocking Potential with the INDIRECT Function
1:48:11 - Crafting a User-Friendly Data Entry Form in Excel
1:50:54 - Gaining Insights: Conditional Formatting in Excel
2:00:00 - Analyzing Data with SUMIF and SUMIFS Functions
2:06:51 - Counting Data Points with COUNTIF and COUNTIFS Functions
2:20:16 - Working with Dates: Date and Time Functions in Excel
2:31:04 - Mastering Pivot Tables for Data Analysis in Excel
2:47:51 - Lookup Techniques: How to Use VLOOKUP in Excel
2:57:30 - Leveraging the UNIQUE and FILTER Functions for Advanced Data Analysis
#exceltutorial #excelskills #learnexcel #exceltips
This video provides a basic introduction into the top 10 most important formulas used in excel. These include the average function, autosum, Sum If, Count, Counta, Count If function, Concantenate, If logical function, Vlookup, and Drop Down Lists.
Full-Length Math & Science Videos:
https://www.patreon.com/mathsc....iencetutor/collectio
Excel Tutorial For Beginners:
https://www.youtube.com/watch?v=nK-uNYuvcag
Top 30 Excel Tips & Shortcuts:
https://www.youtube.com/watch?v=UMad9_-4rOU
_________________________________________
Excel - Statistics - Mean, Median, Mode:
https://www.youtube.com/watch?v=aRR86imVsxM
Excel Scatter Charts:
https://www.youtube.com/watch?v=hwqq0HYrers
Excel - Finding Slope & Y-Intercept:
https://www.youtube.com/watch?v=KwQsV77bYDY
Solving Polynomial Equations - Goal Seek:
https://www.youtube.com/watch?v=lomAl6XB_SM
__________________________________________
How To Calculate Loan Payments In Excel:
https://www.youtube.com/watch?v=ifbNN2SoKlk
How To Create an Amortization Table:
https://www.youtube.com/watch?v=QZfMW203v4U
How To Look Up Customer Data In Excel:
https://www.youtube.com/watch?v=HDda6ny40ZM
How To Create a Data Entry Form In Excel:
https://www.youtube.com/watch?v=_tZLGBgQCYo
_________________________________________
YouTube Channel Growth Accelerator:
https://www.patreon.com/YouTub....eChannelGrowthAccele
Algebra For Beginners:
https://www.video-tutor.net/al....gebra-for-beginners-
Final Exams and Video Playlists:
https://www.video-tutor.net/
Full-Length Math & Science Videos:
https://www.patreon.com/mathsc....iencetutor/collectio
Want more Excel videos? Here’s my Excel playlist: https://www.youtube.com/playli....st?list=PLmkaw6oRnRv This video tutorial will show you how to use Microsoft Excel for beginners level 4. Click here to go to level 1 for beginners https://youtu.be/k1VUZEVuDJ8 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
Here's a link to the practice data: https://drive.google.com/file/....d/1vUHUUZq5mFWJZR1E9
Intermediate Microsoft Excel Lesson 1: https://youtu.be/PqczHnsNFdM
Dive deeper into formulas and functions in excel with this playlist: https://youtube.com/playlist?l....ist=PLmkaw6oRnRv_GeQ
Read my Excel Tutorial here: https://teachers.tech/microsoft-excel-tutorial/
Subscribe to Teacher's Tech: http://bit.ly/Subscribe_TeachersTech
0:00 Introduction
1:04 What is Conditional Formatting in Excel?
1:44 How to use Conditional Formatting
12:18 What is Data Validation in Microsoft Excel?
12:53 How to create a drop-down menu in Excel
15:31 Create a drop-down list from a list
20:07 How does a slicer work in Microsoft Excel?
20:54 Add slicers to your worksheet
Learn about dependent drop-down lists in Excel: https://youtu.be/oYF162_Cmwc
***More Videos on Microsoft Excel***
Dive deeper into formulas and functions: https://youtu.be/tyGaEl3ec8o
Microsoft Excel for Beginners - Level 1: https://youtu.be/k1VUZEVuDJ8
Microsoft Excel for Beginners - Level 2: https://youtu.be/bhZckWTLkJM
Microsoft Excel for Beginners - Level 3: https://youtu.be/47yu50CsH00
Microsoft Excel for Beginners - Level 5: https://youtu.be/sK4-Jk7SCPg
VLOOKUP Function for Excel: https://youtu.be/Lw03WcG4mt4
Learn Pivot Tables for Beginners: https://youtu.be/igSovq_H24A
How to QUICKLY Use 3D Formulas in Excel: https://youtu.be/Ad5QbfQLM2s
10 Best Excel Tips for Beginners: https://youtu.be/ZthlSLYc5UQ
How to Make a Line Graph in Excel: https://youtu.be/0jdX22qM8JA
I use Camtasia to create my videos:
Use this coupon code: TEACHCAM10
Camtasia purchase with 10% OFF code applied: https://techsmith.z6rjha.net/c/1264585/701976/5161
Camtasia EDU 10% OFF with code applied: https://techsmith.z6rjha.net/c/1264585/704928/5161
Camtasia Download page: https://techsmith.z6rjha.net/c/1264585/489271/5161
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 the support!
In this video, I will show you how to import data from the internet to a worksheet in Microsoft Excel and I will show you how to use tables in Microsoft Excel.
Want more Excel videos? Here’s my Excel playlist: https://www.youtube.com/playli....st?list=PLmkaw6oRnRv
0:00 Introduction
1:23 Import data from a webpage to Excel sheet
7:28 Creating tables in Excel
9:30 Sorting in tables
10:55 Styles options in Excel Tables
14:30 Remove duplicate rows in tables
17:09 Create a table shortcut
17:33 Copy data across multiple sheets in Excel
19:33 Format an entire sheet in Excel
Practice Sheet: https://leveragingdigitalinc-m....y.sharepoint.com/:x:
Dive deeper into formulas and functions in excel with this playlist: https://youtube.com/playlist?l....ist=PLmkaw6oRnRv_GeQ
Subscribe to Teacher's Tech: http://bit.ly/Subscribe_TeachersTech
***More Videos on Microsoft Excel***
Dive deeper into formulas and functions: https://youtu.be/tyGaEl3ec8o
Microsoft Excel for Beginners - Level 1: https://youtu.be/k1VUZEVuDJ8
Microsoft Excel for Beginners - Level 2: https://youtu.be/bhZckWTLkJM
Microsoft Excel for Beginners - Level 3: https://youtu.be/47yu50CsH00
Excel for Beginners Tutorial - Level 4: https://youtu.be/c8qePWuYleg
VLOOKUP Function for Excel: https://youtu.be/Lw03WcG4mt4
Learn Pivot Tables for Beginners: https://youtu.be/igSovq_H24A
How to QUICKLY Use 3D Formulas in Excel: https://youtu.be/Ad5QbfQLM2s
10 Best Excel Tips for Beginners: https://youtu.be/ZthlSLYc5UQ
How to Make a Line Graph in Excel: https://youtu.be/0jdX22qM8JA
Get ready for Excel interview Assessment Test for job application using this step by step guide. In this tutorial you will learn 20 typical assessment exercises, asked during Excel interview assessment test.
Practice Microsoft Excel Assessment Test: https://www.howtoanalyzedata.n....et/how-to-pass-the-m
[Download Files Use in This Video – Premium Download]
- Download XLSX Work Files to Get Ready and Pass Excel Assessment Test: https://www.howtoanalyzedata.net/ugr5
The Microsoft Excel Assessment Test is a standardized evaluation tool designed to measure an individual's proficiency in using Microsoft Excel, a widely used spreadsheet software application.
By understanding the nature of the Microsoft Excel Assessment Test and adopting effective preparation strategies, job seekers can enhance their Excel skills and increase their chances of success in the recruitment process.
Excel assessment test is commonly used by employers during the recruitment process to assess candidates' Excel skills and determine their suitability for roles that require Excel proficiency.
In This Video:
1. How to extend Column B to fit Total Cost by month in Excel 00:01
2. How to calculate Total Cost of expenses by month using Formula in Excel 02:11
3. How to create a border around the table in Excel 03:43
4. How to format the data as currency in Excel 04:25
5. How to use a formula to calculate Total Costs in Excel 05:08
6. How to use a formula to calculate Average Costs in Excel 06:30
7. How to change the alignment in column D to right in Excel 07:51
8. How to calculate quarterly cost for Q1 (Quarter 1) and Q2 in Excel 08:13
9. How to save the file to Documents Folder in Excel 09:13
10. How to change page orientation to Landscape in Excel 09:40
11. How to fit work table into single page for print out in Excel 10:06
12. How to center table header values in Excel 11:47
13. How to check the spelling of the document in Excel 12:06
14. How to rename Sheet1 as Business Expenses in Excel 12:58
15. How to add a new worksheet in Excel 13:35
16. How to create a column chart to show expenses for the first quarter in Excel 13:52
17. How to change the width of Columns I and J so the contents fits in Excel 15:20
18. How to bold all headings and change headings font to 12 points in Excel 15:46
19. How to merge and Center the table heading "Business Expenses" in Excel 16:25
20. How to forecast Lease cost for third quarter by calculating Q3 total in Excel 17:19
__________
[Microsoft Office - 50% Discount]
Practice Microsoft Office Hiring Test:
https://www.howtoanalyzedata.n....et/how-to-pass-the-m
[Individual Office Products]
Practice Microsoft Excel Assessment Test: https://www.howtoanalyzedata.n....et/how-to-pass-the-m
Practice PowerPoint Assessment Test: https://www.howtoanalyzedata.n....et/microsoft-powerpo
Practice Word Assessment Test: https://www.howtoanalyzedata.n....et/microsoft-word-as
____
Prepare for an Assessment Test: https://www.howtoanalyzedata.n....et/assessment-test-p
Download FREE Sample Hiring Assessment Test Questions (PDF eBook): https://www.howtoanalyzedata.net/0fyb
____
LEGAL DISCLOSURE:
Copyright © 2024 Online Training for Everyone LLC. All rights reserved.
This training content was created by Online Training for Everyone LLC or its subsidiaries and hired contractors for illustrative purposes only to demonstrate fictitious data, ideas, and facts from the public domain related to the presented concepts. The content in this video is for informational purposes only and does not constitute professional advice. The actual user experience with the described system and content may be different and may not resemble the described content – viewer discretion is advised.
Online Training for Everyone LLC and its affiliates make no warranty that:
a) The materials are error-free, complete, reliable, or current
b) Defects will be corrected
c) The results obtained by the use of the demonstration components of this material will reflect the actual results obtained by the use of Online Training for Everyone LLC products and/or services.
This training content may contain the trade names or trademarks of various third parties, and if so, any such use is solely for illustrative purposes only. All product and company names are trademarks(TM) or Registered(C) trademarks of their respective holders. Use of them does not imply any affiliation with, endorsement by, or association of any kind between them and Online Training for Everyone LLC. You should not rely solely on the information provided in this video and should seek professional advice as appropriate.
#EmploymentTest #AssessmentTest #IQTest #OnlineTrainingForEveryone
Finally, a dedicated video to MS Excel!
In almost every video I make about Personal Finance, I figure out a way to include MS Excel in it!!
This video is not going to give a 100% understanding of Excel, so here is my recommended course on Udemy which I have taken personally, and go back to it whenever I need some help.
You can check it out here: https://bit.ly/3W0wkny
So why not give you a dedicated video on MS Excel?
MS Excel, in my opinion, is the most powerful software ever made!
I use it for everything - budgeting, my video ideas, all my personal finance, and whatnot!
In this video, I will explain to you the basic and most important thing about Excel, that if you understand this one thing, you are done with 80% of fundamentals!
Click here to subscribe to my YouTube channel: http://shorturl.at/bizNX
------------------------------------------------------------------------------------------------------------------
Ankur Warikoo is an entrepreneur, an angel investor, a mentor and an active public speaker.
For the past 4 years, Warikoo has been actively sharing content on YouTube, LinkedIn, Instagram, Facebook and Twitter amassing a following of 3 Million+ people.
He posts 3 Hindi and English videos every week on his YouTube channel, where he talks about entrepreneurship, how to grow in life, personal finance and failure.
Warikoo started his entrepreneurial journey in 2008. His most recent startup is nearbuy.com where he was the founder and CEO from 2015 until 2019.
Prior to that, Ankur started Groupon’s India business in 2011 and acted as the Country CEO from 2011-15, and Head of Groupon APAC from 2013-15.
An alumnus of the Indian School of Business, Ankur is an active Angel investor and mentor to several startups.
Ankur has been part of Fortune Magazine’s 40 under 40 List for India, LinkedIn India’s PowerProfiles List, LinkedIn India’s Spotlight List and India’s Top Executives under 40 list.
-----------------------------------------------------------------------------------------------------------------------------
My bestselling books:
‘GET EPIC SHIT DONE’: https://ankurwarikoo.com/getepicshitdone
‘Do Epic Shit’: https://ankurwarikoo.com/doepicshit
My gear for shooting this video:
🎥 Sony a7III camera: https://bit.ly/3M42wAV
🎬 Sony FE 24-70 f2.8 Lens: https://bit.ly/3KCCiF0
🎙️ Shure SM7B Microphone: https://bit.ly/3O1NAVA
🔆 Fill Light 60W: https://bit.ly/37aJolP
💡 Key Light 150W: https://bit.ly/3O9nyjs
📽️ Benro IT15 Tripod for Sony a7III camera: https://bit.ly/3O4PvJ1
Useful links:
20 books for your 20s: https://bit.ly/WarikooBooks
20 online courses for your 20s: https://bit.ly/WarikooOnlineCourses
Gadgets that I use: https://bit.ly/WarikooGadgets
The above links are on Amazon.
If you buy any of these using the above links, I stand to make affiliate income from it. 100% of this income is contributed towards the education of kids who cannot afford it. In 2021 we contributed 38L and in 2022 we contributed 53L.
Let’s connect online:
🎙️ My weekly podcast Woice with warikoo (Spotify): https://open.spotify.com/show/....1g7wpoqydK6hszvi4DFy
📩 My weekly newsletter warikoo Wanderings: https://ankurwarikoo.com/newsletter/
📱 Instagram: https://instagram.com/ankurwarikoo
🐦 Twitter: https://twitter.com/warikoo
👨🏻💻 LinkedIn: https://www.linkedin.com/in/warikoo
😄 Facebook: https://www.facebook.com/awarikoo/
🖋️ Daily Blog: https://ankurwarikoo.com/blog/
Are you ready to go beyond the Excel basics that you already know? This video is for you! You learn how to manage a large spreadsheet, how to work with multiple worksheets, how to work with data (including grouping and importing data, and more), advanced chart skills, how to work with data lists, how to document and audit a spreadsheet, and advanced printing options. This sequel to the best, most comprehensive Excel for Beginners course will help you take your Excel learning to the next level!
***Consider supporting Technology for Teachers and Students on Patreon***: https://www.patreon.com/techno....logyforteachersandst Here's my entire playlist of Excel tutorials: HTTP://bit.ly/tech4excel Please say "Thanks" by clicking the Thanks button below the video. Here are the practice files for this video: https://bit.ly/excelforintermediate #excel #exceltutorials #microsoft365 #microsoftexcel
Table of Contents:
00:00 - Intro
00:33 - MANAGING A LARGE SPREADSHEET
01:06 - Zoom Options
04:07 - Using Split
08:57 - Freeze Panes
11:50 - Adding, Reordering, and Naming Worksheet
14:36 - Naming Cells, Formulas, and Constants
19:31 - How to Quickly Enter Date and Time
20:40 - WORKING WITH MULTIPLE WORKSHEETS
21:23 - Editing the Same Cell in Multiple Sheets
23:26 - Opening Multiple Excel Windows
25:29 - Moving or Copying a Worksheet
27:54 - Linking Two Workbooks
30:59 - Creating a Summary Worksheet
33:22 - WORKING WITH DATA
33:38 - Grouping Data
37:24 - Importing Data into Excel
39:48 - Hyperlinking to Another File
41:44 - ADVANCED CHART SKILLS
41:59 - Creating a New Chart
45:32 - Customizing a Chart
47:36 - Adding or Editing Chart Titles
50:49 - Adding Graphics and Textboxes to Charts
54:16 - Adding WordArt to a Sheet
54:47 - Adding SmartArt Objects
56:33 - WORKING WITH DATA LISTS
57:20 - Using Data Forms to Add and Edit Records
01:03:47 - Sorting Data
01:07:30 - Filtering Data
01:10:24 - Creating a Custom Filter
01:12:29 - DOCUMENTING AND AUDITING A WORKSHEET
01:13:07 - Adding Comments and Notes
01:16:44 - Setting Up a Watch Window
01:20:27 - Other Auditing Features
01:22:21 - Error Checking
01:23:35 - ADDITIONAL PRINTING OPTIONS
01:24:13 - Changing Margins and Orientation
01:26:12 - Page Breaks and Page Break Preview
01:27:25 - Print Formulas
🔥 Learn Excel in just 2 hours: https://kevinstratvert.thinkific.com
In this step-by-step Microsoft Excel tutorial, learn how to use Formulas and Functions. We start with the fundamentals of entering formulas into Excel. Then we advance to the most common formulas and functions that you'll encounter in Excel. This video is perfect for beginners who are new to formulas and functions, and even more advanced users who want to pick up a new trick or two.
📚 RESOURCES
- Excel Workbook without formulas to follow along: https://1drv.ms/x/s!AmxrofZZlZ....-whN9F9EUuTyuaf_kIbQ
- Completed Workbook with all formulas and Functions: https://1drv.ms/x/s!AmxrofZZlZ....-whN9QhwPmlmuTzwgZBg
- Learn the fundamentals of Excel in just 2 hours: https://kevinstratvert.thinkific.com
⌚ TIMESTAMPS
00:00 Introduction
00:45 Status bar metrics
02:03 Enter formula to add
02:50 Edit formulas
03:06 Relative references
05:29 Fill handle
06:13 Subtract
06:57 Multiply
07:40 Absolute reference
09:46 Reference cells on other sheets
10:45 Name manager
12:03 Divide
12:44 Order of operations
14:40 Basic functions
15:04 Sum function
17:46 Formula text function
18:13 Discovering functions
18:37 Auto sum
19:37 Max function
20:15 Min function
20:48 Large function
21:54 Small function
22:35 Count function
23:00 Counta function
23:49 Countblank function
24:08 Average function
24:44 Median function
25:00 Mode function
25:23 Sumif function
27:29 Wildcards
28:36 Sumifs function
31:26 Proper function
32:00 Trim function
32:25 Concat function
33:39 & function
34:05 Textjoin function
34:52 Right, left and mid functions
35:27 Len function
35:46 Find and search functions
36:40 Left together with find
38:23 Logical functions
39:21 And function
39:53 Or function
40:14 If function
41:27 If together with and
42:23 If together with or
43:00 Nested if
44:41 Ifs function
45:32 Vlookup function
47:18 Xlookup function
49:24 Today and now functions
49:51 Bonus
52:04 Wrap up
📺 RELATED VIDEOS
- Playlist with all my videos on Excel: https://youtube.com/playlist?l....ist=PLlKpQrBME6xLYou
🙌 SUPPORT THE CHANNEL
- Hit the THANKS button in any video!
- Amazon affiliate link: https://amzn.to/3kCP2yz (Purchasing through this link gives me a small commission to support videos on this channel -- the price to you is the same)
🔽 CONNECT WITH ME
- Official web site: http://www.kevinstratvert.com
- LinkedIn: https://www.linkedin.com/in/kevinstratvert/
- Discord: https://bit.ly/KevinStratvertDiscord
- Twitter: https://twitter.com/kevstrat
- Facebook: https://www.facebook.com/Kevin....-Stratvert-101912218
- TikTok: https://www.tiktok.com/@kevinstratvert
- Instagram: https://www.instagram.com/kevinstratvert/
🎒 MY COURSES
- Excel for Beginners in under 2 hours: https://kevinstratvert.thinkific.com/
🙏 REQUEST VIDEOS
https://forms.gle/BDrTNUoxheEoMLGt5
🔔 SUBSCRIBE ON YOUTUBE
https://www.youtube.com/user/k....evlers?sub_confirmat
#stratvert #MicrosoftAmbassador
