excelisfun
excelisfunVideo
- Format:
- YouTube channel
- New videos:
- Irregular
- Typical length:
- about 15 minutes, not counting Shorts
- Latest video:
About this show
Mike Girvin: 18 Year Excel & Power BI YouTuber, 23 years as professor at Highline College, 13 years as an Excel and Power BI author (5 books), and 10 years running an award-winning boomerang manufacturing company (Gel Boomerangs) with sports boomerang sales all over the world. Here at my excelisfun YouTube Channel, I provide free education for the world, with over 3,800 videos, over 100 playlists free classes, over 10,000 downloadable Excel example files, and over 2,000 free pdf notes files. Data analysis, accounting, finance and statistics are my specialty. Hopefully these free Excel & Power BI resources will help you to become better with Excel, Power BI and data analysis so you can save time at work, help coworkers become better, and save so much time that you can take an extra vacation! This is all free, so pass the word along to all who you know: excelisfun is here to help! Go Team! P.S. if you want to Donate, use PayPal link below, or join my YouTube channel : )
Videos come from the channel's public YouTube feed. The artwork is the newest video thumbnail. Last updated . Names, artwork and text belong to their publishers.
Cosmos
Similar by topic and creator
- Neso Academy
Shares the topics Education and Technology. - Gate Smashers
Shares the topics Education and Technology. - Simplilearn
Shares the topics Education and Technology.
Videos
Power Query #7: Merge Join Feature: All Seven Examples
· 21 min
Download Zipped folder with files: https://excelisfun.net/files/PowerQuery07Files.zip Free Power Query YouTube class from Mike excelisfun Girvin: https://www.youtube.com/playlist?list=PLrRPvpgDmw0lHaJfr4mjRcOMEYqKKvKBj Buy Mike Girvins Power Query M Code book: https://www.amazon.com/Transformative-Magic-Power-Query-Excel/dp/1615470832/ This video teaches how to use the 7 types of Joins when you use Merge feature Power Query. Many easy to understand examples. Topics: 1. (00:00) Intro Song 2. (00:11) Introduction 3. (00:23) Download files so you can practice 4. (00:32) Defined the 7 types of Merge Joins in Power Query 5. (03:16) Accessing Merge Join in Excel and Power BI Desktop 6. (03:26) Files for Power BI example 7. (03:44) MUST use Queries NOT Excel Tables 8. (04:25) Left-Outer Join to lookup a product price 9. (05:37) Left-Outer Join to do a two-value lookup 10. (06:36) Table.NestedJoin Function 11. (07:28) Left-Outer Join to use one lookup value to return multiple matches 12. (09:22) Join-Aggregate feature for Left-Outer Join 13. (09:49) Why you don’t use Join-Aggregate feature: Query is slow 14. (10:25) Alternative to the Join-Aggregate feature: Query is MUCH faster 15. (12:43) Right-Outer Join to join supplier and product tables 16. (14:06) Left-Anti Join to return items in left table that are NOT in right table 17. (15:50) Right-Anti Join to return items in right table that are NOT in left table 18. (17:00) Inner-Join as an AND Logical Test to return items in both tables 19. (17:51) Full-Outer as an OR Logical Test to return all records in both tables 20. (19:23) Self-Join to lookup employee name who referring new employee 21. (20:49) Video Summary and Conclusions 22. (21:23) Mike Girvin’s Power Query M Code book 23. (21:32) Closing and Video Links This video has subtitles or audio translations in these 109 languages: Abkhazian, Afrikaans, Albanian, Amharic, Arabic, Armenian, Azerbaijani, Bambara, Bangla, Basque, Belarusian, Bosnian, Bulgarian, Burmese, Cantonese, Cantonese (Hong Kong), Chinese, Chinese (Hong Kong), Chinese (Singapore), Chinese (Taiwan), Croatian, Czech, Danish, Dutch, Dutch (Netherlands), Estonian, Faroese, Fijian, Filipino, Finnish, French, French (Belgium), French (Canada), French (France), French (Switzerland), Georgian, German, German (Germany), Greek, Hebrew, Hindi, Hungarian, Icelandic, Indonesian, Irish, Italian, Japanese, Khmer, Korean, Kurdish, Lao, Latin, Latvian, Lithuanian, Luxembourgish, Macedonian, Maithili, Malagasy, Malay, Malayalam, Maltese, Mongolian, Nepali, Norwegian, Pashto, Persian, Persian (Afghanistan), Persian (Iran), Polish, Portuguese, Portuguese (Brazil), Punjabi, Russian, Samoan, Sanskrit, Santali, Scottish Gaelic, Serbian, Serbian (Cyrillic), Serbian (Latin), Sicilian, Sindhi, Sinhala, Slovak, Slovenian, Somali, Spanish, Spanish (Latin America), Spanish (Mexico), Spanish (Spain), Spanish (United States), Swahili, Swedish, Tajik, Tamil, Tatar, Telugu, Thai, Tibetan, Turkish, Turkmen, Ukrainian, Urdu, Uyghur, Uzbek, Vietnamese, Welsh, Western Frisian, Zulu. Click gear icon below video to set subtitles, audio and language. #excel #excelisfun #analytics #analysis #dataanalysis #dataanalytics #excelmvp #powerbi #powerquery #powerbidesktop #freeclass #freecourse #freeclasses #excelclasses #powerquery #powerquerytutorial #microsoftexcel #microsoftmvp #datamodel #datamodeling, #join #joinoperator #merge #powerqueryjoin #combine #datamodel #datascience View Power Query Video pdf notes: https://excelisfun.net/files/PowerQuery-07.pdf
Not rated yetPower Query #6: 12 Tables Into One Table With Just A Click: Combine Files Button
· 12 min
Download Zipped folder with files: https://excelisfun.net/files/PowerQuery06Files.zip Free Power Query YouTube class from Mike excelisfun Girvin: https://www.youtube.com/playlist?list=PLrRPvpgDmw0lHaJfr4mjRcOMEYqKKvKBj Buy Mike Girvins Power Query M Code book: https://www.amazon.com/Transformative-Magic-Power-Query-Excel/dp/1615470832/ This video teaches you how to use the From Folder feature and Combine Files button to append files from a folder, whether Csv files, Excel files or other file types. 12 tables into one table with just a click! Topics: 1. (00:00) Intro Song 2. (00:11) Introduction 3. (00:42) Download files so you can practice 4. (01:06) Folders of files, On Premises Folder Path, and how the structure of the data in each file MUST be the same 5. (01:34) Folders with CSV Files 6. (01:43) Folders with Excel Files 7. (01:47) VERY IMPORTANT NOTES about structure of Excel files 8. (03:33) Import folder of CSV files using the From File / From Folder feature in Excel 9. (03:48) Import folder of CSV files using the Folder feature in Power BI Desktop 10. (04:32) Binary M Code Values 11. (04:51) Filter out non-CSV files 12. (05:20) Table.SelectRows function 13. (05:38) Remove Other Columns (Keep Content Column Only) 14. (05:53) Table.SelectColumns function 15. (06:08) Combine Files button to create helper queries, query steps, and append all the tables. 16. (06:23) Make sure delimiter is a comma 17. (06:44) What the Helper Queries, Custom Function, and New Applied Query Steps do and what they mean 18. (08:51) Load the Appended Table to the Worksheet 19. (09:14) Add new CSV files to the folder, refresh query and the Appened table updates with new data 20. (10:06) From Folder feature and Combine Files button to append data from 12 Excel files 21. (10:35) Make sure to select an Excel Worksheet object that represents the structure in all the other Excel files to this automatic process can build the correct M Code for the Append Query 22. (11:09) Look at Automatic M Code that assures that only Worksheets named “Sheet1” are imported when the custom function is used. 23. (11:29) Custom Function is invoked in each row of the table with the Binary Column filled with Excel files 24. (11:51) Close and load new append table to the worksheet. 25. (12:00) Summary 26. (12:24) Closing This video has subtitles or audio translations in these 152 languages: Abkhazian, Afar, Akan, Albanian, Amharic, Arabic, Armenian, Assamese, Aymara, Azerbaijani, Bambara, Bangla, Bangla (India), Bashkir, Basque, Belarusian, Bhojpuri, Bosnian, Breton, Bulgarian, Burmese, Cantonese, Cantonese (Hong Kong), Catalan, Chinese, Chinese (China), Chinese (Hong Kong), Chinese (Singapore), Chinese (Taiwan), Corsican, Croatian, Czech, Danish, Dogri, Dutch, Dutch (Belgium), Dutch (Netherlands), Dzongkha, Esperanto, Estonian, Ewe, Faroese, Fijian, Filipino, Finnish, French, French (Belgium), French (Canada), French (France), French (Switzerland), Fula, Galician, Ganda, Georgian, German, German (Austria), German (Germany), German (Switzerland), Greek, Guarani, Gujarati, Haitian Creole, Hausa, Hawaiian, Hebrew, Hindi, Hungarian, Icelandic, Indonesian, Inuktitut, Irish, Italian, Japanese, Javanese, Khmer, Korean, Kurdish, Lao, Latin, Latvian, Lingala, Lithuanian, Luxembourgish, Macedonian, Maithili, Malagasy, Malay, Malay (Singapore), Malayalam, Maltese, Marathi, Mongolian, Nepali, Norwegian, Papiamento, Pashto, Persian, Persian (Afghanistan), Persian (Iran), Polish, Portuguese, Portuguese (Brazil), Portuguese (Portugal), Punjabi, Romanian, Rundi, Russian, Samoan, Sango, Sanskrit, Santali, Scottish Gaelic, Serbian, Serbian (Cyrillic), Serbian (Latin), Shona, Sicilian, Sindhi, Sinhala, Slovak, Slovenian, Somali, Spanish, Spanish (Latin America), Spanish (Mexico), Spanish (Spain), Spanish (United States), Sundanese, Swahili, Swati, Swedish, Tajik, Tamil, Tatar, Telugu, Thai, Tibetan, Tigrinya, Tongan, Tsonga, Tswana, Turkish, Turkmen, Ukrainian, Urdu, Uyghur, Uzbek, Venda,…
Not rated yetPower Query #5: Append Tables with Table.Combine Function: Seven Examples
· 17 min
Download Zipped folder with files: https://excelisfun.net/files/PowerQuery05Files.zip Free Power Query YouTube class from Mike excelisfun Girvin: https://www.youtube.com/playlist?list=PLrRPvpgDmw0lHaJfr4mjRcOMEYqKKvKBj Buy Mike Girvin's Power Query M Code book: https://www.amazon.com/Transformative-Magic-Power-Query-Excel/dp/1615470832/ Topics: 1. (00:00) Intro Song 2. (00:11) Introduction 3. (00:52) Download files 4. (01:17) Goal for video append external files project 5. (01:53) Six examples that teach the fundamentals of the Append Operation 6. (02:24) Keyboard to open 7. (02:34) Example 1: Append feature in Power Query with the Table.Combine function 8. (03:42) Example 2: Fix Data Types in Source Tables, and Data Types Flow Through to Appended Tables 9. (04:43) Example 3: Append Tables with Inconsistent Field Names 10. (05:40) Example 4 & 5: Ampersand, &, to append tables 11. (07:40) Example 6: Second Argument in Table.Combine Function: Columns. Choose columns to append 12. (07:47) Difference Between “Reference” and “Duplicate” Queries 13. (09:29) Table Type Preview of Video #9 14. (09:53) Table Column M Code Lookup Syntax Preview of Video #9 15. (10:20) Load As “Create Connection Only” 16. (10:31) Edit Load Location to Load Queries to Excel Worksheet 17. (11:03) Fix Source Table Inconsistent Field Names So That Tables Can Append Correctly 18. (12:20) Look at Excel Tables That We Will Import 19. (12:32) Look At the Text Tab Delimited File That We Will Import 20. (12:55) Import Multiple Excel Tables from an Excel File 21. (13:17) Append Two Tables 22. (13:41) Import Text File with a Tab Delimiter 23. (14:06) Append Table to Existing Append Method 1: Edit Source Query Step 24. (14:36) Append Table to Existing Append Method 2: Edit M Code in Formula Bar 25. (15:05) Sort Table By Test Within Student Name 26. (15:15) Table.Sort function 27. (15:27) List Within A List to Sort 28. (16:15) Load To Worksheet 29. (16:49) Summary 30. (17:36) Closing This video has subtitles or audio translations in these 178 languages: Abkhazian, Afar, Afrikaans, Akan, Albanian, Amharic, Arabic, Armenian, Assamese, Aymara, Azerbaijani, Bambara, Bangla, Bangla (India), Bashkir, Basque, Belarusian, Bhojpuri, Bosnian, Breton, Bulgarian, Burmese, Cantonese, Cantonese (Hong Kong), Catalan, Chinese, Chinese (China), Chinese (Hong Kong), Chinese (Simplified), Chinese (Singapore), Chinese (Taiwan), Chinese (Traditional), Corsican, Croatian, Czech, Danish, Dogri, Dutch, Dutch (Belgium), Dutch (Netherlands), Dzongkha, Esperanto, Estonian, Ewe, Faroese, Fijian, Filipino, Finnish, French, French (Belgium), French (Canada), French (France), French (Switzerland), Fula, Galician, Ganda, Georgian, German, German (Austria), German (Germany), German (Switzerland), Greek, Guarani, Gujarati, Haitian Creole, Hausa, Hawaiian, Hebrew, Hindi, Hungarian, Icelandic, Igbo, Indonesian, Inuktitut, Irish, Italian, Japanese, Javanese, Kalaallisut, Kannada, Kazakh, Khmer, Kinyarwanda, Konkani, Korean, Kurdish, Kyrgyz, Lao, Latin, Latvian, Lingala, Lithuanian, Luo, Luxembourgish, Macedonian, Maithili, Malagasy, Malay, Malay (Singapore), Malayalam, Maltese, Marathi, Mizo, Mongolian, Mongolian (Mongolian), Māori, Nepali, Northern Sotho, Norwegian, Occitan, Odia, Oromo, Papiamento, Pashto, Persian, Persian (Afghanistan), Persian (Iran), Polish, Portuguese, Portuguese (Brazil), Portuguese (Portugal), Punjabi, Quechua, Romanian, Rundi, Russian, Samoan, Sango, Sanskrit, Santali, Scottish Gaelic, Serbian, Serbian (Cyrillic), Serbian (Latin), Shona, Sicilian, Sindhi, Sinhala, Slovak, Slovenian, Somali, South Ndebele, Southern Sotho, Spanish, Spanish (Latin America), Spanish (Mexico), Spanish (Spain), Spanish (United States), Sundanese, Swahili, Swati, Swedish, Tajik, Tamil, Tatar, Telugu, Thai, Tibetan, Tigrinya, Tok Pisin, Tongan, Tsonga, Tswana, Turkish, Turkmen, Ukrainian, Urdu, Uyghur, Uzbek, Venda, Vietnamese, Welsh, Western Frisian, Wolof, Xhosa, Yiddish, Yoruba, Zulu. Click gear…
Not rated yetPower Query #4: How to Unpivot Columns with Table.UnpivotOtherColumns function
· 20 min
Download Zipped folder with files: https://excelisfun.net/files/PowerQuery04Files.zip Free Power Query YouTube class from Mike excelisfun Girvin: https://www.youtube.com/playlist?list=PLrRPvpgDmw0lHaJfr4mjRcOMEYqKKvKBj Buy Mike Girvins Power Query M Code book: https://www.amazon.com/Transformative-Magic-Power-Query-Excel/dp/1615470832/ or Mr Excel: https://www.mrexcel.com/products/the-transformative-magic-of-power-query-m-code-in-excel-and-power-bi/ Topics: 1. (00:00) Intro Song 2. (00:11) Introduction 3. (00:36) Tentative List of Videos for the Power Query Class 4. (01:04) Look at data for this video 5. (01:43) Goal for Examples 1 and 2 6. (02:09) What is a Cross Tabulated (Cross Tab) Table? 7. (02:43) How is a Cross Tabulated translated into a Proper Table? 8. (03:11) Files used in this video 9. (03:28) Example 1: Unpivot cross tabulated table with 1 column and 1 row headers variables 10. (03:46) Convert table to an Excel Table 11. (04:27) Bring Excel Table from current workbook into Power Query Editor 12. (05:26) Excel.CurrentWorkbook function 13. (05:48) Unpivoting and the Table.UnpivotOtherColumns Function 14. (07:07) Edit M Code in formula bar to rename columns 15. (07:19) M Code List Value in second argument of the Table.UnpivotOtherColumns Function 16. (08:33) Advanced Editor and the let expression 17. (09:07) Close and Load to the Excel worksheet 18. (09:35) Use Query Output Table to analyze: Sort, Create PivotTable and Chart 19. (11:50) Example 2: Unpivot cross tabulated table with 2 column and 1 row headers variables 20. (15:25) Example 3: How to unpivot in Power BI Desktop 21. (18:44) Uncheck Enable Load in the Power Query Editor in Power BI Desktop 22. (19:06) Summary 23. (19:34) Mike Girvin’s Power Query M Code book 24. (19:43) Closing This video has subtitles or audio translations in these 135 languages: Abkhazian, Afar, Afrikaans, Akan, Albanian, Arabic, Armenian, Assamese, Aymara, Azerbaijani, Bambara, Bangla, Bangla (India), Bashkir, Basque, Belarusian, Bhojpuri, Bosnian, Breton, Bulgarian, Burmese, Cantonese, Cantonese (Hong Kong), Catalan, Chinese, Chinese (China), Chinese (Hong Kong), Chinese (Singapore), Chinese (Taiwan), Corsican, Czech, Danish, Dogri, Dutch, Dutch (Belgium), Dutch (Netherlands), Estonian, Faroese, Fijian, Filipino, Finnish, French, French (Belgium), French (Canada), French (France), French (Switzerland), Georgian, German, German (Austria), German (Germany), German (Switzerland), Greek, Guarani, Gujarati, Hebrew, Hindi, Hungarian, Icelandic, Indonesian, Italian, Japanese, Khmer, Korean, Kurdish, Lao, Latin, Latvian, Lithuanian, Luxembourgish, Macedonian, Maithili, Malagasy, Malay, Malay (Singapore), Malayalam, Maltese, Mongolian, Nepali, Norwegian, Papiamento, Pashto, Persian, Persian (Afghanistan), Persian (Iran), Polish, Portuguese, Portuguese (Brazil), Portuguese (Portugal), Punjabi, Romanian, Russian, Samoan, Sango, Sanskrit, Santali, Scottish Gaelic, Serbian, Serbian (Cyrillic), Serbian (Latin), Sicilian, Sindhi, Sinhala, Slovak, Slovenian, Somali, Spanish, Spanish (Latin America), Spanish (Mexico), Spanish (Spain), Spanish (United States), Sundanese, Swahili, Swati, Swedish, Tajik, Tamil, Tatar, Telugu, Thai, Tibetan, Tigrinya, Tongan, Tsonga, Tswana, Turkish, Turkmen, Ukrainian, Urdu, Uyghur, Uzbek, Venda, Vietnamese, Welsh, Western Frisian, Zulu. Click gear icon below video to set subtitles, audio and language. #excelisfun #MikeGirvin #PowerQuery #Excel #PowerBI #PowerBIDesktop #Excel365 #LearnPowerQuery #freeclass #DataAnalysis #BusinessIntelligence #Microsoft #TableUnpivotOtherColumns #freepowerquerycourse #powerquerycourse #powerqueryclass #freecourse #unpivot #crosstab #Table.UnpivotOtherColumns #mcode #cleandata #transformdata #unpivottable #unpivotcolumns
Not rated yetConditionally Format Row in Schedule for Today’s Date - Mixed Cell References | EMT 1924
· 5 min
Download Excel File: https://excelisfun.net/files/EMT1924.xlsx Mike excelisfun Girvin Excel books: https://www.amazon.com/stores/Mike-excelisfun-Girvin/author/B009Q5T4P2?ref=sr_ntt_srch_lnk_1&ccs_id=5f0ec91c-7a28-4a2b-9c87-04a7ee3159e6 Mike Girvin’s free Excel Class: https://www.youtube.com/playlist?list=PLrRPvpgDmw0k7ocn_EnBaSJ6RwLDOZdfo Learn how to conditionally format a row in your schedule for today’s date using a Logical Formula and Mixed Cell References in the Format Cells Dialog Box. Topics: 1. (00:00) Introduction 2. (00:09) Painting with Mike excelisfun Girvin 3. (00:19) Goal of Video 4. (00:34) How Conditional Formatting Works 5. (01:02) Create Logical Formula 6. (01:53) Mixed Cell References 7. (02:32) F4 Merry-Go-Round Key 8. (03:07) TODAY() Function 9. (03:20) Ctrl + Enter keyboard and what it does 10. (03:26) Fill Handle & Crosshair Angry Rabbit for Formula Copying Magic! 11. (04:01) Test Formula 12. (04:25) Paste Formula into Conditional Formatting Dialog Box 13. (05:28) Test Conditional Formatting 14. (05:47) Closing Use a formula to determine which cells to format. Edit The Rule Description. Format Values Where This Value is TRUE. This video has subtitles or audio translations in these 134 languages: Abkhazian, Afar, Afrikaans, Akan, Albanian, Amharic, Arabic, Armenian, Azerbaijani, Bambara, Bangla, Bangla (India), Bashkir, Basque, Belarusian, Bosnian, Breton, Bulgarian, Burmese, Cantonese, Cantonese (Hong Kong), Catalan, Chinese, Chinese (China), Chinese (Hong Kong), Chinese (Singapore), Chinese (Taiwan), Corsican, Croatian, Czech, Danish, Dogri, Dutch, Dutch (Belgium), Dutch (Netherlands), Estonian, Faroese, Fijian, Filipino, Finnish, French, French (Belgium), French (Canada), French (France), French (Switzerland), Georgian, German, German (Austria), German (Germany), German (Switzerland), Greek, Hebrew, Hindi, Hungarian, Icelandic, Indonesian, Irish, Italian, Japanese, Khmer, Korean, Kurdish, Lao, Latin, Latvian, Lithuanian, Luxembourgish, Macedonian, Maithili, Malagasy, Malay, Malay (Singapore), Malayalam, Maltese, Mongolian, Nepali, Norwegian, Papiamento, Pashto, Persian, Persian (Afghanistan), Persian (Iran), Polish, Portuguese, Portuguese (Brazil), Portuguese (Portugal), Punjabi, Romanian, Russian, Samoan, Sango, Sanskrit, Santali, Scottish Gaelic, Serbian, Serbian (Cyrillic), Serbian (Latin), Shona, Sicilian, Sindhi, Sinhala, Slovak, Slovenian, Somali, Spanish, Spanish (Latin America), Spanish (Mexico), Spanish (Spain), Spanish (United States), Sundanese, Swahili, Swati, Swedish, Tajik, Tamil, Tatar, Telugu, Thai, Tibetan, Tigrinya, Tongan, Tsonga, Tswana, Turkish, Turkmen, Ukrainian, Urdu, Uyghur, Uzbek, Venda, Vietnamese, Welsh, Western Frisian, Zulu. Click gear icon below video to set subtitles, audio and language. #excel #microsoft #excelisfun #excelcourse #excelclasses #excelcourse #excelconditionalformatting #conditionalformating #conditionalformatting #excelhindi #excelhinditutorial #exceltips #exceltutorial #exceltutorialforbeginners #mixedcellreferences #cellreference #excelformula #excelformulas #logicalformulas #Excellogic #scheduleinexcel
Not rated yetSort "City, State" Text by State Then City | SORTBY Array Function - EMT 1923
· 3 min
Download Excel File: https://excelisfun.net/files/EMT1923.xlsx Mike excelisfun Girvin Excel books: https://www.amazon.com/stores/Mike-excelisfun-Girvin/author/B009Q5T4P2?ref=sr_ntt_srch_lnk_1&ccs_id=5f0ec91c-7a28-4a2b-9c87-04a7ee3159e6 Mike Girvin’s free Excel Class: https://www.youtube.com/playlist?list=PLrRPvpgDmw0k7ocn_EnBaSJ6RwLDOZdfo Learn how to short text with city and state by state forts and then by city using the SORTBY Dynamic Spilled Array Formula Topics: 1. (00:00) Introduction 2. (00:39) Coffee with Mike excelisfun Girvin 3. (00:47) Download File 4. (00:52) Goal for Formula 5. (01:14) First part of formula with SORTBY and RIGHT functions. 6. (02:17) Second part of formula 7. (02:33) Dynamic Spilled Array Formula and Ghosts 8. (03:32) Summary 9. (03:42) Closing This video has subtitles or audio translations in these 132 languages: Abkhazian, Afar, Afrikaans, Akan, Albanian, Amharic, Arabic, Armenian, Azerbaijani, Bambara, Bangla, Bangla (India), Basque, Belarusian, Bhojpuri, Bosnian, Breton, Bulgarian, Burmese, Cantonese, Cantonese (Hong Kong), Catalan, Chinese, Chinese (China), Chinese (Hong Kong), Chinese (Singapore), Chinese (Taiwan), Croatian, Czech, Danish, Dutch, Dutch (Belgium), Dutch (Netherlands), Estonian, Faroese, Fijian, Filipino, Finnish, French, French (Belgium), French (Canada), French (France), French (Switzerland), Georgian, German, German (Austria), German (Germany), German (Switzerland), Greek, Hebrew, Hindi, Hungarian, Icelandic, Indonesian, Irish, Italian, Japanese, Khmer, Korean, Kurdish, Lao, Latin, Latvian, Lithuanian, Luxembourgish, Macedonian, Maithili, Malagasy, Malay, Malay (Singapore), Malayalam, Maltese, Mongolian, Nepali, Norwegian, Papiamento, Pashto, Persian, Persian (Afghanistan), Persian (Iran), Polish, Portuguese, Portuguese (Brazil), Portuguese (Portugal), Punjabi, Romanian, Russian, Samoan, Sango, Sanskrit, Santali, Scottish Gaelic, Serbian, Serbian (Cyrillic), Serbian (Latin), Sicilian, Sindhi, Sinhala, Slovak, Slovenian, Somali, Spanish, Spanish (Latin America), Spanish (Mexico), Spanish (Spain), Spanish (United States), Sundanese, Swahili, Swati, Swedish, Tajik, Tamil, Tatar, Telugu, Thai, Tibetan, Tigrinya, Tongan, Tsonga, Tswana, Turkish, Turkmen, Ukrainian, Urdu, Uyghur, Uzbek, Venda, Vietnamese, Welsh, Western Frisian, Yoruba, Zulu. Click gear icon below video to set subtitles, audio and language. #excel #microsoft #excelisfun #excelcourse #sortby #arrayformulas #dynamicspilledarray #excelformulas #excelfunctions #excelforanalysts #excelforwork #excelforstudents #excelforjob #excelformulasinhindi #skatespots #skatespot #bmx #bmxlife Skate Locations that I have been to as of July 30, 2026: Alameda, CA Bakersfield, CA Capitola, CA Eureka, CA Fremont, CA Newark, CA Oakland - Lower Bob's, CA Oakland - Piedmont, CA Oakland - Towns, CA Redding, CA San Francisco - 3rd & Army, CA San Francisco - Ocean Front, CA San Francisco - Portrero, CA San Francisco -Shit Pit, CA Santa Cruz - Derby Park, CA Santa Cruz - Downtown, CA Scotts Valley, CA Shasta Lake City (New Park), CA Shasta Lake City (Old Park), CA Ukiah, CA Venice, CA Chehalem Valley Skatepark, OR Florence, OR Jefferson, Eugene, OR Portland - Burnside, OR Arlington, WA Battle Ground, WA Burien, WA Burlington, WA Ellensburg, WA Gig Harbor, WA Lake Stevens, WA Liberty Lake, WA Longachers, Kent, WA Monroe, WA Port Angeles, WA Port Orchard, WA Richland, WA Sadro Wolley, WA Seattle - Blackmarket Circle Masonite Ramp, WA Seattle - Delridge, WA Seattle - Girv Ramp, WA Seattle - Greenlake, WA Seattle - Jefferson, WA Seattle - Judkins, WA Seattle - Marginal Way, WA Seattle - Rainer Beach, WA Seattle - Rox Hill, WA Seattle - Southpark River City, WA Seattle - Space Needle "Seascape", WA Seattle, Grindline Headquarters 13 foot Masonite 1/2 Pipe, WA Seattle, Grindline Headquarters Egg Bowl, WA Spokane - Riverfront Skatepark, WA Spokane -Hillyard Skatepark, WA Spokane -Joe Albi Skatepark, WA Spokane Valley - YMCA, WA Tulalip, WA…
Not rated yetExcel Sort Left To Right. Horizontal Sort. Excel Short 83
· 53 sec
Learn how use the Sort dialog box to sort left to right in Excel. Download Excel File: https://excelisfun.net/files/ExcelShort83.xlsx Buy excelisfun’s Excel Books: https://www.amazon.com/stores/Mike-excelisfun-Girvin/author/B009Q5T4P2?ref=ap_rdr&ccs_id=6f8ce877-462f-447e-b825-7ede1f72a9d3 Free Excel Class from excelisfun: https://www.youtube.com/playlist?list=PLrRPvpgDmw0k7ocn_EnBaSJ6RwLDOZdfo #excel365 #mikegirvin #michaelgirvin #excelisfun #excelformulas, #excelfunctions #sort #sortfeature #lefttoright #sorting #excelsort #sortExcel #excelsorting
Not rated yetPQ #3: Full Free Lesson in Power BI Desktop: Power Query, M, Data Model, DAX Formulas, Visualizing
· 42 min
Download Zipped folder with files: https://excelisfun.net/files/PowerQuery03Files.zip Free Power Query YouTube class from Mike excelisfun Girvin: https://www.youtube.com/playlist?list=PLrRPvpgDmw0lHaJfr4mjRcOMEYqKKvKBj Buy Mike Girvins Power Query M Code book: https://www.amazon.com/Transformative-Magic-Power-Query-Excel/dp/1615470832/ or Mr Excel: https://www.mrexcel.com/products/the-transformative-magic-of-power-query-m-code-in-excel-and-power-bi/ Download Power BI Desktop: https://powerbi.microsoft.com/en-us/desktop/ Topics: 1. (00:00) Intro Clip 2. (11:30) What is in this video 3. (01:01) Download files correctly 4. (02:25) pdf notes: Free book 5. (02:59) 5 main Power Query features that are different in Power BI Desktop from Excel 6. (04:54) Overview of video #3 project 7. (06:36) Open Start File 8. (06:43) Tour of Power BI Desktop 9. (07:21) Where is Power Query in Power BI Desktop? 10. (07:43) Import CSV Fact Table file 11. (08:10) Power Query Editor 12. (09:18) Advanced Editor 13. (09:25) let expression and how it works 14. (10:00) Close Power Query Editor without Applying query steps and loading to the Data Model 15. (10:26) What to do with this message: There are pending changes in your queries that haven’t been applied 16. (10:33) Import an Excel Table from an Excel file 17. (11:46) Import Access Database table 18. (12:36) Transform Data: Split by Dash Delimiter to get lookup values 19. (12:52) Efficient M Code: Delete repetitious query steps 20. (13:17) Split By Delimiter feature 21. (13:55) Edit M Code in Formula Bar 22. (15:10) Clean Data: Convert ISO Date to Real Serial Number Date 23. (15:31) Watch M Code change LIVE as you use the user interface 24. (15:52) Why you NEVER drag and drop data fields into Data Model Driven Visuals 25. (16:39) Intentionally forget important M Code Query step 26. (17:10) Load all 3 queries to Data Model using Close & Apply button 27. (17:24) Look at loaded tables in Table View & Model View 28. (17:58) Create Relationships 29. (19:41) Introduction to REALTED DAX lookup function 30. (20:29) DAX Measures and DAX Calculated Columns. One-Step or Two-Step DAX Measure Methods? 31. (21:32) Create DAX Calculated COLUMN 32. (22:23) Row Context and how it works in a Calculated Column and X Iterator functions such as SUMX 33. (23:27) Validate that returned lookup values are correct, discover a problem, and fix it in the Power Query Editor 34. (24:42) Use Transform Data button to open Power Query 35. (24:54) Replace feature in Power Query to fix mismatched lookup values 36. (25:17) Apply Changes to Data Model 37. (25:51) Create Net Sales DAX Calculated Column Formula 38. (26:19) Row Context 39. (28:21) DO NOT create Implicit Measures. Create Explicit Measures 40. (28:45) Create Explicit Measure with SUM function that adds values from Calculated Column (Two-Step Measure Method) 41. (29:24) What Icon looks like for Measure in Power BI 42. (29:37) Compare Preview of Grand Total for Measure in: Worksheet, Power Pivot, and Power BI 43. (29:56) Use Report View to Preview the results from a Measure using a Matrix Visualization 44. (30:57) One-Step Measure Method using the SUMX function 45. (31:05) DAX formulas: Data Analysis eXpressions 46. (31:42) Copy Calculated Column formula 47. (31:53) SUMX Function 48. (33:10) Test SUMX Measure in Report View 49. (33:24) Compare and contrast One-Step Measure to the Two-Step Measure 50. (34:17) Hide Fields that you do not want in the Reporting Area 51. (35:36) Create Dashboard visuals: Matrix and Stacked Column 52. (36:20) Filter Context and how it works with Measures 53. (38:32) How Filter Context & Row Context work together in the SUMX function 54. (39:14) Edward Tufte “No Chart Junk” Rule 55. (40:41) Interactive Visuals 56. (41:23) Summary 57. (41:53) Mike excelisfun Girvin’s Power Query M Code book 58. (42:02) Closing This video has subtitles or audio translations a 137 languages, some of them are listed here: Afrikaans, Albanian, Amharic, Arabic, Armenian,…
Not rated yetExcel Keyboard to Select Full Range & Remove Only The Formatting!!!! Excel Short 82
· 57 sec
Learn how to select the current region and remove formatting only. Learn key keyboards for each task. Download Excel File: https://excelisfun.net/files/ExcelShorts81and82.xlsx Buy excelisfun’s Excel Books: https://www.amazon.com/stores/Mike-excelisfun-Girvin/author/B009Q5T4P2?ref=ap_rdr&ccs_id=6f8ce877-462f-447e-b825-7ede1f72a9d3 Free Excel Class from excelisfun: https://www.youtube.com/playlist?list=PLrRPvpgDmw0k7ocn_EnBaSJ6RwLDOZdfo #excel365 #mikegirvin #michaelgirvin #excelisfun #excelformulas #excelfunctions #selectall #selectcurrentregion #ExcelFormatting
Not rated yetAmazing Excel Selection Keyboard Shortcut. Do You Know It? Excel Short 81
· 46 sec
Learn how use the Ctrl and Shift And Arrow keys to do the impossible: select ranges not next to each other (noncontiguous) and then select a range of cells to the end of the current region. Download Excel File: https://excelisfun.net/files/ExcelShorts81and82.xlsx Buy excelisfun’s Excel Books: https://www.amazon.com/stores/Mike-excelisfun-Girvin/author/B009Q5T4P2?ref=ap_rdr&ccs_id=6f8ce877-462f-447e-b825-7ede1f72a9d3 Free Excel Class from excelisfun: https://www.youtube.com/playlist?list=PLrRPvpgDmw0k7ocn_EnBaSJ6RwLDOZdfo #excel #excel365 #excelisfun #mikegirvin #freeexcellessons #excelformulas #excelfunctions #keyboard #selection #selectiontrick ##keyboardshortcuts #excelkeyboardshortcuts
Not rated yetPower Query #2: Import, Clean, Transform & Load Data in Excel
· 52 min
Download Zipped folder with files: https://excelisfun.net/files/PowerQuery02Files.zip Free Power Query YouTube class from Mike excelisfun Girvin: https://www.youtube.com/playlist?list=PLrRPvpgDmw0lHaJfr4mjRcOMEYqKKvKBj Buy Mike Girvins Power Query M Code book: https://www.amazon.com/Transformative-Magic-Power-Query-Excel/dp/1615470832/ Topics: 1. (00:00) Introduction 2. (00:21) Download files to good location for Power Query & unzip folder 3. (02:00) Source data files for import 4. (02:23) Turn file extension on in Control Panel 5. (03:18) Open Excel Start file & look at video project goals 6. (03:58) What is cleaning data? 7. (04:21) What is transforming data? 8. (04:53) PDF notes for video #2: free book! 9. (05:12) What is Power Query in Excel? 10. (05:35) Structure of data in a CSV file 11. (06:01) What is a delimiter? 12. (06:22) Import Csv File 13. (07:16) Introduction to Power Query Editor 14. (07:44) Naming a query 15. (08:03) Applied Steps 16. (08:07) Changing Data Load Settings in Options 17. (09:05) Introduction to M Code in Applied Steps & Formula Bar 18. (09:52) M Code is case sensitive 19. (10:31) On Premises File & Folder Paths to link Source Data and Destination Data 20. (11:50) Data Types to create consistent data 21. (12:24) let expression and the Advanced Editor 22. (13:47) Naming convention for Identifiers: NO SPACES!!!!!! 23. (15:08) Close & Load To, Only Create Connection 24. (15:58) Queries & Connections task pane 25. (16:07) Structure of data in an Excel file 26. (17:17) Import data from an Excel file 27. (19:59) Structure of data in an Access database file 28. (20:17) Import data from an Access file 29. (21:05) Compare how data arrives in the Power Query Editor from Csv, Excel, and Access file sources (data type difference) 30. (22:18) Edit an existing query by opening the Power Query Editor 31. (22:48) Clean Data: Split By Delimiter to create Product ID & Sales Channel columns 32. (23:40) Edit M Code in Formula Bar and delete query steps to learn how editing query steps can affect subsequent steps 33. (26:52) Clean data: convert ISO Date to Real Date 34. (27:38) Using Local feature to convert International Dates to Local Dates 35. (28:42) List of all 20 Data Types 36. (28:48) List of all 15 M Code Values, and define Expression 37. (30:18) Defining Lookup or Merge in Power Query M Code 38. (30:48) Transform data: Merge / Join feature to lookup product price and name 39. (32:48) Transform data: Merge / Join feature to lookup location discount 40. (33:16) Error in matching lookup value 41. (33:43) Clean data: Replace Values to create correct lookup values 42. (35:06) Transform data: Add Column Multiply feature 43. (36:04) Table.AddColumn function 44. (36:33) each keyword 45. (36:50) Field Access Operator 46. (37:03) Transform data: Use Custom Column feature to calculate Net Sales 47. (38:44) Rounding in Power Query, not with ROUND, but with: Number.Round 48. (39:20) Function names are M Code Value specific, such as Number, Text, Table, List 49. (39:46) Typing convention for M Code functions 50. (40:24) Custom Column one-step method to calculate Net Sales 51. (41:30) Edit Custom Column in dialog box 52. (41:52) Transform data: Remove Other Columns 53. (42:23) Finished let expression 54. (42:39) Loading a query that has already been loaded 55. (42:41) How to edit load location to load data to an Excel Table in the worksheet 56. (43:10) Create PivotTable and Chart from Query Output in an Excel Table 57. (43:27) What is PivotTable Cache? And why you must refresh twice. 58. (44:31) Creating & Formatting PivotTable & Chart 59. (46:27) Source Data Changes? Refreshing twice when Query is in an Excel Table and PivotTable is created from Excel Table 60. (47:32) DataSource.NotFound Error and how to fix it. 61. (48:36) Data Source Settings 62. (49:26) Refreshing only once when you load directly to PivotTable Report (PivotTable Cache) 63. (50:54) Summary 64. (51:33) Mike excelisfun Girvin’s Power Query M Code Book…
Not rated yetPower Query #1: Introduction to Power Query & Data Analysis in Excel & Power BI
· 22 min
Download Zipped folder with files: https://excelisfun.net/files/PowerQuery01Files.zip Free Power Query YouTube class from Mike excelisfun Girvin: https://www.youtube.com/playlist?list=PLrRPvpgDmw0lHaJfr4mjRcOMEYqKKvKBj Buy Mike Girvins Power Query M Code book: https://www.amazon.com/Transformative-Magic-Power-Query-Excel/dp/1615470832/ In this new Power Query Basics class from excelisfun at YouTube, this is video #1. In this video you will learn about what Power Query can do, how it fits into the full data analysis process, and what the important terms and concepts are in data analysis. This is a class taught by Mike "excelisfun" Girvin, 23 year Highline College Professor, 11 year Excel MVP (2013-2025), 18 years at the excelisfun channel @ YouTube, and author of Excel, Power BI & Power Query books. Topics: 1. (0:00) Introduction. 2. (01:50) Why do we use Power Query? 3. (02:23) What Power Query can do. 4. (03:15) Teaching pedagogy of Mike “excelisfun” Girvin 5. (03:43) What is data analysis? 6. (05:33) Steps in the data analysis process and where Power Query fits in. 7. (08:34) Define Data. 8. (09:25) Default Alignment. 9. (10:16) Number Formatting. 10. (11:38) Data Types and M Code Values. 11. (12:54) Data is NOT Information. 12. (13:16) Define Table. 13. (14:18) What is not a table? 14. (15:43) Copilot & AI and Power Query 15. (17:50) Types of tables. 16. (20:07) Granularity of tables. 17. (21:07) Summary. 18. (21:17) Preview of next video. 19. (21:44) Mike Girvins Power Query Book 20. (22:05) Closing. Mike excelisfun Girvin's books at mrexcel.com: https://www.mrexcel.com/authors/mike-girvin/ Buy Mike excelisfun Girvin's books at Amazon: https://www.amazon.com/stores/Mike-excelisfun-Girvin/author/B009Q5T4P2?ref=ap_rdr&ccs_id=6f8ce877-462f-447e-b825-7ede1f72a9d3 Free Excel Basics Class from excelisfun: https://www.youtube.com/playlist?list=PLrRPvpgDmw0k7ocn_EnBaSJ6RwLDOZdfo This video has subtitles or audio translations in these 107 languages: Afrikaans, Albanian, Arabic, Armenian, Bangla, Bashkir, Basque, Belarusian, Bosnian, Bulgarian, Burmese, Cantonese, Catalan, Chinese, Chinese (Hong Kong), Chinese (Singapore), Chinese (Taiwan), Croatian, Czech, Danish, Dutch, Dutch (Belgium), Dutch (Netherlands), Estonian, Faroese, Fijian, Filipino, Finnish, French, French (Belgium), French (Canada), French (France), French (Switzerland), Georgian, German, German (Austria), German (Germany), German (Switzerland), Greek, Hebrew, Hindi, Hungarian, Icelandic, Indonesian, Italian, Japanese, Khmer, Korean, Kurdish, Lao, Latin, Latvian, Luxembourgish, Macedonian, Maithili, Malagasy, Malay, Malayalam, Maltese, Mongolian, Nepali, Norwegian, Papiamento, Pashto, Persian, Persian (Afghanistan), Persian (Iran), Polish, Portuguese, Portuguese (Brazil), Portuguese (Portugal), Punjabi, Romanian, Russian, Samoan, Sanskrit, Scottish Gaelic, Serbian, Serbian (Cyrillic), Serbian (Latin), Sicilian, Slovak, Slovenian, Somali, Spanish, Spanish (Latin America), Spanish (Mexico), Spanish (Spain), Spanish (United States), Swahili, Swedish, Tajik, Tamil, Tatar, Telugu, Thai, Tibetan, Tsonga, Tswana, Turkish, Turkmen, Ukrainian, Urdu, Vietnamese, Welsh, Western Frisian, Zulu. Click gear icon below video to set subtitles, audio and language. #excelisfun #MikeGirvin #PowerQuery #Excel #PowerBI #PowerBIDesktop #Excel365 #LearnPowerQuery #freeclass #DataAnalysis #BusinessIntelligence #Microsoft #powerquery #powerqueryeditor #powerquerytutorial
Not rated yetexcelisfun Boomerangs Back to YouTube: Make More Excel & Power BI Videos & Classes in 2026 & Beyond!
· 1 min
As many of you know, I’ve had many family responsibilities over the last few years that required a lot of my time. Because of that, I retired from Highline College and stepped away from making YouTube content. However, retirement is not for me because since then I’ve had a non-stop flow of ideas for new videos and classes for the excelisfun channel on YouTube. Not only that, but I looked for a new job, and I found nothing I liked as much as the excelisfun @ YouTube Team!!!! So I had to un-retire and boomerang back to the Team at YouTube! Go Team! Mike excelisfun Girvin's books at mrexcel.com: https://www.mrexcel.com/authors/mike-girvin/ Mike excelisfun Girvin's books at Amazon: https://www.amazon.com/stores/Mike-excelisfun-Girvin/author/B009Q5T4P2?ref=ap_rdr&ccs_id=6f8ce877-462f-447e-b825-7ede1f72a9d3 Free Excel Basics Class from excelisfun: https://www.youtube.com/playlist?list=PLrRPvpgDmw0k7ocn_EnBaSJ6RwLDOZdfo This video has subtitles or audio translations in these 119 languages: Afrikaans, Akan, Albanian, Amharic, Arabic, Armenian, Aymara, Azerbaijani, Bambara, Bangla, Bashkir, Basque, Belarusian, Bosnian, Bulgarian, Burmese, Cantonese, Catalan, Chinese, Chinese (Hong Kong), Chinese (Singapore), Corsican, Croatian, Czech, Danish, Dutch, Dutch (Belgium), Dutch (Netherlands), Estonian, Faroese, Fijian, Filipino, Finnish, French, French (Belgium), French (Canada), French (France), French (Switzerland), Galician, Ganda, Georgian, German, German (Austria), German (Germany), German (Switzerland), Greek, Hebrew, Hindi, Hungarian, Icelandic, Indonesian, Inuktitut, Irish, Italian, Japanese, Khmer, Korean, Kurdish, Lao, Latin, Latvian, Lithuanian, Luxembourgish, Macedonian, Maithili, Malagasy, Malay, Malayalam, Mongolian, Nepali, Norwegian, Papiamento, Pashto, Persian, Persian (Afghanistan), Persian (Iran), Polish, Portuguese, Portuguese (Brazil), Portuguese (Portugal), Punjabi, Romanian, Russian, Samoan, Sanskrit, Scottish Gaelic, Serbian, Serbian (Cyrillic), Serbian (Latin), Sicilian, Sindhi, Slovak, Slovenian, Somali, Spanish, Spanish (Latin America), Spanish (Mexico), Spanish (Spain), Spanish (United States), Swahili, Swedish, Tajik, Tamil, Tatar, Telugu, Thai, Tibetan, Tongan, Tswana, Turkish, Turkmen, Ukrainian, Urdu, Uyghur, Uzbek, Vietnamese, Welsh, Western Frisian, Zulu. Click gear icon below video to set subtitles, audio and language. #excelisfun #MikeGirvin #PowerQuery #Excel #PowerBI #PowerBIDesktop #Excel365 #freeclass #DataAnalysis #BusinessIntelligence #Microsoft #unretire #un-retire #boomerang #boomerrandback #mikegirvinboomerangbacktoyoutube #ismikegirvinstillmakingvideos #DAX #DAXmeasures #DAXformulas #mcode #m #powerqueryeditor #powerquerytutorial #arrayformulas #dynamicspilledarrayformulas #dynamicarrays
Not rated yetLast Video From Mike "excelisfun" Girvin on Feb 16, 2026, 18 years at YouTube!!! Go Team!!!
· 55 sec
After 18 years at YouTube, this is the last video I will post. After posting 3,900 videos, 100 playlists, 20 free college classes, and over 10,000 free practice files, I am retiring. All the free classes, videos, and files are still here for you to learn Excel, Power Query, Power BI and Data Analysis!! Thanks for the wonderful 18 years, Team!!!! Go Team!!!! This video has subtitles or audio translations in these 123 languages: Afrikaans, Akan, Albanian, Amharic, Arabic, Armenian, Azerbaijani, Bambara, Bangla, Bashkir, Basque, Belarusian, Bosnian, Bulgarian, Burmese, Cantonese, Cantonese (Hong Kong), Catalan, Chinese, Chinese (China), Chinese (Simplified), Chinese (Singapore), Chinese (Taiwan), Chinese (Traditional), Croatian, Czech, Danish, Dutch, Dutch (Belgium), Dutch (Netherlands), Estonian, Faroese, Fijian, Filipino, Finnish, French, French (Belgium), French (Canada), French (France), French (Switzerland), Georgian, German, German (Austria), German (Germany), German (Switzerland), Greek, Hebrew, Hindi, Hungarian, Icelandic, Indonesian, Irish, Italian, Japanese, Khmer, Korean, Kurdish, Lao, Latin, Latvian, Lithuanian, Luxembourgish, Macedonian, Maithili, Malagasy, Malay, Malayalam, Maltese, Mongolian, Nepali, Norwegian, Pashto, Persian, Persian (Afghanistan), Persian (Iran), Polish, Portuguese, Portuguese (Brazil), Portuguese (Portugal), Punjabi (experimental), Romanian, Russian, Samoan, Sanskrit, Scottish Gaelic, Serbian, Serbian (Cyrillic), Serbian (Latin), Sicilian, Slovak, Slovenian, Somali, Spanish, Spanish (Latin America), Spanish (Mexico), Spanish (Spain), Spanish (United States), Sundanese, Swahili, Swati, Swedish, Tajik, Tamil (experimental), Tatar, Telugu (experimental), Thai, Tibetan, Tigrinya, Tok Pisin, Tongan, Tsonga, Tswana, Turkish, Turkmen, Ukrainian, Urdu, Uyghur, Uzbek, Venda, Vietnamese, Welsh, Western Frisian, Zulu. Click gear icon below video to set subtitles, audio and language.
Not rated yetExcel SCAN Function Dynamic Spilled Array Formula for Automatic Bank Reconciliation. EMT 1922.
· 10 min
Download: 1) Excel File: https://excelisfun.net/files/EMT1920-1921-1922.xlsx Buy excelisfun’s Excel Books: https://www.amazon.com/stores/Mike-excelisfun-Girvin/author/B009Q5T4P2?ref=ap_rdr&ccs_id=6f8ce877-462f-447e-b825-7ede1f72a9d3 Free Excel Class from excelisfun: https://www.youtube.com/playlist?list=PLrRPvpgDmw0k7ocn_EnBaSJ6RwLDOZdfo Learn how to create dynamic spilled array formulas and functions. Specifically, learn how to create a dynamic spilled array formula to perform automatic bank reconciliation, an important and common accounting task. Lean about the power of Microsoft's amazing SACN Dynamic Spilled Array Formula to calculate running totals and use a relative cell reference in a dynamic spilled array formula. Topics: 1. (00:00) Introduction 2. (01:12) Single Input, Single Output Formula and how they are different than Dynamic Spilled Array Formulas. 3. (02:20) Why we need to use SCAN function rather than just arrays in the formula, and why Aggregate Formulas can NEVER spill an array of values. 4. (03:21) SCAN function to calculate a Running Total. SCAN function is the Dynamic Spilled Array function that can invoke a Relative Cell Reference in a Dynamic Spilled Array Formula. 5. (04:11) The differences between deleting Single Input, Single Output formulas and Dynamic Spilled Array Formulas. 6. (04:41) SCAN Formula for My Book Balance. 7. (04:57) Dynamic Spilled Array Formulas only live in the top cell. 8. (05:13) Remaining cells contain Ghost Formulas. 9. (05:24) Why Dynamic Spilled Array Formulas are so convenient. 10. (05:39) Referencing Ghost Formulas in a Dynamic Spilled Array. 11. (07:14) Editing a Dynamic Spilled Array Formula. 12. (07:18) IF and ISNUMBER functions. 13. (07:49) Zero Length Text String. 14. (08:09) Test Formula. 15. (08:24) SCAN Formula for Bank Balance. 16. (09:24) Why Omitting value_if_false argument in the IF is efficient. 17. (10:24) Summary. 18. (10:41) Closing #excel #microsoft #excelisfun #excelcourse #mikegirvin #excel365 #dynamicspilledarrayformulas #spilledarrays #arrayformulas #excelformulas #excelfunctions #excelfunction #scanfunction #byrow #scan #scanarray #excel365 #excel #exceltips #exceltutorial #exceltips #excellent #excellence #bankreconciliation #accounting #accountingtips #debit #credit #isnumber #isnumberfunction #sum #sumfunction #sumformula #excelmagictrick #excelmagictrick This video has subtitles or audio translations in these languages: Abkhazian, Afrikaans, Albanian, Amharic, Arabic, Armenian, Bangla, Belarusian, Bosnian, Bulgarian, Burmese, Cantonese, Cantonese (Hong Kong), Catalan, Chinese, Chinese (China), Chinese (Hong Kong), Chinese (Simplified), Chinese (Singapore), Chinese (Taiwan), Chinese (Traditional), Corsican, Croatian, Czech, Danish, Dutch, Dutch (Netherlands), Estonian, Faroese, Fijian, Filipino, Finnish, French, French (Belgium), French (Canada), French (France), French (Switzerland), Georgian, German, German (Austria), German (Germany), German (Switzerland), Greek, Hebrew, Hindi, Hungarian, Icelandic, Indonesian, Irish, Italian, Japanese, Khmer, Korean, Kurdish, Lao, Latvian, Lithuanian, Luxembourgish, Macedonian, Maithili, Malagasy, Malay, Malay (Singapore), Malayalam, Maltese, Mongolian, Nepali, Norwegian, Pashto, Persian, Persian (Afghanistan), Persian (Iran), Polish, Portuguese, Portuguese (Brazil), Portuguese (Portugal), Punjabi (experimental), Romanian, Russian, Sanskrit, Scottish Gaelic, Serbian, Serbian (Cyrillic), Serbian (Latin), Sicilian, Slovak, Slovenian, Somali, Spanish, Spanish (Latin America), Spanish (Mexico), Spanish (Spain), Spanish (United States), Swahili, Swedish, Tajik, Tamil (experimental), Tatar, Telugu (experimental), Thai, Tibetan, Tongan, Tsonga, Turkish, Turkmen, Ukrainian, Urdu, Uzbek, Vietnamese, Welsh, Western Frisian, Zulu. Click gear icon below video to set subtitles, audio and language.
Not rated yetExcel Formula for Accounting Bank Reconciliation with IF, ISNUMBER & SUM Functions. EMT 1921.
· 11 min
Download: 1) Excel File: https://excelisfun.net/files/EMT1920-1921-1922.xlsx Buy excelisfun’s Excel Books: https://www.amazon.com/stores/Mike-excelisfun-Girvin/author/B009Q5T4P2?ref=ap_rdr&ccs_id=6f8ce877-462f-447e-b825-7ede1f72a9d3 Free Excel Class from excelisfun: https://www.youtube.com/playlist?list=PLrRPvpgDmw0k7ocn_EnBaSJ6RwLDOZdfo Learn how to create an amazingly efficient set of formulas to calculate the book balance and the bank balance for a checking or savings account. See an amazing SUM function trick to avoid errors. See how to automatically reconcile an account with Excel Formulas. Topics: 1. (00:00) Introduction. 2. (00:38) Fundamental problem with tracking bank account balances, and thus why bank reconciliation is such an important accounting task. 3. (02:31) Data Validation dropdown list feature to verify that only a y value can be added to the reconciliation column. 4. (03:11) #1 Formula to calculate “My Book Balance” using the SUM, IF, and ISNUMBER functions. (03:52) SUM function trick to reference the previous bank balance (Relative Cell Reference) and not get a #VALUE! Error. 5. (04:29) Angry Rabbit (Crosshair) Trick #1. 6. (06:52) Angry Rabbit (Crosshair) Trick #2. 7. (07:50) #2 Formula to calculate “Bank Balance” using the SUM, ISNUMBER, and two back-back nested IF functions. 8. (09:16) Angry Rabbit (Crosshair) Trick #3. 9. (10:34) Next video: Dynamic Spilled Array Formula. 10. (10:59) Closing. #excel #microsoft #excelisfun #excelcourse #mikegirvin #excel365 #BankReconciliation #accountreconciliation #accounting #accountingtask #accountingtricks #accountingtips #isnumber #if #sum #sumfunction #ifformula #iffunction #isnumber #isnumberfunction #nestedif #nestedfunctions #runningtotal #runningtotalformula This video has subtitles or audio translations in these languages: Abkhazian, Afrikaans, Amharic, Arabic (experimental), Armenian, Bangla (experimental), Bashkir, Basque, Belarusian, Bosnian, Bulgarian, Burmese, Cantonese, Chinese, Chinese (China), Chinese (Hong Kong), Chinese (Taiwan), Croatian, Czech, Danish, Dutch, Dutch (Belgium), Dutch (Netherlands), English (Australia), English (Ireland), Estonian, Faroese, Fijian, Filipino, Finnish, French, French (Belgium), French (Canada), French (France), French (Switzerland), Georgian, German, German (Austria), German (Germany), German (Switzerland), Greek, Haitian Creole, Hebrew (experimental), Hindi, Hungarian, Icelandic, Indonesian, Irish, Italian, Japanese, Kazakh, Khmer, Korean (experimental), Lao, Latin, Latvian, Lithuanian, Luxembourgish, Macedonian, Maithili, Malagasy, Malay, Malay (Singapore), Malayalam, Maltese, Mongolian, Nepali, Norwegian, Papiamento, Pashto, Persian, Persian (Afghanistan), Persian (Iran), Polish, Portuguese, Portuguese (Brazil), Portuguese (Portugal), Punjabi (experimental), Romanian, Russian (experimental), Sanskrit, Scottish Gaelic, Serbian, Serbian (Cyrillic), Serbian (Latin), Sicilian, Slovak, Slovenian, Somali, Spanish, Spanish (Latin America), Spanish (Mexico), Spanish (Spain), Spanish (United States), Swahili, Swedish, Tajik, Tamil (experimental), Tatar, Telugu (experimental), Thai, Tibetan, Tongan, Tsonga, Tswana, Turkish, Turkmen, Ukrainian, Urdu, Uzbek, Vietnamese, Welsh, Western Frisian, Zulu. Click gear icon below video to set subtitles, audio and language.
Not rated yetComplete Lesson in Excel Text Formulas that use References to Dates, Money & Arrays. EMT 1920.
· 7 min
Download Excel File: https://excelisfun.net/files/EMT1920-1921.xlsx Buy excelisfun’s Excel Books: https://www.amazon.com/stores/Mike-excelisfun-Girvin/author/B009Q5T4P2?ref=ap_rdr&ccs_id=6f8ce877-462f-447e-b825-7ede1f72a9d3 Free Excel Class from excelisfun: https://www.youtube.com/playlist?list=PLrRPvpgDmw0k7ocn_EnBaSJ6RwLDOZdfo Complete lesson in Excel Text Formulas, including: 1) Text typed directly into formula, 2) References to date, dollar amounts and arrays, 3) Fundamental text formula rule that formulas cannot see Number Formatting, 4) Add Number Formatting to formula with the functions DOLLAR and FIXED, 5) use an array of values from a range of cells with the ARRAYTOTEXT function. See how to take financial data and create a ledger text entry based on the financial data. Topics: 1. (00:00) Introduction 2. (00:30) Fundamental text formula rule that formulas cannot see Number Formatting 3. (00:54) Date Number Formatting, Serial Numbers, and Date Math 4. (01:05) General Number Formatting 5. (02:10) Text typed directly into formulas 6. (02:51) TEXT function to convert a number to text in a specified Number Format. 7. (04:40) ARRAYTOTEXT Function to convert an array into a text string with a delimiter. 8. (05:03) DOLLAR function to convert a number to text with Currency Number Format applied. 9. (06:03) FIXED function to convert a number to text with Comma Number Format applied. 10. (06:56) Copy ledger text string formula and paste as values only. 11. (07:19) Preview of next video and summary. 12. (07:37) Closing #TEXTfunction #ARRAYTOTEXTFunction #DOLLARfunction #FIXEDfunction #DateMath #GeneralNumberFormatting #SerialNumbers #DateNumberFormatting #excelformatting #exceldateformat #textformula #exceltext #excel #microsoft #excelisfun #excelcourse #mikegirvin #excel365 #freeexcellessons #excelformulas #excelfunctions #exceltips #exceltutorial #exceltricks This video has subtitles or audio translations in these languages: Afrikaans, Amharic, Arabic (experimental), Armenian, Bangla (experimental), Belarusian, Bosnian, Cantonese, Chinese, Croatian, Czech, Danish, Dutch, Dutch (Belgium), Dutch (Netherlands), Estonian, Faroese, Filipino, Finnish, French, French (Belgium), French (France), Georgian, German, German (Austria), German (Germany), German (Switzerland), Greek, Hebrew (experimental), Hindi, Hungarian, Icelandic, Indonesian, Irish, Italian, Japanese, Khmer, Korean (experimental), Kurdish, Lao, Latvian, Luxembourgish, Macedonian, Maithili, Malagasy, Malay, Malayalam, Mongolian, Nepali, Norwegian, Pashto, Persian, Persian (Afghanistan), Persian (Iran), Polish, Portuguese, Portuguese (Brazil), Portuguese (Portugal), Punjabi (experimental), Romanian, Russian (experimental), Sanskrit, Scottish Gaelic, Serbian, Serbian (Cyrillic), Serbian (Latin), Sicilian, Slovak, Slovenian, Somali, Spanish, Spanish (Latin America), Spanish (Mexico), Spanish (Spain), Spanish (United States), Swahili, Swedish, Tajik, Tamil (experimental), Tatar, Telugu (experimental), Thai, Tibetan, Tswana, Turkish, Turkmen, Ukrainian, Urdu, Vietnamese, Welsh, Western Frisian, Zulu. Click gear icon below video to set subtitles, audio and language.
Not rated yetexcelisfun Flashback Friday 6: Sparkling Christmas Tree in Excel! Build Conditional Formatting Tree
· 2 min
Download File: https://excelisfun.net/files/EMT1361.xlsx (re-issue for 2025). Happy Holidays and Merry Christmas!!! Excel Happy Holidays! Conditional Formatting Fun on Christmas Day in Excel : ) See How To Build A Conditional Formatting Christmas Tree In Excel! See the RAND() function that generates random numbers between 0 and 1 with a uniform distribution AND See Conditional Formatting with Icons to make a Christmas Tree with sparkling Lights in Excel. #mikegirvin #excel #excel365 #excelisfun #freeexcellessons #excelformulas #excelfunctions #christmas #christmastree #excelchristmastree #conditionalformating #excelconditionalformatting This video has subtitles or audio translations in these languages: Afrikaans, Amharic, Arabic (experimental), Armenian, Bangla (experimental), Belarusian, Bulgarian, Cantonese, Chinese, Czech, Danish, Dutch, Dutch (Belgium), Dutch (Netherlands), Filipino, Finnish, French, French (Belgium), French (Canada), French (France), French (Switzerland), German, German (Germany), Greek, Hebrew (experimental), Hindi, Icelandic, Indonesian, Irish, Italian, Japanese, Khmer, Korean (experimental), Lao, Latvian, Lithuanian, Luxembourgish, Macedonian, Malagasy, Malay, Malayalam, Mongolian, Nepali, Norwegian, Pashto, Persian, Persian (Afghanistan), Persian (Iran), Polish, Portuguese, Portuguese (Brazil), Portuguese (Portugal), Punjabi (experimental), Romanian, Russian (experimental), Sanskrit, Scottish Gaelic, Serbian, Sicilian, Slovak, Slovenian, Somali, Spanish, Spanish (Latin America), Spanish (Mexico), Spanish (Spain), Spanish (United States), Swahili, Tajik, Tamil (experimental), Tatar, Telugu (experimental), Thai, Tibetan, Turkish, Turkmen, Ukrainian, Urdu, Uzbek, Vietnamese, Welsh, Western Frisian, Zulu. Click gear icon below video to set subtitles, audio and language.
Not rated yetExtend Excel Date Format To Other Dates: Fill Formatting Only Trick! Excel Short 80
· 1 min
Learn how use the Fill Handle (Angry Rabbit) to extend your preferred Date Format to other Dates using the Fill Format Only Smart Tag. Download Excel File: https://excelisfun.net/files/ExcelShort80.xlsx Buy excelisfun’s Excel Books: https://www.amazon.com/stores/Mike-excelisfun-Girvin/author/B009Q5T4P2?ref=ap_rdr&ccs_id=6f8ce877-462f-447e-b825-7ede1f72a9d3 Free Excel Class from excelisfun: https://www.youtube.com/playlist?list=PLrRPvpgDmw0k7ocn_EnBaSJ6RwLDOZdfo #excel365 #mikegirvin #michaelgirvin #excelisfun #excelformulas, #excelfunctionsguide This video has subtitles or audio translations in these languages: Afrikaans, Amharic, Arabic (experimental), Armenian, Bangla (experimental), Bosnian, Bulgarian, Cantonese, Chinese, Danish, Dutch, Dutch (Netherlands), Estonian, Filipino, Finnish, French, French (France), German, German (Germany), Greek, Hebrew (experimental), Hindi, Icelandic, Indonesian, Irish, Italian, Japanese, Khmer, Korean (experimental), Latvian, Lithuanian, Luxembourgish, Macedonian, Maithili, Malagasy, Malay, Malayalam, Mongolian, Nepali, Norwegian, Pashto, Persian, Polish, Portuguese, Portuguese (Brazil), Punjabi (experimental), Russian (experimental), Sanskrit, Scottish Gaelic, Serbian, Sicilian, Slovak, Slovenian, Somali, Spanish, Spanish (Latin America), Spanish (Mexico), Spanish (Spain), Spanish (United States), Swahili, Swedish, Tajik, Tamil (experimental), Tatar, Telugu (experimental), Thai, Tibetan, Turkish, Turkmen, Ukrainian, Urdu, Uzbek, Vietnamese, Welsh, Zulu. Click gear icon below video to set subtitles, audio and language.
Not rated yetPower Query Custom Function with Parameter to Get & Transform Multiple Csv Files Data. EMT 1919
· 13 min
Download: 1) Excel File: https://excelisfun.net/files/EMT1917-1919.xlsx 2) Zipped Data Folder: https://excelisfun.net/files/SeattleAirportData.zip Buy excelisfun’s Power Query M Code book: https://www.mrexcel.com/products/the-transformative-magic-of-power-query-m-code-in-excel-and-power-bi/ Buy excelisfun’s other Excel Books: https://www.amazon.com/stores/Mike-excelisfun-Girvin/author/B009Q5T4P2?ref=ap_rdr&ccs_id=6f8ce877-462f-447e-b825-7ede1f72a9d3 Free Excel Class from excelisfun: https://www.youtube.com/playlist?list=PLrRPvpgDmw0k7ocn_EnBaSJ6RwLDOZdfo Learn how to import multiple Csv files that each have a cross tabulated data structure and build a Custom Column Formula to convert each table to a proper table and then append them all into a single table. Learn a lot about M Code in this video. Topics: 1. (00:00) Introduction. 2. (00:36) excelisfun’s Power Query M Code Book. 3. (00:51) Advantage of using a Parameter in a Custom Function. 4. (01:57) Cross Tab data. 5. (02:23) Files to download. 6. (02:35) Goal of Video. 7. (02:42) From Folder feature. 8. (03:26) Create Sample File with Two Way M Code Lookup. 9. (05:31) Create Parameter. 10. (06:10) Create query with code for Custom Function. 11. (08:01) Create Custom Function. 12. (09:30) Use Custom Function in final query. 13. (10:00) Combine tables. 14. (11:02) Edit Custom Function. 15. (11:56) Power of parameter. 16. (12:24) Add files to folder and see if everything updates. 17. (13:00) Summary 18. (13:06) Closing #excel #microsoft #excelisfun #excelcourse #mikegirvin #excel365 #powerquery #customfunction #powerqueryfunction #powerquerycustomfunction #importmultiplefiles #letexpression #letstatement #mcode #powerquerymcode #importdata #exceldataanalysis #powerbidataanalysis This video has subtitles or audio translations in these languages: Afrikaans, Amharic, Arabic (experimental), Bangla (experimental), Belarusian, Bosnian, Bulgarian, Burmese, Cantonese, Chinese, Chinese (China), Czech, Danish, Dutch, Dutch (Netherlands), Estonian, Faroese, Filipino, Finnish, French, French (France), Georgian, German, German (Germany), Greek, Hebrew (experimental), Hindi, Icelandic, Indonesian, Irish, Italian, Japanese, Khmer, Korean (experimental), Latvian, Lithuanian, Luxembourgish, Macedonian, Maithili, Malagasy, Malay, Malayalam, Mongolian, Nepali, Norwegian, Pashto, Persian, Persian (Afghanistan), Persian (Iran), Polish, Portuguese, Portuguese (Brazil), Punjabi (experimental), Romanian, Russian (experimental), Sanskrit, Scottish Gaelic, Serbian, Sicilian, Slovak, Slovenian, Somali, Spanish, Spanish (Latin America), Spanish (Mexico), Spanish (Spain), Spanish (United States), Swahili, Swedish, Tajik, Tamil (experimental), Tatar, Telugu (experimental), Thai, Tibetan, Turkish, Turkmen, Ukrainian, Urdu, Vietnamese, Welsh, Western Frisian, Zulu. Click gear icon below video to set subtitles, audio and language.
Not rated yet