Operations in Excel
Excel
Excel: How to Find the Top 10 Values in a List
Occasionally you may want to find the top 10 values in a list in Excel. Fortunately this is easy to do using the LARGE()...
Excel
How to Find the Top 10% of Values in an Excel Column
Occasional you may want to find the top 10% of values in an Excel column. Fortunately there are two quick ways to do this:
1....
Excel
How to Select a Random Sample in Excel (Step-by-Step)
Often you may want to select a random sample from a dataset in Excel. Fortunately this is easy to do using the RAND() function, which...
Excel
How to Compare Two Excel Sheets for Differences
Occasionally you may want to compare two different Excel sheets to identify the differences between them.
Fortunately this is fairly easy to do and this...
Excel
How to Load the Analysis ToolPak in Excel
The Analysis ToolPak is a free Microsoft Excel add-in program that provides tools needed to perform complex statistical, financial, or engineering analyses.
To load the...
Excel
Excel: Conditional Formatting if Cell is Greater Than or Equal to Value
To apply conditional formatting to cells that are greater than or equal to some value in Excel, you can use the New Rule option...
Excel
Excel: How to Convert Date to Day of Week
You can use the following formulas to convert a date to the day of the week in Excel:
Formula 1: Convert Date to Abbreviated Day...
Subscribe
- Never miss a story with notifications
- Gain full access to our premium content
- Browse free from up to 5 devices at once
Must read