@chandoo_ Chandoo

Chandoo posts on YouTube about how to, what is, excel, business the most. They currently have [-------] followers and [---] posts still getting attention that total [------] engagements in the last [--] hours.

Engagements: [------] #

• [--] Week [-------] -4.90%
• [--] Month [-------] -26%
• [--] Months [---------] -2.60%
• [--] Year [---------] +169%

Mentions: [--] #

• [--] Week [--] +6%
• [--] Month [--] -6.50%
• [--] Months [---] +19%
• [--] Year [---] +245%

Followers: [-------] #

• [--] Week [-------] +0.24%
• [--] Month [-------] +0.85%
• [--] Months [-------] +5.40%
• [--] Year [-------] +16%

CreatorRank: [-------] #

Social Influence

Social category influence technology brands 11.11% stocks 6.17% finance 5.56% social networks 1.85% currencies 1.23% countries 0.62%

Social topic influence how to 35.19%, what is #3337, excel 6.17%, business #4464, microsoft #618, if you 4.94%, topics 4.32%, make a 4.32%, tutorial #4192, the new 3.09%

Top accounts mentioned or mentioned by @column

Top assets mentioned Microsoft Corp. (MSFT) FilesCoins Power Cu (FILECOIN) Alphabet Inc Class A (GOOGL)

Top Social Posts

Top posts by engagements in the last [--] hours

"How to use Excel formula references - A1 vs. $A$1 vs $A1 vs A$1 explained Want to write better & smarter formulas Then you must master the reference styles in Excel. There are [--] styles in Excel cell refs. 1) Relative reference - A1 2) Absolute reference - $A$1 3) Mixed reference style - $A1 4) Also mixed reference style - A$1 5) Table reference - TableColumn 6) Table relative - @Column In this video 👇 ============== 0:00 - Introduction to Excel reference styles (relative) 1:33 - How to make a reference Absolute 2:20 - Cell reference used in business situation - Example 3:49 - Using Mixed"
YouTube Link 2021-09-07T08:30Z 833K followers, 42.5K engagements

"How to pick the "perfect" chart for your situation in Power BI Power BI has a LOT of chart types. So when & how to use these charts in data analysis situations In this video let me share my top tips for picking and using the right chart type for your needs. You will learn how to work with these [--] basic chart types. Power BI Bar chart Column chart Small Multiple chart Line chart Area chart Pie chart Donut chart Card visual Multi-row card visual Table Matrix Scatter (XY) plot Animated scatter (XY) plot Waterfall chart Tooltip pages + Tips on all other visuals 👩💻 Sample file & Explanation:"
YouTube Link 2023-07-11T08:00Z 833K followers, 156.6K engagements

"3 Practical Tips for YOUR Success - Data Analyst Interviews 1) Show don't tell - Include examples of your previous work in the CV. Snapshots of your best dashboards or may be a video of your project 2) Be flexible - Recruiters like to hire people with flexible & open attitude towards nature of work operating environment and practices. 3) Focus on learning not on earning - Look at new job as an opportunity to learn. Money will follow later. All the best my friend. 👍 FREE DATA ANALYSIS COURSE 🎁📚 Are you looking to learn data analysis Check out my free course here -"
YouTube Link 2021-08-23T08:30Z 833K followers, 259.1K engagements

"3 Powerful Data Slides for your NEXT Presentation (Free PPT File) Magic Trick 1: Creating a progress chart with animation Magic Trick 2: Fill a percentage of a shape Magic Trick 3: Jazz up numbers on a slide with transitions In the video: 0:00: Demo of the [--] PowerPoint Magic Tricks 0:38: Creating the progress chart (donut chat) 2:30: Animating the progress chart 3:29: Filling inside a shape 5:50: Creating a [--] number slide with wow effect 📁 Download the presentation and practice: https://chandoo.org/wp/wp-content/uploads/2024/06/3-TIPS-DEMO.pptx 😎 More PowerPoint Tips & Tricks: Animated"
YouTube Link 2024-06-18T08:00Z 834K followers, 24.5K engagements

"How to find Outliers in Your Data Easily with Z-Scores in Excel Do you want to find out if there are any outliers in your data You can use simple Excel formulas to calculate z-scores and identify the outliers. To identify the outliers we need to first calculate the z-scores of every data point. To do this you need to calculate the average and standard deviation of the data first. Z-score of a data point is defined as (data point value - average)/standard deviation. Once all the z-scores are calculated we then consider any data point with absolute z-score higher than [--] as an outlier. We can"
YouTube Link 2023-12-05T07:00Z 834K followers, 54.8K engagements

"10 next level SUMIFS tricks only Excel Pros KNOW Take your SUMIFS & other ifs skills to next level with these [--] powerful techniques. Sample file: ========= https://chandoo.org/wp/wp-content/uploads/2021/05/sumifs-xifs-examples-demo.xlsx Topics covered in this video (timestamps): ================================== 0:00 - Introduction 0:26 - 2D SUMIFS 1:04 - SUMIFS with multiple AND conditions 1:39 - SUMIFS with OR condition 2:46 - SUMPRODUCT alternative 3:32 - Multi-condition lookup with SUMIFS 4:10 - Greater than less than conditions 4:31 - SUM between dates 5:29 - Pattern matching"
YouTube Link 2021-05-26T08:45Z 833K followers, 82.3K engagements

"Excel LAMBDA() Function - What is it and when to use it PREPARE TO BE AMAZED LAMBDA() function will change how you use & work in Excel. In this video let me demonstrate the LAMBDA and its practical applications. We can use LAMBDA() to create any type of functions in Excel. This revolutionizes the way we work with Excel. Download the sample file from here 🟩 ================================ You need Excel [---] to use LAMBDA. Currently you also need to enable the "insider" program option but very soon you don't need that for LAMBDA. Learn more about LAMBDA & Get the workbook from here -"
YouTube Link 2022-04-07T09:00Z 833K followers, 69K engagements

"Data Analyst Job Interview - Don't make these [--] mistakes Got a data analyst / data scientist or other data professional interview coming up Make sure you are not doing these [--] mistakes. I had the fortune of attending over [--] interviews during the course of my life so far and I made these mistakes at one point or another. In this brief video let me share these mistakes with you so you can be SUCCESSFUL in your journey. The mistakes =========== 1) Giving impulsive answers 2) Not enough research 3) Using the same examples 4) All talk and no show 5) Being inflexible 6) Focusing too much on money"
YouTube Link 2021-10-13T07:30Z 834K followers, 103K engagements

"Learn For Loop in Python Properly (with sample code 👩💻) Loops & Lists are two most important aspects of Python. In this video learn how to work with them with clear and practical examples. What we are going to learn: 1) Programming concepts like data types objects and control flow 2) How to use for loop to loop through list of items 3) A cool trick to write faster and better loops 4) Using list comprehension - alternative to loops 👩💻 Code used in this video: https://github.com/chandoo-org/python 🕐 Video timestamps: 0:00 - Introduction to looping and list comprehension 0:15 - [--] Main"
YouTube Link 2024-12-17T12:01Z 833K followers, 11.9K engagements

"How to ACTUALLY use AI + PYTHON to Analyze Data (real-time example) Learn how to analyze hospital data with Python (pandas) with the help of AI tools. We are going to perform [--] levels of data tasks. 1) Data loading and exploratory analysis 2) Answering a specific business question 3) Performing practical analysis of data Watch this if you currently code in Python. You will become more productive and better at your work with the ideas presented in this. 🕐 Video Topics and Timestamps: 0:00 - Spilling my secrets 0:52 - Chapter [--] - Data Exploration with Python (using AI) 7:03 - Chapter [--] -"
YouTube Link 2026-02-05T14:30Z 835K followers, 12.1K engagements

"Learn Power BI Service in Just [--] Minutes Just got access to Power BI reports Watch this "perfect" getting started tutorial to get more out of the reports and dashboards shared with you. Topics covered in this video: 0:00 - What is Power BI Service 0:55 - Accessing Power BI Service via app.powerbi.com 2:08 - Power BI Service vs. Power BI Desktop 2:31 - Opening a report in Power BI Service 2:55 - Using a Report in Power BI Service 3:40 - Resetting filters in Power BI 4:00 - Multi-selecting items in Power BI 5:00 - Using "Filter Panel" in Power BI Service 6:17 - Sorting visuals 6:52 - Focus"
YouTube Link 2025-09-09T13:00Z 835K followers, 24.6K engagements

"How to make an Excel Dashboard in [--] Easy Steps (Interactive + Free File) Dashboards are a highly sought after skill in business analytics. In this comprehensive and detailed video learn how to create a beautiful & functional business KPI (metric) dashboard using Microsoft Excel in less than [--] minutes. Prior skills needed: Basic familiarity with Excel (watch this tutorial: https://youtu.be/F7aPazuS8QY ) How to create a pivot table (watch this tutorial: https://youtu.be/aofsdpjvK7w ) How to create slicers (watch this tutorial: https://youtu.be/ZZ-UGMztoqo ) 📁 Sample Files: Please download the"
YouTube Link 2023-05-09T08:00Z 835K followers, 120.8K engagements

"Learn Data Modelling & Star Schema for Power BI in [--] minutes Data modeling semantic modeling star schema and how to make one in Power BI - all explained neatly and clearly in this video. In this video learn about data modeling in Power BI using a fictional chocolate company as an example. It explains the importance of setting up a star schema which involves organizing data into fact and dimension tables. I also cover the process of importing data into Power BI establishing relationships between tables and creating visualizations to analyze the data. 💡 What you will learn: =================="
YouTube Link 2024-10-15T12:15Z 834K followers, 225.5K engagements

"Learn VBA & Excel Macros in [--] minutes - with code samples 👨💻 VBA is a great entry-level programming language. If you have been looking for a solid no-frills and practical guide to learn VBA here it is. In this detailed video * Learn what VBA is and how to find it in Excel * How to use recorder to record and replay Macros (steps or actions) * How to write your own code using Visual Basic Editor (VBE) * Making a simple to-do list app in Excel * Creating a data extractor app in Excel * How to self-learn VBA with recorder & help Watch PART [--] here 2👉 ==================== I just released a part"
YouTube Link 2021-07-01T08:45Z 835K followers, 303.2K engagements

"WRAPROWS in Excel - a must have function Day [--] WRAP data in Excel quickly and efficiently with the new "WRAPROWS" and "WRAPCOLS" functions. chandoo chandoo.org Excel spreadsheets chandoo chandoo.org Excel spreadsheets"
YouTube Link 2026-01-24T15:00Z 835K followers, 20.9K engagements

"Complete Excel Tutorial for Data Analysis in [--] Hours (with FREE Files) Power Query Tables Formulas Pivots Charts Dashboard All in one video. Learn everything practice the concepts and improve your skills in just [--] hours. This is my holiday gift for you 🎁 📁 Download the files: https://chandoo.org/wp/complete-excel-course-free/ Topics covered in this video: Power Query Web scraping Data cleaning & automation Adding columns How to use Excel Conditional formatting Quick analysis of data Autosum Excel Tables Excel functions & formulas COUNTIFS SUMIFS AVERAGEIFS XLOOKUP FILTER INDEX CHOOSECOLS"
YouTube Link 2024-12-26T12:00Z 834K followers, 597.2K engagements

