Md. Shah Alam
From the video contents, Job Holders, Job Seekers, Students will be able to develop their skills and knowledge on MS Excel, Power Query and Power BI on the purpose that they can manage their data related tasks more efficiently and productively, and add more value to their organization. Md. Shah Alam, Microsoft Certified Trainer, Excel and Power BI, will help you enhance your knowledge on Excel, Power BI and Data Analysis.
Solution to Challenge-11 | Power Query M | Unique Combination| Groupby|List.Distinct| Table.Distinct
Successful Completion of 5 Incredible Years as an Excel and Power BI Trainer
Solution to Challenge-10 | Excel 365 Dynamic Array Formulas | Let| Unique| Groupby
Solution to Challenge-9 | Power Query M Code | Group by| Table.SelectRows
Art of Writing Long Formulas in Excel || Learn to Build Complex Formulas Step-by-Step
Solution to Challenge-9 | Excel 365 Dynamic Array Formulas | Boolean Logic with MAP & GROUPBY
Solution to Challenge8| Power Query M| Date.ToText|Groupby|List.Transform|List.Distinct|Text.Combine
Navigation in Excel| Ctrl + Arrows| Ctrl + Dot| Ctrl + Shift + Arrows
Solution to Challenge-8| Excel 365 Dynamic Array Formulas| Groupby|Lambda|Textjoin
Solution to Challenge-7| Power Query M| Table.SelectRows
Top 5 Sales Amount of a Category| Excel Dynamic Array|Power Query M|Postgre SQL
Previous and Next Row Number|Power Query M
Solution to Challenge-7| Excel 365 Dynamic Array Formulas| Let|Scan|Hstack
Top 5 Sales Amount| Excel Dynamic Array|Power Query M|Postgre SQL
Returning Value with Groupby Applying Condition|Power Query M
Solution to Challenge-6| Power Query M| Table.SelectRows
Change Column Names Dynamically| NestedList|List.Transorm|Power Query M
Previous and Next Row Numbers|Excel 365 Dynamic Array Formula|Let|Sequence|Filter|Vstack|Sort
Power Pivot and Dynamic Arrays for Data Analysis in Excel|Excel 365 Dynamic Array|Power Pivot
Solution to Challenge-6| Excel 365 Dynamic Array Formulas| Let|Filter
Use Ampersand (&) in Power Query| Three (3) Examples
Solution to Challenge-5|Power Query M|List.Contains
Solution to Challenge-5| Excel 365 Dynamic Array|Let|Sortby|Take|Xmatch
Solution to Challenge-4|Power Query M|Text.Split|List.Reverse|Text.Combine
Solution to Challenge-4| Excel 365 Dynamic Array|TextSplit|Let|Sequence|Sortby|Textjoin|Map|Lambda
Free Webinar|VBA The Best Automation Tool in Excel
Solution to Challenge-3| Power Query M Code|Text.Reverse|Text.ToList|List.Select|List.Transform
Solution to Challenge-3|Excel 365 Dynamic Array Functions|Map|Lambda|Let|MID|Sequence|Filter
Boolean| MS Excel
Solution to Challenge-2|Power Query M|Text.Select|Text.Start|Text After & Before Delimiter