Recommended Microsoft Excel Tips
- Filtering a Range into a List of Unique Records
- Sizing Charts with the Window in Microsoft Excel.
- Finding Minimum / Maximum Values
- Separating a Number Into Digits
- Adding Euro format to the number format in Microsoft Excel
- Selecting a sheet from shortcut menu in Microsoft Excel
- Formatting a Negative Number with Parentheses
- Add special symbols to the number format
- Create and Add a Function for Reversed Text Characters in Microsoft Excel
- Altering results returned in case of an error.
- Combining the Contents of Every N Number of Cells into One Value
- Creating Charts with F11 in Microsoft Excel
- Opening a template file automatically upon starting Microsoft Excel
- Splitting a Full Address into Three Separate Cells
- Moving Between Precedent and Dependent Cells
- Performing calculations based on multiple criteria, using SUMPRODUCT function
- Counting values meeting multiple criteria in different columns.
- Changing the Indentation in a Cell
- Extracting Characters from Text Using Text Formulas
- Quickly Typing Dates into Cells
- Coloring Numbers Based on Specific Criteria
- Reversing the Word Order within a String
- Totaling Time Values
- Ranking Salespeople According To Sales Figure
- Creating New IP Addresses
- Rounding Numbers that Meet Specified Criteria
- Automatically Wrapping Text in a Cell
- Hiding/Unhiding a Row(s) or Column(s)
- Filtering by the Date Field
- Fast Copying & Pasting in Adjacent Cells
Sort by Version
