Category: Excel


Deprecated: Creation of dynamic property ternplugin\youtube_video::$post is deprecated in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/automatic-video-posts/vendor/ternstyle/plugin/src/class/youtube_video.php on line 64

Excel Fastest Way to Copy Formula to All Rows #excel

Posted on by Annie D

Microsoft Excel Tutorial: Fastest Way to Copy Formula to All Rows.

Check out this tutorial on Excel’s Fast Way to Copy Formula to All Rows!

Are you tired of dragging your formulas down to thousands of rows? Say goodbye to that tedious process! In this video, we’ll show you a quick and efficient method to copy your formulas across multiple rows without the hassle.

Most people start by creating their formula in the first row, then painstakingly drag it down, row by row. It’s slow, it’s frustrating, and it’s not efficient. But fear not! We have a solution that will save you time Continue reading “Excel Fastest Way to Copy Formula to All Rows #excel” →


Deprecated: Creation of dynamic property ternplugin\youtube_video::$post is deprecated in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/automatic-video-posts/vendor/ternstyle/plugin/src/class/youtube_video.php on line 64

Append Tables in Excel. Excel Magic Trick 1852

Posted on by Annie D

Download Excel File: https://excelisfun.net/files/EMT1852.xlsx
Learn the old way and the new way to append tables in Excel.
Topics:
1. (00:00) Introduction
2. (00:10) Old Method
3. (00:17) New Method with VSTACK
4. (00:37) Summary
5. (00:53) Closing, Video Links

#excel #excelisfun #analytics #analysis #dataanalysis #dataanalytics #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftexcel #microsoftmvp #VSTACK


Deprecated: Creation of dynamic property ternplugin\youtube_video::$post is deprecated in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/automatic-video-posts/vendor/ternstyle/plugin/src/class/youtube_video.php on line 64

Excel Keeps Inserting Old Formula – How to Fix It! – Episode 2640

Posted on by Annie D

Microsoft Excel Tutorial: Excel Keeps Inserting Old Formula – How to Fix It!

Every time that Tori adds a new row to her Excel table, four columns auto-fill formulas from years ago.

Oh my gosh. Ever had a crazy frustrating problem with Excel? In this video, we tackle Tori’s Excel nightmare head-on. Tori’s adding new rows to her table, only to find four columns haunted by formulas from three years ago! What gives?

Hey there! If you’re facing Excel woes like Tori, hit that Like button below to help more folks find this solution-packed video – thanks for the support!

Picture this: Tori’s table Continue reading “Excel Keeps Inserting Old Formula – How to Fix It! – Episode 2640” →


Deprecated: Creation of dynamic property ternplugin\youtube_video::$post is deprecated in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/automatic-video-posts/vendor/ternstyle/plugin/src/class/youtube_video.php on line 64

Excelisfun: 16 Years at YouTube: SQRT(256) Birthday Party!!!! Excel Magic Trick 1851

Posted on by Annie D

Download Excel File: https://excelisfun.net/files/EMT1851.xlsx
Celebrate Mike Girvin’s excelisfun 16 Years at YouTube Birthday Party!!! Learn Power Query M Code tricks too.
Topics:
1. (00:00) Introduction
2. (00:01) Thanks you for 16 years!!!!
3. (00:25) Alphanumeric Min and Max. List.Min on Text items, Words!?!?! Yes!
4. (01:37) Group By Can Insensitive!?!? Yes!!! With Table.GroupBy function
5. (02:32) Closing, Video Links

#excel #excelisfun #analytics #analysis #dataanalysis #dataanalytics #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftexcel #microsoftmvp #powerquery, #mcode
Comparer.Ordinal, Comparer.OrdinalIgnoreCase


Deprecated: Creation of dynamic property ternplugin\youtube_video::$post is deprecated in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/automatic-video-posts/vendor/ternstyle/plugin/src/class/youtube_video.php on line 64

Excel – First Look At Copilot AI For Excel – Episode 2636

