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.
Steps Recorder is sometimes referred to as Problem Steps Recorder or PSR. Steps Recorder is a FREE application available for all Windows users that allow to screen capture & annotate steps.
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
When we are constructing a simple or complex formula LET function will be very handy, just imagine it works like a variable/parameter where you can declare your value or formula with a meaningful name and reuse it with the name within the formula construction each time required
Simple steps shows how to lock the VBA code
Copy Spell Number VBA Code for FREE ..!! No more worries about converting the number to word manually in Excel. It happens often time we wish to convert number to text, currently, there is no built-in function in Excel but yet with the help of VBA we can manage to do it. This is the customized code as per currency
