Simple Trick to Create A Data Entry Table In Excel Power Query
Simple Trick to Create Data Entry Table In Excel Power Query
Category: Excel
Webinar London Excel Meetup – Dynamic Reports With Power Query
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…
Extract Username From Email Address In Excel
This formula in Excel will allow you to extract the username from the email address from a cell.
Get Data From PDF In Excel with Power Query PDF Connector
Amazing New PDF connector for Excel in Power Query get the data from PDF into Excel
Get Sheet Names using Power Query Excel for mac and windows
One Click Refresh Dynamic Solution to Get Sheet Names using Power Query Excel for mac and windows
WEBINAR – POWER QUERY and POWER AUTOMATE – Faraz Shaikh
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…
Get Workbook Location-Name-Sheet Name With Formulas
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.
Unhide Active workbook sheets with VBA Excel for Mac & Windows
With this VBA code, we can easily unhide all the sheet which are hidden in the active workbook.
Convert All Sheets Data Into Excel Tables with VBA
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
Multiple Results using VLOOKUP and INDEX + MATCH formulas
Search for Multiple LOOKUP Values and Return Multiple Results using VLOOKUP and INDEX MATCH formulas