Posted on by Annie D

Microsoft Excel Tutorial: Preview of AI Copilot for Excel.

Welcome to episode 2636 of Mr. Excel’s netcast! In this video, we will be taking a first look at Copilot AI for Excel, a new feature from Microsoft that has been generating a lot of buzz. I was lucky enough to get a sneak peek at this feature, even though it was initially only available for enterprises with over 100 customers. But now, I have access to it and I’m excited to share it with you.

In this video, we will be exploring the Copilot feature and its capabilities. We will be working Continue reading “Excel – First Look At Copilot AI For Excel – Episode 2636” →


Deprecated: Creation of dynamic property ternplugin\youtube_video::$post is deprecated in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/automatic-video-posts/vendor/ternstyle/plugin/src/class/youtube_video.php on line 64

Excel – Naked Cowboy Sings for Spreadsheet Day from Times Square #excel #nsfw – Episode S0050

Posted on by Annie D

Microsoft Excel Tutorial: 🎵 Celebrating Spreadsheet Day in Times Square with the Naked Cowboy! 🎵 | Excel Song and Serenade.

Welcome to my latest video, where the Naked Cowboy, is celebrating Spreadsheet Day from the iconic Times Square in New York City. As a lover of all things Excel, he couldn’t resist the opportunity to serenade the accounting team and all spreadsheet enthusiasts out there with a special song. So, grab your calculators and get ready to sing along with me!

For those who may not know, Spreadsheet Day falls on October 17th and is a day dedicated to celebrating the powerful Continue reading “Excel – Naked Cowboy Sings for Spreadsheet Day from Times Square #excel #nsfw – Episode S0050” →


Deprecated: Creation of dynamic property ternplugin\youtube_video::$post is deprecated in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/automatic-video-posts/vendor/ternstyle/plugin/src/class/youtube_video.php on line 64

Don’t Use PivotTables. Use COUNTIFS or FREQUNCY Functions Instead. Excel Magic Trick 1849

Posted on by Annie D

Download Excel File: https://excelisfun.net/files/EMT1847-1849.xlsx
Learn about how PivotTables cannot include upper limit when grouping number data with decimals. COUNTIFS and FREQUNCY Functions do include upper limits when grouping numbers into upper and lower limit categories.
Topics:
1. (00:00) Introduction
2. (00:06) PivotTable
3. (01:45) COUNTIFS
4. (02:49) Text Labels for Formula Report
5. (03:25) Find Feature to create labels for PivotTable
6. (03:56) FREQUENCY Array Function
7. (05:15) Summary
8. (05:30) Closing, Video Links

#excel #excelisfun #analytics #analysis #dataanalysis #dataanalytics #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftexcel #microsoftmvp #lookup #xlookup


Deprecated: Creation of dynamic property ternplugin\youtube_video::$post is deprecated in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/automatic-video-posts/vendor/ternstyle/plugin/src/class/youtube_video.php on line 64

Count Below Hurdle: PivotTable, COUNTIFS, GROUPBY or Power Query? Magic Trick 1848

Posted on by Annie D

Download Excel File: https://excelisfun.net/files/EMT1847-1849.xlsx
Learn about how to count assembly line station times that are under 10 seconds using PivotTable, COUNTIFS function, GROUPBY function and Power Query.
Topics:
1. (00:00) Introduction
2. (00:06) Counting Assembly Line Post Times Less Than 10 Seconds
3. (00:43) COUNTIFS
4. (01:54) PivotTable with Helper Column
5. (02:57) GROUPBY Array Function
6. (04:05) Power Query
7. (05:22) Summary
8. (05:35) Closing, Video Links

#excel #excelisfun #analytics #analysis #dataanalysis #dataanalytics #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftexcel #microsoftmvp #countifs #groupby #pivottable #powerquery #powerquerytutorial


Deprecated: Creation of dynamic property ternplugin\youtube_video::$post is deprecated in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/automatic-video-posts/vendor/ternstyle/plugin/src/class/youtube_video.php on line 64

