Summary
Keywords
Full Transcript
🔥IITK - Professional Certificate Course in Data Analytics and Generative AI (India Only) - https://www.simplilearn.com/iitk-professional-certificate-course-data-analytics?utm_campaign=HCg6IZL3-JU&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=HCg6IZL3-JU&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. 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 course: 00:00:00 - Introduction to Excel Full Course 2026 00:02:03 - What is Microsoft Excel 00:27:41 - 10 important excel formulas 00:34:32 - How to become data analyst in 2026 04:57:22 - Excel Basics 05:15:42 - Excel Dashboard Tutorial For Beginners 05:25:52 - Excel for Data Analytics 2026 06:34:29 - Data Cleaning in Excel 06:57:14 - Excel Lookup Functions - Vlookup, Hlookup, Xlookup 07:37:31 - Pivot Tables In Excel 07:40:32 - How to Create a Pivot Table Using Multiple Sheets in Excel 07:44:05 - How To Sort Data In Excel 08:07:42 - Slicer and Filter in Excel 08:35:51 - How To Use IF Formula In Excel - ADVANCED TIPS 08:46:12 - Conditional Formatting In Excel 08:49:31 - Data Validation In Excel 09:16:11 - How To Remove Duplicates In Excel 09:20:23 - Excel Power Query Tutorial For Beginners 10:18:05 - Automate Data Tasks with power Query 10:37:36 - Charts and Graphs In Excel 10:58:37 - Excel Data Visualization Course 12:52:00 - Essential Skills For Data Analysis In Excel 13:07:42 - Excel Macros And VBA For Beginners 15:21:15 - Business Analytics With Excel 15:23:42 - Intro to Business Analytics begins 15:24:15 - Data is new oil analogy 15:28:31 - Business analytics definition 15:32:19 - BI versus BA differences 15:36:15 - Four types of analytics explained 15:40:35 - Big Data foundations and 3Vs 15:42:37 - Internet in a minute stats 15:47:09 - IoT and device growth 15:50:45 - Structured, semi, unstructured data 15:57:55 - Big Data definition and 3Vs 16:05:13 - From 3Vs to 7Vs and 10Vs 16:06:55 - AI, ML, Deep Learning simplified 16:11:19 - Machine learning green apple case 16:17:09 - Deep learning provenance example 16:18:31 - Big Data application areas 16:19:37 - Netflix House of Cards anecdote 16:22:48 - Target pregnancy mail story 16:26:32 - Credit card fraud detection 16:33:06 - Police case solved by AI aging 16:47:50 - Healthcare staffing and telemedicine 16:54:59 - Excel intro, versions, and basics 17:03:13 - MultiPlan, Lotus, Excel history 17:06:50 - Freeze panes step‑by‑step 18:18:23 - Remove duplicates and pitfalls 18:32:32 - Conditional formatting on Airbnb 18:32:32 - Host sheet: response/acceptance 18:56:49 - Places: price color scales 19:05:24 - Top/bottom rules and data bars 19:13:34 - Icon sets for availability 19:17:04 - References, Text to Columns, Flash Fill 19:17:04 - Relative, absolute, mixed refs 20:00:37 - Text to Columns: delimiters 20:29:31 - Flash Fill patterns and emails 20:42:37 - Data validation: rules and dropdowns 20:42:37 - Whole/decimal number rules 22:01:25 - Sorting and filtering techniques 22:01:25 - Basic sorts numbers/dates 22:34:54 - Sort by color and custom order 37:30:23 - Data Scraping From Website To Excel with AI 37:56:33 - How To Make Money With Excel In 2026 38:03:38 - How To Use Python In Excel 41:42:20 - Top 20 Most Important Excel Formulas 42:44:46 - How To Increase Your Excel Skills With ChatGPT 45:22:35 - How to use ChatGPT to build an excel dashboard 45:53:33 - 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
Continue this lesson in the app
Install CourseHive on Android or iOS to keep learning while you move.
