Recommended Microsoft Excel Tips
- Quickly Typing Dates into Cells
- Use Smart Tag to fill series of dates in Microsoft Excel
- Copying and Pasting Validation list only in Microsoft Excel
- Filtering a Range into a List of Unique Records
- Saving Filtering Criteria
- Retrieving the Value of the First Nonblank Cell in a List
- Indicators for the maximal and minimal values
- Rounding Numbers to Millions with Thousands as a Decimal
- Calculating Hours Worked
- Adding a Custom Function That Returns the Quarter Number
- Changing the Standard Font
- Getting Continuously Refreshed Data from a Web Site in Excel 2000
- Inserting a picture (company logo) in the header in Microsoft Excel 2002 xp
- Rounding Numbers to Thousands
- Entering the Current Time into a Cell
- Altering the results returned by VLOOKUP.
- Avoiding Problems when Numeric Values are used as Text
- Summing Annual Expenses by Respective Quarters
- Combining Text from Different Cells
- Selecting a row or rows in Microsoft Excel
- Avoiding Errors When Counting Date Values That Meet Specified Criteria
- Printing a Chart in Microsoft Excel
- Transposing Cells
- Altering results returned in case of an error.
- Summarize data according to criteria from the data table using Sumif formula, Offset formula and Combo Box in Microsoft Excel
- Using Cell Reference with Keyboard signs in the Criteria Range argument when using COUNTIF formula.
- Formatting a Negative Number with Parentheses
- Combining the Contents of Every N Number of Cells into One Value
- Converting Time to Decimal Values
- Finding Minimum / Maximum Values
Sort by Version