"Excel VBA Macros - Beginner to PRO Masterclass with Code Samples Learn how to develop VBA code to solve practical problems in this Masterclass. Code samples will be provided. 📁 Sample file (from the stream): https://files.chandoo.org/vba/live-demo.xlsm Timestamps: =========== 0:00 - Welcome message & hellos (skip this if you want) 12:00 - What is covered in this video (VBA intro practical example VBA vs. Python vs. Office Scripts) 16:20 - Introduction to VBA - What is it and when / where to use it 26:54 - Using "Macro Recorder" and creating your first VBA macro - simple example 33:50 -"
YouTube Link 2023-09-23T18:41Z 834K followers, 187.3K engagements

"Your first [--] minutes of Power BI - A no-nonsense getting started tutorial for beginners Power BI is the most popular and in-demand "DATA" skill these days. In this succinct and practical video let me show you how to get started and use Power BI to create an impressive business report all in [--] minutes Ready Set your clocks and GO 📗 Data file: Use this sample data file to practice the concepts covered in the video. https://chandoo.org/wp/wp-content/uploads/2022/09/sample-data-10mins.xlsx ✅ Completed workbook: Download this if you need to cross-check or refer"
YouTube Link 2022-09-20T08:00Z 834K followers, 1.7M engagements

"AWESOME Excel trick to combine data from files with DIFFERENT headers I want to combine data from different files but the format doesn't match. In this video let me show you two advanced Excel tricks to solve the problem. We are going to use Power Query and simple M code to take data in different files and combine it. This works great if you have files with columns out of order or different column headers. IN THIS VIDEO: =============== 0:00 - Problem 1: Columns not in same order 4:08 - Problem 2: Column names do not match 📂DOWNLOAD SAMPLE DATA: ========================= Sample data -"
YouTube Link 2023-02-14T07:00Z 834K followers, 132.9K engagements

"Advanced SQL for Data Analysis - [--] Powerful Examples in [--] minutes 🕗 Learn ADVANCED SQL with [--] PRACTICAL QUERIES in this video. 💥 Course page 👉 https://chandoo.org/dac You will be learning: How to use WHERE clause in SQL Work with AND / OR / LIKE / IN operators in SQL Getting DISTINCT values with SQL Grouping data with GROUP BY Using SQL JOINS Creating Common Table Expressions (CTE) Business Analysis and Decision Making with SQL For the purpose of this video we will be using the Sakila sample database of MySQL. I explain the process of installing MySQL and the sample databases in the"
YouTube Link 2024-08-06T08:00Z 835K followers, 127.6K engagements

"Excel Tutorial for Beginners: Learn it FAST 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 👉"
YouTube Link 2021-10-05T08:10Z 834K followers, 546.3K engagements

"How to calculate Compound Interest in Excel - Formula with Examples 💻 Compound interest is defined as "the interest on savings calculated on both the initial principal and the accumulated interest from previous periods." Classically known as "interest on interest" this is the most common type of interest used in everyday finance situations. To calculate compound interest in Excel on principal amount P at the rate of interest R for the number of years N and compounded T times per year we can use the formula = P*(1+R/T)(N*T) In this video understand how to calculate various kinds of compound"
YouTube Link 2024-04-02T07:00Z 834K followers, 69.2K engagements

"Learn SQL + Database Concepts in [--] Minutes First lesson of my FREE Data Analyst Course. 💥Important Links: ================ Get the materials and instructions here - https://chandoo.org/dac Install MySQL - https://dev.mysql.com/downloads/installer/ Sakila Database information - https://dev.mysql.com/doc/sakila/en/sakila-structure.html Advanced Excel Course - https://chandoo.org/wp/excel-school-program/ Power BI Course - https://chandoo.org/wp/power-bi-course/ 🤔What you will learn: ================== What is a database What is SQL How to install MySQL on your computer How to write SQL"
YouTube Link 2024-07-30T08:00Z 834K followers, 178.9K engagements

"8 strategies I used to learn & master Excel in a short time 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 [--] 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"
YouTube Link 2021-08-17T08:30Z 834K followers, 456.2K engagements

"Introducing Free Data Analyst Course - SQL / Excel / Power BI / Python Get the course here - https://chandoo.org/dac Announcing my first ever FREE Data Analyst Course right here on YouTube. First video - https://youtu.be/Iceaqdy7mEs #freedataanalystcourse #chandoo #excel #powerbi #Sql #python #fdac chandoo chandoo.org Excel spreadsheets free data analysis course data analyst course free chandoo chandoo.org Excel spreadsheets free data analysis course data analyst course free"
YouTube Link 2024-07-29T08:00Z 834K followers, 262.4K engagements

"Test Your SQL Skills With These Real Interview Questions Since my first job as a software engineer SQL has been a constant. In this video I share [--] sql interview questions that truly test your knowledge perfect for anyone aiming for a data analyst interview. You'll learn sql through practical examples and get essential interview tips for using sql for data analysts in real-world scenarios. 0:00 - Why SQL is important for interviews 1:45 - Chapter [--] - Question [--] & [--] 3:07 - Chapter [--] - Questions 3-5 8:17 - Chapter [--] - Questions 6-8 10:26 - Chapter [--] - Questions 9-10 11:29 - Chapter [--] - Final"
YouTube Link 2025-12-16T12:00Z 835K followers, 49.5K engagements

"Power Query - Beginner to PRO Masterclass in [--] minutes Learn Power Query in [--] minutes. Sample file: https://chandoo.org/dac In this video you will learn: Why Power Query is the best feature in Excel and Power BI Webscraping with Power Query Understanding the PQ Editor Screen Data cleaning with Power Query editor Fill down operation (dealing with nulls) Adding columns Filtering the data Find / replace values Trimming data Column Quality Indicators Adding column based on rules (conditional column) Fixing date format issues Splitting First and Last name Writing M code to create columns"
YouTube Link 2024-08-13T08:00Z 834K followers, 417.4K engagements

"Mind-blowing Excel Trick - MODE for TEXT VALUES MODE (most frequent item) for text values using this simple but elegant Excel formula trick. chandoo chandoo.org Excel spreadsheets chandoo chandoo.org Excel spreadsheets"
YouTube Link 2025-12-27T10:30Z 835K followers, 30.2K engagements

"Create your first Power BI APP in [--] minutes Power BI Apps are so easy and powerful. In this easy tutorial learn how to make your first app and publish it to your audience. Want to Learn Power BI for dashboard & report creation Join my full Power BI Course - https://chandoo.org/wp/power-bi-course/ Free tutorial on YouTube - https://youtu.be/al4OfLIOl2w #powerbi chandoo chandoo.org how to create a power bi app power bi app power bi app audience power bi app audience permissions chandoo chandoo.org how to create a power bi app power bi app power bi app audience power bi app audience permissions"
YouTube Link 2025-10-01T12:00Z 835K followers, 19.8K engagements

"I made offline ChatGPT using just Excel Formulas My boss wanted to add "AI" to our data. So I made an offline GPT to analyse our budget data and present insights. In this video let me share the Excel GPT and how I built it. 0:00 - Why I made offline ChatGPT with Excel 1:45 - Chapter [--] - Demo of my offline chatgpt in Excel 3:07 - Chapter [--] - How I made the offline ChatGPT with Excel formulas 8:17 - Chapter [--] - Closer look at the Excel formula 10:26 - Chapter [--] - The end result 11:29 - Chapter [--] - But what if you can't write Excel formulas 🤷♂🤷♀ 📂 Demo file:"
YouTube Link 2025-12-04T12:00Z 835K followers, 12.5K engagements

"Power Query Tutorial - What is it how to use it & [--] complete examples + Free download Power Query (Get & Transform data in Excel) is a true game changer 💥. It can simplify and automate various data activities. In this in-depth video tutorial learn all about this powerful time-saving technology. You will learn: * What is Power Query and how to launch it from Excel or Power BI * How to connect and load data from any type of sources - excel files CSVs text files web pages PDF folders etc. * How to perform common data cleansing activities with Power Query * Adding columns using rules *"
YouTube Link 2020-08-26T08:50Z 834K followers, 752.9K engagements

"How to use SQL with Power BI 💡 End-to-end Demo with Sample Files Do you want to use SQL with Power BI to take your data analysis to next level Join me on this free & live masterclass to learn how to set up SQL queries as data source how to parameterize them in your Power BI report. We will be using the FREE Awesome Chocolates Dataset for this live stream. Download the dataset .SQL file from below link. https://chandoo.org/wp/learn-sql-for-data-analysis/ In this video: ============= 0:00 - Introduction and hellos 5:04 - Agenda slides 8:37 - Where to download the sample data (SQL files) 16:10"
YouTube Link 2023-02-24T18:00Z 834K followers, 319.9K engagements

"Excel SCAN Function is Shockingly Powerful Step-by-Step Every heard of SCAN function in Excel Today let me show you why you need this function and how it changes the way you solve your data problems. I think SCAN is Magic ✨ You are going learn: What is SCAN function in Excel SCAN syntax and application How to use SCAN to calculate running total quickly Using SCAN to get Maximum values SCAN with LAMBDA Advanced SCAN usage when your data is dynamic WHAT IS SCAN FUNCTION Scan function in Excel let's us run an operation on a range and returns all the intermediate results. For example you can use"
YouTube Link 2024-03-19T07:00Z 835K followers, 321.2K engagements

"KNOW the difference between Data Base // Data Warehouse // Data Lake (Easy Explanation👌) Confusing your data lakes with actual lakes Not sure how much land you need for the data warehouse You have come to the right place my friend. In this concept buster video let me explain what Data base data warehouse and data lake are and how they connect / differ In this video 👉 ============== 0:00 - Intro & Databases 1:38 - Data warehouse 2:28 - Why can't we use DB for reporting 3:09 - ETL how data goes from DB to DWH 4:05 - What is a Data Lake 5:46 - Examples of DB DWH & DL 6:43 - How to access data"
YouTube Link 2021-10-26T12:45Z 834K followers, 574K engagements

"Dynamic Moving Average with Excel OFFSET Want to calculate Moving Average on your data but the window is dynamic You can use OFFSET function to do this easily. In this video learn how to use OFFSET to setup a dynamic moving average window and calculate the moving average for your data. chandoo chandoo.org Excel spreadsheets chandoo chandoo.org Excel spreadsheets"
YouTube Link 2025-11-03T13:01Z 835K followers, 18.9K engagements

"Learn Excel Pivot Tables in [--] Minutes - A complete beginner's tutorial Just started your data analyst career Pivot Tables make your life easy. In this short but PACKED video let me show you how to make [--] everyday reports using Pivot Tables in Excel. Be sure to download sample dataset to practice the concepts. Link - https://chandoo.org/wp/wp-content/uploads/2021/05/awesome-sales-analysis-final.xlsx In this video: ========== 0:00 - Introduction 1:24 - Making your first pivot table 2:33 - Total Sales by Sales Person - Report [--] 3:40 - Sales by Person & Geography - Report [--] 4:34 - Sales by"
YouTube Link 2021-05-17T08:30Z 835K followers, 434.4K engagements

"Build Your First Power BI Report in One Hour (free masterclass + sample files 📂) Build a real Power BI dashboard step-by-step from raw data to insights. Learn how to build a complete Power BI dashboard from scratch using a realistic hospital analytics dataset. In this live masterclass we go step-by-step from understanding raw data to creating meaningful business insights using data modeling DAX measures and interactive visuals in Power BI. Youll learn how experienced analysts actually work including how to design analysis goals build measures understand evaluation context and create"
YouTube Link 2026-02-07T01:22Z 835K followers, 15.1K engagements

