Category: Excel

Excel – RegEx Building Blocks – 2643

Posted on by Annie D

Microsoft Excel Tutorial: Learning the Building Blocks for RegEx in Excel
Learn the basic building blocks of RegEx in Excel.

To download the RegEx Cheat Sheet and workbook from today: https://www.mrexcel.com/youtube/fbHQgDM0P1E/

Welcome back to MrExcel’s YouTube channel! In this video, we’ll dive into the building blocks for mastering Regular Expressions (RegEx) and their integration in Excel. If you find this video helpful, don’t forget to click the Like button below – it helps us reach more viewers. We’ve got over 2,500 videos on various Excel topics, so there’s plenty to explore!

Our focus today is on RegEx, specifically the new functions Continue reading “Excel – RegEx Building Blocks – 2643” →

Excel RegEx Support For Pattern Matching – Episode 2642

Posted on by Annie D

Microsoft Excel Tutorial: Excel Adds RegEx Support for Pattern Matching in Excel.

🎥 Unlocking the Power of RegEx in Excel: New Features Explained! 📊

Hey Excel enthusiasts! 🌟 In today’s video, we’re diving into an exciting new feature: RegEx support in Excel for pattern matching. If you enjoy exploring new Excel functionalities, this is a must-watch! Don’t forget to Like this video to help it reach more people. 👍

🔥 What’s New? 🔥
Excel has introduced three powerful RegEx functions: RegExTest, RegExReplace, and RegExExtract. These functions are set to revolutionize how we handle data patterns. Plus, there are updates to XLOOKUP and XMATCH functions Continue reading “Excel RegEx Support For Pattern Matching – Episode 2642” →

DAME 05: Master Power Query M Code & Become a Data Shaping Ninja (The Secret Behind Data Analysis)

Posted on by Annie D

DAME 05: Master Power Query M Code & Become a Data Shaping Ninja (The Secret Behind Data Analysis)
Download files: DAME05zip Pdf notes to read online: DAME05pdfNotes
Alternative download site: https://excelisfun.net/files/DAMEwithMPT05.zip, pdf notes: https://excelisfun.net/files/05-DAMEMPT.pdf
In this video learn about all the fundamentals of the M Code language, the coding language behind Power Query. Learn all about the keys to M Code Mastery: M Code Values, Expressions, Data Types, Operations by Data Types, let expression, M Code Lookup, Custom Functions, and M Code functions such as: Table.AddColumn, Csv.Documnet, Excel.CurrectWorkbook, Table.Group and much more!
Free YouTube Data Analysis Class about Continue reading “DAME 05: Master Power Query M Code & Become a Data Shaping Ninja (The Secret Behind Data Analysis)” →

DAME 04: Data Analysis with Excel Worksheet Formulas: 4 Comprehensive examples.

Posted on by Annie D

Download files: https://people.highline.edu/mgirvin/AllClasses/348/348/2024/Content/Week06/Video04Files.zip
Free YouTube Data Analysis Class about Microsoft Power Tools in 2024 taught by Excel MVP and Highline College Professor, Mike “excelisfun” Girvin.
In this video learn about when Excel worksheet formulas are the perfect tool for data analysis. An hour lesson in the power of Excel worksheet formulas and when they beat PivotTables, Power Query and Power BI.
Topics:
1. (00:00) Introduction
2. (00:40) 4 scenarios where worksheet formulas are better than other tools.
3. (02:33) Example #1: Enter Data In Worksheet & Need Analysis Off To Side.
4. (03:22) MOD function for hours worked formula
5. (05:19) Line Chart
6. (06:37) 7-Day Continue reading “DAME 04: Data Analysis with Excel Worksheet Formulas: 4 Comprehensive examples.” →

DAME 03: PivotTables Rule for Quick & Easy Reports! 34 Amazing PT Tricks.

Posted on by Annie D

Download files: https://people.highline.edu/mgirvin/AllClasses/348/348/2024/Content/Week06/Video03Files.zip Pdf notes to read online: https://people.highline.edu/mgirvin/AllClasses/348/348/2024/Content/Week06/03-DAMEMPT.pdf
Free YouTube Data Analysis Class about Microsoft Power Tools in 2024 taught by Excel MVP and Highline College Professor, Mike “excelisfun” Girvin. This video teaches you the beauty and simplicity of PowerQuery yo get, transform, abd load the data to the location that you want/.

