Databricks Tutorial | Databricks Free Edition Tutorial with End-to-End Data + AI Project

End To End Data Analytics Project for Portfolio using SQL, Python, Power BI, Project Report, GitHub | Company-Level Data Analyst Project 📊 Build a Real-World Data Analyst Project for Resume with Python, SQL, and Power BI on a Retail Customer Behavior and Shopping Trends dataset. This isn’t just another beginner project, it’s a complete, company-level analytics workflow exactly like what data analysts do in real organizations. From loading and cleaning raw data in Python, to performing data cleaning, exploratory data analysis (EDA), analyzing and solving business problems using SQL, to building an interactive Power BI dashboard, you’ll learn how real data projects move from messy data to executive presentations. 🎯 Whether you’re applying for Data Analyst jobs or building your portfolio, this project has everything: ✅ Define a real business problem statement from a retail company use case ✅ Load, clean, and transform data using Python (pandas) ✅ Simulate business transactions and run advanced queries using SQL ✅ Visualize insights through a beautiful Power BI dashboard ✅ Create a project report for documentation (mandatory in real teams) ✅ Build a presentation deck using Gamma AI ✅ Publish everything on GitHub to make your portfolio stand out 📌 Timestamps: 00:00 – Introduction & Project Overview 02:25 – Business Problem Statement 03:46 – Dataset Overview in Excel 06:45 – Data Loading & Exploratory Data Analysis (Python) 25:15 – Business Analysis using SQL 49:00 – Dashboard Creation in Power BI 1:14:22 – Creating the Project Report 1:15:49 – Building the Presentation Deck 1:17:48 – Uploading Project to GitHub 1:21:2 – Posting Project on LinkedIn 1:22:34 – Final Thoughts 🧠 Why This Project? Because this is exactly how real companies work. You’ll follow a corporate-style process, from data to decisions, learning not just technical tools but also how to think like a data analyst inside a business environment. 🔥 If you’re looking for: • End-to-End Data Analytics Project for Portfolio • Real-World Python SQL Power BI Project • Data Analyst Portfolio Project Ideas • Data Analytics Projects with Business Problem Statements • Beginner to Advanced Data Analytics Project This video is for you. 📥 Project Files & Resources: 💾 GitHub Repo (with all code): https://github.com/amlanmohanty1/customer-trends-data-analysis-SQL-Python-PowerBI 📈 Dataset: https://github.com/amlanmohanty1/customer-trends-data-analysis-SQL-Python-PowerBI/blob/main/customer_shopping_behavior.csv 🚨 Also watch this: 🎥 Top Mistakes Data Analysts Make (And How to Avoid Them) → https://www.youtube.com/watch?v=obj8U-9GEdU&list=PLAx-M6Di0SisFJ1rv5M_FRHUlGA5rtUf_&index=4 or 📂 Watch the full Data Analyst Career Playlist → https://www.youtube.com/playlist?list=PLAx-M6Di0SisFJ1rv5M_FRHUlGA5rtUf_ 👤 About Me I’m Amlan Mohanty, a Data Science professional and content creator. I help students and job seekers learn data analytics, grow in their careers, and land high-paying roles in Data Science & Data Analytics. 📩 Connect with Me: Instagram: https://www.instagram.com/datacareerschool/ LinkedIn: https://www.linkedin.com/in/amlanmohanty1/ 👇Drop a comment and tell me — what other projects do you want to see? Or if you’re stuck, I’ll help you out. 🔔 Subscribe to Amlan Mohanty for more projects, SQL tutorials, job strategies, interview prep, and more: https://www.youtube.com/@UCtXZNI2L3VEwNoKKgFu82Kg #dataanalyst #dataanalytics

