Uploaded May 2019 | Updated November 2026, 23 hours ago
Learn for Power Query & PowerBI, How to count the number of occurrences also explains how can we add the index number to the grouped data
00:00 Intro
00:20 Understanding the Data Set
01:10 Loading Data Into Power Query
01:35 Enable Formula Bar In Power Query
02:40 Count the Occurrences Formula
05:10 Adding New Data
05:40 End
๐๐ป Like us on Facebook
facebook.com/ExcelExciting
๐ฅJoin The Facebook Group -
facebook.com/groups/ExcelExciting
***********************************************************
You can check the following videos as well
๐ Handling ๐ Date & Time โณ In Excel (PART 02) โผ๏ธ
youtu.be/hZsilpH0kuw
โโโโโโโโโโโโโโโโโโโโโ
๐Find The Missing Data Based Header Text - PowerQuery
youtu.be/zGZZD6GMCck
โโโโโโโโโโโโโโโโโโโโโ
๐Simple way of using Index & Match explain in detail.
youtu.be/a8zKuoDopEI
โโโโโโโโโโโโโโโโโโโโโ
๐กTip & Trick: Automatically insert decimal point upon entering values (Mac & Windows)
youtu.be/Um44m7HnqqE
โโโโโโโโโโโโโโโโโโโโโ
๐งHow To Install Power Query For Excel 2010 & 2013
youtu.be/uZCXgtPIK9Y
***********************************************************
#PowerQuery #PowerBI #MicrosoftCreators #ProductivityHack
Learn for Power Query & PowerBI, How to count the number of occurrences also explains how can we add the index number to the grouped data
00:00 Intro
00:20 Understanding the Data Set
01:10 Loading Data Into Power Query
01:35 Enable Formula Bar In Power Query
02:40 Count the Occurrences Formula
05:10 Adding New Data
05:40 End
๐๐ป Like us on Facebook
facebook.com/ExcelExciting
๐ฅJoin The Facebook Group -
facebook.com/groups/ExcelExciting
***********************************************************
You can check the following videos as well
๐ Handling ๐ Date & Time โณ In Excel (PART 02) โผ๏ธ
youtu.be/hZsilpH0kuw
โโโโโโโโโโโโโโโโโโโโโ
๐Find The Missing Data Based Header Text - PowerQuery
youtu.be/zGZZD6GMCck
โโโโโโโโโโโโโโโโโโโโโ
๐Simple way of using Index & Match explain in detail.
youtu.be/a8zKuoDopEI
โโโโโโโโโโโโโโโโโโโโโ
๐กTip & Trick: Automatically insert decimal point upon entering values (Mac & Windows)
youtu.be/Um44m7HnqqE
โโโโโโโโโโโโโโโโโโโโโ
๐งHow To Install Power Query For Excel 2010 & 2013
youtu.be/uZCXgtPIK9Y
***********************************************************
#PowerQuery #PowerBI #MicrosoftCreators #ProductivityHack
![VLOOKUP Multiple Match Rows Records [Excel for Mac & Windows]
In this video, we will learn step by step process of extract the multiple match rows records from our data set but not using VLOOKUP. This classic method explained to extract the multiple matching rows records using the new dynamic arrays calculation engine. If you are looking for the new array formula solution, then check out the video on FILTER Function - https://youtu.be/0dlpdQgI3QU
๐ Affiliate links :
- Support me with your Amazon purchases: https://amzn.to/3tR4AUN
- Buy Office365: https://bit.ly/3nKcbnk
๐ฃ Disclosure: Affiliate links, which means there is no additional cost to you. I will receive a small commission if you make a purchase using the links. By doing so youre helping me keep my blog up and running and youre helping me provide for my family so for that I truly thank you for your support. Please only purchase the products if you believe they will add value to you.
๐ https://www.ExcelExciting.com
Connect to our forums feel free to ask for queries & answer them
https://excelexciting.com/forums/
๐๐ปFaraz Shaikh - Excel Master
https://www.facebook.com/ExcelExciting/
๐ฅJoin the Facebook Group -
https://www.facebook.com/groups/ExcelExciting/
***********************************************************
DISCLAIMER: The Talking Emoji If any resemblance with any person, living or dead, is purely coincidental. There is absolutely no intention to hurt any person or group of persons or any section of society through this video. This video is created to impart my understanding of a particular subject for viewers in an easy and fun way.
***********************************************************
You can check the following videos as well
Learn how to use Microsoft Flow / Power Automate
https://youtu.be/HQyxnPYW9Jc
Create Dynamics Flowcharts by connecting EXCEL to VISIO
https://youtu.be/xfIPFiAxQcQ
VLOOKUP Data From Multiple Worksheets [Excel for mac & windows]
https://youtu.be/ROym3e-S4OQ
Trick to Create A Data Entry Table In Power Query for Excel
https://youtu.be/bHPrRbcw6f0
Change Multiple Value using Array Method [Excel for Mac & Windows]
https://youtu.be/c8d3xx8KVl8
***********************************************************
#Excel #FarazShaikh #ExcelExciting #VlookupMultipleMatch #Excel4Mac #Excel4Windows #MicrosoftCreators #ExcelTips #ProductivityHack #MadeWithCamtasia #ExcelForMac #ExcelForWindows #ExcelTricks VLOOKUP Multiple Match Rows Records [Excel for Mac & Windows]](https://i.ytimg.com/vi/pTVxxaZQx24/mqdefault.jpg)


![How to FIX #SPILL! Error in Microsoft Excel [mac & windows]
In this video we will learn how to fix the Microsoft Excel #SPILL! error and we will also understand why #SPILL! errors occur while constructing your formulas.
00:00 Introduction
00:12 About The #SPILL! error?
00:46 Example01 with #SPILL! error
01:47 Example02 with #SPILL! error
03:23 End Screen
๐ Affiliate links :
- Support me with your Amazon purchases: https://amzn.to/3tR4AUN
- Buy Office365: https://bit.ly/3nKcbnk
๐ฃ Disclosure: Affiliate links, which means there is no additional cost to you. I will receive a small commission if you make a purchase using the links. By doing so youre helping me keep my blog up and running and youre helping me provide for my family so for that I truly thank you for your support. Please only purchase the products if you believe they will add value to you.
โฌ๏ธ Download the file
https://excelexciting.com/what-is-the-spill-error-and-how-to-fix-it/
๐ https://www.ExcelExciting.com
Connect to our forums feel free to ask queries & answer them
https://excelexciting.com/forums/
๐๐ปFaraz Shaikh - Excel Master
https://www.facebook.com/ExcelExciting/
๐ฅJoin the Facebook Group -
https://www.facebook.com/groups/ExcelExciting/
***********************************************************
You can check the following videos as well
Extract Multiple Matching Records: https://youtu.be/pTVxxaZQx24
Learn how to use Microsoft Flow / Power Automate: https://youtu.be/HQyxnPYW9Jc
Create Organizational & Business Flowcharts Linked to Excel
https://youtu.be/Cor1mixgotY
Change Multiple Value using Array Method [Excel for Mac & Windows]
https://youtu.be/c8d3xx8KVl8
***********************************************************
#Excel #SPILL! #FarazShaikh #ExcelExciting #MicrosoftCreators #ExcelTips #ProductivityHack #MadeWithCamtasia #ExcelForMac #ExcelForWindows #ExcelOnline #ExcelTricks How to FIX #SPILL! Error in Microsoft Excel [mac & windows]](https://i.ytimg.com/vi/qRunWiF8Wws/mqdefault.jpg)
![How to Add Totals to a Clustered Column Chart in Excel [Step-by-Step Tutorial]
Learn how to enhance your clustered column charts by adding totals with this easy-to-follow tutorial. Discover the simple steps to calculate and display totals in your Excel or PowerPoint clustered column charts.
โฑ Time Stamp
00:00 Intro
00:20 Understanding the problem
01:40 Building the Solution
03:25 Warning with this solution
04:30 Feedback
04:50 End
Handle with VBA
- https://peltiertech.com/chart-udf-control-axis-scale/
- https://exceloffthegrid.com/chart-axis-min-mix/
Credits: Jon Peltier and Mark Proctor. Thank you both!
๐ Affiliate links :
- Support me with your Amazon purchases: https://amzn.to/3tR4AUN
- Buy Office365: https://bit.ly/3nKcbnk
๐ฃ Disclosure: Affiliate links, which means there is no additional cost to you. I will receive a small commission if you make a purchase using the links. By doing so youre helping me keep my blog up and running and youre helping me provide for my family ๐จโ๐ฉโ๐งโ๐ฆ so for that I truly thank you for your support. Please only purchase the products if you believe they will add value to you.
๐ https://www.ExcelExciting.com
Connect to our forums feel free to ask queries & answer them
https://excelexciting.com/forums/
Join our Meetup group Saudi Arabia, Microsoft Excel & PowerPlatform Meetup
https://www.meetup.com/saudi-arabia-microsoft-excel-power-platform-meetup/
๐๐ป Like Facebook Page :
https://www.facebook.com/ExcelExciting/
๐ฅJoin The Facebook Group -
https://www.facebook.com/groups/ExcelExciting/
***********************************************************
You can check the following videos as well
***********************************************************
#Excel #FarazShaikh #ExcelExciting #MicrosoftCreators #ExcelTips #ProductivityHack #MadeWithCamtasia #ExcelForMac #ExcelForWindows #ExcelTricks #excelchart #excelcharts How to Add Totals to a Clustered Column Chart in Excel [Step-by-Step Tutorial]](https://i.ytimg.com/vi/rRe9yS_HloQ/mqdefault.jpg)





![Combine Sheet Into One Master Sheet With VBA [Excel for Mac & Windows]
In this video, we will understand the logic on how to combine sheet code works in Excel For Mac & Windows.
๐ Affiliate links :
- Support me with your Amazon purchases: https://amzn.to/3tR4AUN
- Buy Office365: https://bit.ly/3nKcbnk
๐ฃ Disclosure: Affiliate links, which means there is no additional cost to you. I will receive a small commission if you make a purchase using the links. By doing so youre helping me keep my blog up and running and youre helping me provide for my family so for that I truly thank you for your support. Please only purchase the products if you believe they will add value to you.
Grab the VBA code here
https://excelexciting.com/combine-active-workbook-all-sheets-into-one-master-sheet-with-vba/
๐๐Combine Multiple Excel Worksheets Into One Worksheet | Power Query
https://youtu.be/F5fjv6nXvZo
๐ https://www.ExcelExciting.com
Connect to our forums feel free to ask queries & answer them
https://excelexciting.com/forums/
๐๐ปFaraz Shaikh - Excel Master
https://www.facebook.com/ExcelExciting/
๐ฅJoin The Facebook Group -
https://www.facebook.com/groups/ExcelExciting/
***********************************************************
DISCLAIMER: If any resemblance with any person, living or dead, is purely coincidental. There is absolutely no intention to hurt any person or group of persons or any section of society through this video. This video is created to impart my understanding of a particular subject for viewers in an easy and fun way.
***********************************************************
You can check the following videos as well
Learn In 3 Minutesโฐ How To View Two Sheets Side By Side In Excel
https://youtu.be/dvhqseTo_HQ
How To VLOOKUP & Handle VLOOKUP Error #NA In Excel
https://youtu.be/ugg-NCNscUI
๐ฎExcel Trick : How to Sum the Number With Spaces Or Special Characters
https://youtu.be/dgUu24eUzWw
๐ฎConvert Numbers To Word In Excel (Spell Number) | VBA
https://youtu.be/eMA39dU3UOE
***********************************************************
#FarazShaikh #ExcelExciting #MicrosoftCreators #ExcelTips #ProductivityHack #MadeWithCamtasia #ExcelForMac #ExcelForWindows #ExcelTricks Combine Sheet Into One Master Sheet With VBA [Excel for Mac & Windows]](https://i.ytimg.com/vi/sIxZP3aRyU8/mqdefault.jpg)