"How to create an elegant fun & useful tracker with Excel #ExcelTracker #CreateTrackerSpreadsheet Do you want to create a cool useful and simple tracker with Excel You can use Excel Tables simple data validation rules and conditional formatting to set up a tracker to monitor a list of items progress of a project or a list of to-dos. In this video I will explain how to create such a tracker spreadsheet. Download the sample tracker file: =========================== https://chandoo.org/wp/create-an-excel-tracker/ chandoo chandoo.org Excel spreadsheets how to create a tracker with excel make a"
YouTube Link 2020-03-17T06:15Z 835K followers, 480.6K engagements

"Excel LOOKUP function is CRAZY 🤯 (fastest way to get tenure bands) DAY39 - Using Excel's lookup function you can quickly and efficiently get the employee tenure bands. chandoo chandoo.org Excel spreadsheets chandoo chandoo.org Excel spreadsheets"
YouTube Link 2026-01-15T12:15Z 835K followers, 24.3K engagements

"Make an Incredible Finance KPI Dashboard with Power BI in [--] minutes Make an incredible Power BI Dashboard to visualize your finance KPI data in just [--] minutes. In this video learn how to take raw business data and turn it into useful insights by following these [--] steps: 1) Data Preparation - Connecting and transforming data using Power Query in Power BI 2) Data Modelling - Setting up a semantic model in Power BI with table relationships. 3) Calculations - Performing necessary number crunching using the DAX in Power Pivot 4) Dashboard Visuals & Interactions - Creating and customizing various"
YouTube Link 2024-04-09T08:00Z 834K followers, 209.2K engagements

"Excel Trick to Count UNIQUE Values in Seconds COUNTIFS=MAGIC 🌟 #excel #50fx50days #excelformula chandoo chandoo.org Excel spreadsheets chandoo chandoo.org Excel spreadsheets"
YouTube Link 2025-10-20T09:30Z 835K followers, 111.1K engagements

"AWESOME Excel trick to combine data from multiple sheets Reconcile & consolidate data from multiple worksheets automatically using this amazingly simple Excel trick. You can set up a repeatable process so that every month Excel automatically combines the data for you. In this video 👉 ============== 0:00 - Introduction to the combine sheets problem 1:01 - New file to consolidate the data 2:05 - Updating "power query" steps 3:07 - Cleaning up the combined data 5:35 - Loading data to Excel 5:58 - Testing with new data 6:48 - More Power Query Sample files 📗📗👇 ================ Download the"
YouTube Link 2021-11-23T08:00Z 834K followers, 1.3M engagements

"Excel's INDEX + MATCH - How to use it // [--] real-world examples & tips Get my LOOKUPS for Data Analysis course - https://chandoo.org/wp/lookups-for-data-analysis/ Excel's INDEX+MATCH is a powerful formula alternative to the traditional VLOOKUP. In this DETAILED video learn all about INDEX MATCH combination how to set it up how to use it with plenty of examples. Refer to the sample file (link below) to practice the formula. In this video: ============= 0:00 - Introduction 0:46 - INDEX MATCH - what is it and how to write the formula 2:55 - What to do when there is an error 4:03 - Combine two"
YouTube Link 2021-08-05T08:30Z 834K followers, 305.9K engagements

"The Ultimate Excel Dashboard: Visualize Data Like a Pro 💥 $50 OFF My Dashboards Course (code: SAVE50) 👉 https://chandoo.org/wp/excel-school-program/ Become an Excel Dashboard PRO with this hands-on tutorial. Learn how to think like a business analyst create KPIs set up calculations use pivot tables slicers and build interactive charts + maps to create this dynamic business dashboard in just [--] minutes. This is the perfect end to end Excel project for a data analyst. What you will learn: 1) How to set up the data for your dashboard in Excel 2) What KPIs and business questions to address with"
YouTube Link 2025-11-05T12:01Z 835K followers, 77.7K engagements

"Learn SQL for Data Analysis in one hour (with sample dataset + [--] queries) SQL is one of the most important skills to have for data people. In this comprehensive video learn how to use SQL to perform common data analysis tasks. You will learn: How to use SELECT statement to answer business questions Working with WHERE clause Using AND OR NOT and combining them to create complex queries. Sorting query results using ORDER BY Combining data from two or more tables using JOINS Creating reports with GROUP BY More than [--] example queries tips and ideas 🚨 PRE-REQUISITES: You need any SQL console (I"
YouTube Link 2022-08-23T08:00Z 834K followers, 1.5M engagements

"Learn 80% of DAX in an Hour (with FREE sample file) Want to learn DAX but don't have the time This is the video for you. In this one-hour masterclass learn the 80% essential DAX with practical examples. Understand and master concepts like: How to create measures 🤔 Measure vs. Column ⚙ Measure reusability ♻ Evaluation Context 💻 Basic DAX functions - SUM COUNTROWS AVERAGE DIVIDE 🧮 Conditional DAX functions - IF 🌿 Understanding and using CALCULATE function 📗 Multiple filters with CALCULATE 🥝 How to get good with DAX using ACMBU technique 💡 📁 Download practice workbooks:"
YouTube Link 2024-10-22T12:00Z 835K followers, 390.7K engagements

"Learn Excel COPILOT in just [--] minutes and Work Smarter 🤯 Excel has a new superpower - CoPilot. In this hands-on advanced tutorial learn how to use CoPilot for Excel to get most of out it and work faster. Learn Excel and Work Faster with my Excel School Program (now with AI module) https://chandoo.org/wp/excel-school-program Sample file - https://chandoo-my.sharepoint.com/:x:/g/personal/me_chandoo_onmicrosoft_com/EfJiuUxeO4FDpb5M5yFsKKwBKdXY5yiQkMTGzHfsMWFBeQe=DOjjt5 Video topics: 0:00 - Excel's new Superpower - Copilot 0:55 - What is CoPilot and how to Activate it in Excel 2:16 -"
YouTube Link 2025-10-07T12:01Z 835K followers, 20.3K engagements

"Learn how to use PANDAS in Python in [--] minutes - with [--] real examples Pandas is the most useful data analysis package in Python. You can use it to clean-up transform and analyze data. Recently I had a chance to use Pandas for some work. So in this video let me share a quick but fairly in-depth introduction to Pandas with a real-world case study. 📃❓✅SAMPLE FILES & INSTRUCTIONS: ================================== i n s t a l l a t i o n ⚒ Download and install Pandas & other data analysis packages: - from Anaconda https://www.anaconda.com/ - from Pandas website https://pandas.pydata.org/ -"
YouTube Link 2022-09-13T08:00Z 834K followers, 227.4K engagements

"You don't need work email to use Power BI - Easy Fix 😎 Power BI is amazing until it isn't. It asks for "work email" to use the online service part. In this video let me share an incredibly easy fix to this annoying limitation. Step 1: Sign up for a free trial of another Microsoft product like Dynamics [---] (https://www.microsoft.com/en-us/dynamics-365/free-trial) Step 2: Set up your own free sub-domain on the onmicrosoft.com Step 3: Use that to access Power BI service and publish / share your work with others. Step 4: Join my Power BI course and master the technology -"
YouTube Link 2025-03-18T12:01Z 834K followers, 150K engagements

"How to Split Names in Excel Super Fast First we join then we split chandoo chandoo.org Excel spreadsheets chandoo chandoo.org Excel spreadsheets"
YouTube Link 2025-10-21T09:30Z 835K followers, 39.1K engagements

"Calculate Employee Tenure Easily with this Formula Trick💡 Easily calculate employee tenure and set up buckets with this formula pattern in Excel Day [--] chandoo chandoo.org Excel spreadsheets chandoo chandoo.org Excel spreadsheets"
YouTube Link 2026-01-02T11:30Z 835K followers, 17.9K engagements

"Learn MS Access and Build your First Database Today Microsoft Access is the easiest and best starting database for many businesses and day to day applications. In this comprehensive video learn how to use MS Access and create your very first database in under [--] minutes 📕 Concepts covered in this video What is MS Access Database theory Creating tables and adding data in Access Table design mode vs. data sheet mode Linking one table with another with relationships Keys (primary vs. foreign) Data validation in Access Creating data entry forms in Access Linking one form to another (nested"
YouTube Link 2025-11-19T12:01Z 835K followers, 14.7K engagements

"Make a Gantt Chart in Excel with Just One Formula Gantt Charts are a must in Project Management. See how to quickly and efficiently create a gantt chart with just one simple Excel formula. chandoo chandoo.org Excel spreadsheets chandoo chandoo.org Excel spreadsheets"
YouTube Link 2025-11-14T12:01Z 835K followers, 40.2K engagements

"Combine [--] Tables Quickly with this AMAZING Excel Formula Day 38: Let's combine two tables of data even when the headers don't match. Amazing use of STACKING and LOOKUP functions chandoo chandoo.org Excel spreadsheets chandoo chandoo.org Excel spreadsheets"
YouTube Link 2026-01-07T11:31Z 835K followers, 43.7K engagements

"Data Cleaning in Excel - [--] Tricks (Beginner to PRO) Dirty data on your mind Just spray the amazing "data cleaner" on it. In this video learn how you can use [--] Excel features to clean data with [--] examples. You will learn about: 1) Flash Fill 2) Text to Columns 3) Remove Duplicates 4) Formulas 5) Power Query Video Topics 👇 =============== 0:00 - Data Clean-up - the challenge 1:17 - Extracting the first name (Flash Fill) 2:10 - Get the city from location (Flash Fill) 3:12 - Get the city from location (Text to Columns) 4:20 - Splitting cost centre & ID number (Text to Columns) 5:35 - Duplicate"
YouTube Link 2022-04-12T08:00Z 834K followers, 471.2K engagements

"Learn Tableau in [--] minutes and create your first report (FREE Sample Files) Do you want to learn Tableau In this video learn all the basics you need to start using Tableau straightaway. We are going to understand how to load some data analyse it create some charts and prepare a dashboard with Tableau. DOWNLOAD TABLEAU PUBLIC SOFTWARE: ===================================== Get the FREE Tableau public software from here - https://www.tableau.com/products/public/download 📁Sample Data to Pratice: ====================== The sample data I've used in the video is here 👉"
YouTube Link 2023-03-14T07:00Z 834K followers, 815.3K engagements

"Beginner to PRO Data Analysis with Power BI - Full Length Course (with sample files) You asked for it. Here is a complete and in-depth course on how to use Power BI for data analysis. We are going to cover powerful & practical concepts like ✅ How to load and clean-up data with Power BI ✅ How to build a data model in Power BI ✅ Using DAX & Power Pivot to build measures and calculations ✅ Creating and changing visuals ✅ Answering business questions with Power BI ✅ Understanding trends & creating forecast in Power BI ✅ Customizing visuals & interaction effects ✅ Creating a comprehensive sales"
YouTube Link 2022-02-15T08:00Z 834K followers, 1.2M engagements

"Beginner to Pro FREE Excel Data Analysis Course 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 [--] 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"
YouTube Link 2021-08-12T08:30Z 834K followers, 2.4M engagements

"What is ETL with a clear example - Data Engineering Concepts Do you want to know what ETL (Extract Transform & Load) process is How it looks and what really happens in it In this video understand the [--] key things when it comes to ETL: [--] What is ETL [--] ETL vs. ELT [--] Real-world example of ETL [--] ETL tools & platforms [--] A demo of ETL on my computer IN THIS VIDEO 👇 ================ 0:00 - Introduction to ETL 0:18 - What is ETL 2:14 - ETL vs. ELT - the main difference 2:50 - A real-world example of ETL 6:17 - Examples of ETL operations 7:27 - What tools are used for ETL 9:22 - ETL Demo (with SQL)"
YouTube Link 2023-04-04T08:00Z 834K followers, 224.5K engagements