Become the software engineer AI can't replace. 😳 👉 Join Amigoscode Academy: https://skool.com/amigoscode-academy Members hired at Apple, Amazon & Just Eat. SQL is one of the most easy yet powerful programming languages. In SQL tutorial you will learn SQL in 4 hours and cover important SQL concepts. In this tutorial you will will learn about PostgreSQL and everything you need to know to get you started with databases. Full SQL and Database Courses can be found below 1 ► https://amigoscode.com/p/sql 2 ► https://amigoscode.com/p/database-design 3 ► https://amigoscode.com/p/advanced-databases Exercise Files - https://github.com/amigoscode/sql-postgres-course 🙊 Subscribe to Amigoscode - http://bit.ly/2HpF5V8 ► Courses Available for free here - https://amigoscode.com/courses ► Join Private Facebook Group - https://www.facebook.com/groups/456035171490753/ ► Join Discord - https://bit.ly/2wL029v ⭐ Table Of Contents ⭐ 00:00 - Intro 02:30 - Quick Word Before we begin 03:25 - What is Database 07:18 - What is SQL 08:48 - SQL Example 12:33 - Postgres 15:05 - Install Postgres (MAC OS) 18:43 - Setup Postgres (MAC OS) 22:31 - Install Postgres (Windows 25:51 - PSQL (Windows) 30:55 - Learn SQL the right way 32:18 - Create Database 35:46 - Connecting to Databases 40:24 - Create Table Syntax + Datatypes 44:36 - Create Table Without Constraints 48:12 - Create Table With Constraints 54:56 - Insert Data 58:16 - Insert Into 1:01:47 - SELECT FROM 1:04:38 - Adding Data 1:14:39 - Sorting 1:19:22 - Removing Duplicates 1:21:30 - WHERE clause 1:25:00 - Comparison Operators 1:29:06 - LIMIT OFFSET and FETCH 1:32:24 - IN 1:35:28 - BETWEEN 1:37:30 - LIKE 1:42:55 - GROUP BY 1:46:30 - HAVING 1:52:04 - Car Table 1:55:45 - MIN MAX & AVG 1:59:53 - SUM 2:02:03 - Arithmetic Operators 2:06:14 - Working with Arithmetic Operators 2:10:01 - Alias 2:12:48 - Coalesce 2:16:34 - NULLIF 2:20:39 - Timestamps & Dates 2:20:39 - Adding & Subtracting Dates 2:26:36 - Extracting Fields From Dates 2:28:27 - Age Function 2:30:11 - Primary Keys 2:32:16 - Primary Keys (Part 2) 2:37:30 - Adding Primary Keys Constraints 2:41:58 - Unique Constraints 2:30:11 - Primary Keys 2:50:00 - Check Constraints 2:55:30 - Deleting Records 3:02:25 - Updating Records 3:06:44 - On Conflict Do Nothing 3:11:57 - On Conflict Do Update 3:17:29 - Foreign Keys & Relationships 3:20:45 - Adding Foreign Keys 3:25:59 - Updating Foreign Keys 3:30:26 - Inner Joins 3:36:04 - Left Joins 3:41:49 - Deleting Foreign Keys 3:48:37 - Sequences 3:55:19 - Extensions 3:57:42 - UUID 4:04:12 - UUID in Action 4:14:47 - Exporting to CSV 4:18:02 - Next steps 4:20:00 - Database Design Course 🙊 Here are the goods for all my videos video: ► Recommended Books Clean Code - https://amzn.to/2UGDPlX HTTP: The Definitive Guide - https://amzn.to/2JDVi8s Clean Architecture - https://amzn.to/2xOBNXW ► Computer and Monitor New Apple MacBook Pro - https://amzn.to/3464Mmn Dell 27 INCH Ultrasharp U2719D Monitor - https://amzn.to/2xM3nW1 Double Arm Stand Desk Mount - https://amzn.to/3aYKKfs USB C Hub Multiport Adapter - https://amzn.to/2Jz7NlL ► Camera Gear Sony ILCE7M3B Full Frame Mirrorless Camera - https://amzn.to/346QIJn Sigma 16 mm F1.4 DC DN - https://amzn.to/2wbic3Q Sigma 33B965 30 mm F1.4 DC DC - https://amzn.to/39G37Fd Awesome Screen Saver - https://github.com/JohnCoates/Aerial IDE I use for coding - Iterm - VsCode - GoLand - IntelliJ - Sublime 💯 You can also follow me here: ► Don't forget to subscribe | http://bit.ly/2HpF5V8 ► Join Closed Facebook Group for discussion and early access videos and courses | http://bit.ly/2FbuIkx ► Follow me on Instagram | http://bit.ly/2TSkA9w ► Join Discord - https://bit.ly/2wL029v ❤️ Thanks for watching

