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
Author: Faraz Shaikh
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 Install Windows on a Mac with Apple M1 ARM chip
Apple’s NEW Silicon Chip M1/Pro/Max is designed on ARM architecture, we would need an ARM-based installation file for windows.
Apple Silicon processors now support Power Query Excel for Mac
For a long time, Excel has been an Apple Silicon native (along with the rest of Office, except OneDrive). However, Power Query was the only tool that required Rosetta to run on Apple Silicon Macs. But now with the latest update, it has been enhanced to be Apple Silicon (M1, M1 Pro, M1 Max) native, Excel Power Query no longer requires Rosetta.
How to calculate Hijri Age in Excel
Calculate the Hijri Age In Excel, using the old-school method & with LAMBDA Function.
How to create Excel Table with the current sheet name using VBA
Simple line of VBA Code allow you to convert active sheets data into Excel Table with active sheet name just by one click.
#FarazShaikh #ExcelExciting #VBA #Macro #ExcelForMac #ExcelForWindows
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