"Create a HR Dashboard with Tableau - Full Tutorial Do you want to know how to analyze data and create beautiful dashboards with Tableau This video is for you. Learn how to go beyond the basics of Tableau and use concepts like: 👉 Calculated measures & columns 👉 Customizing visuals 👉 Creating histograms & box plots 👉 Working with "Marks" 👉 Field formatting 👉 Filters Actions and using "Context" 👉 Cumulative totals 👉 Setting up a dashboard We are going to the sample HR data (download it here: https://chandoo.org/wp/wp-content/uploads/2023/09/hr-data-analysis.xlsx) and answer these 10"
YouTube Link 2023-09-12T08:00Z 834K followers, 76.2K engagements

"SQL Joins - Beginner to PRO Masterclass with [--] Examples Left right inner outer anti no matter what you call them Joins are an important part of the SQL for data analysis. In this comprehensive video learn how to create your first join and more with easy clear and relevant explanation of the concepts. 💻 Get the data: ============== Visit https://chandoo.org/wp/learn-sql-for-data-analysis/ to get the dataset. Use the instructions on that page to set up the data in SQL Server or MySQL. Topics covered in this video: ======================= Why we need joins in the first place Joins explained"
YouTube Link 2024-03-12T14:00Z 834K followers, 152.8K engagements

"SQL Basics for people with no prior knowledge 🤷♀🤷♂ SQL If you work as a data engineer scientist or analyst then learning SQL is going to change how you view and handle data. SQL stands for Structured Query Language. In this easy to understand tutorial let me give you all the basics of SQL. Right from SELECT to WHERE clause to Multiple conditions (AND / OR / NOT) to ORDER and GROUP BY. WANT MORE Watch my detailed SQL Video with more than [--] example queries full sample dataset and practical tips. 👉 https://youtu.be/l8DCPaHc5TQ IN THIS VIDEO 👇 ================= 0:00 - What is SQL 0:58 - SQL"
YouTube Link 2022-08-09T08:00Z 834K followers, 267.9K engagements

"5 key skills you need to become a GREAT Data Analyst in [----] 🚀 Do you want to be a GREAT Data Analyst In this video I share what worked & what mistakes I made as a data analyst in my fifteen years of career in analytics. I started as a business analyst with Tata group in India and worked with many Fortune [---] clients all over the world in last [--] years in roles like DATA ANALYST REPORTING ANALYST INFORMATION ANALYST and DATA SCIENTIST. In my recent role as a Senior HR Information Analyst I worked with New Zealand Treasury. 📄Topics in this video (click to jump around):"
YouTube Link 2021-06-16T08:45Z 744K followers, 466.8K engagements

"Python for Data Analysis: The Beginners Ultimate Guide 🚀 Python is essential if you want to work with Data. In this video learn how to set up and use Python on your computer with your first examples. Key skills you will gain are: ✔ How to install Visual Studio Code & Python ✔ How to set up virtual environment for Python in VS Code ✔ How to set up and use Jupyter Notebooks with VS Code ✔ Writing and running your first python code ✔ Using "notebook" style programming to learn Python ✔ Working with Python Lists & slicing ✔ Control flow with IF conditions in Python ✔ Building a simple grade"
YouTube Link 2024-11-26T12:00Z 705K followers, 31.4K engagements

"Create One Pivot Table from Many Sheets AWESOME Excel Trick Ever wanted to make a pivot table but your data is scattered across multiple worksheets Like Jan Feb Mar. In this video learn an AMAZING Excel trick to solve the problem easily. Note: This works in Excel [----] or above (or with Power Query add-in in Excel 2013) Step by step instructions and sample file 👉https://chandoo.org/wp/how-to-make-a-pivot-table-when-you-have-data-in-multiple-sheets-tutorial/ Video Topics: ============== 0:00 - Many sheets One Pivot - the problem 0:42 - Combining the data (using Power Query) 2:08 - Data"
YouTube Link 2023-09-26T07:00Z 668K followers, 74.7K engagements

"STOP using INDEX MATCH in Excel use this instead Excel's INDEX+MATCH formula is a staple for many. But do you know that Excel now has a simple alternative to this powerful formula combination Yes I haven't used INDEX MATCH function in over a year and here is why. 👉 XLOOKUP 👈 The magic new function can do what INDEX+MATCH does with a simpler syntax and offers many extra features. In this video I will show you how you can replace your messy INDEX+MATCH formulas with simpler XLOOKUP variation. Timestamps: =========== 0:00 - Introduction 0:09 - XLOOKUP overview & demo 1:10 - INDEX MATCH"
YouTube Link 2021-03-17T07:45Z 791K followers, 96.7K engagements

"Try this SMART formula to calculate YTD in Excel (works for Financial Years too) Easy quick and smart YTD calculation with Excel formulas. Learn how to total Year to Date values for either calendar year (Jan to Dec) or financial year (any starting point) with simple Excel formulas. The video also has a special bonus trick on how to use OFFSET formula when you have tabular data. In the video 👉 ============== 0:00 - Introduction 0:48 - YTD formula for cell range values (for year starting in January) 1:25 - YTD formula for April / July / September start 2:01 - YTD formula for tabular data 3:13"
YouTube Link 2021-11-18T08:00Z 805K followers, 116K engagements

"Excel Solver - Introduction & Demo What is Excel Solver and How to use it A simple introduction video form chandoo.org. For more info visit http://chandoo.org/wp/2010/10/15/excel-solver-introduction/"
YouTube Link 2010-10-15T02:10Z 794K followers, 115K engagements

"How-to Calculate Project Critical Path using Excel - Step by Step Tutorial Do you know that we can automatically calculate the critical path of a project using Excel formulas In this video let me explain the theory and calculation logic for figuring out the CRITICAL PATH using Excel. Bring your hardhats it's going to be MINDBLOWINGLY AWESOME For a free Critical Path template & more explanation visit 👇 https://chandoo.org/wp/critical-path-excel-template/ In this video ============ 0:00 - What is Critical Path and why it is relevant in Project Management 1:00 - Demo of Critical Path calculator"
YouTube Link 2023-10-03T07:00Z 668K followers, 28.5K engagements

"Spooky spider web chart in Excel - Halloween Fun It is Halloween time so let's be goofy and learn how to create a spider web chart using Excel. What more you can decorate your work reports / spreadsheets with the cobweb. For example workbook and more visit http://chandoo.org/wp/2016/10/28/spider-web-chart/ ================================================= Support to Chandoo.org on Patreon - http://patreon.com/chandoo"
YouTube Link 2016-10-28T06:30Z 747K followers, [----] engagements

"Awesome Trick to Get Dependent Drop Downs in Excel (works for multiple rows too) Need dependent drop downs or cascading drop-downs in Excel Use this simple but elegant approach. This technique relies on the powerful & new XLOOKUP function. Learn more: Tutorial with sample workbook - https://chandoo.org/wp/how-to-create-dependent-drop-downs-in-excel-dynamic-multiple/ Full Excel Course - https://chandoo.org/wp/excel-school-program/"
YouTube Link 2024-02-13T07:00Z 679K followers, 82.6K engagements

"AWESOME Excel trick to scrape data from web automatically 💥Check out https://brightdata.grsm.io/chandoo to sign up for BrightData and to automate your data collection. Thank you BrightData for sponsoring this video 😍 Ever wanted to gather some data from web and use it for analysis You can use Excel's Power Query to setup and automate web scraping easily. In this tutorial let's look at how we can combine US state population data with Chocolate Sales data in Excel. 📗 Sample File: ============= Practice the steps by using the Wikipedia link:"
YouTube Link 2023-10-23T18:21Z 536K followers, 96.5K engagements

"Top [--] Advanced Excel Tips to make you awesome ⚡💡 #ExcelTips Time to celebrate the beauty and versatility of Excel with [--] of my favourite Excel tips for advanced uses. You will be amazed and satisfied for sure. Watch the whole thing & share the video with a friend. Use below timestamps if you need to see a specific tip. Video timestamps ================== 0:00 - Introduction 0:55 - New FILTER function * 1:51 - CHAR(10) Trick 2:46 - CTRL SHIFT [--] - quick currency format 3:06 - Using SUBTOTAL function 3:34 - Slicers on Table 4:25 - Mini charts with REPT() trick 5:19 - Finding 2nd largest"
YouTube Link 2021-06-29T08:45Z 802K followers, 377.7K engagements

"What We don't need to learn DAX anymore (New Power BI Feature) Power BI has an exciting new feature that can "generate the DAX" for you. In this video let me review the "Quick measure suggestions" feature. Using this you can ask Power BI what you want to calculate in "natural language" and it will generate the necessary DAX code for you. LEARN MORE DAX 👩🏼💻 ================== If you want to learn how to write DAX and analyze data easily check out below videos. Beginner to PRO DAX video - https://youtu.be/PQ5lALdFHCU How to set up Star Schema & Data Model in Power BI -"
YouTube Link 2023-01-17T07:00Z 739K followers, 220.2K engagements

"Become an Excel PRO with this complete Dashboard Project 📈 👩💻 Checkout my advanced Excel course at https://chandoo.org/wp/excel-school-program/ 📁 Download files 👉 https://chandoo.org/wp/free-call-centre-dashboard/ In our final lesson of Excel module we will be building a call centre performance dashboard as show-cased above. In this portfolio project you will learn: Designing the dashboard color theme and fonts How to use Data model feature of Excel to connect datasets Creating KPIs and measures using Power Pivot and DAX Using Pivot tables to create all the dashboard calculations Making"
YouTube Link 2024-09-17T14:00Z 749K followers, 60.5K engagements

"Hide Excel cell values with this cool trick 👻😜 #Shorts Ever need to make things disappear Use this simple trick. [--]. For cell values - just use the custom format code ;;; [--]. For charts slicers pictures and other objects - use selection pane and hide / show by clicking on the eye icon 👁 SUBSCRIBE for more awesome Excel tips Watch my other short [--] minute tips here - https://www.youtube.com/watchv=Ji6knw7HpaU&list=PLmejDGrsgFyDsuAgEwuM6CE-QfnudBkFc More on how to use SELECTION PANE - https://youtu.be/s1tpfwKAw1M"
YouTube Link 2021-05-24T08:45Z 805K followers, 47K engagements

"DON'T tell my boss but ChatGPT made this Excel dashboard 🤫 ChatGPT can change the way you look at data and analyze it. Recently I asked ChatGPT to help me build an Excel dashboard and the result was AMAZING. In this video I explain the process and show case the results. 💬 See the ChatGPT prompts & conversation here 👇 https://chat.openai.com/share/e2e95818-0813-4330-9586-7c5d428922f3 📂Sample Data Here is the sample data I used for this example. https://chandoo.org/wp/wp-content/uploads/2023/07/chatgpt-made-this-sample-data.xlsx In this video ============= 0:00 - ChatGPT + Excel intro 0:30"
YouTube Link 2023-07-18T08:00Z 669K followers, 423.2K engagements

"How to create Tooltip Pages in Power BI - Easy Tutorial Take your ordinary looking reports and make them extraordinary with a simple trick in Power BI. 💥USE TOOLTIPS💥 In this quick and powerful video learn how to create and customize tooltips in Power BI. For a sample file and more explanation visit https://chandoo.org/wp/how-to-create-tooltips-in-power-bi/ 🚨 WANT more POWER BI Check out below videos or the Power BI Playlist. Videos: Getting started with Power BI (45 mins 150kviews) - https://youtu.be/uwe8C7K8fXY Learn DAX with [--] practical examples (53 mins RECENT video) -"
YouTube Link 2022-08-16T08:00Z 801K followers, 148K engagements