Learn Full Excel Course from Basic to Advanced with AI | Excel AI Masterclass 2026 #SD108 If you want to become confident in Microsoft Excel and learn practical Excel skills used in real jobs, this masterclass is for you. In this complete course, you will learn Excel step by step from beginner level to advanced level with practical examples and AI-powered productivity techniques. This Excel Masterclass is specially designed for: ✔️ Students ✔️ Office Employees ✔️ MIS Executives ✔️ Data Analysts ✔️ Freelancers ✔️ Business Owners ✔️ Job Seekers Important Links 👉All Practice Files : https://edu.skillcourse.in/free-video/8 🔴Freelancing Mastery Program : https://edu.skillcourse.in 👉Excel Beginners to Advance Masterclass Exam & Certificate Link (Instructions Given in the Video) : https://edu.skillcourse.in/dashboard/tests/30 🚀Excel AI Automation Masterclass Video : https://youtu.be/Zykv4eaVzcQ?si=m_hai456XzR5GVbU Lesson 1-Excel Introduction - 05:58 Lesson 2-Data Entry in Excel - 43:41 Lesson 3-Essential Formulas - 01:13:10 Lesson 4-IF Formulas in Excel - 01:30:35 Lesson 5-Nested IF and IFS Formula - 01:51:25 Lesson 6-Conditional Formatting - 02:13:29 Lesson 7-Sort Data in Excel - 02:38:40 Lesson 8-Filter Data in Excel - 02:52:42 Lesson 9-Sort and Filter Formula in Excel - 03:14:26 Lesson 10-Data Validation - 03:36:12 Lesson 11-Remove Duplicate,Text to Columns, Flash Fill - 03:49:44 Lesson 12-Paste special & GoTo Special - 04:03:57 Lesson 13-31 Excel Formulas - 04:41:38 Lesson 14-Pivot Table Masterclass - 06:20:46 Lesson 15-PowerPivot Table - 09:46:44 Lesson 16-Office 365 and Latest formulas - 11:46:38 Lesson 17-AI Use in excel - 12:58:26 Lesson 18-Claude AI Extension in Excel - 14:07:39 Lesson 19-Freelancing - 14:40:01 🎯 This course will help you: ✔️ Improve productivity ✔️ Work faster in Excel ✔️ Build professional reports ✔️ Handle large datasets ✔️ Learn automation techniques ✔️ Prepare for office jobs and interviews ✔️ Improve Data Analysis skills Whether you are learning Excel for jobs, freelancing, office work, reporting, dashboards, or data analysis, this complete Excel course will help you master Excel professionally. 🔔 Subscribe for more Excel, Power BI, SQL, Python & AI tutorials Trainer: Satish Dhawale #Excel #ExcelCourse #AdvancedExcel #MicrosoftExcel #ExcelTutorial #ExcelMasterclass #AIinExcel #DataAnalysis #PivotTable #ExcelFormulas Get Free Notification for Upcoming Videos = https://forms.gle/5Jz1WJSki3nJrb6v7 ------------------------------------------------------------------------------------------------------------------------------ Learn Satish Sir courses with Certificate Course Website :https://skillcourse.in/ ------------------------------------------------------------------------------------------------------------------------------ Follow us on LinkedIn : https://www.linkedin.com/in/satish-dhawale/ ------------------------------------------------------------------------------------------------------------------------------ Check our latest blogs: https://learnmoreindia.in/ ------------------------------------------------------------------------------------------------------------------------------ Social media Pages: Skill Course LinkedIn : linkedin.com/company/skill-course/ Facebook Page Link: https://www.facebook.com/learnmoreeasily/ Instagram Page Link: https://www.instagram.com/_learn_more_pro_/ Telegram channel: https://telegram.me/learnmoreindia Follow us on X : https://x.com/Satish_Dhawale_ ------------------------------------------------------------------------------------------------------------------------------ My Other Channels: Satish Dhawale: ✅ https://www.youtube.com/@Satish_Dhawale Real Tutorial: ✅ https://www.youtube.com/@realtutorial550 Complete Technology:✅ https://www.youtube.com/@CompleteTechnology Learn more shorts:✅ https://www.youtube.com/@LearnMoreShorts Satish Tech (Marathi):✅ https://www.youtube.com/@Satish_Tech Tally Tutorial:✅ https://www.youtube.com/@TallyTutorial I Love Excel by Skill Course:✅ https://www.youtube.com/@Excel_Tutorial Learn More:✅ https://www.youtube.com/@Learn_More_Pro Curiosity: ✅ https://www.youtube.com/@curiosity9432 ------------------------------------------------------------------------------------------------------------------------------ My YouTube Gears : Best Mic for Recording (Condensor Mic): https://amzn.to/2UUMDnH Best Mic for Recording (Dynamic Mic ): https://amzn.to/3pQgyvD My DSLR Camera Canon 200D: https://amzn.to/39ciw3E My Laptop (Video Editing): https://amzn.to/2UXQj8h Laptop (Office Use/ Home use / Budget Laptop) : https://amzn.to/3l0pniw Antivirus: https://amzn.to/3l3TIgi Screen Recording Software: https://bit.ly/2J39n2j Video Editing Software: https://bit.ly/3nOPlri Green screen with Stand: https://amzn.to/2KAl1Cu