Check First Letter in Each Name Against a List of Letters, Then Count. Excel Magic Trick 1850

Posted on by Annie D

Download Excel File: https://excelisfun.net/files/EMT1850.xlsx
Learn about how to count how many names in a column start with the letters a, b or c. Then make formula dynamic so it can check any set of letters.
Topics:
1. (00:00) Introduction
2. (00:05) Formula that uses LEFT, an array constant {“a”,”b”,”c”} and the SUM function
3. (00:38) Why the two arrays must be in opposite directions
4. (02:22) Dynamic formula linked to a list in the cells.
5. (02:43) Sumamry, Closing, Video Links

#excel #excelisfun #analytics #analysis #dataanalysis #dataanalytics #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftexcel #microsoftmvp #count #left #excelfunctions #countifs


Deprecated: Creation of dynamic property ternplugin\youtube_video::$post is deprecated in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/automatic-video-posts/vendor/ternstyle/plugin/src/class/youtube_video.php on line 64

Excel Customers Paying Less Than Average – Episode 2639

Posted on by Annie D

Microsoft Excel Tutorial: Create an Excel Pivot Table to Identify Which Customers Are Paying Less than Average for a Product.

To download the workbook from today: https://www.mrexcel.com/youtube/4XrKZhiBB-k/

Hey Excel enthusiasts! 👋 In this MrExcel netcast, we tackle a fascinating question from Glenn, who joined our recent Nashville IMA webinar. Ever wondered which customers are paying less than the average? 🧐 We’ve got you covered!

🔍 Using a special pivot table based on the Data Model, we delve into the powerful DAX function CALCULATE. Follow along as we transform our data into a table named “Sales” and explore 12,000 rows of Continue reading “Excel Customers Paying Less Than Average – Episode 2639” →


Deprecated: Creation of dynamic property ternplugin\youtube_video::$post is deprecated in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/automatic-video-posts/vendor/ternstyle/plugin/src/class/youtube_video.php on line 64

Filter Feature CANNOT run an OR Logical Test Across Two Columns: 2 Solutions. Excel Magic Trick 1847

Posted on by Annie D

Download Excel File: https://excelisfun.net/files/EMT1847-1849.xlsx
Learn that the Filter Feature CANNOT run an OR Logical Test Across Two Columns. Solution #1: Add a Helper Column with the OR function. Solution #2: Use the FILTER Array Function. Lean about logical tests in the FILTER function.
Topics:
1. (00:00) Introduction
2. (00:06) Filter Feature CANNOT run an OR Logical Test Across Two Columns
3. (01:03) Helper Column with OR Function to help the Filter Feature
4. (02:01) FILTER Array Function with OR Logical Test
5. (04:06) Summary
6. (04:20) Closing, Video Links

#excel #excelisfun #analytics #analysis #dataanalysis #dataanalytics #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftexcel #microsoftmvp #filter #filterfunction


Deprecated: Creation of dynamic property ternplugin\youtube_video::$post is deprecated in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/automatic-video-posts/vendor/ternstyle/plugin/src/class/youtube_video.php on line 64

Excel Show Details In Excel Pivot Table – Episode 2638

Posted on by Annie D

Microsoft Excel Tutorial: Microsoft improves the Show Details feature in a pivot table and adds new entry points.

To download the workbook from today: https://www.mrexcel.com/youtube/d8kKJlZIr_g/

Unlock New Insights with Excel Pivot Tables! 🚀 In this tutorial, we dive into the latest updates from the Excel team. Discover the new Show Details feature, making data analysis smoother than ever! 📊💡

🔍 Show Details Icon: Spot the new icon on the Pivot Table Analyze tab – it’s a game-changer! Similar to the classic double-click, it opens a new sheet to the left with detailed information. Now, with a handy title indicating the Continue reading “Excel Show Details In Excel Pivot Table – Episode 2638” →