"Master POWER BI's ALL() Functions in Just [--] Minutes Learn the when and how to use ALL function in Power BI. We are also going to cover the difference between ALL ALLSELECTED REMOVEFILTERS ALLEXCEPT and SELECTEDVALUE functions with real-world examples of when and how to use them for data analysis. What we are going to learn: 1) Explanation of the data model 2) How and why we use ALL funciton 3) Using ALL(table) vs. ALL(tablecolumn) with a real-world example 4) DAX Query View to debug and check measures 5) Understanding the "evaluation" context and why sometimes doesn't work 6) ALL vs."
YouTube Link 2025-06-04T13:01Z 765K followers, [----] engagements

"FREE Adv. Masterclass on Power BI - Create a Sales Analytics Dashboard (with files 📁) The best way to learn Power BI is by doing an end-to-end portfolio project. In this video we are going to do just that. Create a super awesome sales analytics dashboard and publish your work to GitHub. Right from data modelling to creating interactive dashboard everything is clearly and neatly explained. 👩💻 What you will learn: =================== 1) How to design a dashboard in Power BI 2) Data modelling with Power BI and star schema development 3) Identifying measures and KPIs for sales analytics 4)"
YouTube Link 2024-07-16T08:00Z 751K followers, 136.8K engagements

"How to calculate Mortage with Extra Payments in Excel We recently took a mortgage on our house. As I am self-employed there is a lot of variability in my income. So I wanted to see the impact of occasional top-up payments. Most online calculators couldn't tell me how it would impact my loan term. So I went ahead and built an Excel calculator to give me the answer. In this video let me tell you the story of that and walk you thru the process of building such a calculator yourself. Download the calculator 💻👇 ========================= Don't care how this is built Just want the calculator Get"
YouTube Link 2022-09-06T08:00Z 800K followers, 40.1K engagements

"Power BI Real Time Project (LIVE Masterclass) Join me for a real-time Power BI project and learn how to build a hotel reservation dashboard using Power Query Power Pivot (DAX) and Power BI. important links 📁Sample blank file - https://files.chandoo.org/pbix/blank-report-v2.pbix 💡 Join Power BI Course - https://www.e-junkie.com/i/xbbt 💻 Know more - https://chandoo.org/wp/power-bi-course/ 📅🕐 Livestream timings: ====================== New York - 8PM Friday 8th November Chicago - 7PM Friday 8th November Seattle - 5PM Friday 8th November London - 1AM Saturday 9th November Dubai - 5AM Saturday"
YouTube Link 2024-11-09T03:32Z 670K followers, 12.1K engagements

"If you are new to Power BI you need to learn these [--] charts Impress everyone with your visual skills by mastering these top [--] Power BI charts 📈 Column chart 📊 Line chart 📈 Donut charts 🍩 KPI Cards 💳 Small Multiples 🔡 Matrix 📰 📁 Blank Power BI file - https://files.chandoo.org/pbix/powerbi-visuals-part1-blank.pbix 🖼 Background Image - https://files.chandoo.org/pbix/img/Slide2.PNG 💡 Completed workbook + more in my Power BI course - https://chandoo.org/wp/power-bi-course/ 🕐 Video Timestamps: =================== 0:00 - Introduction and what you are going to learn 1:03 - How to set"
YouTube Link 2024-11-19T12:01Z 674K followers, [----] engagements

"These are the most important Excel Text Functions you NEED to know Excel Text Functions are important for cleaning up text data extracting portions from cells or presenting combined results. In this concise video learn the most important text functions and how to use them with [--] practical everyday examples. The functions you will learn are: LEFT RIGHT MID LEN FIND TEXTJOIN The examples are: Gender code (M for Male F for Female) Extracting First name from a name Getting Last name from a name Converting a name to "Last name first name" format All male staff names comma separated Word count"
YouTube Link 2021-06-14T08:30Z 767K followers, 36.6K engagements

"How to make pivot tables from large datasets - [--] Techniques Let's say you are staring at a large dataset with multiple columns. You need to make a pivot report from it for a client or manager. How would you go about it Here are five ideas to make pivot tables from large datasets. SAMPLE WORKBOOK ================== Please visit https://chandoo.org/wp/pivot-tables-from-large-data-sets/ to download sample workbook with all these examples"
YouTube Link 2019-08-02T06:41Z 781K followers, 51.2K engagements

"How to make an AWESOME Waterfall Chart in Excel (with [--] adv. tricks) 💥 Free Waterfall Chart Template 👉 https://chandoo.org/wp/betterfall Zebra BI for Office is the latest addition to the Actionable Reporting toolkit for data professionals and enthusiasts who want to take their reports to the next level. With the combination of two powerful add-ins Tables and Charts Zebra BI gives you an immediate understanding of your business performance. Download free template for income statement from https://chandoo.org/wp/betterfall Do you want to create WATERFALL charts in Excel They are great for"
YouTube Link 2022-12-13T07:00Z 665K followers, 31.4K engagements

"10 SURPRISING Copy Paste Secrets for Excel PROs We can't live with CTRL+C (Copy) CTRL+V (Paste). So how well do you know this everyday feature. Here are [--] powerful ways Copy Paste can improve your productivity in Excel. You will be surprised. 👉For more on Excel Copy Paste functionality check this page ================================================== https://chandoo.org/wp/17-excel-paste-special-tricks/ Time stamps: ============== 0:00 - Introduction 00:25 - [--] - Copy paste data to charts 00:47 - [--] - Using CTRL to make copies 01:25 - [--] - Jiggle Copy 02:04 - [--] - Transposing formulas 03:26"
YouTube Link 2021-04-21T09:00Z 771K followers, 259.3K engagements

"ONLY Excel pros use this INDEX MATCH trick 💡 This INDEX MATCH trick that will surely blow your socks off. And then it blows your pants off too with an even better XLOOKUP variation. So yeah bring some spare clothing and watch 😎 📂 Download the sample file: https://chandoo.org/wp/wp-content/uploads/2023/05/index-match-ultimate-trick.xlsx 💡 Learn more: on XLOOKUP (500k views) - https://youtu.be/DDlZXXEI1bU on INDEX MATCH (100k views) - https://youtu.be/kly0uPIM4IU on VLOOKUP (full intro + examples) - https://youtu.be/8rtvDQVQaA0 VLOOKUP or INDEX MATCH (interview questions) -"
YouTube Link 2023-05-16T08:00Z 757K followers, 44.1K engagements

"10x your productivity with these AI tools in Excel 😲 There is a lot of hype around ChatGPT but do you know that Excel has really powerful AI built-into it YES In this video let me share of [--] of my favourite AI features (plus a bonus one) in Excel that really save time & make you more productive Learn all about the AI features in Excel like Flash Fill Column from examples (Power Query) AI automatic analysis of data Recommendations AI formula writer & Automatic forecast with real world examples. 0:00 - Forget ChatGPT 0:34 - Feature [--] - Flash Fill 🦸♂ 2:19 - Feature [--] - Let Excel write the"
YouTube Link 2023-02-28T07:00Z 805K followers, 636K engagements

"Visualizing half a million complaints - Part [--] - Interactive Treemap In this three part series we are going to analyze and visualize half a million rows of consumer complaint data. Check out http://chandoo.org/wp/2016/02/16/analyzing-consumer-complaints-1/ for more information about this"
YouTube Link 2016-02-16T06:43Z 789K followers, [----] engagements

"Impressive Power Query Trick to See Past Data Use Power Query self-joins to solve tricky data challenges. In this example I share how I am using self-joins to get the "prior weekly rental" and "prior move out date" from rental agreement data with Power Query. Sample data file: https://chandoo.org/wp/wp-content/uploads/2025/08/self-join-example.xlsx Need Power BI Skills for yourself Join my Power BI course - https://chandoo.org/wp/power-bi-course/ A data engineer got divorced. When friends ask her what happened she replied "I left the join because it wasn't the right join." 😆 #powerbi"
YouTube Link 2025-08-05T13:02Z 787K followers, [----] engagements

"How to find last non-blank value - Excel lookup challenge Here is a tricky Excel lookup problem. You want to find the last non-blank value for a lookup value. Each value you want to lookup has multiple items in adjacent columns. You need to get the very last item as answer. Watch the video to learn [--] possible solutions to this problem. For more on this visit https://chandoo.org/wp/lookup-last-non-blank-value/ You can download sample workbook there. #lookupLastNonBlankValue #vlookup #xlookup"
YouTube Link 2020-06-16T07:45Z 763K followers, 13.9K engagements

"Using WRAPROWS to Reshape Data (NEW Function 🤯) #excel Manually reshaping data with copy paste No more Use WRAPROWS to do the job like a BOSS 😎 Thank me later. #excel #datacleaning"
YouTube Link 2025-05-30T13:01Z 763K followers, [----] engagements

"The ONLY [--] Excel keyboard shortcuts you need to master Want to learn some useful Excel shortcuts but not sure which ones Here is my choice of top [--] shortcuts to learn. Master these and your productivity will soar. They are: 1) ctrl t - Create tables 2) ctrl d - Fill down 3) ctrl shift L - Apply / remove filters 4) ctrl arrow keys - Navigation around worksheet 5) ctrl [--] - Format anything 6) ctrl alt v - Paste Special 7) f2 - Edit a cell 8) f4 - Change ref. style / repeat last action 9) f9 - Recalculate / evaluate portions of the formula 10) ALT key - access everything on the ribbon For a"
YouTube Link 2020-05-19T08:58Z 787K followers, 235.1K engagements

"How I Use AI To Work Smarter Every Day as a "Data Analyst" 💥 Download Chandoo's Prompting Cheatsheet 👉 https://chandoo.org/wp/15prompts Ever wondered how an experienced Data Analyst actually uses AI In this video let me lift the curtains and showcase my exact process. You will be surprised for sure. ❌ What I don't use AI for ✅ What I use AI for 🧪 To generate Test data and samples 🎨 Design & Mock-up stages of projects 🧑💻 Writing Python Scripts 🏃♀➡ Getting a head start on new projects ✍ Documenting my work 📗 My Prompting Cheat sheet with [--] prompts - https://chandoo.org/wp/15prompts"
YouTube Link 2025-06-10T13:01Z 791K followers, 31.6K engagements

"Your Power BI Charts Are Boring - Replace Them With This 📈 🤩 Get my Power BI course and be a star at work - https://chandoo.org/wp/power-bi-course/ Be exciting. Power BI is pretty powerful but the default charts look 🤮. In this video learn how to make the ultimate column chart to impress the stakeholders. 📁 Sample Data (use it to build the chart) - https://chandoo.org/wp/wp-content/uploads/2025/07/quick-tips-sampledata.xlsx #powerbi #datavisualization"
YouTube Link 2025-07-08T13:02Z 777K followers, 10.4K engagements

"Microsoft Fabric Explained: How Its Revolutionizing Power BI Workflows Microsoft recently announced Fabric a unified data platform. In this video let me jargon bust and explain what it is all about. In this video: ========== What is Microsoft Fabric How Fabric is related to Power BI What can we do with Fabric A real-world example of Fabric Various Fabric components - Data Factory One Lake Purview Real-time Analytics Timestamps: ============= 0:00 - What is Microsoft Fabric 2:05 - Fabric is not "completely" new 2:44 - As a data person what does Fabric mean to you 3:48 - A real-world example of"
YouTube Link 2023-06-06T08:00Z 829K followers, 83K engagements