📘 10 Hours Excel Basic to Advance Course With AI | Full Video Tutorial #LM763 In this Excel tutorial, you will learn Microsoft Excel from basic to advanced level in a complete 10-hour step-by-step video. This course is designed for beginners, students, job seekers, business professionals, and anyone who wants to master Excel with the help of AI-powered productivity tools. From essential formulas to advanced Pivot Tables, dashboards, and AI features, this video provides everything you need to become confident and job-ready in Excel. 🔥 What You Will Learn ✔ Excel Interface & Basics ✔ Formulas and Functions ✔ Data Cleaning, Sorting & Filtering ✔ Conditional Formatting ✔ Data Validation & Data Tools ✔ Pivot Tables, Pivot Charts & Dashboards ✔ Advanced Formulas (VLOOKUP, INDEX, MATCH, Logical & Statistical) ✔ Excel Automation & AI Features Detailed Timestamps / Chapters 00:10 – Introduction 09:25 – Excel Introduction 47:01 – Basic Formulas in Excel 1:06:08 – Conditional Formatting 1:23:30 – Sorting Data in Excel 1:40:13 – Filter in Excel 2:04:41 – Data Validation 2:19:51 – Data Tools 2:30:32 – Sheet & File Protection 2:42:13 – Find, Replace & Paste Special 2:57:32 – Printing Essentials 3:08:45 – Excel Pivot Table Basics 3:25:09 – Pivot Charts 3:32:59 – Slicers & Slicer Settings 3:49:40 – Timeline in Pivot Table 3:56:31 – Grouping & Custom Grouping 4:04:25 – Pivot Table Options & Settings 4:23:22 – Show Values As 4:37:43 – Calculated Fields 4:47:37 – Filters & Filter Reports Page 4:54:47 – Dynamic Pivot Tables 5:04:40 – Pivot Table on Multiple Sheets 5:15:32 – GETPIVOTDATA Formula 5:24:08 – Auto-Refresh Pivot Table 5:27:06 – Creating a Dashboard Using Pivot Tables 6:37:43 – Logical Functions 6:58:59 – VLOOKUP, MATCH & INDEX 7:45:33 – Statistical Formulas 8:13:47 – Date Formulas 8:32:40 – Excel with AI #ExcelTutorial#ExcelCourse#ExcelTraining #ExcelBasicToAdvanced#LearnExcel#excelforbeginners Meet me on Linkedin : https://www.linkedin.com/in/satish-dhawale/ My Data Analysis related content Channel : https://www.youtube.com/@Satish_Dhawale Download All Practice Files : https://drive.google.com/uc?export=download&id=1ceNwz0vTx79mM1O8iIWGkySJuUGtIzKF Get Free Notification for Upcoming Videos = https://forms.gle/9G2xL2c5XrA14HvbA ------------------------------------------------------------------------------------------------------------------------------ Learn Satish Sir courses with Certificate Course Website :https://bit.ly/skill_course Course Features : ✅ सभी Videos सरल हिंदी भाषा में ✅ Basic to Advance Courses ✅ Practice Files (Yes) ✅ PDF Shortcuts ✅ Course Completion Certificate ✅ Instant Access ✅ Watch on Desktop : https://skillcourse.in/ ------------------------------------------------------------------------------------------------------------------------------ Check our latest blogs: https://learnmoreindia.in/ ------------------------------------------------------------------------------------------------------------------------------ Social media Pages: Facebook Page Link: https://bit.ly/3CvGlBT Instagram Page Link: https://bit.ly/3f9R37u Telegram channel: https://telegram.me/learnmoreindia ------------------------------------------------------------------------------------------------------------------------------ For Short tips : https://www.youtube.com/@Skill-Course My Other Channels: Excel Tutorial:✅ https://www.youtube.com/@Excel_Tutorial Complete Technology:✅ https://www.youtube.com/@CompleteTechnology Satish Tech (Marathi):✅ https://www.youtube.com/@Satish_Tech Tally Tutorial:✅ https://www.youtube.com/@TallyTutorial Learn More:✅ https://www.youtube.com/@Learn_More_Pro ------------------------------------------------------------------------------------------------------------------------------ My YouTube Gears : Best Mic for Recording (Condensor Mic): https://amzn.to/2UUMDnH Best Mic for Recording (Dynamic Mic ): https://amzn.to/3pQgyvD My DSLR Camera Canon 200D: https://amzn.to/39ciw3E My Laptop (Video Editing): https://amzn.to/2UXQj8h Laptop (Office Use/ Home use / Budget Laptop) : https://amzn.to/3l0pniw Antivirus: https://amzn.to/3l3TIgi Screen Recording Software: https://bit.ly/2J39n2j Video Editing Software: https://bit.ly/3nOPlri Green screen with Stand: https://amzn.to/2KAl1Cu

