How to Get Percentage of Two Columns in a Pivot Table
When working with Pivot Table, you may need to add extra calculated fields to make your Pivot Table better. For example, to add the percentage calculation between 2 columns, …
Category: Microsoft Excel
How to Extract Text before at sign for Email Address
To extract the text before the at sign (@), you need to find the location of the special character of the at sign (@) and then use the Left …
How to Convert Scientific Notation to x10 Format in Excel
When the numbers in Excel are too large or too small, you may need to convert them into scientific format. However, the default scientific format in Excel is not …
How to Disable Link Update Pop-up Message in Excel
When working with Excel received from others, you may get the pop-up message when you first open the Excel file and ask you to update the links. It might …
How to Convert Weekday to a Number
Sometimes you need to convert weekdays and weekends into number. Weekdays in Excel can be a date, also can be a text string. 1. When Weekdays are Dates (Please …
How to Use MAX Function
In statistics, the maximum value in a dataset is the value of the greatest observation of a sample. You can use the MAX function to find the largest value …