Skip to main content
AmigoFish

excelisfun

excelisfunVideo

Format:
YouTube channel
New videos:
Irregular
Typical length:
about 15 minutes, not counting Shorts
Latest video:
Not rated yet

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

See the full Cosmos

Videos

  • PQ #13: Append Tables with Inconsistent Column Names in Excel & Power BI

    · 13 min

    Download Zipped folder with files: https://excelisfun.net/files/PowerQuery13Files.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/ When you have multiple tables with inconsistent field names (column names, or header names), an append (combine) does not provide a proper table with records: instead, you get many null values mixed in with record values. This video teaches how to fix this problem. We see how to solve the problem when you have CSV text file tables or when you have proper tables, like an Excel Table. In this video learn what to do when you append tables and the result yields many null values. Topics: 1. (00:00) Intro Song 2. (00:11) Introduction 3. (00:24) Review table data with inconsistent field names. 4. (00:55) What happens when you append tables with inconsistent field names? 5. (01:29) Example 1: In an Excel file, we append CSV File table data that has inconsistent field names. Use Csv.Document, Table.Skip and Table.PromoteHeaders functions and the Table Append Operator, Ampersand. Also see the Table.Combine function and the Field Access Operator. In this example we use an Excel Table in the worksheet to store the correct field names. 6. (06:33) Example 2: In a Power BI Desktop file, we append Excel Tables from Multiple Excel Files that has inconsistent field names. Use Excel.Workbook, Table.DemoteHeaders, Table.Skip. Table.Combine functions and the Table Append Operator, Ampersand. In this example we use an M Code Intrinsic table function store the correct field names. 7. (12:28) Summary 8. (12:53) Buy Mike Girvin’s M Code Book 9. (13:02) Closing This video has subtitles or audio translations in these 105 languages: Abkhazian, Afrikaans, Albanian, Arabic, Armenian, Bangla, Belarusian, Bosnian, Bulgarian, Cantonese, Chinese, Chinese (Hong Kong), Chinese (Singapore), Chinese (Taiwan), Croatian, Czech, Danish, Dutch, Dutch (Netherlands), Estonian, Faroese, Fijian, Filipino, Finnish, French, French (Canada), French (France), Georgian, German, German (Germany), Greek, Hawaiian, Hebrew, Hindi, Hungarian, Icelandic, Indonesian, Irish, Italian, Japanese, Khmer, Korean, Kurdish, Lao, Latin, Latvian, Lithuanian, Luxembourgish, Macedonian, Maithili, Malagasy, Malay, Malay (Singapore), Malayalam, Mongolian, Nepali, Norwegian, Papiamento, Pashto, Persian, Persian (Afghanistan), Persian (Iran), Polish, Portuguese, Portuguese (Brazil), Punjabi, Romanian, Russian, Samoan, Sanskrit, 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, Tongan, Tsonga, Tswana, Turkish, Turkmen, Ukrainian, Urdu, Uzbek, 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 #append #appendtables #inconsistent #fieldnames #columnnames #Field #mcode #error #null #nullerrors #functions #formulas #fromfolder #combine #combinetables

    Not rated yet
  • Power Query #12: Import Multiple Excel Sheets or Tables From Multiple Excel Files

    · 36 min

    Download Zipped folder with files: https://excelisfun.net/files/PowerQuery12Files.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 video learn how to use the Excel.Workbook M Code function to import Tables, Sheets and Defined Names from Excel files. Also, learn how to create dynamic folder paths in Excel files to avoid On Premises Folder & File Path DataSource.NotFound errors. Learn how the Excel.Workbook function allows you to filter by Kind Object to import just the tables or sheets that you want. Learn about object name conventions that are the most secure method to ensure that you import only the objects that you want. Finally, learn how to avoid the Table.ExpandTableColumn function and instead use the Table.Combine function by extracting attribute from columns and adding those attributes as columns in Custom Columns, while in the process using the let expression to create variables in Mega M Code Formulas. Topics: 1. (00:00) Introduction 2. (00:27) Description of 4 Examples in Video 3. (02:28) Files and folders to download for this video 4. (03:08) Example 1: Create dynamic folder paths in Excel files to avoid On Premises Folder & File Path DataSource.NotFound errors. Use the worksheet functions CELL and TEXTBEFORE and a Defined Name. Use the M Code Folder.Files function to land a table of files from the folder in order to avoid the Formula.Firewall error. 5. (09:05) Example 2: Reference the dynamic folder path, lookup a single source data Excel file and use the Excel.Workbook function to extract the objects from the Excel file. Learn about the importance of the table that the Excel.Workbook functions returns with the five columns: Name, Data, Item, Kind, and Hidden, including how the Name and Item columns differ. Then use multiple M Code steps to extract the desired Excel Tables, add a Sales Rep column from the attribute column with Table names, and append all desired tables to a single table. 6. (16:34) Example 3: Import multiple Excel files, and filter to get only the correct Excel files from the folder. Then build a Custom Column with the Excel.Workbook function to extract all Excel objects from each of the Excel files and then expand column to append all Excel.Workbook object tables. Then we will transform columns to fix Excel object attribute columns and filter to get just the worksheet data (not Excel Table data) that we need. We will learn about the third and fourth arguments of the Excel.Workbook function, including the second argument to promote headers for worksheet data. We will add data types to the final appended single table from multiple messed up Excel files. 7. (25:05) Example 4: In an Power BI Desktop file we use From Folder and the Excel.Workbook function to import Excel Tables from multiple Excel files. Using the Excel file name and the Excel Table names, we add City and Sales Rep columns to the final appended table. However, in this example we avoid the Table.ExpandTableColumn function and instead use the Table.Combine function by extracting attribute from columns and adding those attributes as columns in Custom Columns, while in the process using the let expression to create variables in two Mega M Code Formulas. With the Custom Columns We condense 11 query steps to just five! 8. (35:49) Summary 9. (36:18) Mike Girvin’s Power Query M Code Book 10. (36:29) Closing This video has subtitles or audio translations in these 89 languages: Abkhazian, Afrikaans, Akan, Albanian, Armenian, Bangla, Belarusian, Bosnian, Bulgarian, Burmese, Cantonese, Chinese, Croatian, Danish, Dutch, Estonian, Faroese, Fijian, Filipino, Finnish, French, Georgian, German, Hawaiian, Hindi, Hungarian, Icelandic, Indonesian, Irish, Italian, Japanese, Khmer, Korean, Kurdish, Lao, Latvian, Lithuanian, Luxembourgish,…

    Not rated yet
  • Power Query #11: Excel.CurrentWorkbook Power Query M Code Function

    · 13 min

    Download Zipped folder with files: https://excelisfun.net/files/PowerQuery11Files.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 video learn all about how the Excel.CurrentWorkbook function imports the contents of the current workbook into the Power Query Editor. Learn how to append all Excel Tables in the current workbook into a single table. Learn about the hidden pitfalls of the Excel.CurrentWorkbook function. Convert sub-tables into consolidated final table. Topics: 1. (00:00) Introduction 2. (00:44) Download File 3. (00:54) What Excel.CurrentWorkbook function does 4. (02:30) Source Data: Excel Tables with Consistent Naming Convention 5. (02:52) Examples of all objects that Excel.CurrentWorkbook can import into Power Query Editor from the Current Workbook, including Excel Tables, Defined Names, Advanced Filter Names, Filter Names, Set Print Area Names, and Dynamic Spilled Array Names 6. (03:53) Recursion Problem with Excel.CurrentWorkbook function. How to stop Recursion. 7. (04:35) 8. (04:44) Four Methods to create Blank Query with the Excel.CurrentWorkbook function: 9. (04:49) 1) Data, Get & Transform, Get Data Dropdown, From Other Sources, Blank Query 10. (05:36) 2) Add Blank Query Button to Quick Access Toolbar 11. (06:08) 3) Keyboard to access Blank Query button in the Quick Access Toolbar 12. (06:24) 4) From Table Range “Hack” Option 13. (07:14) Excel.CurrentWorkbook 14. (07:34) Filter to Only Import the desired Excel Tables 15. (07:54) Replace SalesTable with nothing 16. (08:08) Rename Column 17. (08:13) Expand Content 18. (08:28) Add Data Types 19. (08:43) Load query 20. (09:03) Copy Worksheet Quick Method 21. (09:55) Refresh query when new Excel Table with consistent name is added to workbook 22. (10:11) Importing Dynamic Spilled Array Formula and the automatic Defined Name 23. (11:05) Recursion problem and how to fix it, in second Excel file 24. (11:17) LAMBDA Defined Name not imported when Excel.CurrentWorkbook is used 25. (13:03) Summary 26. (13:14) Mike Girvin’s Power Query Book 27. (13:23) Closing This video has subtitles or audio translations in these 93 languages: Afrikaans, Arabic, Armenian, Bambara, Bangla, Basque, Belarusian, Bhojpuri, Bulgarian, Burmese, Cantonese, Chinese, Croatian, Czech, Danish, Dutch, Dutch (Netherlands), Estonian, Faroese, Fijian, Filipino, Finnish, French, French (France), Georgian, German, German (Germany), Greek, Hawaiian, Hebrew, Hindi, Hungarian, Icelandic, Indonesian, Irish, Italian, Japanese, Khmer, Korean, Kurdish, Lao, Latvian, Lithuanian, Luxembourgish, Macedonian, Maithili, Malagasy, Malay, Malayalam, Mongolian, Nepali, Norwegian, Pashto, Persian, Persian (Afghanistan), Persian (Iran), Polish, Portuguese, Portuguese (Brazil), Punjabi, Romanian, Russian, Samoan, Sanskrit, Scottish Gaelic, Serbian, Sicilian, Sinhala, 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, Vietnamese, Welsh, Zulu. Click gear icon below video to set subtitles, audio and language. #excel #excel365 #excelisfun #mikegirvin #freeexcellessons #excelformulas #excelfunctions #excelisfun #MikeGirvin #PowerQuery #Excel #PowerBI #PowerBIDesktop #Excel365 #LearnPowerQuery #freeclass #DataAnalysis #BusinessIntelligence #Microsoft

    Not rated yet
  • Why Do YouTube Comments Disappear!?!?! EMT1937

    · 39 sec

    Why do YouTube Comments seem to disappear? Sort By Newest can sometimes bring them back. #excel #excel365 #excelisfun #mikegirvin #freeexcellessons #excelformulas #excelfunctions

    Not rated yet
  • Power Query #10: Custom Function, Mega Custom Column Formula, or Parameter Query?

    · 43 min

    Download Zipped folder with files: https://excelisfun.net/files/PowerQuery10Files.zip No pdf files for this video. 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 video, we will use our skills from learning M Code in Powery Query Video #9 to perform advanced M Code Data Transformations to convert multiple CSV files that contain Cross Tabulated Tables into a single Table. We will see three alternatives: Custom Function, Mega Formula in a Custom Column, and a Paramater Query Custom Function. This video is composed of Excel Magic Tricks 1917, 1918, and 1919. This video has subtitles or audio in these 81 languages:Afrikaans, Albanian, Arabic, Bambara, Bangla, Belarusian, Bosnian, Bulgarian, Burmese, Cantonese, Chinese, Czech, Danish, Dutch, Dutch (Netherlands), Estonian, Faroese, Fijian, Filipino, Finnish, French, French (France), German, German (Germany), Greek, Hawaiian, Hebrew, Hindi, Hungarian, Icelandic, Indonesian, Italian, Japanese, Khmer, Korean, Kurdish, Lao, Latin, Latvian, Luxembourgish, Macedonian, Maithili, Malagasy, Malay, Malayalam, Mongolian, Nepali, Persian, Persian (Afghanistan), Persian (Iran), Polish, Portuguese, Portuguese (Brazil), Punjabi, Romanian, Russian, Samoan, Sanskrit, Scottish Gaelic, Serbian, Sicilian, Sindhi, Sinhala, Slovak, Slovenian, Somali, Spanish (United States), Swahili, Swedish, Tajik, Tamil, Tatar, Telugu, Thai, Tibetan, Turkish, Ukrainian, Urdu, Vietnamese, Welsh, Zulu Topics: 1. (00:00) Power Query Song 2. (00:07) Introduction to Video 3. (01:17) Download files for this video 4. (01:36) Method 1 (Excel Magic Trick 1917): Create Custom Function to convert multiple CSV files that contain Cross Tabulated Tables into a single Table. 5. (17:20) Method 2 (Excel Magic Trick 1918): Create Mega Formula in a Power Query Custom Column to convert multiple CSV files that contain Cross Tabulated Tables into a single Table. 6. (31:22) Method 3(Excel Magic Trick 1919): Create a Parameter Query Custom Function to convert multiple CSV files that contain Cross Tabulated Tables into a single Table. 7. (42:59) Summary 8. (43:05) Closing #excel #excel365 #excelisfun #mikegirvin #freeexcellessons #excelformulas #excelfunctions #powerQuery #powerQueryClass #PowerQueryCourse #PowerQueryFreeCourse #Customfunctions #powerQueryCustomfunctions #megaformula #ParameterQuery #powerquerytutorial #powerqueryeditor #advancedexcel advancedpowerQuery

    Not rated yet
  • HSTACK Inside XLOOKUP & Cell Lists. Excel Magic Trick 1936.

    · 1 min

    Download Excel File: https://excelisfun.net/files/EMT1936.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 Learn how to use XLOOKUP & HSTACK functions with Cell Lists. This video has subtitles or audio translation in thes 98 languages: Afrikaans, Albanian, Arabic, Bambara, Bangla, Belarusian, Bosnian, Bulgarian, Burmese, Cantonese, Chinese, Croatian, Czech, Danish, Dutch, Dutch (Netherlands), Esperanto, Estonian, Faroese, Fijian, Filipino, Finnish, French, French (France), Georgian, German, German (Germany), Greek, Hawaiian, Hebrew, Hindi, Hungarian, Icelandic, Indonesian, Irish, Italian, Japanese, Khmer, Korean, Kurdish, Lao, Latin, Latvian, Lithuanian, Luxembourgish, Maithili, Malagasy, Malay, Malayalam, Mongolian, Nepali, Norwegian, Pashto, Persian, Persian (Afghanistan), Persian (Iran), Polish, Portuguese, Portuguese (Brazil), Punjabi, Romanian, Russian, Samoan, Sanskrit, Scottish Gaelic, Serbian, Serbian (Cyrillic), Serbian (Latin), Sicilian, Sindhi, Sinhala, Slovak, Slovenian, Somali, Spanish, Spanish (United States), Swahili, Swedish, Tajik, Tamil, Tatar, Telugu, Thai, Tibetan, Tongan, Tsonga, Tswana, Turkish, Turkmen, Ukrainian, Urdu, Uyghur, Uzbek, Venda, Vietnamese, Welsh, Western Frisian, Zulu Click language icon below video #excel #excel365 #excelisfun #mikegirvin #freeexcellessons #excelformulas #excelfunctions #xlookup #hstack #celllists #excelcelllsist #excelcellarrays #arrayformulas #newfeatures #newexcel #arrayfunctions #xlookupfunctions

    Not rated yet
  • COUNTA function and Cell Arrays. Excel Magic Trick 1935

    · 1 min

    Download Excel File: https://excelisfun.net/files/EMT1935.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 Learn how to hard code Excel Arrays into cells and then use the COUNTA Function to count the items in the cell. This video has subtitles or audio translation in thes 88 languages: Afrikaans, Albanian, Arabic, Armenian, Bangla, Bosnian, Bulgarian, Burmese, Cantonese, Chinese, Croatian, Czech, Danish, Dutch, Dutch (Netherlands), Faroese, Fijian, Filipino, Finnish, French, French (France), Georgian, German, German (Germany), Greek, Hawaiian, Hebrew, Hindi, Hungarian, Icelandic, Indonesian, Irish, Italian, Japanese, Khmer, Korean, Kurdish, Lao, Latin, Latvian, Lithuanian, Luxembourgish, Macedonian, Maithili, Malagasy, Malay, Malayalam, Mongolian, Nepali, Norwegian, Pashto, Persian, Persian (Afghanistan), Persian (Iran), Polish, Portuguese, Portuguese (Brazil), Punjabi, Romanian, Russian, Samoan, Sanskrit, Scottish Gaelic, Serbian, Sicilian, Sinhala, Slovak, Slovenian, Somali, Spanish, Spanish (Latin America), Spanish (Mexico), Spanish (Spain), Spanish (United States), Swahili, Swedish, Tajik, Tamil, Tatar, Telugu, Thai, Tibetan, Turkish, Ukrainian, Urdu, Vietnamese, Welsh, Zulu. Click language icon below video. #excel #excel365 #excelisfun #mikegirvin #freeexcellessons #excelformulas #excelfunctions #COUNTA #CELLIST #CellArray #array #dynamicspilledarray #List

    Not rated yet
  • GROUPBY Reporting Function with Cell Lists. Excel Magic Trick 1933

    · 2 min

    Download Excel File: https://excelisfun.net/files/EMT1932-1934.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 Learn about how the new Excel Cell Lists work with the GROUPBY Function. Video has subtitles and/or audio in these 92 different languages: Afrikaans, Albanian, Arabic, Bambara, Bangla, Belarusian, Bosnian, Bulgarian, Burmese, Cantonese, Chinese, Croatian, Czech, Danish, Dutch, Dutch (Netherlands), Esperanto, Estonian, Faroese, Fijian, Filipino, Finnish, French, French (France), Georgian, German, German (Germany), Greek, Hawaiian, Hebrew, Hindi, Hungarian, Icelandic, Indonesian, Italian, Japanese, Khmer, Korean, Kurdish, Lao, Latin, Latvian, Lithuanian, Macedonian, Maithili, Malagasy, Malay, Malayalam, Mongolian, Nepali, Norwegian, Pashto, Persian, Persian (Afghanistan), Persian (Iran), Polish, Portuguese, Portuguese (Brazil), Punjabi, Romanian, Russian, Samoan, Sanskrit, Scottish Gaelic, Serbian, Sicilian, Sindhi, Sinhala, Slovak, Slovenian, Somali, Spanish, Spanish (Latin America), Spanish (Mexico), Spanish (Spain), Spanish (United States), Tajik, Tamil, Tatar, Telugu, Thai, Tibetan, Turkish, Turkmen, Ukrainian, Urdu, Uyghur, Uzbek, Vietnamese, Welsh, Western Frisian, Zulu #excel #excel365 #excelisfun #mikegirvin #freeexcellessons #excelformulas #excelfunctions

    Not rated yet
  • How To Hard Code Lists & Arrays into Cells: The Difference From Legacy Ctrl Shift Enter. EMT 1934

    · 2 min

    Download Excel File: https://excelisfun.net/files/EMT1932-1934.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 Learn how to hard code Excel Arrays into cells and then use the COUNTA Function to count the items in the cell. Video has subtitles and/or audio in these 92 different languages: Afrikaans, Arabic, Armenian, Bambara, Bangla, Belarusian, Bosnian, Bulgarian, Burmese, Cantonese, Chinese, Croatian, Czech, Danish, Dutch, Dutch (Netherlands), Estonian, Faroese, Fijian, Filipino, Finnish, French, French (France), Georgian, German, German (Germany), Greek, Hawaiian, Hebrew, Hindi, Hungarian, Icelandic, Indonesian, 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), Punjabi, Romanian, Russian, Samoan, Sanskrit, Scottish Gaelic, Serbian, Sicilian, Sindhi, Sinhala, Slovak, Slovenian, Somali, Spanish (United States), Spanish (automatic captions), Swedish, Tajik, Tamil, Tatar, Telugu, Thai, Tibetan, Turkish, Turkmen, Ukrainian, Urdu, Uyghur, Uzbek, Vietnamese, Welsh, Western Frisian, Zulu #excel #excel365 #excelisfun #highlinecollege #mikegirvin #freeexcellessons #excelformulas #excelfunctions #groupby #cellLists #Excellists #Excelarrays #groupbyfunction #excelgroupby #flatten #Flattenfunction

    Not rated yet
  • XLOOKUP Function with Cell Lists and FLATTEN Function. EMT 1932

    · 1 min

    Download Excel File: https://excelisfun.net/files/EMT1932-1934.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 Learn about how the new Excel Cell Lists work with the XLOOKUP Function. Video has subtitles and/or audio in these 97 different languages: Abkhazian, Afrikaans, Albanian, Arabic, Armenian, Bambara, Bangla, Bosnian, Bulgarian, Burmese, Cantonese, Chinese, Croatian, Czech, Danish, Dutch, Dutch (Netherlands), Estonian, Faroese, Fijian, Filipino, Finnish, French, French (France), Georgian, German, German (Germany), Greek, Hawaiian, Hebrew, Hindi, Hungarian, Icelandic, Indonesian, 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), Punjabi, Romanian, Russian, Samoan, Sanskrit, Scottish Gaelic, Serbian, 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 #excel #excel365 #excelisfun #highlinecollege #mikegirvin #freeexcellessons #excelformulas #excelfunctions #xlookup #workbookcompatibility3 #flatten #flattenfunction #dynamicspilledarrayformulas #arrayformulas

    Not rated yet
  • The Missing Piece To Dynamic Spilled Array Formulas: Cell Lists & Arrays & FLATTEN. EMT 1931

    · 3 min

    Download Excel File: https://excelisfun.net/files/EMT1931.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 Learn about the Options Setting Workbook Compatibility 3, and how Cell Lists & the FLATTEN function are the missing piece that allows Dynamic Spilled Array Formulas to spill in all directions. This video has subtitles or audio track in these 86 languages: Afrikaans, Arabic, Armenian, Bambara, Bangla, Belarusian, Bosnian, Bulgarian, Burmese, Cantonese, Chinese, Croatian, Czech, Danish, Dutch, Dutch (Netherlands), Estonian, Faroese, Fijian, Filipino, Finnish, French, French (France), Georgian, German, German (Germany), Greek, Hawaiian, Hebrew, Hindi, Hungarian, Icelandic, Indonesian, Italian, Japanese, Khmer, Korean, Kurdish, Lao, Latin, Latvian, Lithuanian, Macedonian, Maithili, Malagasy, Malay, Malayalam, Mongolian, Nepali, Norwegian, Papiamento, Pashto, Persian, Persian (Afghanistan), Persian (Iran), Polish, Portuguese, Portuguese (Brazil), Punjabi, Romanian, Russian, Samoan, Sanskrit, Scottish Gaelic, Serbian, Sicilian, Sinhala, Somali, Spanish, Spanish (Latin America), Spanish (Mexico), Spanish (United States), Tajik, Tamil, Tatar, Telugu, Thai, Tibetan, Turkish, Turkmen, Ukrainian, Urdu, Vietnamese, Welsh, Western Frisian, Zulu #excelformulas #excel365 #excelisfun #mikegirvin #freeexcellessons #excelformulas #excelfunctions #dynamicspilledarrayformulas #arrays #flatten #celllists #cellarray #arrayformulas

    Not rated yet
  • FLATTEN Function Arguments Explained. EMT1930

    · 4 min

    What does the Download Excel File: https://excelisfun.net/files/EMT1930.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 In this videos learn about The FLATTEN function's three arguments: array, [pad_value], and [levels]. FLATTEN function array argument. FLATTEN function [pad_value] argument. FLATTEN function [levels] argument. Video has subtitles and/or audio in these languages: Afrikaans, Arabic, Armenian, Bambara, Bangla, Belarusian, Bulgarian, Burmese, Cantonese, Chinese, Czech, Danish, Dutch, Dutch (Netherlands), Estonian, Faroese, Fijian, Filipino, French, French (France), German, German (Germany), Greek, Hawaiian, Hebrew, Hindi, Hungarian, Icelandic, Indonesian, 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), Punjabi, Romanian, Russian, Samoan, Sanskrit, Scottish Gaelic, Serbian, Sicilian, Sindhi, Sinhala, Slovak, Slovenian, Somali, Spanish (United States), Tajik, Tamil, Tatar, Telugu, Thai, Tibetan, Turkish, Ukrainian, Urdu, Vietnamese, Welsh, Zulu #excel #excel365 #excelisfun #highlinecollege #mikegirvin #freeexcellessons #excelformulas #excelfunctions #flatten #cellList #CellArray FLATTEN function array argument. FLATTEN function pad_value argument. FLATTEN function levels argument. What does the FLATTEN function array argument do? What does the FLATTEN function pad_value argument do? What does the FLATTEN function levels argument do? array argument in the FLATTEN function. ad_value argument in the FLATTEN function. levels argument in the FLATTEN function.

    Not rated yet
  • FLATTEN Function & Cell Lists To Spill TEXTSPLIT Results Into Rectangular Range. EMT 1929

    · 3 min

    Download Excel File: https://excelisfun.net/files/EMT1927and1928and1929.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 Learn about how to use the new Cell Lists & FLATTEN function to solve the "Spill Array of Arrays" problem. See how to use the TEXTSPLIT function to spill an array formula vertically and horizontally into a rectangular range. The subtitle or audio button below the video offers these 66 languages: Afrikaans, Arabic, Armenian, Bambara, Bangla, Bulgarian, Burmese, Cantonese, Dutch (Netherlands), French (France), German (Germany), Greek, Hebrew, Hindi, Hungarian, Icelandic, Indonesian, Italian, Japanese, Khmer, Korean, Latvian, Malagasy, Malayalam, Nepali, Polish, Portuguese, Portuguese (Brazil), Punjabi, Russian, Sanskrit, Sicilian, Somali, Spanish, Spanish (United States), Swahili, Tamil, Telugu, Thai, Tibetan, Ukrainian, Urdu, Vietnamese, Zulu. #excel #excel365 #excelisfun #mikegirvin #freeexcellessons #excelformulas #excelfunctions #spillarayofarrays #dynamicspilledarrays #excelarrays #flatten #lists #arrays

    Not rated yet
  • Do COLUMNS & ROWS Functions Work on Cell Lists & Arrays? Excel Magic Trick 1928

    · 3 min

    Download Excel File: https://excelisfun.net/files/EMT1927and1928and1929.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 Learn about how the COLUMNS and ROWS functions work on Cell Lists and Cell Arrays #excel #excel365 #excelisfun #mikegirvin #freeexcellessons #excelformulas #excelfunctions #columns #rows #lists #Arrays #Dynamicspilledarrays

    Not rated yet
  • Naming Excel Tables Became Easy. Excel Magic Trick 1927

    · 51 sec

    Download Excel File: https://excelisfun.net/files/EMT1927and1928and1929.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 Learn about the new Excel Table dialog box. The subtitle or audio button below the video offers these 44 langugaes: Afrikaans, Arabic, Armenian, Bambara, Bangla, Bulgarian, Burmese, Cantonese, Dutch (Netherlands), French (France), German (Germany), Greek, Hebrew, Hindi, Hungarian, Icelandic, Indonesian, Italian, Japanese, Khmer, Korean, Latvian, Malagasy, Malayalam, Nepali, Polish, Portuguese, Portuguese (Brazil), Punjabi, Russian, Sanskrit, Sicilian, Somali, Spanish, Spanish (United States), Swahili, Tamil, Telugu, Thai, Tibetan, Ukrainian, Urdu, Vietnamese, Zulu languages: Afrikaans, Arabic, Armenian, Bambara, Bangla, Bulgarian, Burmese, Cantonese, Dutch (Netherlands), French (France), German (Germany), Greek, Hebrew, Hindi, Hungarian, Icelandic, Indonesian, Italian, Japanese, Khmer, Korean, Latvian, Malagasy, Malayalam, Nepali, Polish, Portuguese, Portuguese (Brazil), Punjabi, Russian, Sanskrit, Sicilian, Somali, Spanish, Spanish (United States), Swahili, Tamil, Telugu, Thai, Tibetan, Ukrainian, Urdu, Vietnamese, Zulu

    Not rated yet
  • New Excel Cell Lists & Arrays & FLATTEN Change Everything. Model Building’s New Frontier. EMT 1926

    · 12 min

    Download Excel File: https://excelisfun.net/files/EMT1926.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 Learn about the New Eight Features in Excel, released in Beta on Friday, September 25, 2026: 1) Lists in Single Cells, 2) Tables in Single Cells, 3) Arrays within an Array, the 4 new worksheet functions: 4) FLATTEN, 5) HAS, 6) HASANY, and 7) HASALL, and 8) new filtering capabilities. Topics: 1. (00:00) Introduction 2. (00:15) New Featured In Excel 3. (01:02) Lists in a Single Cell, including INDEX and CHOOSECOLS functions 4. (03:28) Arrays in a Single Cell, Including a Lookup Table in Single Cell and XLOOKUP, VLOOKUP, and LOOKUP functions. 5. (07:06) Arrays within Array in a Single Cell 6. (08:03) FLATTEN function 7. (08:38) HAS Function 8. (08:59) HASANY Function 9. (09:35) HASALL Function 10. (09:58) Filtering with Lists in a Table 11. (10:04) Power Query ???? 12. (10:22) Filter by Item From A List (List Items) 13. (11:05) Filter By List (Displayed Items) 14. (11:21) Excel Features that do not allow lists and arrays in single cells: Spell Check, PivotTables, Find & Replace, Conditional Formatting, COUNTIFS and the like range arguments, Power Query, Charts 15. (11:58) Summary 16. (12:16) Closing Video has subtitles and/or audio in these languages: Abkhazian, Afar, Afrikaans, Akan, Albanian, Arabic, Armenian, Azerbaijani, Bambara, Bangla, Bashkir, Basque, Belarusian, Bosnian, Breton, Bulgarian, Burmese, Cantonese, Chinese, Chinese (Hong Kong), Chinese (Taiwan), Croatian, Czech, Danish, Dutch, Dutch (Belgium), Dutch (Netherlands), Estonian, Faroese, Fijian, Filipino, Finnish, French, French (Belgium), French (Canada), French (France), French (Switzerland), German, German (Germany), Hawaiian, Hebrew, Hindi, Hungarian, Icelandic, Indonesian, Irish, Italian, Japanese, Khmer, Korean, Kurdish, Lao, Latvian, Lithuanian, Luxembourgish, Macedonian, Maithili, Malagasy, Malay, Malayalam, Maltese, Mongolian, Nepali, Norwegian, Papiamento, Pashto, Persian, Persian (Afghanistan), Persian (Iran), Polish, Portuguese, Portuguese (Brazil), Punjabi, Romanian, Russian, Samoan, Sanskrit, Santali, Scottish Gaelic, Serbian, Serbian (Latin), Sicilian, Slovak, Slovenian, Somali, Spanish, Spanish (Latin America), Spanish (Mexico), Spanish (Spain), Spanish (United States), Tajik, Tamil, Tatar, Telugu, Thai, Tibetan, Tigrinya, Tongan, Tsonga, Tswana, Turkish, Turkmen, Ukrainian, Urdu, Uyghur, Uzbek, Vietnamese, Welsh, Western Frisian, Zulu #excel #microsoft #excelisfun #Hasfunction #hasany function #hasall function #Lists #Arrays #ArraysInArray #newmicrosoftfeatures #microsoft #microsoftExcel #FLATTEN

    Not rated yet
  • Power Query #9: The Secrets of Power Query are in the M Code

    · 1 hr 53 min

    Download files: https://excelisfun.net/files/DAMEwithMPT05.zip 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! This video has subtitles or audio translations in these 126 languages. Click gear icon below video to set subtitles, audio and language. Topics: 1. (00:00:00) Introduction 2. (00:00:42) Files to download and follow along 3. (00:01:09) Why M Code? What is M Code? 4. (00:02:20) Power Query Editor in Excel, Power BI Desktop and Data Flows 5. (00:04:28) 3 Places to edit M Code 6. (00:04:44) Introduction to let expression 7. (00:07:17) Define Expressions 8. (00:08:00) Introduction to the 15 M Code Values 9. (00:10:32) Data Types, Type value 10. (00:11:06) Operations and Data Types 11. (00:12:38) Practice identifying Expressions in a let expressions 12. (00:14:26) Group By and Table.Group function 13. (00:16:13) Identifiers in M Code 14. (00:19:27) Keywords 15. (00:19:59) Editing in Advanced Editor, including Shift + Enter 16. (00:20:29) let expression cheat sheet 17. (00:21:43) All 15 M Code Values and Operators for each 18. (00:22:03) How to create a blank query 19. (00:22:44) Null values 20. (00:23:52) Logical values 21. (00:24:32) Text values 22. (00:25:26) Number values 23. (00:25:56) Why it is important to use value type and not data type for determining whether an operation is valid. 24. (00:26:54) Relationship between Values and Data Types 25. (00:28:40) syntax for if expression 26. (00:29:30) Coalesce operator 27. (00:30:31) Table.AddColumn function 28. (00:31:28) Time values 29. (00:32:49) Date values 30. (00:33:37) Date.AddDays function 31. (00:34:00) Subtract dates and you get a Duration value 32. (00:34:10) Duration.Days function 33. (00:34:33) Formulas and Date Values 34. (00:38:39) Calculate hours worked through midnight 35. (00:39:23) Number.From function 36. (00:40:57) Use the let expression to define variables in formulas 37. (00:43:23) Convert ISO Dates to serial number dates 38. (00:44:26) Using Locale feature 39. (00:46:23) Duration.Days vs. Duration.TotalDays functions 40. (00:47:03) Datetime and Datetimezone values 41. (00:48:05) List values 42. (00:51:26) Using a List to solve data transformation task: range of dates into rows 43. (00:54:09) Record values 44. (00:54:22) Generalized Identifiers 45. (00:55:11) Table values 46. (00:56:22) Binary value 47. (00:56:38) M Code lookup, syntax and execution for both Row Index and Key Match Lookup 48. (00:59:27) Row Index Lookup examples 49. (01:01:20) Key Match Lookup examples 50. (01:03:09) Excel.CurrentWorkbook function & Key Match Lookup 51. (01:04:32) Primary Keys and lookup 52. (01:05:00) Drill Down Feature 53. (01:06:38) Aggregate functions and Lists 54. (01:07:32) Merge feature and Join Operations 55. (01:12:30) Function value: Custom Functions 56. (01:13:44) Reusable Custom Function to Calculate Hours Worked 57. (01:18:47) Data Connections dialog box 58. (01:20:06) Reusable Custom Function to Fix and Append Text Files 59. (01:21:01) Csv.Document function 60. (01:24:51) Table.ExpandColumns function 61. (01:25:30) Table.Combine function 62. (01:26:30) each and underscore explained! 63. (01:32:18) Reusable Custom Function to Perform Approximate Match: Four Examples! 64. (01:34:36) Table.Buffer function 65. (01:35:41) Problem with back-to-back each key words 66. (01:36:06) let expression used in specific table scope 67. (01:38:14) Approximate Match Lookup Reusable Formula #1 (Two Arguments) 68. (01:38:44) Approximate Match Lookup Reusable Formula #2 (One Argument and a Hard Coded Table) 69. (01:39:17) Approximate Match Lookup Reusable Formula #3 (List.Accumulate function) 70. (01:41:42) Test three Reusable Approximate Match…

    Not rated yet
  • Formulas or Power Query or Regex: Why Do I Get Zero When I SUM? Excel Magic Trick 1925

    · 13 min

    Download Excel File: https://excelisfun.net/files/EMT1925.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 Learn how to convert text numbers to real numbers so you can SUM to get a total. Learn about character 32, spaces, and non-breaking spaces, character 160, and how to remove them from numbers to convert them to real numbers. This is an important trick because we often get numbers from the internet or download files that have the dreaded character 160. Learn about the functions: LEN, SEQUENCE, MID, SUBSTITUTE, CHAR, CODE, REGEXREPLACE, and learn about Power Query. Topics: 1. (00:00) Introduction 2. (00:16) Painting with Mike excelisfun Girvin 3. (00:26) Add numbers, but we get zero!?!?! 4. (00:46) File with data and the many problems with storing data 5. (00:58) Why Center Alignment is so terrible 6. (01:25) How to Remove Formatting to view real data 7. (01:50) Learn important keyboard shortcuts, and history behind it! 8. (02:03) How to get Alt Keyboards to work 9. (02:39) Do Not Format Cells in Workbook that are not used. DO NOT USE COLUMN HIGHLIGHT ARROW! 10. (03:28) Alternative to Column Highlight Arrow 11. (04:01) Convert text numbers with any math operation, such as Double Negative 12. (04:26) Double Negative and Unitary Operator which evaluates quickly 13. (05:32) What is a #VALUE! Error? 14. (05:50) Use Formulas to investigate what characters are in a cell with digits. 15. (06:28) LEN Function 16. (06:36) General Number Format to remove all Number Formatting 17. (06:45) SEQUENCE Array Function 18. (06:56) MID Function 19. (07:25) CODE function to reveal the code number for a character 20. (08:20) SUBSITUTE function to remove character 160 21. (08:30) CHAR function 22. (09:14) REGEXREPLACE function and regex code to remove white space such as space, tab and non-breaking space 23. (11:22) Bonus #1: Power Query to that remove spaces and non-breaking spaces 24. (11:53) Bonus #2: Excel Table Column Formula to add student marks that removes spaces and non-breaking spaces 25. (12:34) Dynamic Spilled Arrays in Excel Table Columns: Error or No Error? 26. (13:11) Bonus #3: CHAR(160) in pattern argument of REGEXREPLACE function 27. (13:30) Summary 28. (13:36) Closing This video has subtitles or audio translations in these 117 languages: Abkhazian, Afar, Afrikaans, Akan, Albanian, Arabic, Armenian, Azerbaijani, Bambara, Bangla, Bashkir, Basque, Belarusian, Bosnian, Bulgarian, Burmese, Cantonese, Chinese (Hong Kong), Chinese (Singapore), Chinese (Taiwan), Croatian, Czech, Danish, Dutch, Dutch (Netherlands), Estonian, Faroese, Fijian, Filipino, Finnish, French, French (France), Georgian, German, German (Germany), Greek, Hawaiian, Hebrew, Hindi, Hungarian, Icelandic, Indonesian, 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), 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, Tsonga, Tswana, Turkish, Turkmen, Ukrainian, Urdu, Uyghur, Uzbek, Venda, Vietnamese, Welsh, Western Frisian, Yiddish, Yoruba, Zulu. Click gear icon below video to set subtitles, audio and language. #excel #microsoft #excelisfun #excelcourse #arrayformulas #dynamicspilledarray #sum #sumnotwork #total #sumfunction #sequence #len #code #char #Mid #midfunction #regex #REGEXREPLACE #substitute #textnumbers #char160 #nonbreakingspace

    Not rated yet
  • Power Query #8: Optimize Performance with SQL Server Database Connection

    · 28 min

    Download Zipped folder with files: https://excelisfun.net/files/PowerQuery08Files.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/ link to Microsoft Notes on Direct Query: https://docs.microsoft.com/en-us/power-bi/desktop-use-directquery In this video learn how to connect to an SQL Server Database using Power Query and import data into Excel and Power BI Desktop. Learn about Query Folding and how Power Query writes SQL code for you and sends it back to the SQL Server Database to be run more efficiently than in M Code and Power Query. Connect to 7 Million rows of data and build efficient steps to optimize performance. Topics: 1. (00:00) Intro Song 2. (00:11) Introduction to SQL Server Databases 3. (00:45) Download Files 4. (01:05) Overview of Two Video Projects 5. (01:38) Query Folding 6. (02:55) SQL Server Databases and Power Query 7. (05:12) Credentials for server SQL database 8. (05:47) Connect to SQL Server Database in Power Query 9. (08:00) Review transformational steps required for the Power Query generated final report 10. (10:00) Sql.Database M Code Function 11. (10:39) View Native Query is queue that step is sent back to SQL database for Query Folding 12. (11:27) View Native Query to view Power Query generated SQL Code 13. (11:48) Remove column in query to improve reporting area and reduce load size 14. (12:25) Remove Rows to create more efficient queries. Filter Quantity Greater Than Or Equal To 100 15. (13:11) Expand Related Table to get Product Price 16. (13:32) Calculate Net Revenue with Add Column, From Number, Standard dropdown Multiply 17. (14:17) Edit Table.AddColumn M Code function 18. (14:37) List.Product function, and other aggregating list functions 19. (15:46) Group By feature in Power Query and SQL. Group to get unique list of product and a total net revenue for each unique item 20. (16:55) Table.Group M Code function 21. (17:46) Filter the grouped aggregation 22. (18:06) Sort Product A to Z 23. (18:27) Load first query 24. (18:43) Use SQL code option in Power Query 25. (20:22) Connect to second database and run into an issue that requires that we move query steps to create efficient query folding 26. (23:19) Custom Column feature 27. (25:11) In Power BI Desktop use Power Query to connect to an SQL Server Database and then load three tables (one fact and two dimension tables) to the Columnar Database in the Data Model 28. (27:44) Summary 29. (28:21) Mike Girvin’s excelisfun Power Query book 30. (28:30) Closing This video has subtitles or audio translations in these 103 languages: Abkhazian, Afar, Afrikaans, Albanian, Arabic, Armenian, Aymara, Azerbaijani, Bambara, Bangla, Bashkir, Basque, Belarusian, Bhojpuri, Bosnian, Bulgarian, Burmese, Cantonese, Chinese, Chinese (Hong Kong), Chinese (Singapore), Chinese (Taiwan), Croatian, Czech, Danish, Dutch, Dutch (Netherlands), Estonian, Faroese, Fijian, Filipino, Finnish, French, French (France), Georgian, German, German (Germany), Greek, Hawaiian, Hebrew, Hindi, Hungarian, Icelandic, Indonesian, 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), Punjabi, Russian, Samoan, Sanskrit, Scottish Gaelic, Serbian, Sicilian, 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, Uzbek, Vietnamese, Welsh, Western Frisian, Zulu. Click gear icon below video to set subtitles, audio and language. #excel #excelisfun #analytics #analysis #dataanalysis #dataanalytics #powerbi…

    Not rated yet
  • PQ #6 Part 2: Multiple Excel Files, Different Sheet Names Into Table with Combine Button

    · 4 min

    Download Zipped folder with files: https://excelisfun.net/files/PowerQuery06Part02Files.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 12 Excel files each with one sheet, but each sheet has a different name into one table with just a few clicks! Topics: 1. (00:00) Intro Song 2. (00:11) Introduction 3. (00:52) Download files so you can practice 4. (00:59) Difference in Excel File Structure between Video #6 and video #6 Part 2 5. (01:52) From Folder Feature 6. (02:23) Remove Other Columns 7. (02:27) Combine Files button 8. (02:54) Change Code to accommodate the fact that the worksheets have different names 9. (03:50) Summary 10. (04:05) Closing View Power Query Video pdf notes: https://excelisfun.net/files/PowerQuery-06Part02.pdf This video has subtitles or audio translations in these 71 languages: Abkhazian, Afar, Afrikaans, Amharic, Arabic, Assamese, Bangla, Bashkir, Basque, Belarusian, Bosnian, Bulgarian, Burmese, Cantonese, Catalan, Chinese, Chinese (Hong Kong), Chinese (Singapore), Chinese (Taiwan), Croatian, Czech, Danish, Dutch (Netherlands), Estonian, Faroese, Fijian, Filipino, Finnish, French, French (France), German (Germany), Hebrew, Hindi, Hungarian, Icelandic, Indonesian, Italian, Japanese, Korean, Latvian, Lithuanian, Luxembourgish, Macedonian, Maithili, Malay, Malayalam, Norwegian, Persian, Persian (Afghanistan), Persian (Iran), Polish, Portuguese (Brazil), Punjabi, Russian, Sanskrit, Scottish Gaelic, Serbian, Sicilian, Somali, Spanish (United States), Swahili, Swedish, Tamil, Telugu, Thai, Tibetan, Ukrainian, Urdu, Vietnamese, Welsh, Zulu. Click gear icon below video to set subtitles, audio and language. #excelisfun #MikeGirvin #PowerQuery #Excel #PowerBI #PowerBIDesktop #Excel365 #LearnPowerQuery #freeclass #DataAnalysis #BusinessIntelligence #Microsoft #combine #excelpowerquery #import #append #combine #datacleaning #datatransformation #datatraining

    Not rated yet

More in Education

See all Education shows