Learn Python from scratch and start building real AI applications. This is the fastest, beginner-friendly course Python for AI development. 📕 Course Handbook: https://go.datalumina.com/cm5P6b6 📥 Course Resources: https://go.datalumina.com/M2YfRW3 👊🏻 Let's connect on IG: https://www.instagram.com/daveebbelaar/ 🎙️ Try Glaido, the #1 dictation tool for developers: https://get.glaido.com/dave ⏱️ Timestamps 00:00:00 Introduction: Learn Python for AI 00:01:42 Course Overview & Structure 00:03:58 Installing Python 00:04:05 Installing Python on Windows 00:05:10 Installing Python on Mac 00:06:53 Installing VS Code 00:08:34 Setting Up VS Code (Extensions) 00:12:08 Customizing VS Code 00:13:31 Creating Your First Project 00:16:18 Creating a VS Code Workspace 00:18:02 Your First Python File (hello.py) 00:20:10 Running Python Code 00:26:23 Exercise & Recap 00:29:26 Course Resources & Community 00:31:07 Understanding Python Environments 00:33:15 Understanding Python Packages & Pip 00:34:00 Creating Virtual Environments (venv) 00:37:34 A Note on Anaconda 00:38:32 Installing Python Packages (pip install) 00:42:51 Using Python Packages (Import) 00:44:29 Interactive Python with Jupyter 00:48:30 Full Setup Recap & Exercise 00:51:36 What is Programming? 00:55:19 Understanding Python Syntax & PEP8 00:58:00 Understanding & Debugging Errors 01:01:33 Variables 01:06:03 Comments 01:09:48 Data Types Introduction 01:10:12 Numbers (Integers & Floats) 01:13:36 Strings 01:19:39 String Formatting (F strings) 01:21:49 String Methods 01:26:35 Booleans 01:31:02 Operators (Arithmetic, Comparison, Logical) 01:39:19 Shortcut Assignments (+=) 01:40:24 Control Flow Introduction 01:41:35 Conditional Statements (if, elif, else) 01:47:11 Loops (For Loops & range()) 01:52:13 Data Structures Introduction 01:53:32 Lists 01:59:10 Dictionaries 02:00:23 Tuples 02:01:37 Sets 02:05:51 Functions (Defining & Calling) 02:15:02 Function Parameters & Arguments 02:22:42 Global vs Local Variable Scope 02:28:50 Returning Values from Functions 02:37:37 External Tools (Modules, Packages) 02:40:48 Importing Modules & Built ins 02:47:56 Import Methods Summary 02:48:48 Installing Packages & requirements.txt 02:56:04 Working with APIs (Requests Example) 03:06:20 Working with Data Example (Pandas & Matplotlib) 03:10:46 Reading & Saving Data Files 03:14:50 Practical Python Introduction 03:16:47 Project Structure & Organization 03:22:02 Understanding File Paths 03:26:37 Working with Different File Types 03:34:05 Organizing Code into Modules 03:39:39 Error Handling (Try/Except) 03:45:31 Introduction to Classes (OOP) 03:49:09 Creating Your First Class (__init__, self) 03:57:04 Class Attributes vs Instances 04:00:10 Class Methods 04:05:23 Class Inheritance 04:07:32 When to Use Classes vs Functions 04:09:44 Introduction to Git & GitHub 04:12:31 Git Fundamentals 04:15:41 Installing Git 04:16:46 Basic Git Workflow 04:18:41 GitHub Account Setup & Authentication 04:22:37 Cloning GitHub Repositories 04:28:12 Creating Repositories & .gitignore 04:36:12 Using Git with VS Code UI 04:44:05 Environment Variables & Secrets (.env) 04:52:13 Using python dotenv Package 04:55:03 Introduction to Ruff (Linter & Formatter) 04:56:13 Setting Up Ruff in VS Code 04:57:23 Ruff in Action 05:01:10 Introduction to Uv (Modern Package Manager) 05:02:07 Installing Uv 05:02:30 Using Uv (uv init, add, sync) 05:09:01 Complete Python Project Workflow Exercise 05:11:13 Course Wrap up & What's Next 👋🏻 About Me Hi! I'm Dave, AI Engineer and founder of Datalumina®. On this channel, I share practical tutorials that teach developers how to build production-ready AI systems that actually work in the real world. Beyond these tutorials, I also help people start successful freelancing careers. Check out the links above to learn more!

