May 4Database NormalizationGitHub: https://github.com/havishmad/excel_pbi_normalization YouTube: https://youtu.be/cd3x52eulSQ1 min readDatabase NormalizationGitHub:https://github.com/havishmad/excel_pbi_normalizationYouTube:https://youtu.be/cd3x52eulSQ----
May 4Single Function Descriptive StatisticsGitHub: https://github.com/havishmad/excel_descriptive_statistics YouTube: https://youtu.be/UzXruGi452o1 min readSingle Function Descriptive StatisticsGitHub:https://github.com/havishmad/excel_descriptive_statisticsYouTube:https://youtu.be/UzXruGi452o----
May 4Recursion on Excel LAMBDAYouTube: https://youtu.be/_41LyWe4cKs GitHub: https://github.com/havishmad/excel_lambda_recursion1 min readRecursion on Excel LAMBDAYouTube:https://youtu.be/_41LyWe4cKsGitHub:https://github.com/havishmad/excel_lambda_recursion----
May 2Convert multiple CSV to ExcelYouTube: https://youtu.be/X59g66-bI_g GitHub: https://github.com/havishmad/excel_csv_to_excel1 min readConvert multiple CSV to ExcelYouTube:https://youtu.be/X59g66-bI_gGitHub:https://github.com/havishmad/excel_csv_to_excel----
May 2Zip and UnZip using VBAYouTube: https://youtu.be/3OSb4X7z8ms GitHub: https://github.com/havishmad/excel_zip_unzip_vba1 min readZip and UnZip using VBAYouTube:https://youtu.be/3OSb4X7z8msGitHub:https://github.com/havishmad/excel_zip_unzip_vba----
Apr 25VBA vs Apps Editor vs TypeScriptYouTube: https://youtu.be/FjUikthPnM41 min readVBA vs Apps Editor vs TypeScriptYouTube:https://youtu.be/FjUikthPnM4----
Apr 13Remove Null RowsGitHub: https://github.com/havishmad/excel_remove_null_rows YouTube: https://youtu.be/6hMNgY_FGCE1 min readRemove Null RowsGitHub:https://github.com/havishmad/excel_remove_null_rowsYouTube:https://youtu.be/6hMNgY_FGCE----
Apr 10Connect Excel, PowerPoint and WordYouTube: https://youtu.be/RsicQlydlZE1 min readConnect Excel, PowerPoint and WordYouTube:https://youtu.be/RsicQlydlZE----
Apr 10Lookup Unclean DataYouTube: https://youtu.be/7t_94rZFE10 GitHub: https://github.com/havishmad/excel_lookup_unclean_data1 min readLookup Unclean DataYouTube:https://youtu.be/7t_94rZFE10GitHub:https://github.com/havishmad/excel_lookup_unclean_data----
Apr 10Lookup Duplicate ValuesYouTube: Lookup Duplicate Values GitHub: https://github.com/havishmad/excel_lookup_duplicate_values1 min readLookup Duplicate ValuesYouTube:Lookup Duplicate ValuesGitHub:https://github.com/havishmad/excel_lookup_duplicate_values----
