On May 26, 2020, it was my pleasure to present Dynamic Reports with Power Query at London Excel Meetup webinar, we talk about best practices to use the modern Power Query tool and simplify our daily routine task. The webinar was organized by Alan Murray, Founder of Computergaga.com along with Tea Kuseva, Co-Founder of DATEL…
This formula in Excel will allow you to extract the username from the email address from a cell.
Amazing New PDF connector for Excel in Power Query get the data from PDF into Excel
One Click Refresh Dynamic Solution to Get Sheet Names using Power Query Excel for mac and windows
On May 09, 2020, it was my pleasure to present about Power Query & Power Automate to the Pakistani Excel Community, we talk about best practices to use the modern tools and simplify our daily routine task. The webinar was organized by Rahim Zulfiqar Ali, Founder & CEO of Excel Basement during the COVID-19 lockdown…
This simple Excel formula for mac and windows allows us to get the file path/location, name & sheet name of active workbook. Simply copy the formula and paste into your workbook.
With this VBA code, we can easily unhide all the sheet which are hidden in the active workbook.
Simple line of VBA Code allow you to convert all the sheets data into Excel Tables just by one click.
#FarazShaikh #ExcelExciting #VBA #Macro #ExcelForMac #ExcelForWindows
Search for Multiple LOOKUP Values and Return Multiple Results using VLOOKUP and INDEX MATCH formulas
This VBA code allows you to get this of all sheets name in current workbook by creating new worksheet.
#FarazShaikh #ExcelExciting #VBA #Macro #ExcelForMac #ExcelForWindows
