Summary
Keywords
Full Transcript
🔥Data Analyst Masters Program (Discount Code - YTBE15) - https://www.simplilearn.com/data-analyst-masters-certification-training-course?utm_campaign=yCqxdtE2JXE&utm_medium=DescriptionFirstFold&utm_source=Youtube 🔥IITK - Professional Certificate Course in Data Analytics and Generative AI (India Only) - https://www.simplilearn.com/iitk-professional-certificate-course-data-analytics?utm_campaign=yCqxdtE2JXE&utm_medium=DescriptionFirstFold&utm_source=Youtube 🔥IIT Delhi - Data Analytics, Generative AI And Adaptive System - https://www.simplilearn.com/ihfc-iitd-data-analytics-genai-course?utm_campaign=yCqxdtE2JXE&utm_medium=DescriptionFirstFold&utm_source=Youtube This video on Excel Expert Full Course 2026 by Simplilearn will help you learn Microsoft Excel from beginner to advanced level and understand how to use spreadsheets for data analysis, reporting, and business tasks. The course begins with an introduction to Excel and covers basic concepts such as worksheets, cells, formulas, and functions. You will learn important functions like SUM, IF, VLOOKUP, HLOOKUP, and INDEX MATCH for data analysis. The tutorial also covers data cleaning, sorting, filtering, and data validation techniques. You will understand how to create charts, graphs, and dashboards for data visualization. The course explains advanced features like Pivot Tables, Pivot Charts, and conditional formatting. You will also learn how to automate tasks using basic macros and improve productivity. By the end of this Excel tutorial for beginners, you will clearly understand Excel tools and techniques to analyze data and support business decisions. Following are the topics covered in the Excel Expert Full Course 2026: 00:00:00 - Introduction to Excel Full Course 2026 00:03:25 - Excel for Data Analytics 2026 01:12:41 - Excel Lookup Functions 01:52:58 - Pivot Tables In Excel 01:55:59 - How to Create a Pivot Table Using Multiple Sheets in Excel 01:59:32 - Excel Sorting And Filtering and How To Sort Data In Excel 02:23:09 - How To Use IF Formula In Excel 02:33:30 - Conditional Formatting In Excel 02:36:49 - Data Validation In Excel 03:03:29 - How To Remove Duplicates In Excel 03:07:41 - Advance Excel Power Query Tutorial For Beginners 04:05:23 - Essential Skills For Data Analysis In Advance Excel 04:21:05 - Automation using Power Query 2026 04:39:39 - Advance Excel Macros And VBA For Beginners 05:42:06 - Automation Anywhere 06:01:55 - Top Advance Excel Questions Asked In Interviews 06:01:27 - Charts and Graphs In Excel 06:22:28 - Excel Data Visualization Course 06:57:48 - AI Powered Business Analytics with Excel Full Course 07:01:14 - Analytics foundations and business scenarios 07:13:41 - Four types of analytics explained 07:16:48 - Descriptive and diagnostic demos in Excel 07:24:32 - Predictive analytics concepts and examples 07:33:25 - Prescriptive analytics and recommendations 07:36:32 - Business analytics applications across domains 07:55:26 - Excel as a business analytics tool 08:01:57 - Data cleaning basics and importing data (Get Data, JSON, SQL) 08:22:59 - Managing data: sorting, filtering, duplicates, text cleanup 08:52:51 - Data validation, cell references, named ranges 09:13:48 - AI in Excel: ChatGPT add-in and functions 09:25:03 - Formatting: custom numbers/dates and conditional rules 09:47:20 - Functions for analysis: logical, lookup, reference, statistical 10:54:51 - Pivot tables and grouping; Power Pivot model 11:34:28 - Power Query ETL: transform, merge, append, group-by 12:01:08 - Slicers and timelines for interactivity 12:02:23 - Business Analytics With Excel 12:10:39 - Business analytics fundamentals 12:39:32 - Excel interface and navigation 13:33:51 - Demo: table formatting and dates 14:16:11 - Sorting and filtering essentials 14:34:20 - Grouping and CSV import 14:54:31 - Excel Table vs Range tables 15:11:33 - Subtotals and copy visible cells 15:29:23 - Conditional formatting basics 15:49:52 - Data tools and cleaning 16:35:33 - Data Validation essentials 16:56:23 - Custom number and date formats 17:10:23 - Conditional formatting advanced 17:45:31 - Text functions for cleaning 17:56:36 - Logical functions in action 18:44:37 - Aggregates and reporting 19:23:28 - Lookups and references toolkit 21:36:49 - Top Excel Questions Asked In Interviews ✅ Subscribe to our Channel to learn more about the top Technologies: https://bit.ly/2VT4WtH ⏩ Check out More Data Analytics Videos By Simplilearn: https://www.youtube.com/playlist?list=PLEiEAq2VkUUKnB4Yzmn-B6O_hhcP-DanA #ExcelTutorial #ExcelForBeginners #ExcelCourse2026 #LearnExcel #ExcelBasics #AdvancedExcel #ExcelTips #DataAnalysis #ExcelFunctions #exceltraining #exceltutoring #microsoftexcel #learnexcel #freeexcelcourse #excelforbeginners #excelfullcourse #2026 #exceltutorialforbeginners #advanceexcel #excelformula #learnexcelonline #learnexcel 🔥🔥 Interested in Attending Live Classes? Call Us: IN - 18002127688 / US - +18445327688
Continue this lesson in the app
Install CourseHive on Android or iOS to keep learning while you move.