"DAX: Active vs. Inactive Relationships in Power BI Set up more than one relationship between tables in Power BI Data Model. Learn how to work with USERELATIONSHIP() function in DAX to manage active vs. inactive relationships between tables. Also learn how to visualize data from both tables in matrix and "new" card visuals with powerful story-telling tricks. 💥 Sample file (demo): https://app.powerbi.com/viewr=eyJrIjoiODY2N2RiYzUtZjYzNy00OTVmLTgxZDctNjQ0NTA5ZDQxYWYyIiwidCI6IjUzNTA4ZDUyLWQxYjAtNDliMC1iNGJhLTM1MzNjMTI0OWEwMSJ9 📁 Raw data:"
YouTube Link 2025-05-13T13:00Z 810K followers, 10.5K engagements

"How to setup a Star Schema Data Model in Power BI - Easy guide STAR SCHEMA and Data Modeling in Power BI In this video learn what star schema is what are fact & dimension tables and about many to one relationships. You will also learn the difference between star and snow-flake schemas and know how to set up a star schema in Power BI using the data modeling feature. Please use the practice data file here - https://chandoo.org/wp/wp-content/uploads/2022/04/pb-sales-data-blank-clean.xlsx to set up your own star schema data model in Power BI. Video topics 👇 =============== 0:00 - What is Star"
YouTube Link 2022-04-14T08:00Z 830K followers, 122.1K engagements

"Excel dashboard like you have never seen before (PART 2) 💥Download the file from https://chandoo.org/wp/awesome-excel-dashboard/ YES totally made in Excel this beautiful interactive & insightful dashboard is the finest example of what you can achieve with Excel. In this epic video let's create a magnificent dashboard. Join me on this unforgettable journey. 📚Topics covered in this video: ========================= How to design an executive dashboard Picking colors themes and formats for the dashboard Using Data model Power Pivot & DAX to calculate values for the dashboard Creating and"
YouTube Link 2022-07-26T08:00Z 809K followers, 31.7K engagements

"Top [--] Excel Functions for Data Cleaning Clean Data in Excel with this PRO with these amazing "new" functions. Gone are the days of manual data cleaning. Nowadays Excel offers amazing functions to automate the data cleaning process. In this masterclass learn the super tricks and become a data cleaning PRO. ✅ Reshaping data with WRAPROWS and TAKE ✅ Stacking data with HSTACK and VSTACK ✅ Removing excess spaces with TRIM ✅ Replacing typing errors and synonyms with a mapping table and XLOOKUP ✅ Replacing missing values with IF function ✅ Extracting values from text using TEXTSPLIT TEXTBEFORE and"
YouTube Link 2025-05-27T13:00Z 808K followers, 31.7K engagements

"I got braces in my 40s Big news I got braces I have been thinking about getting braces to fix my overbite and crowded bottom teeth for many years now and finally I did it. Late last year (2022) I consulted my dentist reg. getting braces. After getting my chipped wisdom tooth removed I finally started the braces process in March [----]. On 13th of April I got my braces This video chronicles the journey answers some of the pressing (no pun) questions and reveals my new look. Enjoy :) Thanks to my Dentist Dr. Ryan Ku from Johnsonville Dental Centre. https://jdc-vanguarddentalgroup.com/about/ Want"
YouTube Link 2023-05-02T08:00Z 829K followers, 23.7K engagements

"How to add a line to your column chart Learn how to add a line to your column chart at a point to show which values are above / below certain limit. For example workbook and more visit http://chandoo.org/wp/2016/11/02/column-chart-with-line/ ========================================= For more awesome tips & tricks on Excel check out http://chandoo.org Love us Support chandoo.org channel thru Patreon http://patreon.com/chandoo"
YouTube Link 2016-11-02T07:30Z 811K followers, 217.6K engagements

"Excel SUBTOTAL Magic 🪄 Day [--] Let's use Excel SUBTOTAL to see summaries for filtered data instantly chandoo chandoo.org Excel spreadsheets chandoo chandoo.org Excel spreadsheets"
YouTube Link 2025-12-09T12:00Z 835K followers, 25.2K engagements

"Where to get FREE Datasets to practice Data Analytics Do you want some free data sets to practice your data analysis skills In this video let me present you with [--] amazing resources to get FREE Datasets to practice and improve your data analysis skills. The FREE Dataset places 👉 ======================= [--] Kaggle.com [--] workout-wednesday.com [--] Open Government data sites: USA - https://www.data.gov/ NZ - https://stats.govt.nz India - https://data.gov.in/ UK - https://data.gov.uk/ [--] Demo datasets in Power BI / Tableau (more here:"
YouTube Link 2021-11-02T08:00Z 824K followers, 160.3K engagements

"DON'T Make These [--] Pivot Table Mistakes 💥Want to learn ALL of Excel Go for Excel School - https://chandoo.org/wp/excel-school-program/ Pivot Tables are a staple diet for data analysts all over the world. But are you ruining them with these [--] mistakes In this video let's understand how [--] silly mistakes can make your pivot tables WRONG. Video topics 👇: =============== 0:00 - The [--] mistakes you make with Pivots 0:23 - Mistake [--] - Using cell ranges when making pivot 2:08 - Fixing the mistake with tabular data 4:03 - Mistake [--] - Just using default options 5:13 - Mistake [--] - Making a static pivot"
YouTube Link 2022-05-17T08:00Z 815K followers, 181.9K engagements

"This Excel Formula Shows Stock Prices Instantly BUY BUY SELL SELL If you want to keep track of your stock portfolio with Excel this formula is a must have. The new STOCKHISTORY function is great for getting live and historical stock prices and other information right into your spreadsheet grid. chandoo chandoo.org Excel spreadsheets chandoo chandoo.org Excel spreadsheets"
YouTube Link 2025-11-08T12:00Z 835K followers, 12.7K engagements

"How to use Excel VLOOKUP Complete Beginner Tutorial (with sample file) What is VLOOKUP function in MS Excel How to use it How to write lookup formulas How to stop #N/A errors with vlookup How to use INDEX and MATCH functions to lookup values not in the left most column Learn how to answer these questions and more in this video. VLOOKUP tutorial + example file - https://chandoo.org/wp/vlookup-match-and-offset-explained-in-plain-english-spreadcheats/ For example workbook visit https://chandoo.org/wp/wp-content/uploads/2018/05/what-is-vlookup.xlsx #vlookup #Excel #IndexMatch"
YouTube Link 2018-05-10T23:12Z 823K followers, 81.6K engagements

"This Excel Fuzzy Match Formula is CRAZY GOOD 🤩 Fuzzy matching is a bit of hit or miss. But in this video let me show you a simple elegant and powerful way to compare two text values and see what % they match (from left). You can use this technique in data cleaning lookups and data analysis. chandoo chandoo.org Excel spreadsheets chandoo chandoo.org Excel spreadsheets"
YouTube Link 2025-11-06T13:00Z 835K followers, 21.6K engagements

"Top [---] cities comparison Excel chart - Explained ExcelTutorials Top [---] cities comparison Excel chart - Explained ExcelTutorials Here is an interesting way to explore and visualize top [---] cities (or top x anything) using Excel. For details & example workbook visit http://chandoo.org/wp/2014/10/08/top-100-cities-chart/ Do Subscribe Like & Share my video if you like Click The Below Link To SUBSCRIBE: https://www.youtube.com/channel/UC8uU_wruBMHeeRma49dtZKA"
YouTube Link 2014-10-08T07:42Z 806K followers, 33.9K engagements

"Traffic Light Chart in Excel - PM Dashboard Part [--] Traffic Lights Thermometer and Donut charts are efficient ways to communicate overall project status. In this tutorial learn how to make these [--] powerful charts with simple steps using Excel. This is part [--] of our Project Management Dashboard series. Please check out Part [--] - https://www.youtube.com/watchv=FXnyKU6xZeI and the finale (Part 3) here 👉 https://youtu.be/Exlj5qH0rhc 💻👉Please download the files from here ================================== https://chandoo.org/wp/interactive-project-dashboard-with-excel/#part2 Video timestamps:"
YouTube Link 2021-05-19T08:24Z 827K followers, 37.8K engagements

"This Excel Trick shows the New Customers Quickly Who is new I want to know chandoo chandoo.org Excel spreadsheets chandoo chandoo.org Excel spreadsheets"
YouTube Link 2025-10-22T09:30Z 835K followers, 52.5K engagements

"Master Class [--] - Advanced Interactive Charts in Excel Here is the first episode of our Monthly Master Class. Please purchase to view this. Visit http://chandoo.org/wp/2016/04/14/advanced-interactive-charts-using-excel-master-class/ for more details"
YouTube Link 2016-04-15T14:45Z 806K followers, [--] engagements

"5 Conditional Formatting tips to make you a rock star at work 🤘 Aah. Conditional Formatting. My most favourite feature of Excel. In this video let me reveal [--] AMAZING tricks to make you a rock star at work. The five tips are 1) How to highlight top [--] items & Bottom [--] items 2) Highlight data where sales more than $150000 3) Highlight top [--] sales persons with CF Formula rule 4) Using Data Bars to add in-cell visualization 5) Creating a stylish report with conditional formatting Video timestamps 👉 ==================== 0:00 - Introduction 0:25 - Highlighting top [--] sales values 1:35 -"
YouTube Link 2022-03-24T08:00Z 805K followers, 193.3K engagements

"Advanced Pivot with GROUPBY Excel Function You've heard about GROUPBY but do you know this advanced trick chandoo chandoo.org Excel spreadsheets chandoo chandoo.org Excel spreadsheets"
YouTube Link 2025-11-25T12:00Z 835K followers, 23.2K engagements

"Create a Top [--] Dynamic Chart with this CRAZY Trick 💡 We can make a cool & interactive Top [--] Chart using Excel pivot tables & simple formulas. Try this next time you are making a report or dashboard and impress everyone. In this video: ========== 0:00 - Intro & Creating the pivot table 0:58 - Adjusting Pivot settings 1:40 - Calculations for top [--] chart 2:09 - Adding the chart & customizing it 3:12 - Making the chart presentable 🤩 5:51 - More on dashboards & charting Sample file: ========== https://chandoo.org/wp/wp-content/uploads/2021/07/top5-chart-for-dashboards.xlsx More on charting &"
YouTube Link 2021-07-20T08:45Z 817K followers, 56K engagements

"Top [--] Excel Functions you should learn in [----] Excel has 400+ FUNCTIONS and most of these are a WASTE of time. If you want to get good with Excel in a short time focus on these [--] instead. Once you know how to use and combine them you can learn more. So what are the [--] SUMIFS XLOOKUP FILTER COUNTIFS INDEX EDATE UNIQUE TEXTJOIN SORT IFERROR Let's dive in. VIDEO TOPICS: =============== 0:00 - Most Excel functions are useless 0:42 - Number [--] function - SUMIFS 1:52 - XLOOKUP function 2:40 - How to get multiple values with lookup (FILTER function) 3:43 - COUNTIFS Function 5:49 - INDEX Function"
YouTube Link 2022-11-01T07:00Z 737K followers, 151.5K engagements

"I saw my boss do these [--] things in Excel At awesome chocolates we have a boss who is not so good with Excel. So the other day I caught him doing this. and I had to show him a better option. In this video: ============= 0:00 - He was adding blanks rows like this 0:32 - He was adding tracking numbers like this 1:26 - He was getting "dates" like this 2:07 - He was checking duplicates like this 2:45 - He was comparing two lists like this 3:26 - He was doing something UNBELIEVABLE 3:38 - He was setting up monthly sheets like this 4:28 - He was checking values like this 5:27 - He was making pivots"
YouTube Link 2022-10-04T07:00Z 814K followers, 2.7M engagements