🔥 In this complete course, you will learn Excel fundamentals, interface, formatting, formulas, functions, data handling, charts, conditional formatting, sorting, filtering, data validation, text functions, logical functions, lookup functions, date and time functions, financial functions, Pivot Tables, Pivot Charts, dashboards, what-if analysis, advanced data tools, printing setup, page layout, protection, automation basics, and many complex real-world Excel concepts in a step-by-step practical way. 👉Download practice stuff - "Kindly check PIN Comment" ✅Advance Excel LIVE Course (Basic to Advance) - https://web.accountsexpertapp.com/new-courses/1 ✅Checkout Our Website - https://web.accountsexpertapp.com/ ✅Install our App from Playstore - https://play.google.com/store/apps/details?id=co.tarly.wugze ━━━━━━━━━━━━━━━━━━━━━━━ 🌟 🔥 SALE IS LIVE! 🔥 🌟 🎯 Flat 10% OFF on ALL Courses 🎟 Use Coupon Code: WELCOME10 at checkout ⏳ HURRY! Limited Time Offer! ━━━━━━━━━━━━━━━━━━━━━━━ 🚀 How to Enroll? (Super Easy!) 🚀 📲 Via App: Download Accounts Expert from Play Store 📥 💻 Via Website: www.accountsexpertapp.com 🌍 📞 Call/WhatsApp: +91 8804949888 (Get Instant Support!) ☎📩 ━━━━━━━━━━━━━━━━━━━━━━━ 💡 What Do We Offer? 💡 🔹 📊 Advance Excel Live Course – Master formulas, automation & data visualization like a PRO! 🖥📈 🔹 🏢 SAP Live Course – Learn Enterprise Resource Planning (ERP) & boost your corporate career! 🏆💼 🔹 📚 Tally Live Course – Become an expert in GST, accounting & business management! 📖📊 🎯 And Many More! Upgrade your skills & level up your career today! 🚀 ━━━━━━━━━━━━━━━━━━━━━━━ ✅TimeStamp : - 00:00:00- Introduction 00:03:24- Video Overview 00:11:25- What is Data & Its theory 00:19:51- Excel Version 00:24:50- Interface Overview 00:50:31- Movement Shortcut keys 01:04:26- Data Entry 01:25:40- formatting 02:13:23- number format 02:33:12- basic formulae 03:03:56- conditional formatting 03:23:37- A.I Conditional Formatting 03:29:20- Data Creation with A.I 03:31:22- Clipboard 03:36:57- filter 03:45:43- sorting 03:53:30- table creation 04:17:21- Fill Series 04:47:16- Go to special 05:15:03- Paste special 05:35:46- Find & Replace 05:48:29- Clear 05:53:47- Promtion Video 05:54:45- Cell Referencing 06:32:28- text formulas 07:29:24- Rand , Rand between , Rand Array 07:41:09- Large , Small 07:46:45- Round , Roundup , Round down,Int, Trunc 07:59:16- Floor , M round , Ceiling , Mod ,Abs , Power , Sqrt 08:03:42- Current Date & Time 08:11:06- Day , Month , Year , Date , Time , Hour , Minute , Second 08:20:39- Days, Days360, Netwrokdays, Networkdays.intl 08:32:28- Workday, Workday.intl 08:40:10- Edate, ,Eomonth 08:48:47- Datedif , Yearfrac 08:52:47- Weeknum , 08:56:55- IF - Logical formulae 09:22:33- And , Or , ,Nested If and , Nested If Or 09:35:20- IFS 09:41:41- Switch , Iferror , Ifna , Isblank , Isnumber , etc 09:51:58- Sumif ,Average if , Countif 10:14:06- Attendance Tracker Prep (Normal + 365) 10:23:55- Report Creation - Yearly , Monthly though Sumifs , Averageifs , Countifs 10:42:03- lookup & refrence formulas Theory 10:58:02- Theory of Vlookup 11:18:59- Various kind of Vlookup Practical application 11:31:52- Vlookup in multiple sheets & Workbooks 11:36:37- Multiple Values in Vlookup 11:39:00- Reverse Vlookup 11:47:13- Vlookup with true condition 11:49:54- Vlookup with dynamic heading (vlookup + match) 11:57:10- index , match , index + match 12:08:15- Hlookup 12:11:10- Xlookup & With Multiple Values 12:19:05- filter formula multiple conditions 12:27:28- Advance Filter Feature 12:32:02- Financial Formulas - Pmt , Ipmt , Ppmt 12:40:55- Vtsack ,Hstack , Sequence , Transpose , Remove duplicates ,free alternative of 365 12:47:26- Add Developer Tab in Excel 12:49:08- Add Addins in Excel - Formula ai aided tool Bar 12:52:35- Chat Bot Assistants , Prompt Creation 13:16:41- Formula Creation through ai, Copilot 13:21:14- Formula Creation through ai Claude 13:31:24- Pagelayout Tab- All Print Settings 13:44:55- View Tab- Freeze Panes , Views 13:51:41- Review Tab- Sheet Protection 13:56:54- Text To Columns 13:59:33- Data Validation 14:05:49- Consolidation 14:09:23- Power Query 14:23:26- Pivot Table Theory 14:29:54- Pivot Table Creation 14:35:46- Pivot Design Option 14:44:30- Pivot Table Options 14:53:51- Pivot Shows as option 14:59:48- Pivot Slicer 15:02:18- Pivot Timeline 15:05:03- Pivot Chart Element Theory 15:13:39- Bar / Column Chart 15:18:29- Line and Trend Chart 15:21:50- Pie/ Donut Chart 15:24:18- Funnel 15:27:20- Treemap / Sunburst Chart 15:31:08- Map / Radar Chart 15:36:13- Promotion Video 15:37:11- Dashboard Theory 15:42:58- Data Check Overview 15:46:53- Dashboard Creation Planning 15:53:51- KPI Creation 16:08:32- Visual Creation 16:22:42- Dashboard Creation 17:01:22- Report & Dashboard through claude 17:12:10- Prensentation through ai 17:23:33- Assignment Answers keys 17:31:15- Interview Questions 17:33:01- How to Download the Data