Topics:
1. (00:00) Introduction
2. (00:26) Free PivotTable Cheat Sheet in workbook file or pdf notes
3. (00:39) Toy sales Data Set
4. (01:21) Why use PivotTables?
5. (01:58) Basics of PivotTables
6. (02:35) PivotTable Cache
7. (04:02) Change Default PivotTable Layout
8. (04:40) PT Calculations: Summarize Values By, Continue reading “DAME 03: PivotTables Rule for Quick & Easy Reports! 34 Amazing PT Tricks.” →

DAME 2 (Updated): MS Data Analysis Tools: Excel, Power Query, Power BI, Data Flow, DAX & M Code!

Posted on by Annie D

Download files: https://people.highline.edu/mgirvin/AllClasses/348/348/2024/Content/Week01a02/Video01-02Files.zip
Pdf notes to read online: https://people.highline.edu/mgirvin/AllClasses/348/348/2024/Content/Week01a02/01-DAMEMPT.pdf
Alternative link for zipped folder: https://excelisfun.net/files/Video01-02Files.zip
Free YouTube Data Analysis Class about Microsoft Power Tools in 2024 taught by Excel MVP and Highline College Professor, Mike “excelisfun” Girvin.
In this video learn about ALL the Microsoft Power Tools: Excel, Power Query, Power Pivot, Data Model, Power BI, Dataflow, Worksheet formulas, Dynamic Spilled Array Formulas, M Code formulas, DAX formulas, and much more!
Topics:
1. (00:00) Introduction
2. (00:13) List of MS Power Tools taught in video
3. (00:44) Preview of 7 examples
4. (01:48) Why use Worksheet as a data analysis Continue reading “DAME 2 (Updated): MS Data Analysis Tools: Excel, Power Query, Power BI, Data Flow, DAX & M Code!” →

Excel How To Quickly Delete All Blank Columns In Excel 3 Ways – Episode 2641

Posted on by Annie D

Microsoft Excel Tutorial: Three ways to delete hundreds of tiny blank columns in Excel.

Welcome back to another MrExcel tutorial! In this video, we tackle a common Excel dilemma: deleting 365 blank columns swiftly. Hailing from Green Bay, Wisconsin, our viewer shared their data download challenge, and we’re here to provide not one, not two, but three lightning-fast solutions.

First up is the Ctrl+Y or F4 trick, a nifty shortcut that repeats the last command. Watch as we demonstrate how to breeze through column deletion with just a few keystrokes, saving you valuable time.

Next, we delve into the power of Excel’s Go Continue reading “Excel How To Quickly Delete All Blank Columns In Excel 3 Ways – Episode 2641” →

DAME 2: All MS Data Analysis Tools in 1 Video: Excel, Power Query, Power BI, Data Flow, DAX & M Code

Posted on by Annie D

Download files: https://people.highline.edu/mgirvin/AllClasses/348/348/2024/Content/Week01a02/Video01-02Files.zip
Pdf notes to read online: https://people.highline.edu/mgirvin/AllClasses/348/348/2024/Content/Week01a02/01-DAMEMPT.pdf
Alternative link for zipped folder: https://excelisfun.net/files/Video01-02Files.zip
Free YouTube Data Analysis Class about Microsoft Power Tools in 2024 taught by Excel MVP and Highline College Professor, Mike “excelisfun” Girvin.
In this video learn about ALL the Microsoft Power Tools: Excel, Power Query, Power Pivot, Data Model, Power BI, Dataflow, Worksheet formulas, Dynamic Spilled Array Formulas, M Code formulas, DAX formulas, and much more!
Topics:
1. (00:00) Introduction
2. (00:13) List of MS Power Tools taught in video
3. (00:44) Preview of 7 examples
4. (01:48) Why use Worksheet as a data analysis Continue reading “DAME 2: All MS Data Analysis Tools in 1 Video: Excel, Power Query, Power BI, Data Flow, DAX & M Code” →

DAME 01: Data Analysis Terms & the Awesome Microsoft Power Tools!

Posted on by Annie D

Download files: DAME01zip Pdf notes to read online: DAME01pdfNotes
Free YouTube Data Analysis Class about Microsoft Power Tools in 2024 taught my Excel MVP and Highline College Professor, Mike “excelisfun” Girvin.
In this video learn about data analysis terms and all the amazing Microsoft Power Tools such as: Excel, Power Query, Power Pivot, Power BI, Dataflow, Worksheet formulas, Dyanamic Spileld Array Formulas, M Code formulas, DAX formulas, and much more!
Topics:
1. (00:00) DAME Intro Song
2. (00:12) Introduction
3. (01:18) Table terminology
4. (04:52) What is Grian?
5. (06:41) SQL database as a data source
6. (07:55) Columnar Database in the Data Model in Power Pivot and Power Continue reading “DAME 01: Data Analysis Terms & the Awesome Microsoft Power Tools!” →