"I dont use filters in Excel anymore. I use this other function instead 😎 Excel is has 100s of functions but my absolute favourite has to be the FILTER function. It let's you filter a dataset based on conditions. This makes the job of data analysis and calculating summaries so much easier. You can create any type of complex criteria with FILTER function to simplify your job. In this video 💡👉 ================ 0:00 - Introduction to FILTER function with simple examples 1:41 - Understanding the spill range & FILTER output 2:46 - Printing just the names not all data 4:07 - Count of FILTER"
YouTube Link 2021-09-30T07:30Z 830K followers, 729.8K engagements

"Powerful trick to get data from any folder in Excel (works even after renaming) Power Query is great for automation until it doesn't work because someone (I am not naming them) goes ahead and renames a file or the folder Then you witness the slow collapse of your automation domino empire. In this video let me share with you a simple and elegant fix to the problem. Using parameters Learn how to automate tasks effectively with Power Query using dynamic folder paths. video topics: ============= 0:00 - Power Query Automation Error (file renamed ⚠) 0:13 - Creating file name & folder path"
YouTube Link 2024-04-30T08:00Z 819K followers, 21.1K engagements

"Excel formula to get "CLOSEST" Matching Value That is close enough 👉👈 Sometimes we can't find the exact match for a value you are looking for. This video shows the formula technique to get the exact or next closest value. chandoo chandoo.org Excel spreadsheets closest value lookup excel excel lookup closest match chandoo chandoo.org Excel spreadsheets closest value lookup excel excel lookup closest match"
YouTube Link 2025-11-01T09:30Z 835K followers, 14.6K engagements

"Make an AWESOME Dynamic Chart with Checkboxes in Excel ✔ (No VBA) This is going to surely impress everyone in office. A crazy simple and powerful dynamic chart with Excel check boxes. We can use the "Checkbox" form control in Excel to create a stunning chart. The trick is to link your check box to a cell and then build "formulas" to on/off the data. At Awesome Chocolates we are using it to analyze sales data interactively. What are you going to use it for Do tell me in the comments. IN THIS VIDEO 👇 ================ 0:00 - Quick demo of the dynamic chart 0:22 - Enabling the Developer Ribbon"
YouTube Link 2022-04-21T08:00Z 828K followers, 92K engagements

"IRR with Data Tables - Excel Financial Analysis Lesson #FinancialAnalysis #IRR #DataTables #Scenarios Do you want to simulate multiple cash-flow scenarios and calculate the rate of return Then this video is for you. Learn how to * Introduction to IRR & XIRR functions * Calculate rate of return from a set of cash-flows with XIRR * Simulating purchase or terminal value changes with data tables * Apply conditional formatting to visualize the outputs * Common issues and challenges faced when using XIRR Example Workbook and More Details: =============================="
YouTube Link 2019-10-16T05:53Z 809K followers, 15K engagements

"Simple & useful Excel IF formula tip #shorts #shorts A simple trick to spice up your IF formulas. Use Emojis. Just type the regular IF formula and in double quotes use Windows key & . key to access Emoji keypad. Select the emoji you want and your formula will now show that as result. 😎😎😎"
YouTube Link 2021-03-22T08:15Z 811K followers, 70.3K engagements

"WHAT Pivot with an Excel Formula 😲 That is right. The new groupby function can help you make a powerful pivot with formulas. chandoo chandoo.org Excel spreadsheets chandoo chandoo.org Excel spreadsheets"
YouTube Link 2025-11-22T12:00Z 835K followers, 26.5K engagements

"Learn Power Pivot & DAX for Power BI with [--] Beginner to PRO Examples (Sample file included) DAX (Data Analysis Expressions) is the language used by Power Pivot (and Power BI) to build calculations and to analyze data. If you want to be good in Power BI then you must learn DAX. In this comprehensive video learn how to get started and use DAX for many practical scenarios with 20+ examples. What is covered ============== [--] What is DAX & Power Pivot [--] How to create and edit measures in Power BI [--] Evaluation Context explained [--] Customizing the DAX measure display settings [--] Reusing DAX measures"
YouTube Link 2022-06-14T08:00Z 823K followers, 513.1K engagements

"XLOOKUP MULTI CRITERIA MAGIC #excel Multiple criteria with XLOOKUP using the * operator"
YouTube Link 2025-05-22T13:00Z 817K followers, 33.8K engagements

"Date Range Overlap in Excel - Adv. Formula Trick 💡 If you want to know whether one date range overlaps with another use this clever formula pattern in Excel. chandoo chandoo.org Excel spreadsheets chandoo chandoo.org Excel spreadsheets"
YouTube Link 2025-11-17T12:01Z 835K followers, 24.5K engagements

"How to get Excel & MS Office for FREE (Power BI + SQL too) 💥Get all the details in one email - https://chandoo.org/wp/xl4free Do you want Microsoft Excel Power BI and SQL for free Watch this video to figure out how to get all the essential software for data analysis work for free. 🎁 Get Excel / Power BI / SQL for free - all links here: =========================================== ONE EMAIL WITH ALL INFO Let me send you one email with all this info. Sign up here: https://chandoo.org/wp/xl4free EXCEL To get Excel for free: https://excel.new To get Excel Home & Family plan:"
YouTube Link 2024-02-27T07:00Z 823K followers, 40.5K engagements

"How to Find the Highest Value in Excel Instantly SCAN you beauty. 😍 With SCAN function in Excel performing an operation (like maximum) progressively over a list becomes easy. We can use it to find out the MAX so far AVERAGE so far Lower Order Count so far etc. chandoo chandoo.org Excel spreadsheets chandoo chandoo.org Excel spreadsheets"
YouTube Link 2025-11-10T12:01Z 835K followers, 18.3K engagements

"10 awesome things you can do in Excel - WITHOUT any formulas or pivots Every time you see something extraordinary in Excel they have a formula or pivot table engine behind them. In this video let me show you [--] incredibly cool and powerful things you can do in Excel without writing a single formula or pivot table. The [--] things are. Initials from Names with flash fill Totals for Filtered values with "Total Row" feature Compare Lists with conditional formatting Frequency Distribution with histograms & box plots Running Totals with Quick analysis Forex Conversion with Paste Special Spot Extreme"
YouTube Link 2020-10-27T07:00Z 809K followers, 284.5K engagements

"This Excel Trick Finds the Last [--] Salaries Instantly Want to find what is average of recent "x" values use this simple but elegant Excel formula. chandoo chandoo.org Excel spreadsheets chandoo chandoo.org Excel spreadsheets"
YouTube Link 2025-11-27T12:01Z 835K followers, 21.1K engagements

"How I Tracked [--] Stocks in Excel With One Formula MAKEARRAY function in Excel enables us to generate multiple values with just one formula. In this video let me show you how to get stock prices for [--] stocks over a last [--] days using one single formula with MAKEARRAY function. chandoo chandoo.org Excel spreadsheets chandoo chandoo.org Excel spreadsheets"
YouTube Link 2025-11-09T12:01Z 835K followers, 22.1K engagements

"Multiple Find / Replace with List.Accumulate() Power Query In this video let's talk about List.Accumulate() Power Query function. This versatile function can apply an operation on all items in a list and return one final value. We use this little gem to perform multiple find / replace in a piece of text. This technique is useful for replacing keywords or changing text en masse. For full discussion example file and more please visit: https://chandoo.org/wp/multiple-find-replace-list-accumulate #PowerQuery #List.Accumulate #KeywordReplacements #FindReplaceAllItemsExcel"
YouTube Link 2020-05-14T08:15Z 829K followers, 41.5K engagements

"How to link two files in Excel - [--] ways to solve the problem I have a price list Excel workbook & sales data workbook. In this video let's combine these two files using Excel. In the video. =========== 0:00 - File connection problem 0:53 - Using formulas to link two files 1:38 - The problem with formula approach 2:14 - Another way to connect two files (Power Query) 3:49 - What happens when you have new data Sample files: =========== Sales data file - https://chandoo.org/wp/wp-content/uploads/2022/03/Sales-Data.xlsx Price list file -"
YouTube Link 2022-03-15T08:00Z 809K followers, 178.5K engagements

"10 Advanced XLOOKUP Tips & Tricks You don't need a guitar to make your data sing 🎶🎵 You just need XLOOKUP. In this video I present [--] advanced tricks to master the XLOOKUP function. Dive in and thank me later :) In this video: 0:00 - XLOOKUP Rockstar - [--] advanced examples 0:50 - Setting up data in a table format 1:15 - XLOOKUP Syntax and basic usage (TRICK 0) 2:30 - Get all columns of data with XLOOKUP (Trick 1) 3:35 - Get all columns but vertically (Trick 2) 4:18 - Lookup values that begins with (wild card match Trick 3) 5:42 - Equal to or higher than lookup (Trick 4) 7:02 - Multiple"
YouTube Link 2023-11-07T07:00Z 819K followers, 62.3K engagements

"How to use Excel Slicers like a PRO: Basics + [--] Advanced Tricks Excel Slicers can make your pivot tables charts & dashboards DYNAMIC. They are one of my absolute favourite features. In this succinct yet practical video learn all about how to set up & use slicers like a PRO. Video topics 👇 ============== 0:00 - Introduction 0:29 - When to use SLICERS 1:15 - How to insert a slicer 2:03 - Advanced Slicer tips 2:39 - Customizing the Slicer look 3:55 - More than one slicer on a pivot 4:26 - Amazing Dynamic chart with two slicers Example workbook 📗👉 ==================== 💥 A Detailed article +"
YouTube Link 2021-11-11T08:30Z 814K followers, 243.1K engagements

"This formula changes how you make dashboards TOPN in One Cell TEXTJOIN magic for your next dashboard chandoo chandoo.org Excel spreadsheets chandoo chandoo.org Excel spreadsheets"
YouTube Link 2025-10-27T09:30Z 835K followers, 20.8K engagements

"Top [--] Data & Power BI terms every data analyst must know Frustrated by the technical terms like dimensions data modeling or snowflake In this video let me explain more than [--] jargon words when it comes to data modeling & business intelligence world. Terminology explained in this video: Table Fact Dimension Calendar Relationship One to many one to one many to many Keys - Primary & Foreign keys Star schema Snowflake schema Measures Values Aggregation Data Modeling Slicer Filter Query ETL Transformations Batch Data Pipeline Source Refresh --- Want to learn more ================ Check out my"
YouTube Link 2021-07-14T08:30Z 822K followers, 161.4K engagements

"3 Resume Tips for Data Analysts that "actually" work #jobsearch [---] Tips that actually work [--] Make a few distinct versions of your CV and test them out. Improve one that has most traction 2Don't load up the resume with all sorts of jargon & buzz words. Focus on a few key tech (like SQL Power BI Snowflake Azure) and really go deep. 3Say what you have done not what you are asked to do. List your accomplishments instead of job responsibilities in the CV. #resumetips #dataanalyst"
YouTube Link 2025-06-09T09:00Z 827K followers, 29.7K engagements

"The surprising trick to fix Table Spill Formula Errors We can spill formulas in Excel tables with this little trick. chandoo chandoo.org Excel spreadsheets chandoo chandoo.org Excel spreadsheets"
YouTube Link 2025-11-11T12:00Z 835K followers, 18.6K engagements

"Who are our top customers - Excel Formula Trick Top [--] only chandoo chandoo.org Excel spreadsheets chandoo chandoo.org Excel spreadsheets"
YouTube Link 2025-10-25T09:30Z 835K followers, 28K engagements

