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
Category: Tip & Tricks
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.
Steps Recorder (PSR) Records your steps as you click
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.
How to make Dependent Dropdown list with XLOOKUP
XLOOKUP made the life easy to make the dependent dropdown list, we would have never imagined that it would be so simple to construct the formula. Check out post & get you sample file for free of download
Dictate Feature Microsoft Office Application will type for you
Dictate is one of the Microsoft Office Intelligent Services, that will type as you speak. To use this feature you must have Office365 Subscription
Get Data From OneDrive Excel File Using Power Query
Use Power Query (Get & Transform Data) to connect the Excel File from OneDrive Location.
Combine Active Workbook All Sheets Into One Master Sheet With VBA
Copy this simplest VBA Code which allow you to combine all the sheets into one single sheet.