Excel for Data Analyst | Excel Full Course 2026 | Day 2 | Excel for Beginners 2026

In this video, we continue the Excel for Data Analytics 10-Day Challenge, where you will learn all the important Excel concepts required to become a Data Analyst. 🌈 𝐆𝐨𝐨𝐠𝐥𝐞 𝐃𝐚𝐭𝐚 𝐀𝐧𝐚𝐥𝐲𝐭𝐢𝐜𝐬 𝐏𝐫𝐨𝐟𝐞𝐬𝐬𝐢𝐨𝐧𝐚𝐥 𝐂𝐞𝐫𝐭𝐢𝐟𝐢𝐜𝐚𝐭𝐞 - imp.i384100.net/GDataAnalytics 🌈 𝐌𝐢𝐜𝐫𝐨𝐬𝐨𝐟𝐭 𝐏𝐨𝐰𝐞𝐫 𝐁𝐈 𝐃𝐚𝐭𝐚 𝐀𝐧𝐚𝐥𝐲𝐬𝐭 𝐏𝐫𝐨𝐟𝐞𝐬𝐬𝐢𝐨𝐧𝐚𝐥 𝐂𝐞𝐫𝐭𝐢𝐟𝐢𝐜𝐚𝐭𝐞 - imp.i384100.net/DAMicrosoft ______________________________________________ This is Day 2, where we complete the Excel Dashboard basics and explore important Excel tools like format as table, sorting & filtering, basic formulas, charts, text split, flash fill, remove duplicates, freeze panes, comments, sheet protection, and many more practical features used in real projects. You will also get practice Excel sheets and PPT files for each lesson so that you can learn by doing. By the end of this challenge, you will gain strong Excel skills that are required in real Data Analyst jobs, startups, and corporate companies. ______________________________________________ 📚 Topics Covered in This Video: ✅ Format as Table & Cell Styles ✅ Insert / Delete Rows and Columns ✅ Basic Formulas (Sum, Average, Count, Max, Min) ✅ Sorting & Filtering Data ✅ Find & Replace Function ✅ Insert Charts (Column, Line, Pie & Donut) ✅ Hyperlink & Comments in Excel ✅ Text to Columns (Split Text) ✅ Flash Fill (AI Feature in Excel) ✅ Remove Duplicates ✅ Data Validation Basics ✅ Group & Ungroup Rows and Columns ✅ Version History & Workbook Statistics ✅ Sheet Protection & Range Protection ✅ Freeze Panes (Freeze Rows & Columns) ✅ Gridlines, Headings & Formula Bar Options ______________________________________________ 🎯 Who Should Watch This? Beginners who want to learn Excel Students preparing for Data Analyst roles Working professionals switching careers Anyone who wants to improve Excel skills ______________________________________________ 📥 Practice Files & PPT: 🔥Download Dataset and PPT here - https://topvarsity.in/data-analytics-... ______________________________________________ #Excel #DataAnalytics #ExcelForBeginners #LearnExcel #DataAnalyst #ExcelCourse #MicrosoftExcel #ExcelTutorial #ExcelDashboard #Analytics ______________________________________________ 🟨 𝐉𝐨𝐢𝐧 𝐔𝐬 𝐎𝐧 𝐈𝐧𝐬𝐭𝐚𝐠𝐫𝐚𝐦🟨   / topvarsity   ______________________________________________ 🟦 𝐅𝐨𝐫 𝐍𝐨𝐭𝐢𝐟𝐢𝐜𝐚𝐭𝐢𝐨𝐧 𝐉𝐨𝐢𝐧 𝐎𝐮𝐫 𝐓𝐞𝐥𝐞𝐠𝐫𝐚𝐦 𝐂𝐡𝐚𝐧𝐧𝐞𝐥 🟦 https://telegram.me/NotesEngineering ______________________________________________ 00:00 – Introduction to Day 2 Excel Challenge 00:18 – Format as Table & Cell Styles 01:05 – Insert / Delete Rows and Columns 01:30 – Basic Formula Options (Sum, Average, Count) 02:05 – Sorting & Filtering Data 03:40 – Advanced Filtering (Greater Than Conditions) 04:05 – Find & Replace Feature 05:05 – Add-ins & Excel Automation Tools Overview 05:30 – Introduction to Pivot Table Concept 06:05 – Insert Pictures, Shapes & Checkboxes 07:55 – Creating Charts (Column, Line & Pie Charts) 09:35 – Insert Hyperlink & Comments 11:20 – Share Option & Page Layout Basics 12:20 – Show Formulas & Workbook Calculations 13:35 – Custom Sort & Text to Columns (Split Names) 15:35 – Flash Fill (Automatic Pattern Detection) 16:20 – Remove Duplicates & Data Validation 17:05 – Group / Ungroup Rows and Columns 18:00 – Version History & Track Changes 19:05 – Spell Check & Workbook Statistics 20:10 – Sheet Protection & Notes 21:15 – Freeze Panes (Freeze Rows & Columns) 22:30 – Gridlines, Headings & Formula Bar 23:20 – View Options, Zoom & Navigation 24:15 – Draw Tools & Excel Help Options 25:20 – Viewing vs Editing Mode 26:00 – Summary & Next Lecture (Formulas) ______________________________________________ ______________________________________________ Ⓣⓗⓐⓝⓚ Ⓨⓞⓤ ! . . . . . . . #dataanalyst #datascience #businessanalysis #businessintelligence #careerdevelopment #datanerd #python #excel #jobsearch #dataroadmap #dataskills #dataanalytics excel for data analysts data analytics in excel course excel excel course excel tutorial ms excel microsoft excel excel for data analyst excel for beginners learn excel excel tips excel pivot table excel tricks excel tips and tricks advanced excel excel for data analysis excel data analysis ms excel tutorial excel formulas data analysis in excel excel for data analytics excel functions data analytics with excel data analytics in excel full course data analytics in excel clean data in excel data analysis with excel complete excel excel data analysis tutorial