#  @chandoo_ Chandoo Chandoo posts on YouTube about how to, tutorial, what is, business the most. They currently have [-------] followers and [---] posts still getting attention that total [------] engagements in the last [--] hours. ### Engagements: [------] [#](/creator/youtube::UC8uU_wruBMHeeRma49dtZKA/interactions)  - [--] Week [------] +4.10% - [--] Month [-------] -24% - [--] Months [---------] -0.54% - [--] Year [---------] +121% ### Mentions: [--] [#](/creator/youtube::UC8uU_wruBMHeeRma49dtZKA/posts_active)  - [--] Week [--] +6.10% - [--] Month [--] -7.70% - [--] Months [---] +20% - [--] Year [---] +245% ### Followers: [-------] [#](/creator/youtube::UC8uU_wruBMHeeRma49dtZKA/followers)  - [--] Week [-------] +0.24% - [--] Month [-------] +0.85% - [--] Months [-------] +5.60% - [--] Year [-------] +16% ### CreatorRank: [-------] [#](/creator/youtube::UC8uU_wruBMHeeRma49dtZKA/influencer_rank)  ### Social Influence **Social category influence** [technology brands](/list/technology-brands) [stocks](/list/stocks) [finance](/list/finance) [social networks](/list/social-networks) [currencies](/list/currencies) [countries](/list/countries) **Social topic influence** [how to](/topic/how-to), [tutorial](/topic/tutorial) #3698, [what is](/topic/what-is) #2119, [business](/topic/business) #3320, [microsoft](/topic/microsoft) #385, [excel](/topic/excel) #73, [let me](/topic/let-me), [if you](/topic/if-you), [topics](/topic/topics), [the new](/topic/the-new) **Top accounts mentioned or mentioned by** [@column](/creator/undefined) [@programmingwithmosh](/creator/undefined) [@matmatch](/creator/undefined) [@exceloffthegrid](/creator/undefined) **Top assets mentioned** [Microsoft Corp. (MSFT)](/topic/microsoft) [Alphabet Inc Class A (GOOGL)](/topic/$googl) [FilesCoins Power Cu (FILECOIN)](/topic/files) ### Top Social Posts Top posts by engagements in the last [--] hours "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](https://youtube.com/watch?v=MMdcczmULrU) 2024-08-13T08:00Z 834K followers, 416.9K 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](https://youtube.com/watch?v=WgIbvkyY4mI) 2021-10-26T12:45Z 834K followers, 574K 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](https://youtube.com/watch?v=k_ugshJ4wIw) 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](https://youtube.com/watch?v=kly0uPIM4IU) 2021-08-05T08:30Z 834K followers, 305.8K 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](https://youtube.com/watch?v=l8DCPaHc5TQ) 2022-08-23T08:00Z 834K followers, 1.5M 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](https://youtube.com/watch?v=moZ2cL3a90U) 2025-03-18T12:01Z 834K followers, 149.6K 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](https://youtube.com/watch?v=bokH-VVB1fs) 2026-02-07T01:22Z 834K followers, 12.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](https://youtube.com/watch?v=wSfyBw1rlJ4) 2023-09-12T08:00Z 834K followers, 76.2K engagements "These are the ONLY [--] functions you need to know in Excel (to get most things done) Learn the most important Excel functions and how to use them for business data analysis. Formulas & Techniques covered in this video: ==================================== SUMIFS COUNTIFS AVERAGEIFS XLOOKUP MAXIFS INDEX + MATCH FILTER MAX LARGE How and when to use each formula Working with wildcards & patterns Using date ranges in your criteria Multiple criteria with formulas How to combine formulas to solve a problem Download the Sample Workbooks: ============================ ✅ Completed Workbook:" [YouTube Link](https://youtube.com/watch?v=B5hayFelHDU) 2022-03-22T08:00Z 831K followers, 362.1K engagements "How to make a Column Chart with TOTALS in Excel (perfect for data analysis) Create a clustered column chart in Excel with total series. This is ideal when you have many series and want to understand individual vs. total contribution of each data point. Also learn how to add cool "emoji" based data labels to improve the story-telling. Sample file - https://chandoo.org/wp/wp-content/uploads/2025/04/column-column-chart-demo.xlsx" [YouTube Link](https://youtube.com/watch?v=IcbS1E-7FGA) 2025-04-15T13:00Z 830K followers, 25.2K engagements "The little known "BYROW" function changes how you write formulas in Excel 🤫 Excel has many new function but this one is by far my favourite. In this video learn why BYROW() should be your new best friend. Sample file: https://chandoo.org/wp/wp-content/uploads/2025/02/byrow-is-a-beast.xlsx Learn more: https://chandoo.org/wp/how-to-lookup-in-any-column-excel/ Video topics: 1) What is BYROW() formula in Excel and how to use it 2) BYROW() with LAMBDA() 3) Using BYROW() to lookup in any column (advanced trick)" [YouTube Link](https://youtube.com/watch?v=M_-5nwJnO3o) 2025-02-18T12:00Z 831K followers, 91.8K engagements "Clustered column chart with totals in Excel Create a clustered column chart in Excel with totals. Perfect for data analysis when you have lots of data points. Full video - https://youtu.be/IcbS1E-7FGA #excel #chandoo" [YouTube Link](https://youtube.com/watch?v=ahMbNTaFt0s) 2025-04-17T14:00Z 831K followers, 22.6K engagements "5 Advanced Tips on how to use IF formula in Excel that will SURPRISE you 😲 Excel's IF() is one of the most used and fundamental functions. In this video learn how to use IF function and [--] advanced tips. We are going to learn ✔ IF formula syntax ✔ Nested IF formulas ✔ IFS() function to replace nested if formulas ✔ AND conditions in IF formulas ✔ Choose function ✔ Index function ✔ Using IF with lookups For more advanced tips on IF see this video - https://youtu.be/-yFpzIRifK4 📑Video topics =============== 0:00 - IF formula syntax and simple example 1:05 - Calculating GRADE using nested IF" [YouTube Link](https://youtube.com/watch?v=15NtFld9mVM) 2022-06-28T08:00Z 832K followers, 195.3K engagements "How to Combine PDFs to Excel easily (one or many files) You can use Excel's Power Query to easily convert PDF to Excel tables. No extra software or add-ins required. In this video I will show you how to convert one PDF to Excel or combine data from multiple files to a single Excel table. 📜👇 For sample credit card statements (to practice) and more visit ======================================================= https://chandoo.org/wp/extract-data-from-pdf-to-excel Timestamps: ============== 0:00 - Intro 0:44 - Getting data from one PDF to Excel 2:20 - Fixing problems with PDF import 4:03 -" [YouTube Link](https://youtube.com/watch?v=5I0pnj_-LLA) 2021-04-14T08:30Z 832K followers, 124.1K engagements "Forget Complex DAX use this instead in Power BI Power BI's new Visual Calculation feature allows us to do advanced business logic and analytics without the need for complicated (and often messy) DAX. In this video let me demonstrate the power of visual calculations with a cool month on month comparison chart. Learn how to build report and perform data analysis from scratch making your data visualization more impactful. In the video: 0:00 - Demo of Visual Calculation driven sales report 0:25 - Data model for the report 0:50 - Creating the line chart 1:50 - Creating your first visual" [YouTube Link](https://youtube.com/watch?v=FCAWIHlknQI) 2026-01-30T15:00Z 834K followers, [----] engagements "Make an awesome Project Management Dashboard with Excel (Free download Part 1) 💥Ready to use Excel PM Templates - https://chandoo.org/pmt/pmt-index-1.html You are going to LOVE 😍 this awesome Excel Project Management Dashboard. In this detailed and hands-on tutorial let me teach you how you can create an interactive dynamic & beautiful dashboard for managing your projects. In Part [--] of [--] we are going to cover the project plan Gantt chart part. Watch Part [--] 👉 Project progress charts - https://youtu.be/C0F_VKlTX1c and the finale (Part 3) here 👉 https://youtu.be/Exlj5qH0rhc 💻👉Please" [YouTube Link](https://youtube.com/watch?v=FXnyKU6xZeI) 2021-05-12T08:45Z 832K followers, 276K engagements "Powerful trick to combine all Excel files in a folder AUTOMATICALLY Need to automatically combine all files in a folder to One Excel workbook You are going to love this *completely* automatic way. This simple but insanely time saving trick uses Power Query to combine files in a folder. In this video 👇 ============== 0:00 - Introduction to the combine files problem 0:36 - A quick look at the folder & one of the files 1:10 - Combining the files with "Get Data Folder" option in Excel 2:36 - Cleaning up the file data with Power Query rules 5:32 - Loading the data to Excel 5:55 - What happens" [YouTube Link](https://youtube.com/watch?v=SGzegma9bdY) 2021-11-30T08:00Z 831K followers, 350.2K engagements "Make an AMAZING Dashboard with Power BI - End to End Tutorial +Files 💥 $50 Discount on my Power BI Course: Go to https://chandoo.org/wp/power-bi-course/ and use code SAVE50 In this video: ✔ How to design the Power BI report for EIC insurance company ✔ Writing DAX to calculate important KPIs ✔ Using "NEW" card visual and adding conditional formatting ✔ Custom bar chart design ✔ Emoji trick for AWESOME labels ✔ Working with Ribbon charts ✔ Layering "donut" charts to make an impossible chart ✔ Using Scatter Plots + Symmetry Shading to find insights ✔ Finding profitable segments for insurance" [YouTube Link](https://youtube.com/watch?v=TazNFzgWtgA) 2025-03-21T09:20Z 832K followers, 117.2K 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](https://youtube.com/watch?v=VrQSgI596IQ) 2024-03-19T07:00Z 832K followers, 321K 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](https://youtube.com/watch?v=0BY-6tJmz1g) 2026-02-05T14:30Z 834K followers, 11.7K engagements "5 *Advanced* lookup tricks that Data Analysts need to know VLOOKUPS & coffee drive most of the world's economy. No kidding. In this video let me present you with [--] advanced tricks when working with Excel's most used function - The VLOOKUP. These tricks are 1) Pattern matching 2) Looking up in two tables 3) Multi-column results 4) Combine all matches with IF 5) A better function 👉 Get my Excel Lookups Crash Course on SkillShare 💻 =============================================== https://chandoo.org/lookups You will get FREE [--] month premium access 🎁 when you join with the above link. Video" [YouTube Link](https://youtube.com/watch?v=240fbiyFFKI) 2021-07-06T08:45Z 833K followers, 84.9K engagements "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](https://youtube.com/watch?v=4MVNjzsGokc) 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](https://youtube.com/watch?v=5jrsrSDEMxE) 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](https://youtube.com/watch?v=GaHDTC3GAq0) 2021-08-23T08:30Z 833K followers, 259.1K 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](https://youtube.com/watch?v=YEt-aYbDTrs) 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](https://youtube.com/watch?v=YrMCkE59ef4) 2022-04-07T09:00Z 833K followers, 69K 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](https://youtube.com/watch?v=gGwSCptb-kE) 2026-01-15T12:15Z 834K followers, 24.2K engagements "VBA vs. Python - Which is better Visit https://squarespace.com/chandoo to save 10% off your first purchase of a website or domain. Are you a data analyst and not sure if you need to either VBA or Python In this video let me compare these languages and share my opinion & guidance. In this video: ============= 0:00 - Introduction & [--] parameters 0:45 - Ease of learning (parameter 1) 1:27 - Immediate application (2) 2:55 - How many places can we use the language (3) 3:49 - Forgiveness of a language (4) 4:41 - Availability (5) 5:30 - Automation ability (6) 6:58 - So which one to learn 8:55 -" [YouTube Link](https://youtube.com/watch?v=l0o7VMEf0yc) 2021-07-22T08:30Z 834K followers, 139.9K 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](https://youtube.com/watch?v=vSHUjaxBf14) 2024-12-17T12:01Z 833K followers, 11.9K 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](https://youtube.com/watch?v=35VnP0Rz71I) 2023-05-09T08:00Z 834K 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](https://youtube.com/watch?v=4ePNrdxWtY0) 2024-10-15T12:15Z 834K followers, 225K 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](https://youtube.com/watch?v=5k-KpSkrROw) 2021-07-01T08:45Z 834K followers, 303K 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](https://youtube.com/watch?v=7QNgqq154gE) 2024-12-26T12:00Z 834K followers, 596K 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](https://youtube.com/watch?v=7hd1Nn4cNyI) 2023-09-23T18:41Z 834K followers, 187.2K 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](https://youtube.com/watch?v=9tF1IrfLflg) 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](https://youtube.com/watch?v=ECtJQDc8uF8) 2023-02-14T07:00Z 834K followers, 132.8K 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](https://youtube.com/watch?v=Ejxam_CBY9U) 2024-08-06T08:00Z 834K followers, 127.4K 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](https://youtube.com/watch?v=F7aPazuS8QY) 2021-10-05T08:10Z 834K followers, 546K 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](https://youtube.com/watch?v=HnkT-Ol1FWY) 2024-04-02T07:00Z 834K followers, 69.1K 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](https://youtube.com/watch?v=Iceaqdy7mEs) 2024-07-30T08:00Z 834K followers, 178.7K 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](https://youtube.com/watch?v=K0UF-nSc_Mw) 2021-08-17T08:30Z 834K followers, 456.1K 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](https://youtube.com/watch?v=K_1aVbAH98Y) 2024-07-29T08:00Z 834K followers, 262K 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](https://youtube.com/watch?v=L7L2NHAOrOQ) 2024-06-18T08:00Z 834K followers, 24.5K 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](https://youtube.com/watch?v=Lb3vfuew7Gk) 2025-12-16T12:00Z 834K followers, 49K 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](https://youtube.com/watch?v=Ozr44eL-MPg) 2023-12-05T07:00Z 834K followers, 54.8K 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](https://youtube.com/watch?v=PiFAa_jjaEI) 2020-08-26T08:50Z 834K followers, 752.8K 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](https://youtube.com/watch?v=UQJAHUUFK-o) 2023-02-24T18:00Z 834K followers, 319.8K 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](https://youtube.com/watch?v=aofsdpjvK7w) 2021-05-17T08:30Z 834K followers, 434K 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](https://youtube.com/watch?v=e0s9xdx5FF8) 2020-03-17T06:15Z 834K followers, 480.5K 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](https://youtube.com/watch?v=f7lBYh1_9BQ) 2021-10-13T07:30Z 834K followers, 103K engagements "Reverse Lookup in Excel Made Super Easy When you need to lookup from the bottom chandoo chandoo.org Excel spreadsheets chandoo chandoo.org Excel spreadsheets" [YouTube Link](https://youtube.com/watch?v=hlWOBZUYMaE) 2025-10-29T09:30Z 834K followers, 17.1K 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](https://youtube.com/watch?v=i3AR0gt9SHA) 2024-04-09T08:00Z 834K followers, 209K 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](https://youtube.com/watch?v=kKjmf7eT-M8) 2025-10-20T09:30Z 834K followers, 111K 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](https://youtube.com/watch?v=l5qkg8gzY6E) 2025-11-05T12:01Z 834K followers, 76.9K 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](https://youtube.com/watch?v=lD7TvkoQ6rY) 2024-10-22T12:00Z 834K followers, 389.9K 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](https://youtube.com/watch?v=mkYBJwX_dMs) 2022-09-13T08:00Z 834K followers, 227.2K 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](https://youtube.com/watch?v=o8AzvvtUM3w) 2025-11-19T12:01Z 834K followers, 14.6K 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](https://youtube.com/watch?v=q7EpoOwBcnM) 2022-04-12T08:00Z 834K followers, 471.1K 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](https://youtube.com/watch?v=tNLp_JVipoQ) 2023-03-14T07:00Z 834K followers, 814.5K 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](https://youtube.com/watch?v=uwe8C7K8fXY) 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](https://youtube.com/watch?v=v2oNWja7M2E) 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](https://youtube.com/watch?v=wDTzxdShbd8) 2023-04-04T08:00Z 834K followers, 224.4K 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](https://youtube.com/watch?v=xkYpNfpmbGY) 2024-03-12T14:00Z 834K followers, 152.6K 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](https://youtube.com/watch?v=yfWcZ6eot4g) 2022-08-09T08:00Z 834K followers, 267.8K engagements "10 Advanced IF formulas every analyst should know Almost 70% of spreadsheets contain IF formula. So how well do you know it In this *ADVANCED* video learn all about: -- Using IF to check ONLY One of condition -- Any Two out of Three conditions -- Between condition with MEDIAN function -- Replacing nested if formulas with *NEW* IFS function -- Speeding up IF logic with Boolean replacement hack -- Check List membership -- Using Arrays with if (MedianIF example) -- Wildcard comparisons in IF formula -- Using IF with Conditional Formatting -- IF + Charts for awesome results Timestamps:" [YouTube Link](https://youtube.com/watch?v=-yFpzIRifK4) 2021-03-31T07:45Z 801K followers, 225K 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](https://youtube.com/watch?v=0W6zT_tNSpU) 2025-09-09T13:00Z 834K followers, 24.4K engagements "Top [--] Advanced Excel Tricks for Data Analysis - FREE Masterclass with Sample Files Want to analyse data in Excel but don't want to waste hours In this crisp & informative live stream learn my favourite top [--] tricks for getting things done in Excel fast and right. We are going to learn: 1) *NEW* Dynamic Array functionality in Excel 2) *NEW* Text processing functions 3) Forecasting with a single click 4) Quick analytics 5) Conditional Formatting 6) How to combine two tables of data 7) Pivot Tables ++ 8) Instant Dynamic Chart 9) Even Better Dynamic Chart 10) Getting more out of your data Video" [YouTube Link](https://youtube.com/watch?v=3lULeXMt_zg) 2023-10-14T04:35Z 539K followers, 241.8K engagements "Data validation without duplicates - Excel Tricks #ExcelDropDownBox #DataValidationExcel Validating your data as you type can prevent any surprises when you are doing analysis / follow-up on the data. Thankfully Excel has the right tools to do it. In-cell drop-down lists or combo boxes can assist you in picking up a value from a valid list to enter in a cell. But what if you want to set up data validation list without duplicates For example workbook and more tips on Data Validation dropdown boxes visit ========================================= https://chandoo.org/wp/excel-add-drop-down-list/" [YouTube Link](https://youtube.com/watch?v=4Rv5twNqrGM) 2019-09-27T09:46Z 793K followers, 76.8K engagements "HR Data Analytics & Awesome Dashboard with Power BI 💡: End-to-End Project 💥 Want more Join my full Power BI course: https://chandoo.org/wp/power-bi-course/ Learn how to analyze HR (Human Resources) data and create stunning dashboards using Power BI with this complete masterclass. You are going to learn: Loading data into Power BI and cleaning it with Power Query Creating HR metrics like headcount avg. leave balance avg. salary etc. with Power Pivot Adding columns to the data (like Employee's first name age group etc.) Finding relationships between salary and education qualification Using" [YouTube Link](https://youtube.com/watch?v=5KaIU-9EF-0) 2023-09-19T08:00Z 789K followers, 152K engagements "Interactive Sales Chart in Excel & How it works Visit http://chandoo.org/wp/2012/05/09/interactive-sales-chart-in-excel/ to get the excel workbook and know more about this. Interactive Sales chart using Microsoft Excel" [YouTube Link](https://youtube.com/watch?v=6ZNrlA41a2c) 2012-05-09T05:04Z 732K followers, 74K engagements "Power BI: Free vs. Pro vs. Premium - which one should YOU get Power BI comes in three flavours - Vanilla Chocolate Chip & Mango. I am kidding of course. The three variants are Free Pro & Premium. So which one should you go for Let's unravel in this video. Get Power BI from here - https://powerbi.microsoft.com/en-us/pricing/ In this video ============ 0:00 - Power BI FREE vs. PRO vs. PREMIUM options 0:40 - Power BI FREE 1:28 - Power BI PRO & PREMIUM options (what is the difference) 4:01 - Which option is good for you More on Power BI 💡 ================ What is Power BI and how to use it (👌" [YouTube Link](https://youtube.com/watch?v=6tTJkA3Cv_w) 2022-11-29T07:00Z 734K followers, 81.5K engagements "A simple trick to create user friendly Excel dashboards If you have a dashboard that is very long or spans across multiple tabs consider using multiple form controls that link to same cell. For example workbook visit http://chandoo.org/wp/2015/08/16/dashboard-form-controls-trick/" [YouTube Link](https://youtube.com/watch?v=7-G-99DshHg) 2023-10-21T00:45Z 536K followers, [----] engagements "5 Power BI Card Tricks *not* many know - Use them to improve your reports Want to impress your boss with Power BI Then use these [--] AMAZING Card visual tricks. The tricks are [--] Stylized Card [--] Color Changing Card [--] Left aligned Card [--] Card / Chart [--] Special Secret Trick to work with cards faster SAMPLE FILE 📙 ============= Download the sample file from here. It has the [--] cards a full data model so you can practice. https://files.chandoo.org/pbix/5%20Card%20Tricks%20done.pbix Learn more from here - https://powerbiprof.com/the-humble-card-visual/ TIME STAMPS 👉 ================= 0:00 - What we" [YouTube Link](https://youtube.com/watch?v=7RKxD7andMQ) 2022-01-18T08:00Z 791K followers, 80.8K engagements "Super Layout Tricks for Excel Pivot Tables #pivottablelayouts #advancedpivottabletricks By default pivot tables are incompact layout.But you can change the layout appearance and position of fields to create completely new reports. In this video tip I will show you several powerful layout ideas to try next time you are making a pivot table. For example workbook and resources visit: https://chandoo.org/wp/advanced-pivot-tables/" [YouTube Link](https://youtube.com/watch?v=8fBSAjqM_X8) 2020-02-27T02:49Z 787K followers, 38.3K engagements "Make an AWESOME Employee Dashboard with Power BI (Adv. DAX) 💥Master Power BI for data analysis with my course 👉 https://chandoo.org/wp/power-bi-course/ Power BI is great for generating HR reports employee reports and dashboards. In this video learn how to use Power BI Power Query Power Pivot DAX SVG Measures and visual design to create an impressive employee attendance dashboard. 📁Get the files: Sample data: https://github.com/chandoo-org/Power-BI/blob/main/SVG/emp_attendance_data.xlsx Demo report:" [YouTube Link](https://youtube.com/watch?v=8rgLNBYQqmE) 2025-06-17T13:00Z 804K followers, 19.1K engagements "Advanced Pivot Table Tricks #9.1 - Grouping Data without Data Model #groupingDataInPivots #GroupDatesExcelPivot #GroupWithoutDataModel If your pivot tables are *NOT* from data model you can group any fields. Dates can be grouped in to days / months / quarters / years Numbers can be grouped by chunks Text can be grouped by selecting items on the report Here is a video detailing grouping options for non-data-model pivots. For example workbook and resources visit: https://chandoo.org/wp/advanced-pivot-tables/" [YouTube Link](https://youtube.com/watch?v=ABLg6aopl5E) 2020-02-27T02:49Z 786K followers, 14.9K engagements "How to Make Cool Male vs Female Charts in Excel Need to compare Male vs. Female values Use this cool interactive technique to impress everyone in the next meeting. 📁Sample file: https://chandoo.org/wp/wp-content/uploads/2025/04/male-vs-female-chart-demo.xlsx 💥Adv. Excel Course: https://chandoo.org/wp/excel-school-program/ 🤯 Things you will learn in this video: ☑ How to set up Male & Female "stencils" in PowerPoint ☑ Using XLOOKUP + Data Validation to create a dynamic chart in Excel ☑ Axis formatting tricks to get the scaling right 📺 Other Charting Videos You WILL Enjoy: Colum Chart with" [YouTube Link](https://youtube.com/watch?v=AYz3xSVkvd4) 2025-04-29T13:00Z 753K followers, [----] engagements "How to calculate weighted average in Excel (using SUMPRODUCT) #WeightedAverage #SUMPRODUCT #SUMOPRODUCT #WeightedMeanExcel Today we will learn how to calculate weighted averages in Excel using formulas. What is weighted average Weighted average or weighted mean is defined as from wikipedia The weighted mean is similar to an arithmetic mean . where instead of each of the data points contributing equally to the final average some data points contribute more than others. . If all the weights are equal then the weighted mean is the same as the arithmetic mean. For example workbook and more" [YouTube Link](https://youtube.com/watch?v=AnIoXnqYMeQ) 2019-09-19T08:48Z 786K followers, 10.1K engagements "BonaVista ChartTamer - Review by Chandoo.org Bonavista Chart Tamer excel add-in reviewed by http://chandoo.org/wp" [YouTube Link](https://youtube.com/watch?v=CJSpyTO1RE0) 2009-05-02T07:54Z 779K followers, [----] engagements "Make a Fully Interactive & AWESOME Project Management Dashboard with Excel // The Final Part This is the last part of our EPIC Project Management Dashboard with Excel tutorial. Watch previous videos here: Part [--] - Gantt chart & Project Plan creation - https://youtu.be/FXnyKU6xZeI Part [--] - Project Traffic Light chart - https://youtu.be/C0F_VKlTX1c In this video learn how to: The colours fonts & icons of the dashboard Dynamic upcoming activities / issues table Dashboard KPI tiles Embedding Gantt chart into the dashboard Staff resource loading table Updating dashboard when you have new data" [YouTube Link](https://youtube.com/watch?v=Exlj5qH0rhc) 2021-06-10T08:30Z 772K followers, 62K engagements "How I made $100K as Excel Freelancer - [--] life lessons + [--] tips for you I have been freelancing in the Excel & data analysis field since late [----]. In this video I share [--] stories from my freelancing journey and give you [--] practical tips to be a successful freelancer in the data space. 🧰 RESOURCES FOR FREELANCERS Check out this page for a list of resources tips & ideas for freelancers - https://chandoo.org/wp/resources-for-freelancers/ Upwork: https://upwork.pxf.io/kjX1Rn Fiverr: https://go.fiverr.com/visit/bta=419794&brand=fiverrhybrid PS: I am using affiliate links for upwork & fiverr. 📘" [YouTube Link](https://youtube.com/watch?v=FHEPx4KjlG8) 2022-06-21T08:00Z 739K followers, 743.8K engagements "How to Clean Analyze and Present Data with Excel (FREE Adv. Course) You asked for it. Here is my free course on advanced data analytics. 💥Want more. get my Excel School program 👉 https://chandoo.org/wp/excel-school-program/ In this comprehensive video learn: 1) How to approach a data analysis project 2) How to systematically clean data 3) Doing EDA with Excel formulas & tables 4) How to use Power Query to combine two datasets 5) Statistical Analysis of data 6) Using formulas like COUNTIFS SUMIFS XLOOKUP 7) Making an information finder with your data 8) Male vs. Female Analysis with Pivot" [YouTube Link](https://youtube.com/watch?v=H6k28jhclwI) 2023-06-13T08:00Z 639K followers, 395.2K engagements "Power BI Field Parameters - Why & how to use them The latest Power BI feature - *FIELD PARAMETERS* can drastically change the way you and I make visuals for our reports. In this quick and to the point demo let me show how we can implement then for improved story-telling. 🟧Download the sample file 👇 ========================= Download the sample file & play with this cool feature - https://files.chandoo.org/pbix/field-parameters-demo.pbix In the video: ============ 0:00 - Field Parameters in Power BI 1:28 - Enabling Field Parameters 2:03 - Field parameters for measures 4:25 - Field parameters" [YouTube Link](https://youtube.com/watch?v=IR62y8Q_k-o) 2022-05-31T08:00Z 788K followers, 68.8K engagements "Dynamic Dashboard using Excel - a Tutorial Learn how to use Excel Pivot Tables and Slicers to create dynamic dashboards from your data. A tutorial from Chandoo.org To download the example workbook visit http://chandoo.org/wp/2010/12/08/dynamic-dashboard-video-tutorial/" [YouTube Link](https://youtube.com/watch?v=JSfrpC6GL5w) 2010-12-08T07:38Z 801K followers, 222.9K engagements "Power Query MAGIC ⚡Auto-Categorize Text Like a PRO A Power Query PRO trick to help us clean and "automatically tag" data based on a rules table. This time-saving automation has been helping me a lot with "rules-based text classification" and I am excited to share it with you. What you are going to learn 💡 ======================== 1) The challenge of "tagging" or "categorization" based on rules table. 2) Using Text.Contains and the limitation 3) Introducing "loops" ♾ in Power Query with List.Accumulate() 4) Using List.Accumulate with a custom function 5) How to convert our rules logic into an" [YouTube Link](https://youtube.com/watch?v=JesQzM1BABk) 2025-03-11T12:00Z 735K followers, [----] engagements "3 useful VLOOKUP tricks ✨ in one minute #Shorts #shorts #vlookup [--] creative and useful VLOOKUP tricks in one minute. [--]. Use * or as wild cards [--]. Add up or average multiple columns by using them in column_number option like [----] [--]. Deal with extra spaces by using TRIM on the lookup value More on VLOOKUP =============== Video - https://youtu.be/8rtvDQVQaA0" [YouTube Link](https://youtube.com/watch?v=Ji6knw7HpaU) 2021-04-09T08:44Z 804K followers, 136.3K engagements "Stop Dragging in Excel there is a BETTER way Stop dragging in Excel. Use this better and improved way to get what you want. Introducing the SEQUENCE() in Excel. It puts FUN in Functions. We can use it to get numbers texts dates and even improve your formulas. [--] AWESOME examples to get started: SEQUENCE(1000) - makes [----] numbers row-wise ➡ SEQUENCE(1000) - makes [----] numbers column-wise 🔠 SEQUENCE(10 10) - makes 10x10 grid of numbers [--] to [---] 🟠 ="INV" & SEQUENCE(1000) - makes [----] invoice numbers starting with INV1 INV2. INV1000 📅 SEQUENCE(365 "1-JAN-2025") - makes all the [---] days of 2025" [YouTube Link](https://youtube.com/watch?v=Jq2gRt8Boik) 2024-12-03T12:00Z 680K followers, 25.8K engagements "3 Things I do in my new Job to Succeed as a Data Analyst Recently I started a new job as a "BI Developer". Here is my playbook to quickly impress & succeed in any new job. The BLS Rule. B = Learn about the business L = View new job as an opportunity to LEARN new things S = Start small + bonus A = Use AI to get a head start #newjob #careeradvice" [YouTube Link](https://youtube.com/watch?v=KfMbei8LAAY) 2025-09-02T13:00Z 796K followers, [----] engagements "Pivot Tables in Excel - Intro & Step-by-step tutorial #PivotTables #ExcelPivots Excel pivot tables are very useful and powerful feature of MS Excel. They are be used to create instant summaries reports and data analysis from your raw data. In this comprehensive Pivot Tables Tutorial learn what is a Pivot Table how to create one how to filter & sort them changing the calculations and many other tips. Download sample data & learn more from below page. https://chandoo.org/wp/excel-pivot-tables-tutorial/" [YouTube Link](https://youtube.com/watch?v=Kg7aZBtAWd0) 2020-02-04T09:30Z 786K followers, 43.1K engagements "What is Excel and How to use it Introduction to Microsoft Excel - This is part [--] of [--] in the series - Excel Baby Steps. UPDATE - October 2021: I have created a new version of this video with latest Excel information and bit more detail. Please watch the updated tutorial here 👉 https://www.youtube.com/watchv=F7aPazuS8QY Visit https://chandoo.org/wp/excel-basics/ for more information Other Excel Videos for beginners: =========================== [--] (LATEST UPDATE) Excel beginners - complete crash course (30 mins) - https://youtu.be/F7aPazuS8QY [--] Excel for data analysis - Beginner to PRO video" [YouTube Link](https://youtube.com/watch?v=L3-uVawPLKc) 2010-08-10T08:41Z 731K followers, 2.7M engagements "A day in the life of a data analyst in New Zealand Do you wonder what a data analyst does all day I recently started a new job with NZ Govt. and in this video I share how my day looks like what I do what tools & tech I use what I like and hate about the job. In the video: ============= 0:00 - Day in the life of a data analyst 1:28 - My job and what I do 2:38 - My team 3:02 - How does my week look like 4:31 - Typical Data Analysis task that I do 5:05 - What tools & software I use 7:30 - What I like about this job 10:21 - What I don't like much 11:42 - Closing thoughts and how to be a data" [YouTube Link](https://youtube.com/watch?v=Lc55Y7Ai23Q) 2022-10-11T07:00Z 784K followers, 66.7K engagements "Introduction to Forecasting in Excel Learn how to use the awesome Forecasting feature of Excel [----] / [----] / [---]. We will learn about time series forecasting seasonal fluctuations and confidence intervals too. For downloadable workbook and more resources visit https://chandoo.org/wp/forecasting-in-excel/" [YouTube Link](https://youtube.com/watch?v=MIzy-aCYG_I) 2016-07-27T06:28Z 771K followers, 51K engagements "9 box grid - talent mapping - Excel for HR People - Template & Explanation video [--] box grid is a popular methodology used in talent mapping. Staff are rated on a [--] point scale for their potential & performance. Then they are plotted in a 3x3 grid (9 box) to see who sits where. In this video let me explain how to create such a talent mapping template and tracker using Microsoft Excel. While this approach is immediately helpful for anyone in HR the formula / pivot techniques can be used by anyone. So I suggest you to watch this if you want to learn some innovative formula and pivot table uses." [YouTube Link](https://youtube.com/watch?v=MnsQhba0V9A) 2020-11-17T07:00Z 791K followers, 67.2K engagements "How to create risk map in Excel - Charting Tip #ProjectManagement #RiskManagement #RiskMapInExcel Risk maps are useful for visualizing project risks by impact and likelihood. We can use Excel formulas (TEXTJOIN) and simple tables to create them in minutes. In this tutorial learn how to make your own project management risk map with Microsoft Excel. FREE Risk Map Template ===================== https://chandoo.org/wp/excel-risk-map-template/ Looking for more on Project Management =================================== Fully Interactive Project Management Dashboards - [--] part video series [--] Part 1" [YouTube Link](https://youtube.com/watch?v=N8J-t9JxQbA) 2019-08-28T08:00Z 789K followers, 101.3K engagements "Now you can get stock prices in Excel with STOCKHISTORY() function Excel [---] has a new & shiny function - STOCKHISTORY() using which you can pull stock prices in excel historical trends for your analysis. In this video learn all about: * The new STOCKHISTORY function - what is it and how to use it in Excel * Specifying exchange and symbol (ticker) code in STOCKHISTORY() * Historical prices (quotes) by day week or month * Using STOCKHISTORY to get currency exchange rates - USD to INR conversion * How to use STOCKHISTORY() function to make a simple portfolio tracker worksheet Video Timestamps:" [YouTube Link](https://youtube.com/watch?v=NMmQXrEXrGo) 2021-03-15T07:45Z 787K followers, 40.6K 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](https://youtube.com/watch?v=P2Ch6U98jrU) 2025-10-01T12:00Z 834K followers, 19.7K engagements "XLOOKUP vs. INDEX MATCH - Which is faster Ever wonder what is the fastest lookup function in Excel In this experiment style video I test VLOOKUP vs. INDEX+MATCH vs. XLOOKUP by writing [--] million formulas. The results are surprising Note: there is no sample file for this video (the dataset is rather large but feel free to make some random data in Excel to test the concepts yourself). In this video: ============= 0:00 - Fastest lookup formula in Excel 0:26 - Dataset and testing methodology 2:31 - Writing the VLOOKUP formula 3:34 - INDEX MATCH formula 4:34 - Faster INDEX MATCH formulas 6:32 -" [YouTube Link](https://youtube.com/watch?v=PfHwCJrQc8o) 2022-08-02T08:00Z 745K followers, 32.1K engagements "Make an Excel Dashboard in just [--] minutes Do you run an ecommerce business or website You can use this beautiful simple and useful website metrics dashboard to see how everything is going on. This dashboard is easy to work with and you can set it up in less than [--] minutes. For the dashboard template and more visit https://chandoo.org/wp/website-dashboard-template/ Also if you want more customizeable dashboard templates consider my ready to use Excel dashboard pack - https://chandoo.org/dbt/index.html #dashboards #websiteKPIs #websiteDashboard #ExcelDashboardTutorials" [YouTube Link](https://youtube.com/watch?v=QCrVCUkN2XM) 2020-04-28T09:05Z 786K followers, 30.9K engagements "Make an interactive distribution curve (bell curve) in Excel - Easy Trick 💡 Excel Bell curves or frequency distribution curves are handy for analysing and understanding distribution of your data. Recently someone asked me to make a bell-curve to visualize salary distribution of staff. While you can use formulas or complex techniques to make these I used a simple trick to make the bell curve and add interactive effect to it. Needless to say my clients were impressed. Let me show the method in this video and take it to next level. Time stamps for the video: ==================== 0:00 - The bell" [YouTube Link](https://youtube.com/watch?v=QM7TdGn2I78) 2021-04-07T09:00Z 795K followers, 45.9K engagements "The BEST Excel tricks are often the SIMPLEST - Here is the proof Simple yet Powerful. That is the name of the game. 0:24 - TRICK 1: Auto number as you type 3:09 - TRICK 2: Auto highlight when values change more than 10% 6:37 - TRICK 3: Make sure the total adds up to 100% 💥 Want more Check out my Advanced Excel Course - https://chandoo.org/wp/excel-school-program 🎟 GET10% discount with code [--------] #excel #tricks" [YouTube Link](https://youtube.com/watch?v=QOpwyx0omvY) 2025-05-20T13:00Z 763K followers, 17.3K engagements "Beyond Power BI - Data Skills You need in [----] to GROW 🚀 Want to grow your data career and skills in [----] Then you need to think beyond Power BI. In this video let me share my approach for growing your data skills using "value chain analysis". The key skills you want to gain are: 📚 Data engineering & SQL 📚 Coding (for data - like Python) 📚 User interaction skills 📚 Business domain skills 📚 Other BI / Analysis tools - Tableau Excel Python 📚 Forecasting data insights 📚 AI Machine learning GPTs Videos you should check out: SQL - https://youtu.be/l8DCPaHc5TQ Data Engineer vs Data Analyst" [YouTube Link](https://youtube.com/watch?v=RDipBFRmlPc) 2025-02-04T12:00Z 716K followers, 14K engagements "Make a BEAUTIFUL Budget vs. Actual chart in Excel 📊😍 (with adv. tricks) 💥Download FREE Zebra BI tables add-in here 👉 https://bit.ly/3TAATU3 Ever wanted to make an impressive kickass budget vs. actual (or plan vs. actual or target vs. actual) chart In this simple but effective tutorial let's build one using Excel. We are going to use few little-known tricks to make our chart truly extraordinary. Let's GO SAMPLE FILE 👇 ============= Need a hand with this chart Check out the sample file here - https://chandoo.org/wp/wp-content/uploads/2022/10/kickass-budget-vs-actual-chart-1.xlsx VIDEO" [YouTube Link](https://youtube.com/watch?v=REpNnsdHxlY) 2022-10-25T07:00Z 669K followers, 72.9K engagements "Calculate distance and travel time between places using Google Maps API in Excel Here is something fun and useful. Ever wanted to calculate distance between points travel time using Excel See a demo of the technique and visit https://chandoo.org/wp/distance-between-places-excel-maps-api/ for more and sample workbook" [YouTube Link](https://youtube.com/watch?v=RU9D-CyKwEQ) 2018-07-19T09:16Z 787K followers, 24.3K engagements "Data cleaning in Excel - [--] tricks *PROs* use all the time Good data is the cornerstone of great analysis. In this video learn [--] powerful yet EASY ways for data cleaning in Excel that not many know. The tricks you will learn are 0:00 - Introduction 00:18 - Extracting first name with Flash fill feature of Excel 1:47 - Converting numbers to percentages 3:18 - Remove blank cells or rows using Goto special 4:43 - Find common values between two lists 5:32 - Clean-up ugly formats with one click 6:15 - Bonus trick #1 - Remove extra spaces 7:30 - Unstack data easily with simple formulas 9:44 -" [YouTube Link](https://youtube.com/watch?v=SNVjndgWBlw) 2021-03-10T08:27Z 791K followers, 538.2K engagements "I don't use PIVOT tables anymore. I use this other thing instead That is right I no longer use Pivot Tables in Excel. I am now using Power Pivot. In this video let me show you what Power Pivot is and how to use it with Excel. Plus you get to meet Chan2 again 😂 VIDEO TOPICS: =============== 0:00 - What is Power Pivot and how to create one in Excel 1:12 - Why use Power Pivot instead of regular Pivot Tables 3:25 - Practical example of Power Pivot & DAX 📺 LEARN MORE ABOUT POWER PIVOT & DAX: ======================================= Beginner to PRO DAX Lesson with 20+ examples -" [YouTube Link](https://youtube.com/watch?v=SPFQX82X03Q) 2023-06-27T08:00Z 792K followers, 1.4M engagements "How to Present Data for Executive Audience - FREE Masterclass with Sample Files 🚀 Free Excel & Power BI templates: https://bit.ly/3FunWpB 👉 Register for my workshop "How to Build a Business Performance Excel Dashboard with ChatGPT": https://bit.ly/3s5dqBR Join me for this amazing masterclass on how to create and present visuals for compelling story-telling for c-level audience. We are going to talk about [--] concepts and how to implement them using Microsoft Excel. Sample data files will be provided. The session will be for [--] minutes. Get the sample data file here -" [YouTube Link](https://youtube.com/watch?v=Tu6ooTQp2gc) 2023-10-27T18:32Z 537K followers, [----] engagements "How to connect two tables in Excel - With Example Workbook When I was working as a HR data analyst one task I would do every week is combine data in two different tables. In this video let's look at two ways to solve the problem. One using formulas and another with Power Query ⚡. Both methods are really simple to set up and will save you TONS of time in the long run. Video topics 👇 ============== 0:00 - Combining two tables in Excel - the problem 1:15 - Using lookup formulas to combine tables (with XLOOKUP) 2:18 - Using VLOOKUP to combine tables 3:04 - Using Power Query to join two tables" [YouTube Link](https://youtube.com/watch?v=Tw7_YYQWx48) 2022-07-05T08:00Z 677K followers, 163.8K engagements "Make a Pivot Table in Excel This video tutorial by Chandoo.org explains how to make a pivot table in Excel in less than [--] seconds" [YouTube Link](https://youtube.com/watch?v=TwTYWqv0Tm0) 2009-08-24T20:28Z 786K followers, 184K engagements "Don't tell my boss but AI is doing all my Excel work now 🤫 I have been using CoPilot to work faster with Excel. Don't tell my boss though he thinks I am doing all the hard work 😎 In this video: ========== 0:00 - What is CoPilot for Excel and how to enable it 1:30 - How to use CoPilot to clean your data 3:13 - Using CoPilot to write formulas 4:48 - CoPilot and natural language queries 6:58 - Complex analysis scenario with CoPilot 8:52 - Making Pivots with CoPilot 10:12 - Tips & Tricks of using CoPilot 11:16 - Asking CoPilot to find insights on its own 13:04 - Alternatives to CoPilot in Excel" [YouTube Link](https://youtube.com/watch?v=VOvIu5lKoBQ) 2024-09-03T08:00Z 749K followers, 152.7K engagements "How to set up and use Calculation Groups in DAX Power BI Do you know about the CALC. GROUPS feature of DAX This powerful "PRO" feature is a massive timesaver when it comes to building reusable business logic in Power BI. In this video I explain how to set up and use calc. groups in Power BI with a practical example. Get the sample file - https://files.chandoo.org/pbix/calc-groups-demo.pbix Get my full Power BI course - https://chandoo.org/wp/power-bi-course/ #PowerBI" [YouTube Link](https://youtube.com/watch?v=WnLtC3udzSQ) 2023-12-12T07:00Z 786K followers, 39K engagements "5 Tricks Power BI PROs use to Create Amazing Dashboards 👩💻 Make your Power BI reports engaging and binge-worthy with these [--] simple but effective rules. 1) Design charts for readability 2) Write better titles 3) Formatting each chart for the message 4) Use card tricks 5) Create a wireframe Video Timestamps: =================== 0:00 - "Before" & "After" Power BI Reports - Quick demo 0:19 - Rule #1 - Design charts for readability 1:43 - Rule #2 - Write better titles 3:00 - Rule #3 - Formatting each chart for the message 4:10 - Rule #4 - Card tricks to improve your dashboards 6:04 - Rule #5 -" [YouTube Link](https://youtube.com/watch?v=XadqG2SrVSc) 2023-10-10T07:17Z 540K followers, [----] engagements "How to "BUILD" Excel Formulas - [--] Advanced Examples Want to become an Excel PRO Then you must build your formula skills. In this in-depth video I share how I solve [--] real world problems with advanced Excel formulas. Watch my build and learn. EVERYTHING WILL BE AWESOME The formulas are 1) Best Student name by GPA 2) Best sales person in a location 3) Extracting last name from text 4) Multiple IF Condition 5) Manager's manager mystery Video timestamps👉 =================== 0:00 - Introduction to complex formulas 1:28 - (1) Best GPA student name formula 2:37 - Second highest GPA student 3:27 -" [YouTube Link](https://youtube.com/watch?v=Y3DEt7P62G8) 2021-12-07T08:00Z 769K followers, 83.2K engagements "6 Massively time saving Pivot Table tricks (Don't miss #4 & #6) Pivot Tables are very useful. I have blogged and made videos about them many times already. But in this video let me share some of my most favourite time saving tips. For more on this video visit - https://chandoo.org/wp/pivot-table-time-saving-tricks/ 0:00 - Intro 0:51 - Double click to expand details of Pivot 1:37 - Format quickly with this right click option 2:20 - Include filtered items in subtotals 4:05 - Consistent axis in Pivot Charts 5:08 - Repeat item labels in tabular layout 5:55 - Multiple pages with Report filters" [YouTube Link](https://youtube.com/watch?v=YK4IDGz46bc) 2020-07-06T07:30Z 787K followers, 50.6K engagements "This Amazing VLOOKUP Trick Works Across Multiple Sheets 🚀 Do you want to VLOOKUP but in across sheets Then you need this mind-blowing 🤯 trick. 📁 Sample file: https://chandoo.org/wp/wp-content/uploads/2025/03/vlookup-any-sheet.xlsx 💻 10% OFF My Excel Course - https://chandoo.org/wp/excel-school-program/ 🎟 use code SUMPRODUCTIF In this video: 1) How to lookup across multiple sheets 2) Introducing VSTACK to combine all the data 3) Using LET and variables 4) Getting Qty Date & other details with one spillable formula 5) What if multiple matching values are there - using FILTER 🕛 Video" [YouTube Link](https://youtube.com/watch?v=YZ9AoPFUQyA) 2025-03-05T12:01Z 728K followers, [----] engagements "3 Quick tips to get better in Excel formulas [--] - Know how to use Excel references - Table & cell refs [--] - Learn the basic formulas - SUMIFS COUNTIFS XLOOKUP VLOOKUP FILTER IFERROR [--] - Break complex formulas to small steps Helpful tutorial links: ================= 1) Using references in Excel Video - https://youtu.be/4MVNjzsGokc Articles - -- Cell refs - https://chandoo.org/wp/relative-absolute-references-in-formulas/ --- Table refs - https://chandoo.org/wp/introduction-to-structural-references/ 2) Basic Excel functions SUMIFS & COUNTIFS - https://youtu.be/YEt-aYbDTrs IF -" [YouTube Link](https://youtube.com/watch?v=ZfeZ4eYLicM) 2021-08-09T08:30Z 767K followers, 140K engagements "Excel Trick You Didnt Know For Ranking Values Excel doesn't have DENSE RANK. But sometimes that is exactly what we need. In this video learn how to use UNIQUE() with LARGE or SORT to create dense rank in Excel just like how it is in SQL. Sample file: https://chandoo.org/wp/wp-content/uploads/2025/08/dense-rank-excel.xlsx More Excel formulas: https://www.youtube.com/playlistlist=PLmejDGrsgFyDUK8Q_CfZEtQvmRqV0UMm_ #excel #sql #rank" [YouTube Link](https://youtube.com/watch?v=_Jc2CUj9pbY) 2025-08-12T13:00Z 789K followers, [----] engagements "Top [--] Power BI Interview Questions (based on what I usually ask) 💥 FULL Power BI Course - https://chandoo.org/wp/power-bi-course/ Got a Power BI interview coming up. Make sure you know answers to these [--] questions. 0:00 - Top [--] Power BI Interview Questions 0:46 - Explain the difference between a measure and a calculated column. 2:05 - Describe the process of publishing a Power BI report to the service 3:21 - How would you handle missing data 5:30 - What is DAX and give us an example of recent DAX formula you've used 7:22 - How do you connect multiple data sources to a Power BI Report 8:12" [YouTube Link](https://youtube.com/watch?v=aZihsRsEYTE) 2023-10-31T07:00Z 800K followers, 316.9K engagements "New vs. Returning Customers Analysis - Awesome DAX in Power BI 🤩 💥 Sign up for FREE Power BI Live on DAX this weekend 👉 https://chandoo.org/wp/liveclass/ Learn the DAX concepts for performing New vs. Returning customer analysis in Power BI. ✅ Calculate Unique Customer Count ✅ Get "returning" customer count using SUMX and CALCULATE ✅ Alternative approach of using INTERSECT dax function ✅ Visualizing customer data ✅ Enhancing customer analysis with "windows" 📁 Sample Power BI file https://1drv.ms/u/c/e7c6dec249ad257b/EWnD_9DRzfpIsdrF54oGvP4BQ5f20TpogwzBEX4o7oyKMQe=2OjfcT 📁 Sample Data file" [YouTube Link](https://youtube.com/watch?v=adJks3nedsU) 2025-04-08T13:00Z 746K followers, [----] engagements "Power BI is EASY: Get started and make your first report in [--] mins 🕐 Microsoft Power BI is the hottest and most widely sought after skill for data analysts everywhere. In this video we will be covering Introduction to Power BI: how to get started with Power BI including downloading and installing Power BI Desktop loading data and creating visuals and tables. Creating a Business Report: step-by-step process of creating a complete business report using Power BI from loading sample data to formatting visuals and sharing the report with others. Power BI Interface: the main areas of the Power BI" [YouTube Link](https://youtube.com/watch?v=al4OfLIOl2w) 2024-10-08T12:00Z 793K followers, 155.4K engagements "3 POWER BI TRICKS" [YouTube Link](https://youtube.com/watch?v=amyayRKxzNo) 2025-04-07T13:00Z 746K followers, [----] engagements "Scan Data into Excel effortlessly with these [--] tricks 💥PROMO Get the CSUR ET18 Pro scanner from https://bit.ly/3m52dLr Use code CZURFZ to get 15% fan discount. Got several documents with data that needs to go to Excel You can use these two tricks to do it easily. Option 1: Use Office App & Scan Table option Option 2: Use a professional scanner (CZUR ET18) 🔗🔗🔗 Links: ============= Download Office App (andriod) - https://play.google.com/store/apps/detailsid=com.microsoft.office.officehubrow&hl=en_NZ&gl=US Download Office App (iOS) - https://apps.apple.com/us/app/microsoft-office/id541164041" [YouTube Link](https://youtube.com/watch?v=bFMBTFeJUjY) 2022-02-22T08:00Z 771K followers, 214.1K engagements "How I would make the perfect entry-level data resume in [----] (in [--] easy steps) 🎉 Unlock AI for $10 per month https://ntn.so/Chandoo2 Make the perfect entry level data resume with three easy steps. Step 1: Set up your resume for success with a clear and well-defined template. Then customize it for the job you are applying for. Step 2: Build Impact with Limited Experience by highlighting "transferable" skills using ATR style bullet points and creating a strong summary to reflect your passion. Step 3: Stand out with personal branding and social media presence by setting up LinkedIn & GitHub" [YouTube Link](https://youtube.com/watch?v=bYlHkbF-IfM) 2024-11-12T12:00Z 671K followers, [----] engagements "Why Are Cumulative Averages So Hard in Excel (and an easy fix 👌) Cumulative or Running Averages are hard to calculate in Excel. In this video let me explain the challenge and show [--] easy ways to calculate them. Sample file: https://chandoo.org/wp/wp-content/uploads/2025/02/cumulative-average.xlsx How would you do this Leave a comment and let me know. #chandoo #exceltips" [YouTube Link](https://youtube.com/watch?v=dPGICQVQIk0) 2025-02-11T12:01Z 728K followers, [----] engagements "Best Excel Formulas in an hour - Beginner to PRO Masterclass 🎉 Unlock AI for $10 per month: https://ntn.so/Chandoo Here is something that most people get wrong when learning Excel. They learn the functions but not "when" and "how" to use them. So in this masterclass let me tell you "when" and "how" to use Excel functions with [--] business problems. What you will learn in this video: Working with Excel formulas & functions COUNTIFS SUMIFS AVERAGEIFS FILTER Functions multiple criteria CHOOSECOLS function MIN MAX SMALL LARGE SORT + TAKE functions UNIQUE # OPERATOR COUNTA vs. COUNT functions" [YouTube Link](https://youtube.com/watch?v=dVJFyqI_Nw4) 2024-08-27T08:00Z 648K followers, 19K engagements "How to make variance chart in Power BI to measure performance Do you want to create a variance chart (or visual) in Power BI to measure actual vs. target performance This video explains how to create such a chart with synchronized sorting and interactions. We will use conditional formatting visual grouping to achieve a cohesive simple clean & elegant variance chart in Power BI. For a sample workbook and more visit https://chandoo.org/wp/variance-chart-powerbi/ #VarianceChart #PowerBIVisuals #BudgetvActual #ActualvTarget" [YouTube Link](https://youtube.com/watch?v=ePQBg93EEWE) 2020-06-04T08:00Z 785K followers, 81.9K engagements "Email Excel Reports with Power Automate & Office Scrips - One Click Automation 🤖 Ever wanted to send an email of your Excel report to the relevant people with a single click In this video let me show you how we used Office Scripts & Power Automate to solve the problem. You will learn: Email Automation concept How to use Office Scripts How to set up Power Automate Flows How to integrate Excel with Power Automate & Office Scripts IN THIS VIDEO 👇 ================= 0:00 - Email Automation - Quick demo 2:37 - Setting up the Email Contents in Excel 3:50 - Introduction to Office Scripts 8:07 -" [YouTube Link](https://youtube.com/watch?v=eeCqaokSSoQ) 2023-03-21T07:00Z 742K followers, 75.6K engagements "How-to highlight maximum value in charts - Excel tip Ever wanted to highlight maximum value in Excel charts Then this tip is for you. You can easily set up extra series to highlight max min above average values in Excel charts. The trick is to use layering to show values in a way you want. SAMPLE WORKBOOK: ================== https://chandoo.org/wp/how-to-highlight-maximum-value-in-excel-charts/" [YouTube Link](https://youtube.com/watch?v=gMswJ3PrJEo) 2019-08-07T05:11Z 702K followers, 10.6K 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](https://youtube.com/watch?v=gVr9f1GJdZc) 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](https://youtube.com/watch?v=gaPFwH0r4uo) 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](https://youtube.com/watch?v=gi-DSWEUC-A) 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](https://youtube.com/watch?v=gpwqUc3y7ZA) 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](https://youtube.com/watch?v=hBNifaBLGiQ) 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](https://youtube.com/watch?v=hbEn_CeYr6U) 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](https://youtube.com/watch?v=hltpHtza0BU) 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](https://youtube.com/watch?v=jdvp6AqNjT8) 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](https://youtube.com/watch?v=kjD3z_OWWpE) 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](https://youtube.com/watch?v=lFx0MkyBZsg) 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](https://youtube.com/watch?v=m2C_-6PW6WE) 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](https://youtube.com/watch?v=mPCDJag-6Zg) 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](https://youtube.com/watch?v=mYdM46FAQJY) 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](https://youtube.com/watch?v=mfYwbDAY60A) 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](https://youtube.com/watch?v=mp18miYmmJY) 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](https://youtube.com/watch?v=npaQ42K1sTs) 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](https://youtube.com/watch?v=o1WPhrvwjLQ) 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](https://youtube.com/watch?v=ooJO7NW4uJU) 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](https://youtube.com/watch?v=qKvfSvBXHPc) 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](https://youtube.com/watch?v=qjzjYurmb5s) 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](https://youtube.com/watch?v=r7CARn1BL-A) 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](https://youtube.com/watch?v=thvE8Eg-Pqg) 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](https://youtube.com/watch?v=u4aeZ4ukrqI) 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](https://youtube.com/watch?v=u7o-HnoXrTs) 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](https://youtube.com/watch?v=uQoRef0L5Yw) 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](https://youtube.com/watch?v=v4RnVh2iGgU) 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](https://youtube.com/watch?v=xGqH__hLVcU) 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](https://youtube.com/watch?v=y54vn0_VdN8) 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](https://youtube.com/watch?v=yPTbywOkXIo) 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](https://youtube.com/watch?v=ycAhMMYlHjs) 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](https://youtube.com/watch?v=yjgPwBvYZs8) 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](https://youtube.com/watch?v=ykP-agYOtC4) 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](https://youtube.com/watch?v=zQjAmU7RXYw) 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](https://youtube.com/watch?v=zX0P93OBOL0) 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](https://youtube.com/watch?v=--cK4A2djoA) 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](https://youtube.com/watch?v=0-Fe08bdTXA) 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](https://youtube.com/watch?v=1CgG0t59WcM) 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](https://youtube.com/watch?v=2hzUJwz1rik) 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](https://youtube.com/watch?v=2qF1P5R_nFE) 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](https://youtube.com/watch?v=3uNjbewTGGw) 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](https://youtube.com/watch?v=3xh19tLx8Do) 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](https://youtube.com/watch?v=46jWq3ux9dU) 2025-12-09T12:00Z 834K 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](https://youtube.com/watch?v=4FZyHnMQRuc) 2021-11-02T08:00Z 824K followers, 160.3K engagements "Incredibly EASY way to embed your Excel file on a website (will be interactive) Here is an easy way to impress your customers and business partners. Set up an Excel calculator on your website so your visitors can for example see the cost of their order based on latest catalogue prices. You need a website already built Excel file and Microsoft OneDrive account. With just these [--] things you can get your Excel file on to your webpage. Watch this short video and learn how to do it. For more help visit my website: ===============================================" [YouTube Link](https://youtube.com/watch?v=5ViZ7aOxF3I) 2021-03-03T07:45Z 826K followers, 153.6K 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](https://youtube.com/watch?v=5xb7vWNwAwI) 2026-01-24T15:00Z 834K followers, 20.8K 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](https://youtube.com/watch?v=6A3e3s9YBgo) 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](https://youtube.com/watch?v=7G86CkUOfEM) 2025-11-08T12:00Z 834K followers, 12.7K engagements "COUNTIFS with Date Between - This is a must have formula One of the most common and useful business questions is how many "X" between two dates It could be sales employees on vacation or number of issues raised. In this video learn how to use COUNTIFS to answer the question in Excel easily. chandoo chandoo.org Excel spreadsheets chandoo chandoo.org Excel spreadsheets" [YouTube Link](https://youtube.com/watch?v=7ZdETc6jV3Y) 2025-11-15T12:00Z 834K followers, 27.1K 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](https://youtube.com/watch?v=8rtvDQVQaA0) 2018-05-10T23:12Z 823K followers, 81.6K engagements "Second Week Sales Only with SUMIFS (Excel formula) Don't second guess. Just SUMIFS chandoo chandoo.org Excel spreadsheets chandoo chandoo.org Excel spreadsheets" [YouTube Link](https://youtube.com/watch?v=9RIGYR1zp0o) 2025-10-23T09:30Z 834K followers, 27.5K 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](https://youtube.com/watch?v=Avae4MJC3GY) 2025-11-06T13:00Z 834K 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](https://youtube.com/watch?v=Bfab8fty4JA) 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](https://youtube.com/watch?v=C0F_VKlTX1c) 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](https://youtube.com/watch?v=CEDWI-id6X8) 2025-10-22T09:30Z 834K followers, 52.5K engagements "Excel Formula to Show Top Sellers Instantly Top [--] in one cell chandoo chandoo.org Excel spreadsheets chandoo chandoo.org Excel spreadsheets" [YouTube Link](https://youtube.com/watch?v=CFyvQvNWDic) 2025-10-26T09:30Z 834K followers, 23.4K 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](https://youtube.com/watch?v=DzaLKF_ObFo) 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](https://youtube.com/watch?v=El28a08cXIU) 2022-03-24T08:00Z 805K followers, 193.3K engagements "How many days overlap between two projects Excel Formula Magic Find out quickly how many days both projects overlap using this elegant and simple Excel formula chandoo chandoo.org Excel spreadsheets chandoo chandoo.org Excel spreadsheets" [YouTube Link](https://youtube.com/watch?v=EqALWpxps0I) 2025-11-13T12:00Z 834K followers, 24.8K 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](https://youtube.com/watch?v=FQt1msSiDEc) 2025-11-25T12:00Z 834K 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](https://youtube.com/watch?v=Gx9ZVlGkbOk) 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](https://youtube.com/watch?v=HgNCvd8IbSc) 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](https://youtube.com/watch?v=HgfC3etOgsU) 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](https://youtube.com/watch?v=JuTdj2j-9Kg) 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](https://youtube.com/watch?v=JvYB9FOiZVo) 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](https://youtube.com/watch?v=KYhepQTKYoM) 2025-11-01T09:30Z 834K 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](https://youtube.com/watch?v=L3WFN0bGv8I) 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](https://youtube.com/watch?v=MGhRRIP-uNM) 2019-10-16T05:53Z 809K followers, 15K 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](https://youtube.com/watch?v=NDBM8TNmeJw) 2025-12-27T10:30Z 834K followers, 30.1K 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](https://youtube.com/watch?v=NHs_M2MPiJ4) 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](https://youtube.com/watch?v=OWakBDmJJXU) 2025-11-22T12:00Z 834K 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](https://youtube.com/watch?v=PQ5lALdFHCU) 2022-06-14T08:00Z 823K followers, 513.1K 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](https://youtube.com/watch?v=PQhSNaqMFoM) 2025-12-04T12:00Z 834K followers, 12.5K engagements "XLOOKUP MULTI CRITERIA MAGIC #excel Multiple criteria with XLOOKUP using the * operator" [YouTube Link](https://youtube.com/watch?v=PR3v5GHA6p8) 2025-05-22T13:00Z 817K followers, 33.8K engagements Limited data mode. Full metrics available with subscription: lunarcrush.com/pricing
@chandoo_ Chandoo
Chandoo posts on YouTube about how to, tutorial, what is, business the most. They currently have [-------] followers and [---] posts still getting attention that total [------] engagements in the last [--] hours.
Engagements: [------] #
- [--] Week [------] +4.10%
- [--] Month [-------] -24%
- [--] Months [---------] -0.54%
- [--] Year [---------] +121%
Mentions: [--] #
- [--] Week [--] +6.10%
- [--] Month [--] -7.70%
- [--] Months [---] +20%
- [--] Year [---] +245%
Followers: [-------] #
- [--] Week [-------] +0.24%
- [--] Month [-------] +0.85%
- [--] Months [-------] +5.60%
- [--] Year [-------] +16%
CreatorRank: [-------] #
Social Influence
Social category influence technology brands stocks finance social networks currencies countries
Social topic influence how to, tutorial #3698, what is #2119, business #3320, microsoft #385, excel #73, let me, if you, topics, the new
Top accounts mentioned or mentioned by @column @programmingwithmosh @matmatch @exceloffthegrid
Top assets mentioned Microsoft Corp. (MSFT) Alphabet Inc Class A (GOOGL) FilesCoins Power Cu (FILECOIN)
Top Social Posts
Top posts by engagements in the last [--] hours
"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, 416.9K 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
"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.8K 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
"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, 149.6K 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 834K followers, 12.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
"These are the ONLY [--] functions you need to know in Excel (to get most things done) Learn the most important Excel functions and how to use them for business data analysis. Formulas & Techniques covered in this video: ==================================== SUMIFS COUNTIFS AVERAGEIFS XLOOKUP MAXIFS INDEX + MATCH FILTER MAX LARGE How and when to use each formula Working with wildcards & patterns Using date ranges in your criteria Multiple criteria with formulas How to combine formulas to solve a problem Download the Sample Workbooks: ============================ ✅ Completed Workbook:"
YouTube Link 2022-03-22T08:00Z 831K followers, 362.1K engagements
"How to make a Column Chart with TOTALS in Excel (perfect for data analysis) Create a clustered column chart in Excel with total series. This is ideal when you have many series and want to understand individual vs. total contribution of each data point. Also learn how to add cool "emoji" based data labels to improve the story-telling. Sample file - https://chandoo.org/wp/wp-content/uploads/2025/04/column-column-chart-demo.xlsx"
YouTube Link 2025-04-15T13:00Z 830K followers, 25.2K engagements
"The little known "BYROW" function changes how you write formulas in Excel 🤫 Excel has many new function but this one is by far my favourite. In this video learn why BYROW() should be your new best friend. Sample file: https://chandoo.org/wp/wp-content/uploads/2025/02/byrow-is-a-beast.xlsx Learn more: https://chandoo.org/wp/how-to-lookup-in-any-column-excel/ Video topics: 1) What is BYROW() formula in Excel and how to use it 2) BYROW() with LAMBDA() 3) Using BYROW() to lookup in any column (advanced trick)"
YouTube Link 2025-02-18T12:00Z 831K followers, 91.8K engagements
"Clustered column chart with totals in Excel Create a clustered column chart in Excel with totals. Perfect for data analysis when you have lots of data points. Full video - https://youtu.be/IcbS1E-7FGA #excel #chandoo"
YouTube Link 2025-04-17T14:00Z 831K followers, 22.6K engagements
"5 Advanced Tips on how to use IF formula in Excel that will SURPRISE you 😲 Excel's IF() is one of the most used and fundamental functions. In this video learn how to use IF function and [--] advanced tips. We are going to learn ✔ IF formula syntax ✔ Nested IF formulas ✔ IFS() function to replace nested if formulas ✔ AND conditions in IF formulas ✔ Choose function ✔ Index function ✔ Using IF with lookups For more advanced tips on IF see this video - https://youtu.be/-yFpzIRifK4 📑Video topics =============== 0:00 - IF formula syntax and simple example 1:05 - Calculating GRADE using nested IF"
YouTube Link 2022-06-28T08:00Z 832K followers, 195.3K engagements
"How to Combine PDFs to Excel easily (one or many files) You can use Excel's Power Query to easily convert PDF to Excel tables. No extra software or add-ins required. In this video I will show you how to convert one PDF to Excel or combine data from multiple files to a single Excel table. 📜👇 For sample credit card statements (to practice) and more visit ======================================================= https://chandoo.org/wp/extract-data-from-pdf-to-excel Timestamps: ============== 0:00 - Intro 0:44 - Getting data from one PDF to Excel 2:20 - Fixing problems with PDF import 4:03 -"
YouTube Link 2021-04-14T08:30Z 832K followers, 124.1K engagements
"Forget Complex DAX use this instead in Power BI Power BI's new Visual Calculation feature allows us to do advanced business logic and analytics without the need for complicated (and often messy) DAX. In this video let me demonstrate the power of visual calculations with a cool month on month comparison chart. Learn how to build report and perform data analysis from scratch making your data visualization more impactful. In the video: 0:00 - Demo of Visual Calculation driven sales report 0:25 - Data model for the report 0:50 - Creating the line chart 1:50 - Creating your first visual"
YouTube Link 2026-01-30T15:00Z 834K followers, [----] engagements
"Make an awesome Project Management Dashboard with Excel (Free download Part 1) 💥Ready to use Excel PM Templates - https://chandoo.org/pmt/pmt-index-1.html You are going to LOVE 😍 this awesome Excel Project Management Dashboard. In this detailed and hands-on tutorial let me teach you how you can create an interactive dynamic & beautiful dashboard for managing your projects. In Part [--] of [--] we are going to cover the project plan Gantt chart part. Watch Part [--] 👉 Project progress charts - https://youtu.be/C0F_VKlTX1c and the finale (Part 3) here 👉 https://youtu.be/Exlj5qH0rhc 💻👉Please"
YouTube Link 2021-05-12T08:45Z 832K followers, 276K engagements
"Powerful trick to combine all Excel files in a folder AUTOMATICALLY Need to automatically combine all files in a folder to One Excel workbook You are going to love this completely automatic way. This simple but insanely time saving trick uses Power Query to combine files in a folder. In this video 👇 ============== 0:00 - Introduction to the combine files problem 0:36 - A quick look at the folder & one of the files 1:10 - Combining the files with "Get Data Folder" option in Excel 2:36 - Cleaning up the file data with Power Query rules 5:32 - Loading the data to Excel 5:55 - What happens"
YouTube Link 2021-11-30T08:00Z 831K followers, 350.2K engagements
"Make an AMAZING Dashboard with Power BI - End to End Tutorial +Files 💥 $50 Discount on my Power BI Course: Go to https://chandoo.org/wp/power-bi-course/ and use code SAVE50 In this video: ✔ How to design the Power BI report for EIC insurance company ✔ Writing DAX to calculate important KPIs ✔ Using "NEW" card visual and adding conditional formatting ✔ Custom bar chart design ✔ Emoji trick for AWESOME labels ✔ Working with Ribbon charts ✔ Layering "donut" charts to make an impossible chart ✔ Using Scatter Plots + Symmetry Shading to find insights ✔ Finding profitable segments for insurance"
YouTube Link 2025-03-21T09:20Z 832K followers, 117.2K 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 832K followers, 321K 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 834K followers, 11.7K engagements
"5 Advanced lookup tricks that Data Analysts need to know VLOOKUPS & coffee drive most of the world's economy. No kidding. In this video let me present you with [--] advanced tricks when working with Excel's most used function - The VLOOKUP. These tricks are 1) Pattern matching 2) Looking up in two tables 3) Multi-column results 4) Combine all matches with IF 5) A better function 👉 Get my Excel Lookups Crash Course on SkillShare 💻 =============================================== https://chandoo.org/lookups You will get FREE [--] month premium access 🎁 when you join with the above link. Video"
YouTube Link 2021-07-06T08:45Z 833K followers, 84.9K engagements
"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
"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
"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 834K followers, 24.2K engagements
"VBA vs. Python - Which is better Visit https://squarespace.com/chandoo to save 10% off your first purchase of a website or domain. Are you a data analyst and not sure if you need to either VBA or Python In this video let me compare these languages and share my opinion & guidance. In this video: ============= 0:00 - Introduction & [--] parameters 0:45 - Ease of learning (parameter 1) 1:27 - Immediate application (2) 2:55 - How many places can we use the language (3) 3:49 - Forgiveness of a language (4) 4:41 - Availability (5) 5:30 - Automation ability (6) 6:58 - So which one to learn 8:55 -"
YouTube Link 2021-07-22T08:30Z 834K followers, 139.9K 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 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 834K 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, 225K 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 834K followers, 303K 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, 596K 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.2K 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.8K 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 834K followers, 127.4K 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, 546K 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.1K 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.7K 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.1K 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, 262K 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
"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 834K followers, 49K 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
"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.8K 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.8K 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 834K followers, 434K 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 834K followers, 480.5K 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
"Reverse Lookup in Excel Made Super Easy When you need to lookup from the bottom chandoo chandoo.org Excel spreadsheets chandoo chandoo.org Excel spreadsheets"
YouTube Link 2025-10-29T09:30Z 834K followers, 17.1K 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, 209K 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 834K followers, 111K 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 834K followers, 76.9K 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 834K followers, 389.9K 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.2K 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 834K followers, 14.6K 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.1K 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, 814.5K 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.4K 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.6K 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.8K engagements
"10 Advanced IF formulas every analyst should know Almost 70% of spreadsheets contain IF formula. So how well do you know it In this ADVANCED video learn all about: -- Using IF to check ONLY One of condition -- Any Two out of Three conditions -- Between condition with MEDIAN function -- Replacing nested if formulas with NEW IFS function -- Speeding up IF logic with Boolean replacement hack -- Check List membership -- Using Arrays with if (MedianIF example) -- Wildcard comparisons in IF formula -- Using IF with Conditional Formatting -- IF + Charts for awesome results Timestamps:"
YouTube Link 2021-03-31T07:45Z 801K followers, 225K 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 834K followers, 24.4K engagements
"Top [--] Advanced Excel Tricks for Data Analysis - FREE Masterclass with Sample Files Want to analyse data in Excel but don't want to waste hours In this crisp & informative live stream learn my favourite top [--] tricks for getting things done in Excel fast and right. We are going to learn: 1) NEW Dynamic Array functionality in Excel 2) NEW Text processing functions 3) Forecasting with a single click 4) Quick analytics 5) Conditional Formatting 6) How to combine two tables of data 7) Pivot Tables ++ 8) Instant Dynamic Chart 9) Even Better Dynamic Chart 10) Getting more out of your data Video"
YouTube Link 2023-10-14T04:35Z 539K followers, 241.8K engagements
"Data validation without duplicates - Excel Tricks #ExcelDropDownBox #DataValidationExcel Validating your data as you type can prevent any surprises when you are doing analysis / follow-up on the data. Thankfully Excel has the right tools to do it. In-cell drop-down lists or combo boxes can assist you in picking up a value from a valid list to enter in a cell. But what if you want to set up data validation list without duplicates For example workbook and more tips on Data Validation dropdown boxes visit ========================================= https://chandoo.org/wp/excel-add-drop-down-list/"
YouTube Link 2019-09-27T09:46Z 793K followers, 76.8K engagements
"HR Data Analytics & Awesome Dashboard with Power BI 💡: End-to-End Project 💥 Want more Join my full Power BI course: https://chandoo.org/wp/power-bi-course/ Learn how to analyze HR (Human Resources) data and create stunning dashboards using Power BI with this complete masterclass. You are going to learn: Loading data into Power BI and cleaning it with Power Query Creating HR metrics like headcount avg. leave balance avg. salary etc. with Power Pivot Adding columns to the data (like Employee's first name age group etc.) Finding relationships between salary and education qualification Using"
YouTube Link 2023-09-19T08:00Z 789K followers, 152K engagements
"Interactive Sales Chart in Excel & How it works Visit http://chandoo.org/wp/2012/05/09/interactive-sales-chart-in-excel/ to get the excel workbook and know more about this. Interactive Sales chart using Microsoft Excel"
YouTube Link 2012-05-09T05:04Z 732K followers, 74K engagements
"Power BI: Free vs. Pro vs. Premium - which one should YOU get Power BI comes in three flavours - Vanilla Chocolate Chip & Mango. I am kidding of course. The three variants are Free Pro & Premium. So which one should you go for Let's unravel in this video. Get Power BI from here - https://powerbi.microsoft.com/en-us/pricing/ In this video ============ 0:00 - Power BI FREE vs. PRO vs. PREMIUM options 0:40 - Power BI FREE 1:28 - Power BI PRO & PREMIUM options (what is the difference) 4:01 - Which option is good for you More on Power BI 💡 ================ What is Power BI and how to use it (👌"
YouTube Link 2022-11-29T07:00Z 734K followers, 81.5K engagements
"A simple trick to create user friendly Excel dashboards If you have a dashboard that is very long or spans across multiple tabs consider using multiple form controls that link to same cell. For example workbook visit http://chandoo.org/wp/2015/08/16/dashboard-form-controls-trick/"
YouTube Link 2023-10-21T00:45Z 536K followers, [----] engagements
"5 Power BI Card Tricks not many know - Use them to improve your reports Want to impress your boss with Power BI Then use these [--] AMAZING Card visual tricks. The tricks are [--] Stylized Card [--] Color Changing Card [--] Left aligned Card [--] Card / Chart [--] Special Secret Trick to work with cards faster SAMPLE FILE 📙 ============= Download the sample file from here. It has the [--] cards a full data model so you can practice. https://files.chandoo.org/pbix/5%20Card%20Tricks%20done.pbix Learn more from here - https://powerbiprof.com/the-humble-card-visual/ TIME STAMPS 👉 ================= 0:00 - What we"
YouTube Link 2022-01-18T08:00Z 791K followers, 80.8K engagements
"Super Layout Tricks for Excel Pivot Tables #pivottablelayouts #advancedpivottabletricks By default pivot tables are incompact layout.But you can change the layout appearance and position of fields to create completely new reports. In this video tip I will show you several powerful layout ideas to try next time you are making a pivot table. For example workbook and resources visit: https://chandoo.org/wp/advanced-pivot-tables/"
YouTube Link 2020-02-27T02:49Z 787K followers, 38.3K engagements
"Make an AWESOME Employee Dashboard with Power BI (Adv. DAX) 💥Master Power BI for data analysis with my course 👉 https://chandoo.org/wp/power-bi-course/ Power BI is great for generating HR reports employee reports and dashboards. In this video learn how to use Power BI Power Query Power Pivot DAX SVG Measures and visual design to create an impressive employee attendance dashboard. 📁Get the files: Sample data: https://github.com/chandoo-org/Power-BI/blob/main/SVG/emp_attendance_data.xlsx Demo report:"
YouTube Link 2025-06-17T13:00Z 804K followers, 19.1K engagements
"Advanced Pivot Table Tricks #9.1 - Grouping Data without Data Model #groupingDataInPivots #GroupDatesExcelPivot #GroupWithoutDataModel If your pivot tables are NOT from data model you can group any fields. Dates can be grouped in to days / months / quarters / years Numbers can be grouped by chunks Text can be grouped by selecting items on the report Here is a video detailing grouping options for non-data-model pivots. For example workbook and resources visit: https://chandoo.org/wp/advanced-pivot-tables/"
YouTube Link 2020-02-27T02:49Z 786K followers, 14.9K engagements
"How to Make Cool Male vs Female Charts in Excel Need to compare Male vs. Female values Use this cool interactive technique to impress everyone in the next meeting. 📁Sample file: https://chandoo.org/wp/wp-content/uploads/2025/04/male-vs-female-chart-demo.xlsx 💥Adv. Excel Course: https://chandoo.org/wp/excel-school-program/ 🤯 Things you will learn in this video: ☑ How to set up Male & Female "stencils" in PowerPoint ☑ Using XLOOKUP + Data Validation to create a dynamic chart in Excel ☑ Axis formatting tricks to get the scaling right 📺 Other Charting Videos You WILL Enjoy: Colum Chart with"
YouTube Link 2025-04-29T13:00Z 753K followers, [----] engagements
"How to calculate weighted average in Excel (using SUMPRODUCT) #WeightedAverage #SUMPRODUCT #SUMOPRODUCT #WeightedMeanExcel Today we will learn how to calculate weighted averages in Excel using formulas. What is weighted average Weighted average or weighted mean is defined as from wikipedia The weighted mean is similar to an arithmetic mean . where instead of each of the data points contributing equally to the final average some data points contribute more than others. . If all the weights are equal then the weighted mean is the same as the arithmetic mean. For example workbook and more"
YouTube Link 2019-09-19T08:48Z 786K followers, 10.1K engagements
"BonaVista ChartTamer - Review by Chandoo.org Bonavista Chart Tamer excel add-in reviewed by http://chandoo.org/wp"
YouTube Link 2009-05-02T07:54Z 779K followers, [----] engagements
"Make a Fully Interactive & AWESOME Project Management Dashboard with Excel // The Final Part This is the last part of our EPIC Project Management Dashboard with Excel tutorial. Watch previous videos here: Part [--] - Gantt chart & Project Plan creation - https://youtu.be/FXnyKU6xZeI Part [--] - Project Traffic Light chart - https://youtu.be/C0F_VKlTX1c In this video learn how to: The colours fonts & icons of the dashboard Dynamic upcoming activities / issues table Dashboard KPI tiles Embedding Gantt chart into the dashboard Staff resource loading table Updating dashboard when you have new data"
YouTube Link 2021-06-10T08:30Z 772K followers, 62K engagements
"How I made $100K as Excel Freelancer - [--] life lessons + [--] tips for you I have been freelancing in the Excel & data analysis field since late [----]. In this video I share [--] stories from my freelancing journey and give you [--] practical tips to be a successful freelancer in the data space. 🧰 RESOURCES FOR FREELANCERS Check out this page for a list of resources tips & ideas for freelancers - https://chandoo.org/wp/resources-for-freelancers/ Upwork: https://upwork.pxf.io/kjX1Rn Fiverr: https://go.fiverr.com/visit/bta=419794&brand=fiverrhybrid PS: I am using affiliate links for upwork & fiverr. 📘"
YouTube Link 2022-06-21T08:00Z 739K followers, 743.8K engagements
"How to Clean Analyze and Present Data with Excel (FREE Adv. Course) You asked for it. Here is my free course on advanced data analytics. 💥Want more. get my Excel School program 👉 https://chandoo.org/wp/excel-school-program/ In this comprehensive video learn: 1) How to approach a data analysis project 2) How to systematically clean data 3) Doing EDA with Excel formulas & tables 4) How to use Power Query to combine two datasets 5) Statistical Analysis of data 6) Using formulas like COUNTIFS SUMIFS XLOOKUP 7) Making an information finder with your data 8) Male vs. Female Analysis with Pivot"
YouTube Link 2023-06-13T08:00Z 639K followers, 395.2K engagements
"Power BI Field Parameters - Why & how to use them The latest Power BI feature - FIELD PARAMETERS can drastically change the way you and I make visuals for our reports. In this quick and to the point demo let me show how we can implement then for improved story-telling. 🟧Download the sample file 👇 ========================= Download the sample file & play with this cool feature - https://files.chandoo.org/pbix/field-parameters-demo.pbix In the video: ============ 0:00 - Field Parameters in Power BI 1:28 - Enabling Field Parameters 2:03 - Field parameters for measures 4:25 - Field parameters"
YouTube Link 2022-05-31T08:00Z 788K followers, 68.8K engagements
"Dynamic Dashboard using Excel - a Tutorial Learn how to use Excel Pivot Tables and Slicers to create dynamic dashboards from your data. A tutorial from Chandoo.org To download the example workbook visit http://chandoo.org/wp/2010/12/08/dynamic-dashboard-video-tutorial/"
YouTube Link 2010-12-08T07:38Z 801K followers, 222.9K engagements
"Power Query MAGIC ⚡Auto-Categorize Text Like a PRO A Power Query PRO trick to help us clean and "automatically tag" data based on a rules table. This time-saving automation has been helping me a lot with "rules-based text classification" and I am excited to share it with you. What you are going to learn 💡 ======================== 1) The challenge of "tagging" or "categorization" based on rules table. 2) Using Text.Contains and the limitation 3) Introducing "loops" ♾ in Power Query with List.Accumulate() 4) Using List.Accumulate with a custom function 5) How to convert our rules logic into an"
YouTube Link 2025-03-11T12:00Z 735K followers, [----] engagements
"3 useful VLOOKUP tricks ✨ in one minute #Shorts #shorts #vlookup [--] creative and useful VLOOKUP tricks in one minute. [--]. Use * or as wild cards [--]. Add up or average multiple columns by using them in column_number option like [----] [--]. Deal with extra spaces by using TRIM on the lookup value More on VLOOKUP =============== Video - https://youtu.be/8rtvDQVQaA0"
YouTube Link 2021-04-09T08:44Z 804K followers, 136.3K engagements
"Stop Dragging in Excel there is a BETTER way Stop dragging in Excel. Use this better and improved way to get what you want. Introducing the SEQUENCE() in Excel. It puts FUN in Functions. We can use it to get numbers texts dates and even improve your formulas. [--] AWESOME examples to get started: SEQUENCE(1000) - makes [----] numbers row-wise ➡ SEQUENCE(1000) - makes [----] numbers column-wise 🔠 SEQUENCE(10 10) - makes 10x10 grid of numbers [--] to [---] 🟠 ="INV" & SEQUENCE(1000) - makes [----] invoice numbers starting with INV1 INV2. INV1000 📅 SEQUENCE(365 "1-JAN-2025") - makes all the [---] days of 2025"
YouTube Link 2024-12-03T12:00Z 680K followers, 25.8K engagements
"3 Things I do in my new Job to Succeed as a Data Analyst Recently I started a new job as a "BI Developer". Here is my playbook to quickly impress & succeed in any new job. The BLS Rule. B = Learn about the business L = View new job as an opportunity to LEARN new things S = Start small + bonus A = Use AI to get a head start #newjob #careeradvice"
YouTube Link 2025-09-02T13:00Z 796K followers, [----] engagements
"Pivot Tables in Excel - Intro & Step-by-step tutorial #PivotTables #ExcelPivots Excel pivot tables are very useful and powerful feature of MS Excel. They are be used to create instant summaries reports and data analysis from your raw data. In this comprehensive Pivot Tables Tutorial learn what is a Pivot Table how to create one how to filter & sort them changing the calculations and many other tips. Download sample data & learn more from below page. https://chandoo.org/wp/excel-pivot-tables-tutorial/"
YouTube Link 2020-02-04T09:30Z 786K followers, 43.1K engagements
"What is Excel and How to use it Introduction to Microsoft Excel - This is part [--] of [--] in the series - Excel Baby Steps. UPDATE - October 2021: I have created a new version of this video with latest Excel information and bit more detail. Please watch the updated tutorial here 👉 https://www.youtube.com/watchv=F7aPazuS8QY Visit https://chandoo.org/wp/excel-basics/ for more information Other Excel Videos for beginners: =========================== [--] (LATEST UPDATE) Excel beginners - complete crash course (30 mins) - https://youtu.be/F7aPazuS8QY [--] Excel for data analysis - Beginner to PRO video"
YouTube Link 2010-08-10T08:41Z 731K followers, 2.7M engagements
"A day in the life of a data analyst in New Zealand Do you wonder what a data analyst does all day I recently started a new job with NZ Govt. and in this video I share how my day looks like what I do what tools & tech I use what I like and hate about the job. In the video: ============= 0:00 - Day in the life of a data analyst 1:28 - My job and what I do 2:38 - My team 3:02 - How does my week look like 4:31 - Typical Data Analysis task that I do 5:05 - What tools & software I use 7:30 - What I like about this job 10:21 - What I don't like much 11:42 - Closing thoughts and how to be a data"
YouTube Link 2022-10-11T07:00Z 784K followers, 66.7K engagements
"Introduction to Forecasting in Excel Learn how to use the awesome Forecasting feature of Excel [----] / [----] / [---]. We will learn about time series forecasting seasonal fluctuations and confidence intervals too. For downloadable workbook and more resources visit https://chandoo.org/wp/forecasting-in-excel/"
YouTube Link 2016-07-27T06:28Z 771K followers, 51K engagements
"9 box grid - talent mapping - Excel for HR People - Template & Explanation video [--] box grid is a popular methodology used in talent mapping. Staff are rated on a [--] point scale for their potential & performance. Then they are plotted in a 3x3 grid (9 box) to see who sits where. In this video let me explain how to create such a talent mapping template and tracker using Microsoft Excel. While this approach is immediately helpful for anyone in HR the formula / pivot techniques can be used by anyone. So I suggest you to watch this if you want to learn some innovative formula and pivot table uses."
YouTube Link 2020-11-17T07:00Z 791K followers, 67.2K engagements
"How to create risk map in Excel - Charting Tip #ProjectManagement #RiskManagement #RiskMapInExcel Risk maps are useful for visualizing project risks by impact and likelihood. We can use Excel formulas (TEXTJOIN) and simple tables to create them in minutes. In this tutorial learn how to make your own project management risk map with Microsoft Excel. FREE Risk Map Template ===================== https://chandoo.org/wp/excel-risk-map-template/ Looking for more on Project Management =================================== Fully Interactive Project Management Dashboards - [--] part video series [--] Part 1"
YouTube Link 2019-08-28T08:00Z 789K followers, 101.3K engagements
"Now you can get stock prices in Excel with STOCKHISTORY() function Excel [---] has a new & shiny function - STOCKHISTORY() using which you can pull stock prices in excel historical trends for your analysis. In this video learn all about: * The new STOCKHISTORY function - what is it and how to use it in Excel * Specifying exchange and symbol (ticker) code in STOCKHISTORY() * Historical prices (quotes) by day week or month * Using STOCKHISTORY to get currency exchange rates - USD to INR conversion * How to use STOCKHISTORY() function to make a simple portfolio tracker worksheet Video Timestamps:"
YouTube Link 2021-03-15T07:45Z 787K followers, 40.6K 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 834K followers, 19.7K engagements
"XLOOKUP vs. INDEX MATCH - Which is faster Ever wonder what is the fastest lookup function in Excel In this experiment style video I test VLOOKUP vs. INDEX+MATCH vs. XLOOKUP by writing [--] million formulas. The results are surprising Note: there is no sample file for this video (the dataset is rather large but feel free to make some random data in Excel to test the concepts yourself). In this video: ============= 0:00 - Fastest lookup formula in Excel 0:26 - Dataset and testing methodology 2:31 - Writing the VLOOKUP formula 3:34 - INDEX MATCH formula 4:34 - Faster INDEX MATCH formulas 6:32 -"
YouTube Link 2022-08-02T08:00Z 745K followers, 32.1K engagements
"Make an Excel Dashboard in just [--] minutes Do you run an ecommerce business or website You can use this beautiful simple and useful website metrics dashboard to see how everything is going on. This dashboard is easy to work with and you can set it up in less than [--] minutes. For the dashboard template and more visit https://chandoo.org/wp/website-dashboard-template/ Also if you want more customizeable dashboard templates consider my ready to use Excel dashboard pack - https://chandoo.org/dbt/index.html #dashboards #websiteKPIs #websiteDashboard #ExcelDashboardTutorials"
YouTube Link 2020-04-28T09:05Z 786K followers, 30.9K engagements
"Make an interactive distribution curve (bell curve) in Excel - Easy Trick 💡 Excel Bell curves or frequency distribution curves are handy for analysing and understanding distribution of your data. Recently someone asked me to make a bell-curve to visualize salary distribution of staff. While you can use formulas or complex techniques to make these I used a simple trick to make the bell curve and add interactive effect to it. Needless to say my clients were impressed. Let me show the method in this video and take it to next level. Time stamps for the video: ==================== 0:00 - The bell"
YouTube Link 2021-04-07T09:00Z 795K followers, 45.9K engagements
"The BEST Excel tricks are often the SIMPLEST - Here is the proof Simple yet Powerful. That is the name of the game. 0:24 - TRICK 1: Auto number as you type 3:09 - TRICK 2: Auto highlight when values change more than 10% 6:37 - TRICK 3: Make sure the total adds up to 100% 💥 Want more Check out my Advanced Excel Course - https://chandoo.org/wp/excel-school-program 🎟 GET10% discount with code [--------] #excel #tricks"
YouTube Link 2025-05-20T13:00Z 763K followers, 17.3K engagements
"Beyond Power BI - Data Skills You need in [----] to GROW 🚀 Want to grow your data career and skills in [----] Then you need to think beyond Power BI. In this video let me share my approach for growing your data skills using "value chain analysis". The key skills you want to gain are: 📚 Data engineering & SQL 📚 Coding (for data - like Python) 📚 User interaction skills 📚 Business domain skills 📚 Other BI / Analysis tools - Tableau Excel Python 📚 Forecasting data insights 📚 AI Machine learning GPTs Videos you should check out: SQL - https://youtu.be/l8DCPaHc5TQ Data Engineer vs Data Analyst"
YouTube Link 2025-02-04T12:00Z 716K followers, 14K engagements
"Make a BEAUTIFUL Budget vs. Actual chart in Excel 📊😍 (with adv. tricks) 💥Download FREE Zebra BI tables add-in here 👉 https://bit.ly/3TAATU3 Ever wanted to make an impressive kickass budget vs. actual (or plan vs. actual or target vs. actual) chart In this simple but effective tutorial let's build one using Excel. We are going to use few little-known tricks to make our chart truly extraordinary. Let's GO SAMPLE FILE 👇 ============= Need a hand with this chart Check out the sample file here - https://chandoo.org/wp/wp-content/uploads/2022/10/kickass-budget-vs-actual-chart-1.xlsx VIDEO"
YouTube Link 2022-10-25T07:00Z 669K followers, 72.9K engagements
"Calculate distance and travel time between places using Google Maps API in Excel Here is something fun and useful. Ever wanted to calculate distance between points travel time using Excel See a demo of the technique and visit https://chandoo.org/wp/distance-between-places-excel-maps-api/ for more and sample workbook"
YouTube Link 2018-07-19T09:16Z 787K followers, 24.3K engagements
"Data cleaning in Excel - [--] tricks PROs use all the time Good data is the cornerstone of great analysis. In this video learn [--] powerful yet EASY ways for data cleaning in Excel that not many know. The tricks you will learn are 0:00 - Introduction 00:18 - Extracting first name with Flash fill feature of Excel 1:47 - Converting numbers to percentages 3:18 - Remove blank cells or rows using Goto special 4:43 - Find common values between two lists 5:32 - Clean-up ugly formats with one click 6:15 - Bonus trick #1 - Remove extra spaces 7:30 - Unstack data easily with simple formulas 9:44 -"
YouTube Link 2021-03-10T08:27Z 791K followers, 538.2K engagements
"I don't use PIVOT tables anymore. I use this other thing instead That is right I no longer use Pivot Tables in Excel. I am now using Power Pivot. In this video let me show you what Power Pivot is and how to use it with Excel. Plus you get to meet Chan2 again 😂 VIDEO TOPICS: =============== 0:00 - What is Power Pivot and how to create one in Excel 1:12 - Why use Power Pivot instead of regular Pivot Tables 3:25 - Practical example of Power Pivot & DAX 📺 LEARN MORE ABOUT POWER PIVOT & DAX: ======================================= Beginner to PRO DAX Lesson with 20+ examples -"
YouTube Link 2023-06-27T08:00Z 792K followers, 1.4M engagements
"How to Present Data for Executive Audience - FREE Masterclass with Sample Files 🚀 Free Excel & Power BI templates: https://bit.ly/3FunWpB 👉 Register for my workshop "How to Build a Business Performance Excel Dashboard with ChatGPT": https://bit.ly/3s5dqBR Join me for this amazing masterclass on how to create and present visuals for compelling story-telling for c-level audience. We are going to talk about [--] concepts and how to implement them using Microsoft Excel. Sample data files will be provided. The session will be for [--] minutes. Get the sample data file here -"
YouTube Link 2023-10-27T18:32Z 537K followers, [----] engagements
"How to connect two tables in Excel - With Example Workbook When I was working as a HR data analyst one task I would do every week is combine data in two different tables. In this video let's look at two ways to solve the problem. One using formulas and another with Power Query ⚡. Both methods are really simple to set up and will save you TONS of time in the long run. Video topics 👇 ============== 0:00 - Combining two tables in Excel - the problem 1:15 - Using lookup formulas to combine tables (with XLOOKUP) 2:18 - Using VLOOKUP to combine tables 3:04 - Using Power Query to join two tables"
YouTube Link 2022-07-05T08:00Z 677K followers, 163.8K engagements
"Make a Pivot Table in Excel This video tutorial by Chandoo.org explains how to make a pivot table in Excel in less than [--] seconds"
YouTube Link 2009-08-24T20:28Z 786K followers, 184K engagements
"Don't tell my boss but AI is doing all my Excel work now 🤫 I have been using CoPilot to work faster with Excel. Don't tell my boss though he thinks I am doing all the hard work 😎 In this video: ========== 0:00 - What is CoPilot for Excel and how to enable it 1:30 - How to use CoPilot to clean your data 3:13 - Using CoPilot to write formulas 4:48 - CoPilot and natural language queries 6:58 - Complex analysis scenario with CoPilot 8:52 - Making Pivots with CoPilot 10:12 - Tips & Tricks of using CoPilot 11:16 - Asking CoPilot to find insights on its own 13:04 - Alternatives to CoPilot in Excel"
YouTube Link 2024-09-03T08:00Z 749K followers, 152.7K engagements
"How to set up and use Calculation Groups in DAX Power BI Do you know about the CALC. GROUPS feature of DAX This powerful "PRO" feature is a massive timesaver when it comes to building reusable business logic in Power BI. In this video I explain how to set up and use calc. groups in Power BI with a practical example. Get the sample file - https://files.chandoo.org/pbix/calc-groups-demo.pbix Get my full Power BI course - https://chandoo.org/wp/power-bi-course/ #PowerBI"
YouTube Link 2023-12-12T07:00Z 786K followers, 39K engagements
"5 Tricks Power BI PROs use to Create Amazing Dashboards 👩💻 Make your Power BI reports engaging and binge-worthy with these [--] simple but effective rules. 1) Design charts for readability 2) Write better titles 3) Formatting each chart for the message 4) Use card tricks 5) Create a wireframe Video Timestamps: =================== 0:00 - "Before" & "After" Power BI Reports - Quick demo 0:19 - Rule #1 - Design charts for readability 1:43 - Rule #2 - Write better titles 3:00 - Rule #3 - Formatting each chart for the message 4:10 - Rule #4 - Card tricks to improve your dashboards 6:04 - Rule #5 -"
YouTube Link 2023-10-10T07:17Z 540K followers, [----] engagements
"How to "BUILD" Excel Formulas - [--] Advanced Examples Want to become an Excel PRO Then you must build your formula skills. In this in-depth video I share how I solve [--] real world problems with advanced Excel formulas. Watch my build and learn. EVERYTHING WILL BE AWESOME The formulas are 1) Best Student name by GPA 2) Best sales person in a location 3) Extracting last name from text 4) Multiple IF Condition 5) Manager's manager mystery Video timestamps👉 =================== 0:00 - Introduction to complex formulas 1:28 - (1) Best GPA student name formula 2:37 - Second highest GPA student 3:27 -"
YouTube Link 2021-12-07T08:00Z 769K followers, 83.2K engagements
"6 Massively time saving Pivot Table tricks (Don't miss #4 & #6) Pivot Tables are very useful. I have blogged and made videos about them many times already. But in this video let me share some of my most favourite time saving tips. For more on this video visit - https://chandoo.org/wp/pivot-table-time-saving-tricks/ 0:00 - Intro 0:51 - Double click to expand details of Pivot 1:37 - Format quickly with this right click option 2:20 - Include filtered items in subtotals 4:05 - Consistent axis in Pivot Charts 5:08 - Repeat item labels in tabular layout 5:55 - Multiple pages with Report filters"
YouTube Link 2020-07-06T07:30Z 787K followers, 50.6K engagements
"This Amazing VLOOKUP Trick Works Across Multiple Sheets 🚀 Do you want to VLOOKUP but in across sheets Then you need this mind-blowing 🤯 trick. 📁 Sample file: https://chandoo.org/wp/wp-content/uploads/2025/03/vlookup-any-sheet.xlsx 💻 10% OFF My Excel Course - https://chandoo.org/wp/excel-school-program/ 🎟 use code SUMPRODUCTIF In this video: 1) How to lookup across multiple sheets 2) Introducing VSTACK to combine all the data 3) Using LET and variables 4) Getting Qty Date & other details with one spillable formula 5) What if multiple matching values are there - using FILTER 🕛 Video"
YouTube Link 2025-03-05T12:01Z 728K followers, [----] engagements
"3 Quick tips to get better in Excel formulas [--] - Know how to use Excel references - Table & cell refs [--] - Learn the basic formulas - SUMIFS COUNTIFS XLOOKUP VLOOKUP FILTER IFERROR [--] - Break complex formulas to small steps Helpful tutorial links: ================= 1) Using references in Excel Video - https://youtu.be/4MVNjzsGokc Articles - -- Cell refs - https://chandoo.org/wp/relative-absolute-references-in-formulas/ --- Table refs - https://chandoo.org/wp/introduction-to-structural-references/ 2) Basic Excel functions SUMIFS & COUNTIFS - https://youtu.be/YEt-aYbDTrs IF -"
YouTube Link 2021-08-09T08:30Z 767K followers, 140K engagements
"Excel Trick You Didnt Know For Ranking Values Excel doesn't have DENSE RANK. But sometimes that is exactly what we need. In this video learn how to use UNIQUE() with LARGE or SORT to create dense rank in Excel just like how it is in SQL. Sample file: https://chandoo.org/wp/wp-content/uploads/2025/08/dense-rank-excel.xlsx More Excel formulas: https://www.youtube.com/playlistlist=PLmejDGrsgFyDUK8Q_CfZEtQvmRqV0UMm_ #excel #sql #rank"
YouTube Link 2025-08-12T13:00Z 789K followers, [----] engagements
"Top [--] Power BI Interview Questions (based on what I usually ask) 💥 FULL Power BI Course - https://chandoo.org/wp/power-bi-course/ Got a Power BI interview coming up. Make sure you know answers to these [--] questions. 0:00 - Top [--] Power BI Interview Questions 0:46 - Explain the difference between a measure and a calculated column. 2:05 - Describe the process of publishing a Power BI report to the service 3:21 - How would you handle missing data 5:30 - What is DAX and give us an example of recent DAX formula you've used 7:22 - How do you connect multiple data sources to a Power BI Report 8:12"
YouTube Link 2023-10-31T07:00Z 800K followers, 316.9K engagements
"New vs. Returning Customers Analysis - Awesome DAX in Power BI 🤩 💥 Sign up for FREE Power BI Live on DAX this weekend 👉 https://chandoo.org/wp/liveclass/ Learn the DAX concepts for performing New vs. Returning customer analysis in Power BI. ✅ Calculate Unique Customer Count ✅ Get "returning" customer count using SUMX and CALCULATE ✅ Alternative approach of using INTERSECT dax function ✅ Visualizing customer data ✅ Enhancing customer analysis with "windows" 📁 Sample Power BI file https://1drv.ms/u/c/e7c6dec249ad257b/EWnD_9DRzfpIsdrF54oGvP4BQ5f20TpogwzBEX4o7oyKMQe=2OjfcT 📁 Sample Data file"
YouTube Link 2025-04-08T13:00Z 746K followers, [----] engagements
"Power BI is EASY: Get started and make your first report in [--] mins 🕐 Microsoft Power BI is the hottest and most widely sought after skill for data analysts everywhere. In this video we will be covering Introduction to Power BI: how to get started with Power BI including downloading and installing Power BI Desktop loading data and creating visuals and tables. Creating a Business Report: step-by-step process of creating a complete business report using Power BI from loading sample data to formatting visuals and sharing the report with others. Power BI Interface: the main areas of the Power BI"
YouTube Link 2024-10-08T12:00Z 793K followers, 155.4K engagements
"3 POWER BI TRICKS"
YouTube Link 2025-04-07T13:00Z 746K followers, [----] engagements
"Scan Data into Excel effortlessly with these [--] tricks 💥PROMO Get the CSUR ET18 Pro scanner from https://bit.ly/3m52dLr Use code CZURFZ to get 15% fan discount. Got several documents with data that needs to go to Excel You can use these two tricks to do it easily. Option 1: Use Office App & Scan Table option Option 2: Use a professional scanner (CZUR ET18) 🔗🔗🔗 Links: ============= Download Office App (andriod) - https://play.google.com/store/apps/detailsid=com.microsoft.office.officehubrow&hl=en_NZ&gl=US Download Office App (iOS) - https://apps.apple.com/us/app/microsoft-office/id541164041"
YouTube Link 2022-02-22T08:00Z 771K followers, 214.1K engagements
"How I would make the perfect entry-level data resume in [----] (in [--] easy steps) 🎉 Unlock AI for $10 per month https://ntn.so/Chandoo2 Make the perfect entry level data resume with three easy steps. Step 1: Set up your resume for success with a clear and well-defined template. Then customize it for the job you are applying for. Step 2: Build Impact with Limited Experience by highlighting "transferable" skills using ATR style bullet points and creating a strong summary to reflect your passion. Step 3: Stand out with personal branding and social media presence by setting up LinkedIn & GitHub"
YouTube Link 2024-11-12T12:00Z 671K followers, [----] engagements
"Why Are Cumulative Averages So Hard in Excel (and an easy fix 👌) Cumulative or Running Averages are hard to calculate in Excel. In this video let me explain the challenge and show [--] easy ways to calculate them. Sample file: https://chandoo.org/wp/wp-content/uploads/2025/02/cumulative-average.xlsx How would you do this Leave a comment and let me know. #chandoo #exceltips"
YouTube Link 2025-02-11T12:01Z 728K followers, [----] engagements
"Best Excel Formulas in an hour - Beginner to PRO Masterclass 🎉 Unlock AI for $10 per month: https://ntn.so/Chandoo Here is something that most people get wrong when learning Excel. They learn the functions but not "when" and "how" to use them. So in this masterclass let me tell you "when" and "how" to use Excel functions with [--] business problems. What you will learn in this video: Working with Excel formulas & functions COUNTIFS SUMIFS AVERAGEIFS FILTER Functions multiple criteria CHOOSECOLS function MIN MAX SMALL LARGE SORT + TAKE functions UNIQUE # OPERATOR COUNTA vs. COUNT functions"
YouTube Link 2024-08-27T08:00Z 648K followers, 19K engagements
"How to make variance chart in Power BI to measure performance Do you want to create a variance chart (or visual) in Power BI to measure actual vs. target performance This video explains how to create such a chart with synchronized sorting and interactions. We will use conditional formatting visual grouping to achieve a cohesive simple clean & elegant variance chart in Power BI. For a sample workbook and more visit https://chandoo.org/wp/variance-chart-powerbi/ #VarianceChart #PowerBIVisuals #BudgetvActual #ActualvTarget"
YouTube Link 2020-06-04T08:00Z 785K followers, 81.9K engagements
"Email Excel Reports with Power Automate & Office Scrips - One Click Automation 🤖 Ever wanted to send an email of your Excel report to the relevant people with a single click In this video let me show you how we used Office Scripts & Power Automate to solve the problem. You will learn: Email Automation concept How to use Office Scripts How to set up Power Automate Flows How to integrate Excel with Power Automate & Office Scripts IN THIS VIDEO 👇 ================= 0:00 - Email Automation - Quick demo 2:37 - Setting up the Email Contents in Excel 3:50 - Introduction to Office Scripts 8:07 -"
YouTube Link 2023-03-21T07:00Z 742K followers, 75.6K engagements
"How-to highlight maximum value in charts - Excel tip Ever wanted to highlight maximum value in Excel charts Then this tip is for you. You can easily set up extra series to highlight max min above average values in Excel charts. The trick is to use layering to show values in a way you want. SAMPLE WORKBOOK: ================== https://chandoo.org/wp/how-to-highlight-maximum-value-in-excel-charts/"
YouTube Link 2019-08-07T05:11Z 702K followers, 10.6K 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 834K 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
"Incredibly EASY way to embed your Excel file on a website (will be interactive) Here is an easy way to impress your customers and business partners. Set up an Excel calculator on your website so your visitors can for example see the cost of their order based on latest catalogue prices. You need a website already built Excel file and Microsoft OneDrive account. With just these [--] things you can get your Excel file on to your webpage. Watch this short video and learn how to do it. For more help visit my website: ==============================================="
YouTube Link 2021-03-03T07:45Z 826K followers, 153.6K 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 834K followers, 20.8K 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 834K followers, 12.7K engagements
"COUNTIFS with Date Between - This is a must have formula One of the most common and useful business questions is how many "X" between two dates It could be sales employees on vacation or number of issues raised. In this video learn how to use COUNTIFS to answer the question in Excel easily. chandoo chandoo.org Excel spreadsheets chandoo chandoo.org Excel spreadsheets"
YouTube Link 2025-11-15T12:00Z 834K followers, 27.1K 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
"Second Week Sales Only with SUMIFS (Excel formula) Don't second guess. Just SUMIFS chandoo chandoo.org Excel spreadsheets chandoo chandoo.org Excel spreadsheets"
YouTube Link 2025-10-23T09:30Z 834K followers, 27.5K 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 834K 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 834K followers, 52.5K engagements
"Excel Formula to Show Top Sellers Instantly Top [--] in one cell chandoo chandoo.org Excel spreadsheets chandoo chandoo.org Excel spreadsheets"
YouTube Link 2025-10-26T09:30Z 834K followers, 23.4K 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
"How many days overlap between two projects Excel Formula Magic Find out quickly how many days both projects overlap using this elegant and simple Excel formula chandoo chandoo.org Excel spreadsheets chandoo chandoo.org Excel spreadsheets"
YouTube Link 2025-11-13T12:00Z 834K followers, 24.8K 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 834K 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 834K 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
"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 834K followers, 30.1K 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 834K 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
"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 834K followers, 12.5K engagements
"XLOOKUP MULTI CRITERIA MAGIC #excel Multiple criteria with XLOOKUP using the * operator"
YouTube Link 2025-05-22T13:00Z 817K followers, 33.8K engagements
Limited data mode. Full metrics available with subscription: lunarcrush.com/pricing