How to filter max or min value in Power Query using UI Method “TIES” in Excel & Power BI
Filter max or min value in Power Query for Excel & Power BI using the M function List.Max and List.Min
Category: Tip & Tricks
Change mouse pointer color and size on Microsoft Windows 11
Is it hard to find on your PC mouse finder, or sometimes while a presentation you need your audience’s eyes to follow with your mouse pointer then here is the trick. Under Related Settings click on the Mouse pointer We are done !!!
How to highlight the highest value row-wise by comparing two columns in Microsoft Excel?
In this blog, you will learn how to highlight the highest value row-wise by comparing two columns
How to use the Excel Function TIMEVALUE
Spreadsheets can be useful for working with time data because of Excel’s TIMEVALUE function. The function creates a serial number from a text string that represents a time so that it can be utilized in calculations. Simply type the text string that represents the time into the function’s parentheses to utilize the TIMEVALUE function. For…
Dynamic Solution with Power Query to Move the Grand Total in Excel PivotTable
While we are working with PivotTable in Microsoft Excel the Grand Total columns always appear on the right side and at the end of the records. One of my friends ask me if it could be possible to move the Grand Total column to the beginning of records as it would help to see the totals first and then the rest of the value.
Move the Grand Total to the left or to the first column in Excel PivotTable
While we are working with PivotTable in Microsoft Excel the Grand Total columns always appear on the right side and at the end of the records. One of my friends ask me if it could be possible to move the Grand Total column to the beginning of records as it would help to see the totals first and then the rest of the value.
How to calculate Hijri Age in Excel
Calculate the Hijri Age In Excel, using the old-school method & with LAMBDA Function.
How to change autosave or auto-recovery default time in Excel?
Microsoft Excel default saves behavior to autosave the workbook is every 10 minutes. We will see how change that default setting by reducing the time.
How to convert Gregorian to Hijri date and Hijri to Gregorian date
Handling dates is one of most challenging part and if you fail to enter the date correctly then you may lose some amazing features of Excel Time Intelligence. Let us see how to handle Arabic Dates in Excel
Get Live Gold, Silver & Precious Metal Stock Prices In Excel
Get Live Gold, Silver & Precious Metal Stock Prices In Excel.
Extracting precious metal prices like gold, sliver, platinum, etc into excel was one of the challenging task but not any more now.