Одну секунду
Что-то сучилось. Попробуйте еще раз.
Excel Course смотреть последние обновления за сегодня на .
Lean how to use Microsoft Excel from the beginning by creating 6 real-world projects. Most of the content applies to Google Sheets as well. You will learn how to - enter data, - navigate through a spreadsheet, - create formulas to solve problems, - create charts and graphs, - understand relative vs absolute references, - import and export data, - implement VLOOKUP, - use pivot tables, - split and concatenate text, - and more. ✏️ Course developed by Shad Sluiter. Check out his YouTube channel: 🤍 ⭐️ Course Contents ⭐️ ⌨️ (0:00:00) Intro ⌨️ (0:04:14) Payroll ⌨️ (0:39:35) Gradebook ⌨️ (0:57:22) Decision Factors ⌨️ (1:04:40) Sales Database ⌨️ (1:23:13) Car Inventory ⌨️ (1:59:29) Problem Solving Templates ⭐️ Special thanks to our Champion supporters! ⭐️ 🏆 Loc Do 🏆 Joseph C 🏆 DeezMaster Learn to code for free and get a developer job: 🤍 Read hundreds of articles on programming: 🤍
🔥Post Graduate Program In Data Analytics: 🤍 🔥IIT Kanpur Professional Certificate Course In Data Analytics (India Only): 🤍 🔥Caltech Data Analytics Bootcamp(US Only): 🤍 🔥Data Analyst Masters Program (Discount Code - YTBE15): 🤍 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: 🤍 #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: 🤍 🔥🔥 Interested in Attending Live Classes? Call Us: IN - 18002127688 / US - +18445327688
This is the beginning Excel course that you've been waiting for! Learn everything you need to effectively use Excel by watching just one video. You'll learn spreadsheet terminology and the modern Excel layout, how to create and save workbooks, entering values into Excel, Excel formulas and functions, formatting, creating and editing Excel charts, printing options, and publishing options. After watching and mastering this video, you will be able to use Excel effectively in almost any professional setting. Table of Contents: 00:00 - Intro 00:26 - Creating Workbooks, The Anatomy of a Spreadsheet / Spreadsheet Terminology 07:16 - Entering Cell Values and Data in Excel 20:18 - Formulas 30:21 - Functions: SUM, AVERAGE, MAX, MIN, COUNT 38:45 - Formatting Numbers, Text, Cells, Rows, and Columns 44:20 - Creating and Editing Charts 46:46 - Print Options and Publishing Options *Support Technology for Teachers and Students on Patreon*: 🤍 Here's my entire playlist of Excel tutorials: 🤍 Consider saying "Thanks" by clicking the Thanks button below the video. Here's a link to the practice file for this video: 🤍 #excel #exceltutorials #microsoft365
✅ Download the free course files to follow along ➡️🤍 We've combined some of our very best Excel tutorials in this training video to take you from beginner to Excel expert in under 6 hours! We've split this tutorial into 6 comprehensive topics to make sure we got you covered. We start off with the basics with Excel Formulas for Beginners, where we teach you some of the common functions used in Excel such as VLOOKUP, COUNT, SUM, and IF and how calculations work in Excel, and Data Cleaning in Excel, where we share 10 data cleaning tips and tricks like Clear Formatting, Removing Duplicates, and using Find & Replace and how to perform basic cleaning in Power Query. We then move on to intermediate concepts such as Pivot Tables and Dynamic Array Functions, where we discuss 8 functions that use dynamic arrays to solve problems like XLOOKUP and XMATCH. We wrap it up by covering Advanced Formulas in Excel, where we dive deeper into Logical Functions and other advanced Excel functions such as INDEX, MATCH, SUMPRODUCT, SUMIFS, and COUNTIFS and finally VBA Macros for Beginners, where we explain what Macros and VBA are and show you how to Record, Save, and Run Macros in Excel. You will also learn how to edit VBA code and assign Macro shortcuts. We've even included downloadable course files so you can follow along in this course. This will help you put what you are learning into practice and master MS Excel. ✅ 🤍 📝 Use the timestamps below to navigate to different sections of the course. If you already know one of these topics, skip ahead! 0:00:00 - Excel Formulas for Beginners 1:07:19 - Cleaning Data in Excel 2:12:55 - Pivot Tables Excel Tutorial 3:03:44 - Dynamic Array Functions 3:45:20 - Advanced Formulas in Excel 4:41:15 - Macros and Basic VBA in Excel 🌍 Get unlimited training with Simon Sez IT’s 150+ courses ⏩ 🤍 🚀 Level up your skills with a free 30-day trial to our complete training library of 8,500+ videos ⏩ 🤍 💻 Watch more free popular training tutorials from Simon Sez IT: 🔥Check out our FREE 300+ hour training course playlist here ➡️ 🤍 ✅ Check out our free video playlist for Excel beginners 👉🤍 ✅ Excel 2021 Tutorials for Intermediate Users here 👉🤍 ✅ Microsoft Excel Tips and Tricks 👉🤍 ✅ Microsoft Office 2021 and Office 365 Training here 👉🤍 💬Stay in touch! SimonSezIT.com: 🤍 LinkedIn: 🤍 FaceBook: 🤍 🔔 Subscribe to our channel: 🤍 If you enjoyed the video, please give a thumbs up 👍🏽 ;-)
✅ Download the free exercise files to follow along ➡️🤍 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 ⏩ 🤍 🚀 Level up your skills with a free 30-day trial to our complete training library of 8,500+ videos ⏩ 🤍 Check out our Microsoft Excel Long Tutorials playlist here 🔥🤍 ✅ PivotTable training here 👉 🤍 💬Stay in touch! SimonSezIT.com: 🤍 LinkedIn: 🤍
🔥 Go from Excel novice to data analysis ninja in just 2 hours with my Excel for Beginners course: 🤍 Are you looking to upskill your Excel game? Look no farther than this step-by-step tutorial! Learn the essentials of how to use Microsoft Excel, starting with the absolute basics like entering data and formatting. From there, we cover conditional formatting, sorting, filtering, and advance to charts and pivot tables. By the end of this video, you'll have a strong understanding of the fundamentals of Excel. 📚 RESOURCES - My Excel course that will teach you the fundamentals of Excel in just 2 hours: 🤍 - All the Excel shortcut keys: 🤍 ⌚ TIMESTAMPS 00:00 Introduction 0:26 Get Excel 1:01 Start page 1:30 Cells, columns, and rows 2:08 Adjust zoom 2:23 Enter data 3:41 Format cells 4:36 Auto fit contents 5:20 Hide and unhide 5:55 Move columns and rows 6:32 Tables 7:19 Insert columns and rows 7:46 Conditional formatting 8:25 Status bar 8:45 Analyze data 9:15 Formulas 9:49 Functions 10:39 Sorting and filtering 11:37 Charts 12:18 Pivot tables 15:02 Collaborate with others 15:26 Wrap up 📺 RELATED VIDEOS - Playlist with all my videos on Excel: 🤍 📩 NEWSLETTER - Get the latest high-quality tutorial and tips and tricks videos emailed to your inbox each week: 🤍 🔽 CONNECT WITH ME - Official web site: 🤍 - LinkedIn: 🤍 - Discord: 🤍 - Twitter: 🤍 - Facebook: 🤍 - TikTok: 🤍 - Instagram: 🤍 🎒 MY COURSES - Go from Excel novice to data analysis ninja in just 2 hours: 🤍 🙏 REQUEST VIDEOS 🤍 🔔 SUBSCRIBE ON YOUTUBE 🤍 🙌 SUPPORT THE CHANNEL - Hit the THANKS button in any video! - Amazon affiliate link: 🤍 (Purchasing through this link gives me a small commission to support videos on this channel the price to you is the same) #stratvert #excel
🔥 Go from Excel novice to data analysis ninja in just 2 hours with my Excel for Beginners course: 🤍 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: 🤍 - Completed Workbook with all formulas and Functions: 🤍 - Learn the fundamentals of Excel in just 2 hours: 🤍 ⌚ 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: 🤍 🙌 SUPPORT THE CHANNEL - Hit the THANKS button in any video! - Amazon affiliate link: 🤍 (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: 🤍 - LinkedIn: 🤍 - Discord: 🤍 - Twitter: 🤍 - Facebook: 🤍 - TikTok: 🤍 - Instagram: 🤍 🎒 MY COURSES - Excel for Beginners in under 2 hours: 🤍 🙏 REQUEST VIDEOS 🤍 🔔 SUBSCRIBE ON YOUTUBE 🤍 #stratvert #MicrosoftAmbassador
Want more Excel videos? Here’s my Excel playlist: 🤍 This video tutorial will show you how to use Microsoft Excel for beginners. Microsoft Excel is a powerful spreadsheet tool that is part of Microsoft Office. This is a detailed beginners tutorial, the below timestamps will help you navigate through the lessons that are covered. Looking for more? Let me know in the comments below what types of things you would like to learn in Microsoft Excel. Intermediate Microsoft Excel Class: 🤍 Dive deeper into formulas and functions in excel with this playlist: 🤍 Creating Charts in Excel: 🤍 0:00 Start 1:07 Starting up 1:27 Recent documents and pinning documents 1:54 Templates 2:34 Layout - Tabs, ribbons, and groups in Microsoft Excel 3:48 Rows, Columns, Cells and Ranges 5:49 Worksheets in Microsoft Excel 6:52 View and zooming 7:30 Inputting Data 10:56 Formatting Data 13:38 Wrapping Text 14:22 Insert Row/ Merge & Center cells 15:41 Currency formatting 16:20 Print view 17:02 Add cell borders and colors 18:18 Basic formulas in Microsoft Excel 21:17 Copy formula 23:45 Freeze Pane 24:52 Basic Microsoft Excel functions 28:59 “Tell Me” in Microsoft Excel 29:43 Inserting charts in Microsoft Excel Excel for Beginners Tutorial - Level 2: 🤍 Excel for Beginners Tuotiral - Level 3: 🤍 Excel for Beginners Tutorial - Level 4: 🤍 Microsoft Excel for Beginners - Level 5: 🤍 VLOOKUP Function for Excel: 🤍 Learn Pivot Tables for Beginners: 🤍 10 Best Excel Beginners Tips: 🤍 Make a Line Graph in Excel: 🤍 I use Camtasia to create my video tutorials: 🤍 DISCLAIMER: This video and description contain affiliate links, which means that if you click on one of the product links and end up purchasing it, I’ll receive a small commission. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
🔥Post Graduate Program In Data Analytics: 🤍 🔥IIT Kanpur Professional Certificate Course In Data Analytics (India Only): 🤍 🔥Caltech Data Analytics Bootcamp(US Only): 🤍 🔥Data Analyst Masters Program (Discount Code - YTBE15): 🤍 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: 🤍 #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: 🤍 🔥🔥 Interested in Attending Live Classes? Call Us: IN - 18002127688 / US - +18445327688"
Excel 2021 Full Course Tutorial (3+ Hours) Get Ad-Free Training by becoming a member today! 🤍 Exercise Files: 🤍 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: 🤍 For Private Group Trainings please visit: 🤍 Manuals: 🤍 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.
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 - 🤍 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: 🤍 Free Excel Course - 🤍 Paid Online Training - 🤍 Best Excel Books: 🤍 ⚙️ Gear I Recommend: Camera - 🤍 Screen Recorder - techsmith.z6rjha.net/26D9Q USB Mic - 🤍 Wireless Mic: 🤍 Lighting - 🤍 Subscribe to get awesome Excel Tips every week: 🤍 Note: Some of these links here are affiliate links! #Excel #ExcelTips #ExcelTutorial
✅ Download to follow along and complete the exercises ➡️🤍 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. ✅🤍 📝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 ⏩ 🤍 🚀 Level up your skills with a free 30-day trial to our complete training library of 8,500+ videos ⏩ 🤍 💻 Watch more free popular training tutorials from Simon Sez IT: 🔥Check out our FREE 300+ hour training course playlist here ➡️ 🤍 ✅ Check out our free video playlist for Excel beginners 👉🤍 ✅ Excel 2021 Tutorials for Intermediate Users here 👉🤍 ✅ Microsoft Excel Tips and Tricks 👉🤍 ✅ Microsoft Office 2021 and Office 365 Training here 👉🤍 💬Stay in touch! SimonSezIT.com: 🤍 LinkedIn: 🤍 FaceBook: 🤍 🔔 Subscribe to our channel: 🤍 If you enjoyed the video, please give a thumbs up 👍🏽 ;-)
Excel Skills for Business 👉🏼 🤍 Excel Basics for Data Analytics 👉🏼 🤍 Courses for Data Nerds 📜 Google Data Analytics Certificate (START HERE) 👉🏼 🤍 💿 SQL for Data Science 👉🏼 🤍 🧾 Excel Skills for Business 👉🏼 🤍 🐍 Python for Everybody 👉🏼 🤍 📊 Data Visualization with Tableau 👉🏼 🤍 🏴☠️ Data Science: Foundations using R 👉🏼 🤍 ➕ Coursera Plus Subscription (7-day free trial) 👉🏼 🤍 👨🏼🏫 All courses 👉🏼 🤍 Build a Portfolio 👩🏻💻Build portfolio here 👉🏼 🤍 Rebate Code: "LUKE" My Portfolio 👉🏼 🤍 Books for Data Nerds 📚 Books I’ve read 👉🏼 🤍 📗 Data Analyst Must Read 👉🏼 🤍 📙 Tableau 👉🏼 🤍 📘 Power BI👉🏼 🤍 📕 Python 👉🏼 🤍 Tech for Data Nerds ⚙️ Tech I use 👉🏼 🤍 🪟Windows on a Mac (Parallels VM) 👉🏼 🤍 👨🏼💻 M1 Macbook Air (Mac of choice) 👉🏼 🤍 💻 Dell XPS 13 (PC of choice) 👉🏼 🤍 💻 Asus Vivo Book (Lowest Cost PC) 👉🏼 🤍 💻Lenovo IdeaPad (Best Value PC)👉🏼 🤍 Social Media / Contact Me 👾 r/DataNerd 👉🏼 🤍 🌄 Instagram: 🤍 ⏰ TikTok: 🤍 📘 Facebook: 🤍 🙋🏼♂️Newsletter: 🤍 As a member of the Amazon, Coursera, Hostinger, and Parallels Affiliate Programs, I earn a commission from qualifying purchases on the links above. It costs you nothing but helps me with content creation. #datanerd #dataanalyst #datascience
"*Note: 1+ Years of Work Experience Recommended to Sign up for Below Programs⬇️ 🔥Post Graduate Program In Data Analytics: 🤍 🔥IIT Kanpur Professional Certificate Course In Data Analytics (India Only): 🤍 🔥Caltech Data Analytics Bootcamp(US Only): 🤍 🔥Data Analyst Masters Program (Discount Code - YTBE15): 🤍 This Excel Tutorial full course will help you get started with Excel and explore the features it offers. You will take a tour to understand Excel basics and look at how to write functions, sort, and filter data, how to import data and split data into multiple columns, learn about sumif and countif functions, and many more functions and formulas available in Microsoft Excel. Dataset Link - 🤍 00:01:18 Introduction to MS Excel 00:04:47 Excel Basics 00:21:41 Lock Cells in Excel 00:27:09 Page Setup in Excel 00:45:13 What if Analysis 00:49:34 Charts in Excel 01:07:50 Data Validation in Excel 01:34:20 Lookup Functions in Excel 02:14:20 Slicers in Excel 02:18:42 Excel Budget Template 02:25:35 MIS Report in Excel 02:35:43 Excel Macros 02:47:09 Excel VBA 03:37:56 Regression in Excel 04:04:32 Excel Power Query 05:29:50 Excel Interview Questions ✅Subscribe to our Channel to learn more about the top Technologies: 🤍 ⏩ Check out the Excel tutorial videos: 🤍 #advancedExcelFullCourse #advancedExcelTutorial #ExcelTraining #AdvancedExcelFormulas #AdvancedExcelFunctions #Vlookup #hlookup #xlookup #sumifs #concatinate #if #excelDashboard #excelReport #ExcelDataAnalytics #ExcelCourse #ExcelFullCourse #ExcelTutorial #MicrosoftExcelTutorial #ExcelTutorialForBeginners #LearnExcel #Simplilearn #2022 What is Microsoft Excel? Excel is one of the best applications available on the market for creating spreadsheets to crunch numbers and dashboard reports as well as storing and administering data. This software first appeared on the scene back in 1987, and since then it has grown to become one of the most popular pieces of software for home or business. 🔥Free Business Analytics with Excel Course - 🤍 ➡️ 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. ✅ Key Features - Post Graduate Program certificate and Alumni Association membership - Exclusive hackathons and Ask me Anything sessions by IBM - 8X higher live interaction in live online classes by industry experts - Capstone from 3 domains and 14+ Data Analytics Projects with Industry datasets from Google PlayStore, Lyft, World Bank etc. - Master Classes delivered by Purdue faculty and IBM experts - Simplilearn's JobAssist helps you get noticed by top hiring companies - Resume preparation and LinkedIn profile building - 1:1 mock interview - Career accelerator webinars ✅ Skills Covered - Data Analytics - Statistical Analysis using Excel - Data Analysis Python and R - Data Visualization Tableau and Power BI - Linear and logistic regression modules - Clustering using kmeans - Supervised Learning 👉 Learn More at: 🤍 🔥Caltech Data Analytics Bootcamp(US Only): 🤍 🔥🔥 Interested in Attending Live Classes? Call Us: IN - 18002127688 / US - +18445327688 🎓Enhance your expertise in the below technologies to secure lucrative, high-paying job opportunities: 🟡 AI & Machine Learning - 🤍 🟢 Cyber Security - 🤍 🔴 Data Analytics - 🤍 🟠 Data Science - 🤍 🔵 Cloud Computing - 🤍
✅ Download to follow along and complete the exercises ➡️ 🤍 In this Microsoft Excel 2021 Advanced training course, fast-track your Excel skills to expert level. We introduce you to new dynamic array functions, how to deal with spills in arrays, and use advanced Excel formulas and functions like XLOOKUP and XMATCH. We also discuss the difference between Unique and Distinct, how to use different sort functions, and advanced filtering. You will learn to create advanced and flexible lookup formulas, use statistical functions to rank data, calculate the MEDIAN and MODE, and so much more! We've even included downloadable exercise and instructor files from our paid-for course so you can follow along and complete the exercises in this Advanced Excel 2021/365 Tutorial. This will help you put what you are learning into practice and master Excel. ✅ 🤍 📝 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:03:09 - Exercise 01 0:05:15 - Dynamic Arrays 0:07:31 - Spill and Arrays 0:18:23 - Extract and Count Unique Entries 0:24:38 - Unique vs. Distinct 0:28:02 - Unique with Multiple Criteria 0:31:13 - Unique Values by Column 0:35:37 - SORT Function 0:44:30 - Horizontal Sort 0:50:38 - SORTBY Function 0:56:47 - Horizontal SORTBY 0:59:52 - Sequence and Unstacking Records 1:10:02 - Filter Function 1:16:59 - Using Filter with Logic Plus Operator 1:21:47 - Using Filter with Logic Asterisk Operator 1:27:27 - Using Filter with Logic Equals Operator 1:31:40 - Using Filter with Logic Minus Operator 1:36:29 - RANDARRAY and RANDBETWEEN 1:46:11 - XLookUp 1:58:34 - XMatch 2:04:55 - Exercise 02 2:18:04 - Two-way Lookups 2:26:29 - CHOOSE Function 2:36:33 - SWITCH Function 2:41:03 - Exercise 03 2:48:11 - Median and Mode 2:54:25 - Using LARGE and SMALL 3:01:58 - Ranking Data 3:09:39 - COUNTBLANK Function 3:14:25 - Exercise 04 3:21:31 - Rounding Values 3:28:29 - Specialized Rounding 3:33:00 - Aggregate Function 3:37:31 - Exercise 05 🌍 Get unlimited training with Simon Sez IT’s 150+ courses ⏩ 🤍 🚀 Level up your skills with a free 30-day trial to our complete training library of 8,500+ videos ⏩ 🤍 💻 Watch more free popular training tutorials from Simon Sez IT: 🔥Check out our FREE 300+ hour training course playlist here ➡️ 🤍 ✅ Check out our free video playlist for Excel beginners 👉🤍 ✅ Excel 2021 Tutorials for Intermediate Users here 👉🤍 ✅ Microsoft Excel Tips and Tricks 👉🤍 ✅ Microsoft Office 2021 and Office 365 Training here 👉🤍 💬Stay in touch! SimonSezIT.com: 🤍 LinkedIn: 🤍 FaceBook: 🤍 🔔 Subscribe to our channel: 🤍 If you enjoyed the video, please give a thumbs up 👍🏽 ;-) ❤️ We appreciate your support!
✅ Download to follow along and complete the exercises ➡️ 🤍 In this Excel 2021 Intermediate training course, you will build on your beginner-level Excel knowledge and expand your skills. We'll go over Excel logical functions such as IF, COUNTIF, and SUMIF and Excel lookup functions like VLOOKUP, HLOOKUP, INDEX, and MATCH. We will also discuss various other Excel formulas such as UNIQUE, CONCAT, and so much more! You will also learn how to use advanced filters, sort columns and lists, use custom date formats, remove duplicate entries, split and combine data, and many other Excel tips and tricks. After this training video, you will have a solid foundation for using Excel 2021/Excel 365, as part of the Office 2021 suite of applications. We've even included downloadable exercise and instructor files from our paid-for course so you can follow along and complete the exercises in this Microsoft Excel 2021/365 Tutorial. ✅ 🤍 📝 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:06:38 - Improve Readability with Cell Styles 0:11:37 - Controlling Data Input 0:19:57 - Adding Navigation Buttons 0:28:43 - Logical Functions 0:42:02 - The IF Function 0:47:28 - Nested IFs 0:55:30 - The IFs Function 1:01:35 - Conditional IFs 1:08:20 - Multiple Criteria 1:15:33 - Error Handling 1:21:34 - Exercise 01 1:29:04 - VLOOKUP (Exact Match) 1:39:44 - VLOOKUP (Approximate Match) 1:44:10 - HLOOKUP Function 1:49:49 - INDEX and MATCH 2:00:16 - XLookup and XMatch 2:10:26 - OFFSET Function 2:21:17 - INDIRECT Function 2:30:24 - Exercise 02 2:35:26 - Sorting on Multiple Columns 2:42:31 - Sorting Using a Custom List 2:46:07 - SORT and SORTBY Functions 2:56:07 - Advanced Filter 3:02:59 - UNIQUE Function 3:08:16 - FILTER Function 3:17:48 - Exercise 03 3:23:29 - How Dates and Times are Stored 3:27:39 - Custom Date and Time Formats 3:34:49 - Time and Date Functions 3:43:33 - WORKDAY and WORKDAY.INT Functions 3:47:22 - NETWORKDAYS and NETWORKDAYS.INT Functions 3:50:20 - DATEDIF Function 3:56:33 - EDATE and EOMONTH Functions 4:03:55 - Exercise 04 4:08:51 - Importing Data into Excel 4:18:46 - Removing Blank Rows, Cells, and Duplicate Entries 4:24:07 - Changing Case and Removing Spaces 4:33:12 - Splitting Up Data Using Text to Columns 4:40:15 - Splitting Up Data Using Text Functions 4:48:22 - Using Flash Fill 4:53:21 - CONCAT Function 5:00:50 - Formatting Data as Table 🌍 Get unlimited training with Simon Sez IT’s 150+ courses ⏩ 🤍 🚀 Level up your skills with a free 30-day trial to our complete training library of 8,500+ videos ⏩ 🤍 💻 Watch more free popular training tutorials from Simon Sez IT: 🔥Check out our FREE 300+ hour training course playlist here ➡️ 🤍 ✅ Check out our free video playlist for Beginner to Advance Excel Training 👉🤍 ✅How to Use Pivot Tables in Excel video playlist 👉 🤍 ✅ Microsoft Excel 30 Tips and Tricks here 👉 🤍 ✅ Microsoft Office 2021 and Office 365 playlist here 👉 🤍 🔥Check out our FREE 300+ hour training course playlist here ➡️ 🤍 💬Stay in touch! SimonSezIT.com: 🤍 LinkedIn: 🤍 FaceBook: 🤍 🔔 Subscribe to our channel: 🤍 If you enjoyed the video, please give a thumbs up 👍🏽 ;-)
Want more Excel videos? Here’s my Excel playlist: 🤍 This video tutorial will show you how to use Microsoft Excel for beginners level 2. Click here to go to level 1 for beginners 🤍 Microsoft Excel is a powerful spreadsheet tool that is part of Microsoft Office. This is a detailed beginners tutorial, the below timestamps will help you navigate through the lessons that are covered. Looking for more? Let me know in the comments below what types of things you would like to learn in Microsoft Excel Intermediate Microsoft Excel Lesson 1: 🤍 Dive deeper into formulas and functions in excel with this playlist: 🤍 Creating Charts in Excel: 🤍 Subscribe to Teacher's Tech: 🤍 0:00 Start 0:52 AutoFilling cells in Excel 4:18 Add your own autofill 5:49 Sorting data in Excel 8:56 Using filters in Microsoft Excel 12:45 Round functions in Excel 15:40 Relative Relative cell references 17:14 Absolute Relative cell references 18:55 Absolute Absolute cell references 20:17 Relative Absolute cell references *More Videos on Microsoft Excel* Dive deeper into formulas and functions: 🤍 Microsoft Excel for Beginners - Level 1: 🤍 Microsoft Excel Tutorial - Level 3: 🤍 Microsoft Excel Tutorial - Level 4: 🤍 Microsoft Excel for Beginners - Level 5: 🤍 VLOOKUP Function for Excel: 🤍 Learn Pivot Tables for Beginners: 🤍 10 Best Excel Tips for Beginners: 🤍 How to Make a Line Graph in Excel: 🤍 I use Camtasia to create my videos: Use this coupon code: TEACHCAM10 Camtasia purchase with 10% OFF code applied: 🤍 Camtasia EDU 10% OFF with code applied: 🤍 Camtasia Download page: 🤍 DISCLAIMER: This video and description contain affiliate links, which means that if you click on one of the product links and end up purchasing it, I’ll receive a small commission. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
In this video, you'll learn how to work with cells and ranges in Excel. Since a worksheet in Excel is made up for cells, if you want to become proficient in Excel, you need to know how to best work with cells and ranges. And this video will teach you exactly that. It covers the following topics: Cell address nomenclature Selecting cell/ranges in Excel Copying and moving cells/ranges in Excel Using paste special Selecting special cells Using find and replace to select cells Adding comments and Using quick analysis ☕ If you're the videos useful and would like to support me, you can buy me a coffee - 🤍 This video is a part of my Free Online Excel Training where I show you how to use Excel from the basics and also cover a lot of advanced topics. You can find more details about this Free Excel Training + the download files here: 🤍 You can also access the Full Excel Training on YouTube here: 🤍 Free Excel Course - 🤍 Paid Online Training - 🤍 Best Excel Books: 🤍 ⚙️ Gear I Recommend: Camera - 🤍 Screen Recorder - techsmith.z6rjha.net/26D9Q USB Mic - 🤍 Wireless Mic: 🤍 Lighting - 🤍 Subscribe to get awesome Excel Tips every week: 🤍 Note: Some of these links here are affiliate links! #Excel #ExcelTips #ExcelTutorial
"*Note: 1+ Years of Work Experience Recommended to Sign up for Below Programs⬇️ 🔥Post Graduate Program In Data Analytics: 🤍 🔥IIT Kanpur Professional Certificate Course In Data Analytics (India Only): 🤍 🔥Caltech Data Analytics Bootcamp(US Only): 🤍 🔥Data Analyst Masters Program (Discount Code - YTBE15): 🤍 This video on complete excel course - beginner to expert 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. 00:00:00 Introduction to Microsoft Excel Full Course Excel Basic Knowledge How To Change Lower Case To Upper Case In Excel? How To Add Rows In Excel? How To Add Columns In Excel? How To Select Entire Column In Excel? How to Compare Two Columns In Excel? How To Convert Rows To Columns In Excel? How to Group Rows in Excel? How To Remove Blank Rows In Excel? How To Freeze Row In Excel Tutorial How to Convert Numbers to Words in Excel? Combining Data From Multiple Cells In Excel How To Merge Cells In Excel How to Add Date in Excel? How To Change Date Format In Excel (dd/mm/yyyy) To (mm/dd/yyyy) How To Calculate Age In Excel From A Date Of Birth? How To Calculate Time Difference in Excel? Checkboxes In Excel How to Insert Excel in PPT? How To Insert Image In Excel? How To Insert PDF in Excel Sheet? How To Convert PDF To Excel How to Insert Tick Mark in Excel? How to add Watermark in Excel? How to Increase Cell Size in Excel? How to create Barcode In Excel Excel Flash Fill How to Add Hyperlink In Excel Index Match In Excel How to Sort by Date in Excel? How to Use AutoSum In Excel How To Sort Data In Excel? Slicer and Filter in Excel How to Add Filters in Excel How to Create Drop-Down List In Excel? Data Validation In Excel How To Lock(Protect) Cells In Excel How To Calculate Average In Excel? Excel Print Page Setup Page Break In Excel For Beginners Conditional Formatting In Excel How to Count Colored Cells in Excel? DateDif In Excel Explained Remove Duplicates In Excel SUMIFS Formula in Excel How To Create Pivot Tables In Excel Autofill In Excel Explained ✅ Subscribe to our Channel to learn more about the top Technologies: 🤍 ⏩ Check out the Data Analytics Training Videos: 🤍 #ExcelCourse #CompleteExcelCourse #AdvancedExcelTutorial #ExcelTraining #MSExcel #ExcelForBeginners #ExcelFullCourse #LearnExcel #2023 #Simplilearn ➡️ Data Analytics Bootcamp The Caltech Data Analytics Bootcamp is ideal for working professionals from all backgrounds. Develop core skills such as mastering excel, creating data-driven presentations, data manipulation with SQL, analyzing data with Python, and data visualization with Tableau. Learn data analysis with tools such as AWS. ✅ Key features - Simplilearn Career Service helps you get noticed by top hiring companies - Data Analytics Bootcamp Certificate from Caltech CTME - Caltech CTME Circle Membership - Online Convocation by Caltech CTME Program Director - Access to integrated Data Analytics Labs ✅ Skills Covered - Data Analytics - Statistical Analysis using Excel - Data Analytics using Python - Data Visualization with Tableau - Linear and Logistic Regression - Data Manipulation - Data Analysis in AWS ✅ Enroll Course Now: 🤍 🔥🔥 *Interested in Attending Live Classes? Call Us:* IN - 18002127688 / US - +18445327688 👉 Listen to what millions of users say about our courses! 🤍 🔥 Enroll for Free Courses by Simplilearn: 🤍
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
Excel 2021 Beginner Tutorial Get Ad-Free Training by becoming a member today! 🤍 Exercise Files: 🤍 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: 🤍 For Private Group Trainings please visit: 🤍 Manuals: 🤍 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.
* Download this Practice Workbook HERE: 🤍 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): 🤍 2) Complete MS Excel Tutorial for Beginners (Video 2): 🤍 3) Most Commonly asked MS Excel Interview Questions and Answers (Video 3): 🤍 Our Interview Preparation Course (12+ Videos): 🤍 * OUR OTHER VIDEOS YOU MIGHT LIKE: 1) Stock Market for Beginners: 🤍 2) Zerodha Trading Tutorial for Beginners: 🤍 * #MSExcel #CompleteExcelTutorial #Excel2023 #LearnExcel
🤍 free udemy course free udemy free course #free course
#Shorts | Advance Filter Hacks | Only 1 % Excel User Know | Excel Tips & Tricks #shorts #advancefilter #gyaniabhijeetji
You asked for it. Here is my free course to help you kick start your data analytics journey. In this comprehensive video, learn: 1) How to approach a data analysis project 2) A real-world example data with 10 problems 3) Step by step walk thru 4) How to calculate descriptive statistics (mean, median, quartiles, range, distinct items & count) 5) Exploratory data analysis in Excel 6) Analysis with formulas vs. pivots (necessary techniques) 7) Top / bottom performing items 8) Anomaly detection 9) Best in class analysis 10) Complete report preparation 11) Combining data in different tables (spreadsheets) 12) Answering open ended questions 13) Preparing and using Excel charts 14) Challenges & homework assignment You will also learn below Excel features: 1) Using Tables 2) Formulas 3) Pivot Tables & Power Pivot measures 4) Conditional formatting 5) Charts 6) Data Validation 7) Keyboard Shortcuts & tricks ⏱ Video Timestamps: 0:00 - Introduction 2:12 - Descriptive statistics in Excel 8:05 - Exploratory Data Analysis (EDA) with conditional formatting 13:20 - Sales by Country report with formulas 19:01 - Sales by Country report with Pivots 23:43 - Top 5 products with $ per unit 27:13 - Anomaly detection in your data 31:24 - Best in category analysis 33:36 - Profit analysis (combining two tables) 37:26 - Dynamic country level sales report 41:55 - Which products to discontinue (Open ended questions) 💥📁 Sample files: Blank data file (perfect for following along) - 🤍 Completed workbook - 🤍 ⛔⚠ Got an ERROR - Can't Change Array? Here is the fix - 🤍 What to watch next? = I recommend setting aside sometime to practice what you just learned. But if you are in the mood to watch more, I suggest these videos: 5 key skills you need to be a GREAT data analyst - 🤍 5 Excel Skills you need to focus on - 🤍 15 Excel functions you should know - 🤍 My playlist on data analysis - 🤍 Want to learn more? Join my Excel School 👉 = If you want more step by step education & resources to be AWESOME at your work, consider joining my Excel School program. This online class will teach you everything you need for data analysis + reporting roles. Visit 🤍 to sign up today. My Recommended Excel Books 📚👌: = 🤍 😎 SAY HELLO 👋 = Apart from YouTube, I frequently post on, my blog - 🤍 twitter - 🤍 Instagram - 🤍 Have a beautiful day 🌼🌞😀 #DataAnalysis #Excel
#exceltutorial #excel #excelforbegginers Support OUR CHANNEL for 1K Subscribers Family, for More Excel and Access Functions, Tricks, Short Keys and More. Channel: 🤍 Excel Shortcut Keys: 🤍 Microsoft Access: 🤍 Microsoft Excel: 🤍 Best Excel Shortcuts in Hindi In today's video you will learn top most improtant keyboard shortcuts. You can speed up your work in excel and save time just using keyboard shortcuts. Excel Tutoring | Excel Shortcut Keys #ctrlshortcut #shortcutkeys #KeyPointsEducation #ctrlshortcuts #ctrl #Keyboard #computer #ctrlwithatoz #keyboardctrl #atozwithctrl #ctrlwithalphabets #ctrlalphabetsshortcuts #KeyboardShortcuts #CTRLwith Shortcuts #UseofCTRL #laptop #ctrlatozshortcutkeys #PivotTable #PivotTableTutorial #AdvancedPivotTable #HowToUse #ExcelTipsandTricks #AdvancedExcel #ExcelTutorial #LearnExcel #Excel_Formulas_and_Functions #Excel_online_course #deepakeduworld #Microsoft_Excel #How_To #KeyboardShortcuts #ExcelShortcuts #ExcelTutorial Topics on Shortcuts: 1. How To Use shorcut In Hindi Easy To Use In Simple Way 2. Simple Use Of short cut 3. Learn To Use short cut 4. Excel shortcut Example Hindi 5. How To Use short keys In Hindi 6. Excel Formula In Hindi 7. Use Formula In Hindi 8. How To Do A Formula In Hindi 9. How To Use Formula In Excel In Hindi 10. How To Use Functions In Excel 11. Excel Tricks Tutorial 12. Using tricks Formula In Hindi 13. Formula In Hindi 14. Shorcut Keys In Excel 15. Shortcuts In Excel Microsoft Excel full course in Hindi Complete Excel Tutorial For Beginners in Hindi All Excel Menus/Tabs step by step explaining This Excel course is beginners to advanced
Excel 2021 Advanced Tutorial Get Ad-Free Training by becoming a member today! 🤍 Exercise Files: 🤍 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: 🤍 For Private Group Trainings please visit: 🤍 Manuals: 🤍 Username: manuals Password: password Start 0:00 Introduction 0:03 Formatting Lists as Tables 2:03 Flash Fill 10:59 Custom Sorting 13:46 Subtotals 17:59 QA Tool 22:38 Data Charts 25:45 Sparklines 33:13 Introduction to Pivot Tables 38:10 Advanced Pivot Tables Options 50:16 Data Validation 57:45 Conditional Formats 1:04:18 Comments and Notes 1:10:49 Linking Data 1:13:24 Privacy and Protection 1:16:25 Conclusion 1:20:00 #excel #excel2021 #exceltutorial (C) 2022 Learnit, Inc. Any illegal reproduction of this content will result in immediate legal action.
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: 🤍 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: 🤍 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’: 🤍 ‘Do Epic Shit’: 🤍 My gear for shooting this video: 🎥 Sony a7III camera: 🤍 🎬 Sony FE 24-70 f2.8 Lens: 🤍 🎙️ Shure SM7B Microphone: 🤍 🔆 Fill Light 60W: 🤍 💡 Key Light 150W: 🤍 📽️ Benro IT15 Tripod for Sony a7III camera: 🤍 Useful links: 20 books for your 20s: 🤍 20 online courses for your 20s: 🤍 Gadgets that I use: 🤍 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): 🤍 📩 My weekly newsletter warikoo Wanderings: 🤍 📱 Instagram: 🤍 🐦 Twitter: 🤍 👨🏻💻 LinkedIn: 🤍 😄 Facebook: 🤍 🖋️ Daily Blog: 🤍
Do you need to learn Excel Quickly? May be you have a job interview or need to transition to a role where Excel skills are mandatory. In this video, I share 8 tactics & mindset that worked REALLY well for me when I had to learn Excel / Power BI and other technical tools. The tactics: 💡 1) Pick "a" problem 2) Go W I D E before going DEEP 3) Connect the dots 4) Play to learn 5) Stop nit-picking 6) Share what you learn 7) Reflect & Revise 8) Knockout the H 9) Bonus: Go for a course Timestamps: ⏱ = 0:00 - Pick a problem (1) 1:19 - Go wide before going deep (2) 2:54 - Connecting the dots (3) 3:45 - Having a play with Excel (4) 4:54 - Stop worrying about small details (5) 5:39 - Share what you learn (6) 7:17 - Reflect and Revise (7) 8:35 - Knockout the H (8) 9:07 - Join a course Playlists & videos for learning Excel: 📚 FREE beginner Excel Course - 🤍 Top 10 Excel Formulas - 🤍 FREE Data Analysis Course - 🤍 Getting started with Pivot Tables - 🤍 🔥🔥🔥 Excel School online classes - 🤍 Happy Learning 🌼🌞😀 #ExcelTips #learnexcel
Learn the basics of using Microsoft Excel, including the anatomy of a spreadsheet, how to enter data, how to make your data look good so it's easier to read and use, and more. This tutorial was made using Excel 2016, but is applicable to older versions of Excel and newer versions too. *Consider supporting Technology for Teachers and Students on Patreon*: 🤍 Consider saying "Thanks" by clicking the Thanks button below the video. If you like this video, here's my entire playlist of Excel tutorials: 🤍 Click below for more information about some of the movies mentioned in this tutorial: Dirty Rotten Scoundrels: 🤍 Ladyhawke: 🤍 Stardust: 🤍 Young Sherlock Holmes: 🤍
Join 400,000+ professionals in our courses: 🤍 Learn the basics of using Microsoft Excel. How a spreadsheet is setup, and how you can enter data in Excel. Learn useful Excel shortcuts. Understand how the menu bar (the Excel Ribbon) works and where to find different features. Learn formatting in Excel to display your data better. This basic tutorial is for all versions of Excel (Excel 2010, Excel 2013, Excel 2016, Excel 2019 and Excel for Office 365). Looking for more Excel basics videos? Check out this playlist: 🤍 Time Stamps 00:00 Learn the Basics of Microsoft Excel 00:27 Anatomy of a spreadsheet in Microsoft Excel 01:20 What is a Cell in Microsoft Excel 03:50 What is a Range in Microsoft Excel 04:41 Excel Cursor and Mouse Pointer Shapes 05:48 How to Change Size of Rows and Columns in Excel 07:26 How to Use the Ribbon in Microsoft Excel 09:25 How to Enter Data in Microsoft Excel 11:47 How to Format Data in Microsoft Excel * Complete Excel Essentials course for beginners: 🤍 ⯆ The full article to Excel for beginners: 🤍 ★ My Online Excel Courses ► 🤍 ✉ Not sure which of my Excel courses fits best for you? Take the quiz: 🤍 RESOURCES I Recommend: 🤍 Get Microsoft 365: 🤍 Microsoft Surface: 🤍 GEAR Screen recorder: 🤍 Main Camera: 🤍 Backup Camera: 🤍 Main Lens: 🤍 Zoom Lens: 🤍 Audio Recorder: 🤍 Microphone: 🤍 Lights: 🤍 More resources on my Amazon page: 🤍 Let’s connect on social: Instagram: 🤍 Twitter: 🤍 LinkedIn: 🤍 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
Click Here for Python Course in Telugu 👇 🤍 GitHub link: 🤍 Instagram-link: 🤍 Facebook link: 🤍 linkedin: 🤍 Telegramlink: 🤍 #pythonlife.in
In this Excel formulas and functions tutorial you'll learn important Excel functions. I'll also show you an Excel trick that will make it easier for you to search for and properly use any Excel function. You'll learn simple formulas and functions in Excel. 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 functions. We also cover autosum and the averageifs functions. Time Stamps 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 ⯆ DOWNLOAD the workbook here: 🤍 More Excel Tutorials for Beginners: 🤍 Intermediate Excel Functions (including the Excel IF and VLOOKUP functions): 🤍 My Excel Essentials Course: 🤍 ★ ALL my Excel Courses ► 🤍 _ ✉ Not sure which of my Excel courses fits best for you? Take the quiz: 🤍 EXCEL RESOURCES I Recommend: 🤍 Get Microsoft 365: 🤍 Microsoft Surface: 🤍 GEAR Screen recorder: 🤍 Main Camera: 🤍 Backup Camera: 🤍 Main Lens: 🤍 Zoom Lens: 🤍 Audio Recorder: 🤍 Microphone: 🤍 Lights: 🤍 More resources on my Amazon page: 🤍 Let’s connect on social: Instagram: 🤍 Twitter: 🤍 LinkedIn: 🤍 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! #msexcel #excel
MS Excel - Introduction - Beginner's Guide Lecture By: Mr. Pavan Lalwani Tutorials Point India Private Limited To Buy Full Excel Course: 🤍 Use coupon "YOUTUBE" to get FLAT 10% OFF at Checkout. Check out latest Video Courses and eBooks : 🤍 Learn the basics of using Microsoft Excel, like create & close files, editing data, the cell reference, including the anatomy of a spreadsheet, how to enter data, how to make your data look good so it's easier to read and use, and more. It is applicable to older versions and newer versions too. For more updates on courses and tips follow us on: Facebook: 🤍 Twitter: 🤍 LinkedIn: 🤍
MS Excel - Pivot Table Example 1 Video Tutorials Lecture By: Mr. Pavan Lalwani Tutorials Point India Private Limited To Buy Full Excel Course: 🤍 Use coupon "YOUTUBE" to get FLAT 10% OFF at Checkout. Check out latest Video Courses and eBooks : 🤍 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: 🤍 Twitter: 🤍 LinkedIn: 🤍
Welcome to our Excel Full Course for Data Analysis with Projects! In this in-depth tutorial, we explore the powerful capabilities of Excel for data analysis, providing you with valuable skills to excel in the world of data-driven decision-making. With a runtime of 2 hours, this tutorial covers essential techniques and features, along with hands-on projects to reinforce your learning. Whether you're a beginner or looking to enhance your Excel skills, join us for this comprehensive Excel tutorial in 2023 and unlock the potential of data analysis. 👉 Acquire our latest Data Analytics Mastery Course now: 🤍 👉 Take a look at the module for the course: 🤍 👉 Datasets: 🤍 👉 Power BI Full Course - FREE - 🤍 WsCube Tech is a leading Web, Mobile App & Digital Marketing company, and institute in India. We help businesses of all sizes to build their online presence, grow their business, and reach new heights. 👉For Digital Marketing services (Brand Building, SEO, SMO, PPC, SEM, Content Writing), Web Development and App Development solutions, visit our website: 🤍 👉Want to learn new skills and improve existing ones with in-depth and practical sessions? Enroll in our advanced online courses now and make yourself job-ready: 🤍 All the courses are job-oriented, up-to-date with the latest algorithms and modules, fully practical, and provide you hands-on projects. 👉 Want to learn and acquire skills in English? Visit WsCube Tech English channel: 🤍 Video Chapters 00:00:00 - Excel Introduction 00:01:28 - Introduction to MS Excel and Beginner's Guide 00:12:01 - Basic Functions of Excel 00:16:24 - Basics of Formatting in Excel 00:21:11 - Sorting Data in Excel - Different Methods to Sort 00:27:57 - Filtering Data in Excel 00:33:56 - Basics of Formula/Functions 00:39:22 - Text Functions in Excel 00:49:43 - sIf, AND and OR Functions in Excel 00:57:08 - Date & Time Functions in Excel 01:04:01 - COUNTIF, COUNTIFS, SUMIF, SUMIFS - Functions in Excel 01:10:38 - Data Validation in Excel 01:18:42 - Vlookup in Excel 01:28:43 - Hlookup in Excel 01:30:51 - Lookup in Excel 01:37:07 - Xlookup in Excel 01:44:25 - Index+Match in excel 01:49:14 - Using Conditional Formatting 01:56:32 - Macros in Excel 02:01:08 -Summarizing Data with Pivot Tables 02:07:33 - Working with Slicers 02:11:52 - Power Query in Excel 02:21:50 - Power Pivot in Excel 02:33:14 - Visualizing Data with Charts 02:39:31 - Excel Dashboard 📞 For more info about the courses, call us: +91-7878985501, +91-9269698122 ✅ CONNECT WITH THE FOUNDER (Mr. Kushagra Bhatia) - 👉 Instagram - 🤍 👉 LinkedIn - 🤍 👉 Facebook - 🤍 Connect with WsCube Tech on social media for the latest offers, promos, job vacancies, and much more: 😄 Facebook: 🤍 🐦 Twitter: 🤍 📱 Instagram: 🤍 👨🏻💻 LinkedIn: 🤍 🔺 Youtube: 🤍 🌐 Website: 🤍 | Thanks |- #exceltutorial #dataanalysis #excel
excel full course (excel သင်ခန်းစာ အစ / အဆုံး ) #aungcomputer #excel #exceltutorial #exceltips #excel_formulas_and_functions
Are you new to Excel and not sure where to begin or how to know all the basics in one place? You have come to the right place. In this concise yet in-depth video, learn: 1) What is Excel and how to use it? 2) How to enter and format data in Excel? 3) Understanding Excel's ribbon UI 4) How to set up filters & sort data? 5) How to add totals or averages with formulas? 6) How to create a chart from your data 7) How to highlight values below a certain number, automatically? 8) Example file & homework problems for you Video topics & timestamps ⏱👉 0:00 - Introduction to Excel (Tanvi's tracking troubles) 1:15 - Starting Excel 1:38 - Understanding the Excel Screen (ribbon, formula bar, grid and status bar) 4:09 - Setting up the sales tracker 7:35 - Exploring Excel Ribbons 8:21 - Formatting the data so it looks nice 11:37 - Using filters to understand data (which customers paid by cash)? 13:05 - Formatting currency values 13:57 - Sorting data so highest amount shows on top 15:46 - Writing formulas to add up values 21:01 - Clearing away things in your spreadsheet 21:29 - Calculating average of values with formulas 22:39 - Visually representing data with Excel charts 24:08 - Formatting and adjusting Excel charts 27:27 - Special charting tip: Showing just selected data in the graph 28:26 - Highlighting values that are below 1200 (conditional formatting) 29:57 - Homework problems & closing remarks Sample file 📗👇 = You can download the sample file for this course from here: 🤍 FREE Excel Tips Book 📖💥 = Download your copy of 50 Excel Tips book from here - 🤍 Learn more 💻⏩ = Now that you finished the basic Excel course, here are the next learning stops for you. 1️⃣ Beginner to PRO Data Analysis course - 45 minute video - 🤍 2️⃣ Create your first pivot table and 7 more in 10 minutes - 🤍 3️⃣ How to use Excel's cell references to write better formulas - 🤍 4️⃣ Excel Basic Skills - Article - 🤍 5️⃣ Complete Excel Course (Paid program by me) - 🤍 Happy learning 🌼🌞😀 #ExcelCourse
AD: Sign up to enroll for a 7-day free trial with Coursera now! 🤍 Learn all the fundamentals of Data Analysis on Excel in 10 minutes! 🆓 DOWNLOAD Free Excel file for this video: 🤍 #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: 🤍 👉 Excel for Business & Finance Course: 🤍 🚀 All our courses: 🤍 SOCIALS: 🎬 My Company YouTube Channel: 🤍 📸 Instagram - 🤍 🤳 TikTok - 🤍 🧑💻 LinkedIn - 🤍 ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ 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.
.svg){kind=small}
![[FREE EXCEL COURSE] Lesson 4 - Working with Cells and Ranges](https://i.ytimg.com/vi/B16UleW3uUM/mqdefault.jpg "[FREE EXCEL COURSE] Lesson 4 - Working with Cells and Ranges")
![Excel Full Course for Data Analysis with Projects [ 2 Hours] | Excel Tutorial 2023](https://i.ytimg.com/vi/SA_SDo-cqpg/mqdefault.jpg "Excel Full Course for Data Analysis with Projects [ 2 Hours] | Excel Tutorial 2023")