"Introduction to DAX SVG Charts (way better than default Power BI visuals) Today let's create SVG Measures with DAX to jazz up your Power BI reports. 📁 Sample file + resources: https://chandoo.org/wp/how-to-svg-dax-measures-power-bi/ 🗃 Ready to use SVG Templates: https://kerrykolosko.com/portfolio/ 🎨 SVG Editor: https://boxy-svg.com/app 😍 Calendar Chart Inspiration: https://public.tableau.com/app/profile/bigxpt/viz/SALARYWORKHOURS/SALARY #powerbi #dax #svg"
YouTube Link 2025-05-06T13:01Z 820K followers, 12K engagements

"XLOOKUP in Excel Step-by-Step Tutorial for Beginners (better than VLOOKUP) Want to learn XLOOKUP You have come to the right place. "XLOOKUP is probably the most powerful XL function" - my grandma How to use XLOOKUP =XLOOKUP( value you want to find in the column where your data is specify the column you want as a result) XLOOKUP Example 1: =XLOOKUP( "Richard" B8:B42 H8:H42) XLOOKUP Example 2: =XLOOKUP( "EMP1012" C8:C42 B8:B42 "Person not found") Why use XLOOKUP XLOOKUP is an easy versatile and powerful XL function that let's you search what you want in your data and get matching results. It is"
YouTube Link 2025-07-02T13:01Z 827K followers, 45.2K engagements

"Combine Excel Sheets with this simple formula Do you know that Excel now has a formula to combine data from multiple sheets Yes the VSTACK() function can combine data from multiple worksheets in one go. In this quick video let me show you how to use the VSTACK function to combine data from monthly budget worksheets. 📁 Sample data file: ================= https://chandoo.org/wp/wp-content/uploads/2024/06/vstack-conslidation.xlsx #excel #chandoo #consolidation"
YouTube Link 2024-06-05T08:00Z 823K followers, 44.6K engagements

"Excel Secrets They Dont Teach You (Managers Must Watch) Do you work as a manager and use Excel Then this live stream is for you. In this informative useful and incredibly time-saving session learn the most impactful Excel concepts & tricks that matter to you. 📂 Sample file: https://chandoo.org/wp/wp-content/uploads/2025/03/sample-file-done.xlsx Stream timing: Wellington (NZ ) Sunday [--] March [----] at 2:00 p.m. New Delhi (India) Sunday [--] March [----] at 6:30 a.m. New York (USA - EST) Saturday [--] March [----] at 8:00 p.m. Chicago(USA - CST) Saturday [--] March [----] at 7:00 p.m. Seattle (USA PST)"
YouTube Link 2025-02-26T03:57Z 727K followers, 18K engagements

"Easy XLOOKUP Hacks You Need To Try in Excel We always lookup [--]. XLOOKUP is one of the most powerful and useful XL functions ever. In this video learn how to take your XLOOKUP skills to next level and impress everyone with a sneaky little trick by looking up [--]. Topics covered: ✔ How to do multi-criteria lookups ✔ Boolean arithmetic - the powerful of 1s & 0s ✔ Advanced AND criteria ✔ Advanced OR criteria with xlookup ✔ How to see all matching values FILTER(1) trick 📁Sample file - https://chandoo.org/wp/wp-content/uploads/2025/07/xlookup-multiple-criteria.xlsx 📺More on XLOOKUP XLOOKUP in SIX"
YouTube Link 2025-07-22T13:01Z 817K followers, 46.1K engagements

"Power Query for Accountants & Finance People Time for another monthly master class. In this session learn why Power Query is important for accountants and finance professionals. SAMPLE FILE =========== https://chandoo.org/wp/power-query-tips-for-accountants/ We cover below topics: 1) What is Power Query quick intro 2) Extracting data from bank / card statements 3) Combining monthly ledger data files to one complete set 4) Reconciling paid vs. sent invoices 5) Currency exchange rate calculations"
YouTube Link 2018-08-30T01:42Z 828K followers, 31.5K engagements

"When to add a MEASURE and when to add a Column in DAX Not sure when to create a measure or add column in Power BI In this easy video learn why & when you should make each of them best practice advice with examples. Topics in this video 👉 ==================== 0:00 - Introduction to the model 0:30 - Simple rule for "when to make a measure" with example 1:51 - When to create a column with example 3:38 - How to decide when either a measure or column can do the job 5:15 - Avoiding columns with "Iterator" measures (SUMX example) 6:29 - Back to square one - Measure vs. Column 7:25 - Closing remarks"
YouTube Link 2021-11-09T08:00Z 818K followers, 153.4K engagements

"Summarize Filtered Values in Excel - Formula Trick Using MAP and SUBTOTAL we can easily summarize filtered values. Day [--] chandoo chandoo.org Excel spreadsheets chandoo chandoo.org Excel spreadsheets"
YouTube Link 2025-12-10T12:01Z 835K followers, 26.7K engagements

"Different calculation for subtotals - DAX trick for Excel Power Pivot #DAX #TOPN #PowerPivot #DifferentOutput4Subtotals Excel Pivot Table subtotals are great for seeing grouped up results. What if you want to see a different outcome for subtotal - for example the best salesperson's name in each month instead of total sales You can use DAX to calculate a different value when looking at subtotal level. Get the sample file from - https://chandoo.org/wp/wp-content/uploads/2020/03/adv.-pivot-table-tricks-1.xlsx"
YouTube Link 2020-03-03T07:16Z 811K followers, 21.4K engagements

"How to calculate age in Excel (as of today or on a specific date 📆) Want to know how old someone is given their date of birth in a cell You can use Excel's date functions to do just that. In this video learn how to use TODAY DATEDIF EDATE functions to calculate age from a date in Excel. Learn more here - https://chandoo.org/wp/duration-between-two-dates-in-years-months-days-excel-formula/ Sample File 📗👉 ============== Download practice workbook here - https://chandoo.org/wp/wp-content/uploads/2022/03/calculate-age.xlsx It has a special surprise for you. More on Excel Date & Time"
YouTube Link 2022-03-01T08:00Z 815K followers, 73.6K engagements

"How to Create Org. Charts in Excel linked to your Data (no Visio needed) Ever wanted to create an organizational chart or hierarchy graph in Excel In this quick tutorial learn how to make org. charts with-in Excel from your own data. You can easily update them when your data changes and email the output graph (or image) to a client or your boss. SAMPLE FILE 📂: ============== Download the sample file and make organizational charts with your data. https://chandoo.org/wp/wp-content/uploads/2023/01/org-chart-in-Excel-easy-trick.xlsx 🧰 More Charts & Templates for work:"
YouTube Link 2023-01-24T07:00Z 807K followers, 64.2K engagements

"Compare Two Texts - Excel Formula Hack When your text cells almost match but you need to compare them. use this trick. In this video learn how to set up a fuzzy matching logic with Excel formulas. chandoo chandoo.org Excel spreadsheets chandoo chandoo.org Excel spreadsheets"
YouTube Link 2025-11-07T13:01Z 835K followers, 15.1K engagements

"BUSINESS Analyst vs. DATA Analyst - What do they do skills & career paths. I worked as both - a business analyst (2006-2010) and data analyst (2016 to now). So in this video let me tell what it is like working as a business analyst vs. data analyst. What do Business Analysts do💼🤵 ============================== Business analysts sit between business & technology teams and help with implementation of technology initiatives. They * Talk to business & IT teams * Requirement analysis & documentation * Design & Mock-up * Develop test scenarios & test plans * Prepare business proposals What do"
YouTube Link 2022-03-10T08:00Z 823K followers, 849.8K engagements

"6 Must have line charts for business data analysis 📈👌 Line charts are a staple in data analysis. But do you know these [--] variations to them Use these line chart options to analyze and present business data in different ways. Charts covered in this video: Regular line chart [--]. Indexed chart for comparing trends [--]. Sparkline for tiny insights [--]. Spaghetti line chart for bringing focus on a specific series [--]. Smoothed line chart for evening out edges [--]. Forecast chart to predict future values based on trend and seasonality [--]. Line chart combinations when just a line won't do * Bonus trick -"
YouTube Link 2020-10-01T07:45Z 813K followers, 20.8K engagements

"How to make an interactive TOP [--] Chart with Power BI (using parameters) 🏆 Participate in my Dashboard Competition 👉 https://bit.ly/3xgC1WB If you make dashboards or reports with Power BI you often get questions like "but I want to see top [--] products not just 5" or "can we see top [--] store names instead of all" from your stakeholders all the time. In this video let me present you with an elegant and simple solution to such problems. A dynamic TOPN chart What is TOPN TOPN is a DAX function which returns filtered table with just top n (or bottom n) values based on a criteria. For example: We"
YouTube Link 2024-04-16T08:00Z 821K followers, 38.7K engagements

"Python for Absolute Beginners with [--] Easy Projects + Code Samples Python is an excellent programming language to learn for people in data professions. In this in-depth video learn how to get started with Python and use it for practical situations. You will also learn how to build [--] projects (2 mini-projects and one big project). If you have been on the lookout for a thorough & easy explanation on how to write Python code this is the video for you. Please set aside [--] hours of time to learn and practice. Let's GO 📚What is covered in the video ========================= Getting started with"
YouTube Link 2022-05-24T08:00Z 827K followers, 458.4K engagements

"Excel GROUPBY Function is MAGIC🪄 Groupby is becoming my new favourite function in Excel. In this video you will see why. We are using it to find the day with most sales. chandoo chandoo.org Excel spreadsheets how to use groupby function in excel excel groupby function chandoo chandoo.org Excel spreadsheets how to use groupby function in excel excel groupby function"
YouTube Link 2025-10-31T09:30Z 835K followers, 23.3K engagements

"FREE [--] Month Road Map to Learn Advanced Excel and Becoming a Data Analyst 💥Download the Roadmap 👉 https://chandoo.org/wp/3rmap 💻 Learn Excel on demand https://chandoo.org/wp/excel-school-program/ I have been using Microsoft Excel for the last [--] years. I have also been teaching consulting and sharing Excel knowledge with the world for [--] of those last [--] years. Many times people ask me how to learn Excel in a structured manner. This roadmap video is my answer to that question. In this comprehensive and detailed video I share my ideal 3-month roadmap to learn Advanced Excel Skills. I call"
YouTube Link 2023-01-31T07:00Z 816K followers, 314.2K engagements

"Indian Rupee Formatting in Excel - The right way to do it (1234567.89) Ever wanted to format Indian currency (Rupee ) in Excel It is tricky. Well not any more. You can use a simple windows setting to format More Excel formatting tricks 👉 https://youtu.be/2pn47abZCWU More Data clean-up tricks 👉 https://youtu.be/SNVjndgWBlw Have a beautiful day 😀🌞🌼"
YouTube Link 2021-09-23T08:30Z 819K followers, 103.5K engagements

"Excel Pivot Tables - Master Data Analysis in just [--] minutes 👉 Check out my complete Excel course - https://chandoo.org/wp/excel-school-program/ While Excel formulas are powerful you also need to plan and think hard before writing them to solve business problems. This is why I love Pivot tables. They are really easy to make and provide the biggest bang for buck. We can use Pivots to analyze data and answer business questions effectively and elegantly in short amount of time. In this lesson learn how to: Create a pivot table from your data Using the fields panel to construct your "dream""
YouTube Link 2024-09-10T08:00Z 809K followers, 84.8K engagements

Limited data mode. Full metrics available with subscription: lunarcrush.com/pricing